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

*********************************