Hello everyone,
I'm trying to determine the uptime and last reboot for servers. Below is the query I am trying to execute: ELECT cs.Name0 AS 'ComputerName', DATEDIFF(HOUR, os.LastBootUpTime0, ws.LastHWScan) AS 'Uptime (in Hours)', CONVERT(VARCHAR(26), os.LastBootUpTime0, 100) AS 'Last Reboot Date/Time', CONVERT(VARCHAR(26), ws.LastHWScan, 101) AS 'Last Hardware Inventory' FROM dbo.v_GS_WORKSTATION_STATUS ws LEFT OUTER JOIN dbo.v_GS_Operating_System os ON ws.ResourceID = os.ResourceID LEFT OUTER JOIN dbo.v_GS_COMPUTER_SYSTEM cs ON cs.ResourceID = os.ResourceID WHERE os.Caption0 LIKE '%server%' ORDER BY os.LastBootUpTime0 ASC I'm getting a syntax error, Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '''. Can someone tell me what I'm doing wrong? Thank you, Brian
