Recently at Microsoft Ignite I attended a session with David Falkus (BRK3026) where he showed some of the possibilites of leveraging Microsoft Graph to report on key data from Intune and transfer audit events...
Category - Reporting
Jan Ketil Skanke
SCConfigMgr Software Update Compliance Dashboard – Version 2.0 released
I’ve been on a bit of a reporting spree here lately and I have been giving a little bit of love to the two PowerBI templates I’ve got out on TechNet and GitHub. I can now happily say that I’ve done...
Jordan Benzing
SCConfigMgr OSD Dashboard Version 1.0
Recently PowerBI had its birthday and I put a tweet out there on twitter asking what type of dashboard people would like to see in celebration. Well the results came in pretty quick and it was almost a tie between OSD...
CMPivot in ConfigMgr 1806 – Part 3 – CMPivot and SQL Reports
So far in this series we’ve talked how to use CMPivot to query online machines in your environment and what you can then do with that information. Now we’re going to take a step back from the tool itself and...
CMPivot in ConfigMgr 1806 – Part 1 – What is CMPivot and your first query
Since the early days of ConfigMgr when it was first named ‘SMS’ there was always this background joke that what SMS really stood for was ‘Slow Moving Software’ however with the advent of CMPivot...
How to use SMSProv.log to build reports
When working in ConfigMgr I frequently find information in the console is placed in inconvenient or inefficient locations especially when working with large chunks of information. Today I want to talk about a trick...
ConfigMgr Patch Compliance With PowerBI – V1.0.0.7
Almost two weeks ago I released a pretty generic report on reporting patch compliance using PowerBI and System Center Configuration Manager and I was shocked at the amount of feedback I got from the community! So first...
Dell Warranty Checker – ConfigMgr PowerBI Report
In case you missed it, Dell released an update to their excellent Command Integration Suite this week. As part of the update they included a new version of their warranty checker utility, thankfully this now has an...
Maurice Daly
BitLocker Compliance Reporting with PowerBI
Security audits, we all love them right? Being asked the same questions by management such as are our machines encrypted and how can I get a report to show that. So taking BitLocker encryption as an example, how can we...
Keeping Data Current with the PowerBI Gateway
Recently I shared a PowerBI template that could be used as a solid starting point for compliance reporting on servers, and with a couple tweaks, you could make it work for desktops too. Great, but now its time to go...