Querying for Advertisement Status in SCCM

The following query can be run in SQL against your CAS or Primary Site to collect the status of one or more advertisements. I find it useful to run this instead of the built-in reports because I can more easily link out to other sources, in this case my Active Directory Users table (v_r_user) and add/drop data as needed.


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.