John, >> This seems to work. How can I format the date time to be month/day/year >> HH:MM:SS?
Should be like this: select distinct v_R_System_Valid.Netbios_Name0 AS [Computer Name], CONVERT(VARCHAR(24), V_GS_OPERATING_SYSTEM.LastBootUpTime0, 101) + ' ' + CONVERT(VARCHAR(24), V_GS_OPERATING_SYSTEM.LastBootUpTime0, 108) AS [Last Boot Time] from v_R_System_Valid inner join v_GS_OPERATING_SYSTEM on v_GS_OPERATING_SYSTEM.ResourceID = v_R_System_Valid.ResourceID Duncan Russell [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Marcum, John Sent: Thursday, September 12, 2013 12:05 To: '[email protected]' Subject: RE: [mssms] Uptime for List of Servers Sorry, forgot to attach the SQL select distinct v_R_System_Valid.Netbios_Name0 AS [Computer Name], V_GS_OPERATING_SYSTEM.LastBootUpTime0 AS [Last Boot Time] from v_R_System_Valid inner join v_GS_OPERATING_SYSTEM on v_GS_OPERATING_SYSTEM.ResourceID = v_R_System_Valid.ResourceID ________________________________ John Marcum Sr. Desktop Architect Bradley Arant Boult Cummings LLP ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Rod Trent Sent: Thursday, September 12, 2013 10:20 AM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Uptime for List of Servers Would this work? http://social.technet.microsoft.com/Forums/systemcenter/en-US/e0147d8a-8946-42bb-b6ed-a3c92bae5b23/last-reboot-report Rod Trent<http://myitforum.com/myitforumwp/community/members/rodtrent/> [WindowsITProButton]<http://windowsitpro.com/author/rod-trent>[myITSMButton]<http://www.myitforum.com/>[TwitterButton]<http://twitter.com/rodtrent>[Facebookbutton]<http://www.facebook.com/rodtrent>[LinkedInButton]<http://www.linkedin.com/profile/view?id=2881785> From: [email protected]<mailto:[email protected]> [mailto:[email protected]]<mailto:[mailto:[email protected]]> On Behalf Of Marcum, John Sent: Thursday, September 12, 2013 10:56 AM To: SMS List ([email protected]<mailto:[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. ________________________________ 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. ________________________________ 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. 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.
<<inline: image001.png>>
<<inline: image002.png>>
<<inline: image003.png>>
<<inline: image004.png>>
<<inline: image005.png>>
