SCCM report that lists all systems that have NOT been rebooted in the last 14 days.

Ken Thompson
Ken Thompson used Ask the Experts™
on
I'm having no luck with this on Google.  

I need to create a custom report in SCCM that will list out all systems that have not rebooted within the last 14 days.  I'm completely unfamiliar with creating SCCM reports.  I'm looking for a step-by-step on how to create this report.  So far, I've found lots of SQL statements that don't work but that's about it.

If you have a link to a video or article on how to do this it would be great!

Thank you,
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Systems Administrator
Commented:
This would work:

https://www.itsupportguides.com/knowledge-base/configmgr-sccm/sccm-query-computers-that-havent-rebooted-for-7-days/

Create a query to build a collection of computers that haven't rebooted in 14 days (change 7 to 14) and then you can use the report "All resources in a collection" and select that collection you built with a dynamic query and then you can export that report result out to a CSV, XLS, PDF, etc.
Adam LeinssSystems Administrator

Commented:
Specifically, the query would like this:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId where DATEDIFF(DD, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime, GETDATE()) > 14

Open in new window

Ken ThompsonIRM - SCCM Systems Analyst V

Author

Commented:
This solution was the fastest and worked perfectly.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial