8 votesNoted · AdminAdam Meltzer (ConfigMgr Product Team) (Software Engineer, System Center Configuration Manager) responded
This appears to be a bug in the SMS Provider. I’ll file this internally.
You can work around it in the short term by using Invoke-CMWmiQuery to run a query and add -Option Fast.
Tnx Adam for the update, already worked around it for my current needs, just wanted to report it :)
Updated by bobmn for sangeev/OSD
Erik DK: Thanks exactly what I was looking for.
@Anonymous For Operating Systems use:
Tempted to mark this completed, now that we’ve released full blown powerBI integration:
Building reports & dashboards doesn’t get much easier than that.
There is a bug in the solution that prevents data to be populated in the Updates Page.
There is an error in the store procedure called pbist_sccm.sp_populateupdate.
On row 35 it says:
TRUNCATE TABLE pbist_sccm.update;
but it should say:
TRUNCATE TABLE pbist_sccm.update_staging;
Otherwise the store procedure just moves the data from pbist_sccm.update_staging to pbist_sccm.update but then wipes the data again...