Were you sleeping at my MMS presentation?
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]] On
Behalf Of Marcum, John
Sent: Thursday, September 12, 2013 8:56 AM
To: SMS List ([email protected])
Subject: [mssms] Uptime for List of Servers
What's the easiest way to get the last reboot time for a list of servers?
________________________________
John Marcum
Sr. Desktop Architect
Bradley Arant Boult Cummings LLP
________________________________
________________________________
Confidentiality Notice: This e-mail is from a law firm and may be protected by
the attorney-client or work product privileges. If you have received this
message in error, please notify the sender by replying to this e-mail and then
delete it from your computer.
