Compliance details reporting
I love to use PowerBI to get data that I want. But I need to make a report which shows which compliance / configuration policy item fails and on which devices. Like report of devices that have one CI in Failed state.

4 comments
-
frasim@microsoft.com commented
BTW - I also posted a similar ask, more specifically addressing the missing data in the Intune wherehouse here -> https://microsoftintune.uservoice.com/forums/291681-ideas/suggestions/38547556-policyid-to-deviceid-missing
-
Chris Wood commented
We've also got this requirement... I raised a support call but the only answer that I've had so far is that it's not available... not really a satisfactory answer when we're trying to comply with legislation!
-
Curtis K commented
Just to ensure that we're talking about the same thing, what I REALLY need (for audit and regulatory reasons) is for the data warehouse to include the FULL details of the compliance state of a device, just like what you can see in the Intune dashboard when you drill into a device that is Not Compliant. For example, if the "Minimum OS version" is Not Compliant, or the device is Inactive. That kind of thing. Just simply knowing that a device is Not Compliant is not enough, we need to be able to report out on why and show the metrics on that. As a financial institution, this is a critical regulatory issue. Thanks
-
Ash Hoque commented
This is something we desperately need since having discovered the data in the portal is out of date, and the only way to get real time data is via the graph api and power BI. Therefore we need some meaningful accurate data.