Category: SQL Server

July 11, 2018
Seven Tips for Writing SCCM Dashboards

At the last Midwest Management Summit which was held at the Mall of America, I was stopped in the hallway after one of my SCCM reporting presentations. I was asked…

June 27, 2018
How to Start Editing SCCM Reports with Report Builder

Did you know that you need a Role-Based Administration (RBA) security role when you want to edit System Center Configuration Manager (SCCM) Current Branch or 2012 R2 reports with Report…

June 20, 2018
How Big Should My Dashboard Be?

Is there a standard dashboard size? Is there a maximum or a minimum width or length? These may seem like simple questions, but there are no easy answers. I often…

June 6, 2018
Updated-How to Create a SQL Server Computer Account Login

This blog post was originally published in early 2017, but since then newer versions of SQL Server were released, so I thought that it was time for an update. Here…

May 4, 2018
SCCM Reporting and You at OWSUG

The Ottawa Windows Server User Group (OWSUG) is hosting a session called SCCM Reporting and You! This session will be held on Wednesday May 9 at 6:00 p.m. SCCM Reporting…

May 2, 2018
How to Import Custom SCCM Data into ServiceNow

This is the fourth post in a five-post blog set. This one will focus on how to import custom SCCM data. Originally, I created a blog post set around ServiceNow…

April 24, 2018
How to Integrate SCCM Data with ServiceNow

This post is the third post in a five-post set intended to help show you how to integrate SCCM data with ServiceNow. Here I will show you how to create…

March 21, 2018
Updated – How to Match SSRS Brand Colors with SSRS Site Items

A number of updates have occurred with SQL Server Reporting Services (SSRS) since I first published my original blog post on this topic over a year ago, so I thought…

December 27, 2017
SCCM Maintenance Tasks

This time of year is a good time (when things are a bit slow) to check Configuration Manager’s (SCCM) environment to ensure that everything is working well. We all know…

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…