How to: Create custom SQL- based Reports in System Center 2012 R2: Configuration Manager

A customer asked me  for a “how-to” on how to Create reports in SCCM 2012, so why not share with everyone. This post is not intended to show how to write or design queries, but show you have to create  a report based on a SQL query you might already have. Even-though we are skipping […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager 2012, Configuration Manager 2012 R2, Configuration Manager 2012 SP1, Home, Microsoft SQL, SQL Reporting services  |  1 Comment

Dealing with Jailbroken/Roted devices in ConfigMgr 2012 R2 & Intune

As you enroll a mobile device into Intune/ConfigMgr 2012 R2, inventory data will automatically be uploaded to the ConfigMgr database. One of the data being collected is the Jailbroken/rooted condition. In the below example the device is being detected as a jailbroken device. One of the many benefits of using Intune as the MDM solution […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager, Tips and tricks  |  Comment

Case of the missing Hardware Inventory

I recently played around with adding registry data to SCCM Hardware Inventory using RegKeyToMof, but during the tests I ended up with a big problem, no clients were delivering any hardware inventory at all. The problem quickly spread to all clients so I started the oh-so well known journey of troubleshooting. First let’s look at […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager 2012 SP1, Inventory, Troubleshooting  |  10 Comments

Error when running Application reports in ConfigMgr 2012

During the SQL Reporting Services site system role, SCCM automatically create a login in SQL and assign the required permissions to the account that you have specified. However I have seen several times that the account do not have the permissions required to run some of the Application reports.   When running the Software Distribution […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager, Configuration Manager 2012, SQL Reporting services, Tips and tricks, Troubleshooting  |  5 Comments

Migrate reports from SCCM 2007 to SCCM 2012 SP1

The built-in migration wizard in ConfigMgr 2012 can migrate most objects but not reports. In ConfigMgr 2012 classical ASP reports (as we know them from earlier versions) are no longer supported. Migrate the classical reports to SQL Reporting Services in SCCM 2007 Below is a walk thru of how you migrate your existing classical reports […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager, Configuration Manager 2012, Tips and tricks  |  11 Comments

CSV REPORT: Get ConfigMgr Collection Excluded or Included Collection Rules

Currently there should be no builtin report that will show you Excluded or Included collections and because of that I did two simple PowerShell scripts that queries Included or Excluded collections. Both of these scripts creates a CSV file. You can run this script on your Primary, CAS or Central site like this: Get-CMCollectionExcludedCollectionRules.ps1 -SiteCode PS1 -SiteServer […]

Category: Config Mgr. Inventory and Reporting, Config Mgr. SP2, Configuration Manager 2012, Configuration Manager R3, Powershell  |  1 Comment

Creating the Reporting User role in ConfigMgr. 2012

Role based Security in ConfigMgr. 2012 is much different from ConfigMgr. 2007. The new version ships with predefined security roles like Administrator, Infrastructure Administrator etc. One role is missing though – the Reporting User role. Create the Reporting User role Open the ConfigMgr. Console, navigate to the Administration workspace and select Security, Security Roles Select […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager, Configuration Manager 2012, Security  |  13 Comments

Configuration Manager 2007 Reporting Point – Cannot set application role ‘webreport_approle’

Stumbled over an issue with a Configuration Manager 2007 Reporting point this morning. The customer couldn’t run a report, instead they got this message in the browser: Cannot set application role ‘webreport_approle’ because it does not exist or the password is incorrect For what-ever reason it turned out the application role has dropped the default […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager, Troubleshooting  |  1 Comment

Error installing SQL Reporting Builder 3.0 in ConfigMgr. 2012

It has happen to me before, and it will happen again. I ran my ConfigMgr. 2012 administrator console without starting it as Administrator. When trying to edit a report I got the error message: Report Builder 2.0  is not installed as a click-once application on report server The error message is kind of funny, as […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager, SQL Reporting services, Tips and tricks  |  Comment

Easy way to change logos in Configuration Manager 2012 reports

During my session I03 @ Microsoft Campus Days in Copenhagen I demonstrated how to easily change the default logo on all the canned reports in Configuration Manager 2012. As promised on the session, here are the needed steps. My demo environment has SQL Reporting Services and Configuration Manager installed in D:\Program files on the same […]

Category: Config Mgr. Inventory and Reporting, Configuration Manager, Configuration Manager 2012, Tips and tricks  |  11 Comments