PolicyID to DeviceID missing
I've had a chance to review the great work in reporting. But based on feedback and comments lots of questions around getting policy/configuration compliance to device mapping.
Looking at your schema it seems like the one table that is missing is a mapping of deviceId <=> PolicyId. This one many to many table would solve many question problems on what device has what policy, and even what user is had what compliance level.

Can you tell us more about the core reporting scenarios that would be addressed by adding deviceId→policyId mapping? The information is pretty granular, so we’re trying to figure out if Data Warehouse is the best tool for what you want to do. Walk us through your “happy path” for what you need to know, and what you do with the data when you have it.
2 comments
-
Norman Racine commented
I agree this is a very important management tool. We need to identify which devices have which policies and the status of those policies. Right now, there is no method to perform this ... it has to be done one-by-one. Not practical if thousand of devices.
-
frasim@microsoft.com commented
Yes - Gladly.
The main thing that I can't assemble in my own data set (powerbi report) is to see what policies are applied to which device. For instance if I have device 1 - and it has a 2 device configuration policies - I need to be able to report on it. currently the view is available in portal here -> Microsoft Intune ->Devices - All devices -> DEVICE name - Device configuration -> and you can export the devices list. This is highly inefficient. The net net result should be using Power BI I should be able to create a view ---- Device list --- Applied Policies ---- State