BY os.LastBootUpTime0 ASC
Total rows: 10521
Daniel Ratliff
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Brian McDonald
Sent: Friday, October 07, 2016 2:17 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Re: Uptime and Last Reboot for Servers
y, October 7, 2016 12:40:03 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Uptime and Last Reboot for Servers
No, I would not consider that query to be accurate. Its only querying hardware
inventory, which in most environments is kept around for 30+ days. This means
you still get inactive
Ratliff
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Brian McDonald
Sent: Friday, October 07, 2016 1:30 PM
To: mssms@lists.myitforum.com
Subject: [mssms] Re: Uptime and Last Reboot for Servers
Yeah, I got it from here: http://www.scomgod.com/?p=652
istsad...@lists.myitforum.com <listsad...@lists.myitforum.com> on behalf
of Marcum, John <jmar...@bradley.com>
Sent: Friday, October 7, 2016 11:20:34 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Uptime and Last Reboot for Servers
All the quotes are messed up. Remove them and type the
AM
To: mssms@lists.myitforum.com
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)',
CONVER
: [mssms] Re: Uptime and Last Reboot for Servers
[External Email]
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
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
7 matches
Mail list logo