SCCM 2007

Posted on 2011-10-18
Last Modified: 2012-05-12
how can i run a report or somehow tell when the last time a server was booted?
Question by:NAMEWITHELD12
    LVL 20

    Expert Comment

    by:Hendrik Wiese
    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.
    LVL 11

    Expert Comment

    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

    Open in new window

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

    Expert Comment

    by:Hendrik Wiese
    My apologies - so we all learn something new. Cheers :)
    LVL 1

    Author Comment

    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?
    LVL 11

    Accepted Solution

    For report you can use this SQL:
       sys.netbios_name0 AS [Computer Name], 
       os.LastBootUpTime0 AS [Bootup Time]
       dbo.v_R_System AS sys 
       LEFT JOIN dbo.v_GS_Operating_system AS os 
          ON sys.resourceID = os.resourceID 
       LEFT JOIN dbo.v_GS_Workstation_Status AS wss 
          ON sys.resourceID = wss.resourceID 
       sys.obsolete0 = 0 
       AND sys.client0 = 1 

    Open in new window


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
    Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
    This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
    This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now