That was it! Thanks so much everyone!
Brian ________________________________ From: [email protected] <[email protected]> on behalf of Williams, John <[email protected]> Sent: Friday, October 7, 2016 11:21:18 AM To: [email protected] Subject: [mssms] RE: Uptime and Last Reboot for Servers I believe it is your commas (they are the newer MS Word type instead of the ones used in SQL) you are using. I've changed them within SQL and got this to work. 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 Best Regards, John Williams From: [email protected] [mailto:[email protected]] On Behalf Of Brian McDonald Sent: Friday, October 7, 2016 9:11 AM To: [email protected] Subject: [mssms] Re: Uptime and Last Reboot for Servers 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]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> on behalf of Brian McDonald <[email protected]<mailto:[email protected]>> Sent: Friday, October 7, 2016 10:55:41 AM To: [email protected]<mailto:[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
