SCCM Report – Clients that have not reported recently – Per Collection

There was a question in the Technet forum for a report with Last Hardware and Last Software inventory date per collection. Therefor I added the CollectionID as a condition for the built-in report “Clients that have not reported recently (in a specified number of days)” so that it can be run per collection.
This can be useful for providing reports for different sites, division or regions with client activity, so that they can check non-responsive clients in their area. The report can be downloaded here:  https://ccmexec.com/wp-content/uploads/2011/05/Last_Inventory1.mof
Otherwise the query is available here: https://ccmexec.com/wp-content/uploads/2011/05/Last_Inventory1.TXT

If you import the query on your own don’t forget to create a prompt called @varCollection.

And the query for the CollectionID for the Prompted value, to be able to search for collectionID’s

begin

if (@__filterwildcard = '')

select distinct CollectionID, Name from v_Collection order by Name

else

select distinct CollectionID, Name from v_Collection

WHERE CollectionID like @__filterwildcard

order by Name

end

/Jörgen