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. Last_Inventory1 The report can be downloaded here:  http://ccmexec.com/wp-content/uploads/2011/05/Last_Inventory1.mof
Otherwise the query is available here: http://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

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

6 Comments

Add a Comment

Your email address will not be published. Required fields are marked *