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...
Tag - 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 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...
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...
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...
Maurice Daly
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...