Report to find systems that have not rebooted for N number of days

Products

• Client Management Suite
• IT Management Suite

Issue/Introduction

The Computer Reboot History report shows all of the last reboots, but there are no dates to filter on. The Server Admins would like a report of systems that have not rebooted in N days so that they can be addressed.

Environment

ITMS 8.x

Resolution

A report was created that uses a Input Variable N to determine which systems to report in the list.  Systems in the Report have not been rebooted in N days. 

Import the Report attached to this KB to a folder of your choice.

Similarly, this SQL Report returns similar results but does not use Input Variables:

SELECT DISTINCT v.[Name] AS 'Computer Name',
v.[Domain] AS 'Domain',
t1.[Reboot Time] AS 'Reboot Date',
v.[Guid] AS 'Guid'
FROM dbo.vRebootHistory t1
JOIN dbo.vComputer v
    ON t1.[_ResourceGuid] = v.[Guid]
JOIN dbo.ScopeMembership sm
    ON sm.[ResourceGuid] = v.Guid
WHERE t1.[Reboot Time]  < getdate() - 30   --- days since last reboot
-- and UPPER(v.[Name]) LIKE UPPER('%ComputerName%')