SCCM report all workstations that haven’t rebooted since installation of hotfix package.


  • I have suppressed reboot for a hotfix and I have displayed a message for users who have logged in at that time " that they need to reboot their system". I want to get a report how many users did a reboot after installtion of this hotfix?

    Thursday, February 23, 2012 5:40 AM


All replies

  • Hi,

    here is a link to a query in the console:

    Try this as a report query:

    select distinct V_R_SYSTEM.Name0,V_GS_PatchStatusEx.LastStateName from V_R_System  inner join V_GS_PatchStatusEx on V_GS_PatchStatusEx.ResourceID = V_R_System.ResourceId where V_GS_PatchStatusEx.LastStateName = 'Reboot pending'


    -- My System Center blog -- Twitter @ccmexec

    Thursday, February 23, 2012 6:13 AM
  • Try this query : -

    This will provide the time and the days of the last reboot .

    SELECT v.Name0, v.Active0, v.Obsolete0, v.Client_Version0,
    Convert(VarChar(10), OS.LastBootUpTime0, 101) 'Last Boot Date',
    os.lastBootUpTime0,DATEDIFF(dd, LastBootUpTime0, GETDATE())AS 'Number of Days since last bootup'
    FROM v_R_System V
    JOIN v_Gs_Operating_System OS on v.ResourceID = OS.ResourceID

    Thursday, February 23, 2012 6:37 AM
  • You should also have a look at this utility, it can force a restart on those computers who has not been restarted for x-number of days. Combine that with the report, and you have full control - more info on how to use the tool

    Kent Agerlund | My blogs: and | Twitter: @Agerlund | Linkedin: Kent Agerlund

    Thursday, February 23, 2012 11:53 AM
  • thanks Rabz it did provide detailed report but I want to know specifically after successfull installation of that package, how many users not yet rebooted.
    Also there is one slight problem with that result, it displayed Last Boot date in US date format (mm/dd/yyyy) but Last boot up time in AUS date format (dd/mm/yyyy) as a result of that it doesn't provide accurate result.

    • Edited by Vimal80 Thursday, February 23, 2012 10:30 PM
    Thursday, February 23, 2012 10:03 PM
  • thanks Jorgen, I want a specific report "after successfull installation of that package, how many users not yet rebooted."
    Thursday, February 23, 2012 10:18 PM
  • Hi Kent, that is a great tool but management want to display only remainder to reboot not the option to reboot with it.
    Thursday, February 23, 2012 10:24 PM
  • What is wrong is Jörgen, query? It will tell you all PCs that are still pending reboot, Is that exactly what you asked for?

    Saturday, March 10, 2012 4:27 PM