I'm aware I was missing the 'S' in Select in the below. Here is the FULL query i'm running. [😊]
SELECT 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 ________________________________ From: [email protected] <[email protected]> on behalf of Brian McDonald <[email protected]> Sent: Friday, October 7, 2016 10:55:41 AM To: [email protected] Subject: [mssms] Uptime and Last Reboot for Servers 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
