Category: Tips

December 12, 2017
Getting Started with Power BI Desktop and SCCM

In this blog post I will show you how to connect Power BI Desktop to your System Center Configuration Manager (SCCM) SQL Server database. During the connection process I will…

December 6, 2017
How to Install Power BI Desktop

I was looking at my upcoming blog post set about Power BI and I thought it would be appropriate to start off first by showing you how to install Power…

November 21, 2017
How to Setup, Configure and Use SCCM’s Asset Intelligence

Asset Intelligence (AI) is one of the underused features of System Center Configuration Manager (SCCM). AI is comprised of two basic elements: Asset Intelligence Synchronization Point and Asset Intelligence Inventory…

November 15, 2017
How Can I Hide an SSRS Gauge in a Dashboard?

A super-cool feature with SQL Server Reporting Services (SSRS) is all of the available options for creating dashboards and reports! For example, did you know that you can hide an…

November 8, 2017
How Can I Update the Plain SSRS Gauge in a Dashboard?

The default SQL Server Reporting Services (SSRS) reports in System Center Configuration Manager (SCCM), let’s face it, are plain. When you create a custom dashboard or report, however, they don’t…

October 30, 2017
Last Reminder to Vote for Local Account-Group Details for a Computer OR Component Health States by Site

The report choices in Enhansoft’s October 2017 poll are Local Account-Group Details for a Computer and Component Health States by Site. Which Microsoft System Center Configuration Manager (SCCM) report do…

October 26, 2017
What Happened to the Tools Gauge in My SSRS Dashboard?

In the screenshot below, you can see that there is clearly an issue with the Tools gauge in my SQL Server Reporting Services (SSRS) dashboard. The purple arrow is pointing…

October 25, 2017
How Do I Bulk Upgrade SSRS RDLs from SQL Server 2005 to SQL Server 2008 R2?

I discussed how I needed to update each SQL Server Reporting Services (SSRS) RDL in yesterday’s blog post called, “What Does the Error Message, “Unknown Report Version 9.0,” in Visual…

October 24, 2017
What Does the Error Message, “Unknown Report Version 9.0,” in Visual Studio 2015 Mean?

A long time ago I started working on two projects using SQL Server Business Intelligence Development Studio 2005 (BIDS). I wanted to keep working on these projects, so I upgraded…

October 23, 2017
How Do I Enable CLR within SQL Server?

If you take a copy of your System Center Configuration Manager (SCCM) database and put it on your laptop (or anywhere else) without SQL Server common language runtime (CLR) enabled,…