I recently ran a poll (back over Christmas) asking the community about what they would like to see and by popular demand people asked for an update to the PowerBI patching dashboard and man with all of the little bugs I...
Category - Reporting
Jordan Benzing
Getting started with Microsoft Intune Diagnostics and Log Analytics
Microsoft Intune has for a good time now included built-in logs for activity in your Intune environment. Up until now there has not been any native support for getting a aggregated view of these logs. I have earlier...
Jan Ketil Skanke
How to use a scheduled task to query SQL
Several months ago I created a script that would allow someone to extract information from the ConfigMgr SQL Database and e-mail that data. I wrote this as a workaround to SSRS subscription reports at the time as the...
Export Microsoft Intune audit data to Log Analytics using Graph API and Azure Automation
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...
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...
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...