Support Forum: Get Support for Patch My PC Products and Services

Commercial Products: Support for Our Enterprise Product for Microsoft ConfigMgr and Intune => Commercial/Paid Products: Support and General Questions (ConfigMgr and Intune) => Topic started by: sixthchain on March 26, 2023, 06:02:31 PM

Title: CI_ID not showing against Resource_ID in Compliance_info table | Powerbi
Post by: sixthchain on March 26, 2023, 06:02:31 PM
Hey All,

I'm using the powerbi dashboard for MECM. I need to look at compliance for an office update but have found that the number of compliant vs non-compliant devices varies between the powerbi dashboard and the report I've built in MECM console.

I've compared some data and have found that some devices in powerbi don't have the CI_ID for the office update against the resource_ID n the Compliance_Info table. No wonder why the numbers are different.

Would anyone be able to assist or explain how i can troubleshoot this further to understand what/why this is happening?

The device in question is in the patching collection, other updates show against the resource_ID except for the office updates.

Thanks.
Title: Re: CI_ID not showing against Resource_ID in Compliance_info table | Powerbi
Post by: Ben Whitmore (Patch My PC) on March 27, 2023, 09:20:31 AM
Hey there, thanks for reaching out. It will be easier for us to tag the correct engineers for visibility if you can log this at https://patchmypc.com/technical-support (https://patchmypc.com/technical-support)

Thank you :)