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]] On Behalf Of Rod Trent Sent: Thursday, September 12, 2013 10:20 AM To: [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.
<<inline: image001.png>>
<<inline: image002.png>>
<<inline: image003.png>>
<<inline: image004.png>>
<<inline: image005.png>>
