—-This report will give you server uptime information: SELECT os.Caption0 AS ‘Operating System’, cs.Name0 AS Name, DATEDIFF(hour, os.LastBootUpTime0, ws.LastHWScan) AS ‘Uptime (in Hours)’, CONVERT(varchar(20), os.LastBootUpTime0, 100) AS ‘Last Reboot Date/Time’, CONVERT(varchar(20), ws.LastHWScan, 100) AS ‘Last Hardware Inventory’ FROM v_GS_WORKSTATION_STATUS AS ws LEFT OUTER JOIN v_GS_OPERATING_SYSTEM AS os ON ws.ResourceID = os.ResourceID INNER JOIN v_GS_COMPUTER_SYSTEM AS cs ON cs.ResourceID = os.ResourceID WHERE (os.Caption0 LIKE ‘%server%’) AND (ws.LastHWScan <> 0) AND (cs.Name0 IS NOT NULL) ORDER BY Name   —-This report will give you Workstations uptime information: SELECT     TOP (100) PERCENT os.Caption0 AS ‘Operating System’, cs.Name0 AS Name, DATEDIFF(hour, os.LastBootUpTime0, ws.LastHWScan) AS ‘Uptime (in Hours)’,
                      CONVERT(varchar(20), os.LastBootUpTime0, 100) AS ‘Last Reboot Date/Time’, CONVERT(varchar(20), ws.LastHWScan, 100) AS ‘Last Hardware Inventory’
FROM         dbo.v_GS_WORKSTATION_STATUS AS ws LEFT OUTER JOIN
                      dbo.v_GS_OPERATING_SYSTEM AS os ON ws.ResourceID = os.ResourceID INNER JOIN
                      dbo.v_GS_COMPUTER_SYSTEM AS cs ON cs.ResourceID = os.ResourceID
WHERE     (ws.LastHWScan <> 0) AND (cs.Name0 IS NOT NULL) AND (os.Caption0 LIKE ‘%xp%’) OR
                      (os.Caption0 LIKE ‘%7%’) OR
                      (os.Caption0 LIKE ‘%vista%’)
ORDER BY Name

 

Leave a Reply