Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi folks,
I've spent some time deploying the SCCM Solution Template for PBI a while ago. It's been mainly trouble-free. Nice! However I have come across data differences between the base tables that SCCM uses, namely pbist_sccm.computerprogram vs what SCCM SSRS reports display. eg. The pre-canned SCCM report:
Count Inventoried products and versions for a specific product uses 2 main datasets. These datasets use:
fn_rbac_GS_SoftwareProduct
fn_rbac_SoftwareProduct
Strangely, these functions use views and the views also use views ... quite a nested setup .... seems bizarre ... BUT in the end the query appears to source data from 2 SCCM tables:
SoftwareProductMap
SoftwareInventory
When comparing the PBI SCCM Solution Template code that populates the Program, ComputerProgram and ProgramInventory tables the code appears to source data from 2 SCCM tables:
Add_Remove_Programs_64_DATA
Add_Remove_Programs_DATA
WAY different! ..... Why did I have cause to check?
Well because when I was modelling data in PBI I was unable to return any MachineIDs when searching for IEv11...but since I'm contracting for a massive Fed Govt Dept ... which I know uses IEv11 ..... it clearly wasnt correct. Even my own WS has IEv11 installed.
Note .... the SCCM SSRS report (above) DID return data that contained reference to IEv11
Why has the SCCM Solution Template code used different tables to those used by in-built SCCM SSRS reports?
AND What does MSFT intend to do to rectify the issue since the Software Inventory report appears to be incorrect?
If you create a slicer using the Programs table the list is NOT complete.
I'm now slightly reluctant to accept other data visualizations that the SCCM Solution Template showcases.
Regards,
John
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.