SCCM 2012 report count Advertisement
This report will show a simple count of advertisement running on SCCM 2012:
********************************
SELECT COUNT(LastStateName) AS Count, LastStateName
FROM dbo.v_ClientAdvertisementStatus
WHERE (DATEDIFF(m, LastStatusTime, GETDATE()) = 1)
GROUP BY LastStateName
*********************************
********************************
SELECT COUNT(LastStateName) AS Count, LastStateName
FROM dbo.v_ClientAdvertisementStatus
WHERE (DATEDIFF(m, LastStatusTime, GETDATE()) = 1)
GROUP BY LastStateName
*********************************