<div>
You will only be able to check this if you have SCOM alerts setup. SCCM will not be able to tell you this. Alternatively you would have to look at the Event Logs.
</div>


You will only be able to check this if you have SCOM alerts setup. SCCM will not be able to tell you this. Alternatively you would have to look at the Event Logs.

<div>
That's nto true. You can run this query:<br />

<pre><code id="code-20-36985182-1">select SMS_R_System.NetbiosName, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId order by SMS_R_System.NetbiosName</code></pre>
You'll get Netbios computer names and last boot-up date and time.
</div>


That's nto true. You can run this query:


select SMS_R_System.NetbiosName, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId order by SMS_R_System.NetbiosName

You'll get Netbios computer names and last boot-up date and time.

<div>
My apologies - so we all learn something new. Cheers :)
</div>


My apologies - so we all learn something new. Cheers :)

<div>
so i can take this and make a report out of it by just creating a new report and then editing the SQL and pasting what you have above?
</div>


so i can take this and make a report out of it by just creating a new report and then editing the SQL and pasting what you have above?

<div>
<div class="content wysiwyg-content">
how can i run a report or somehow tell when the last time a server was booted?
</div>
</div>


how can i run a report or somehow tell when the last time a server was booted?

SCCM 2007

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.