Find all workstation that have not rebooting in a week.

User this query to find all workstations that have not rebooted in a week, simple version.

SELECT

            CS.Name0 as ‘PC Name’,

            CS.UserName0 as ‘User ID’,

            OS.lastbootuptime0 as ‘Boot Time’

FROM

            v_GS_COMPUTER_SYSTEM CS,

            v_GS_OPERATING_SYSTEM OS

WHERE

            CS.ResourceID = OS.ResourceID

            and datediff(dd,lastbootuptime0, Getdate()) > 7