Works for me. Could be your missing S in SELECT?
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
Daniel Ratliff
From: [email protected] [mailto:[email protected]] On
Behalf Of Brian McDonald
Sent: Friday, October 07, 2016 11:56 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
The information transmitted is intended only for the person or entity to which
it is addressed
and may contain CONFIDENTIAL material. If you receive this
material/information in error,
please contact the sender and delete or destroy the material/information.
