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
if (@__filterwildcard = '')
select distinct CollectionID, Name from v_Collection order by Name
select distinct CollectionID, Name from v_Collection
WHERE CollectionID like @__filterwildcard
order by Name