Sccm compliance report not updating
I spend the whole morning working with people hanging over my shoulder watching me write SQL queries to get the information they where looking for.
This report is one of the main software update dashboard reports.
I am not going to take any credit for the report as my work was very limited. State Name as Last Enforcement State, count(*) as Number Of Computers from v_CIAssignment a join v_Assignment State_Combined assc on a.