[mssms] RE: Uptime and Last Reboot for Servers

2016-10-07 Thread Daniel Ratliff
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

[mssms] Re: Uptime and Last Reboot for Servers

2016-10-07 Thread Brian McDonald
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

[mssms] RE: Uptime and Last Reboot for Servers

2016-10-07 Thread Daniel Ratliff
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

[mssms] Re: Uptime and Last Reboot for Servers

2016-10-07 Thread Brian McDonald
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

[mssms] Re: Uptime and Last Reboot for Servers

2016-10-07 Thread Brian McDonald
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

2016-10-07 Thread Marcum, John
: [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

[mssms] RE: Uptime and Last Reboot for Servers

2016-10-07 Thread Daniel Ratliff
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