SCCM Report - Power Management > Computers with a pending reboot

This is an SCCM report to generate a list of computers that are pending a reboot from updating them

This report was created and tested for SCCM 2012 Current Branch

Create these parameters

  • OS - available values
    • Server - %Server%
    • Workstation - %Workstation%
    • Any - %

Then create this query in Datasets

select 
CS.Name0 as "Computer Name",
CS.User_Name0 as "User Name",
CS.Operating_System_Name_and0 as "OS",
CS.AD_Site_Name0 as "AD Site",
CS.Full_Domain_Name0 as "Domain"

from v_AssignmentState_Combined
join v_R_System CS on CS.ResourceID=v_AssignmentState_Combined.ResourceID

where StateID='5' AND
CS.Operating_System_Name_and0 Like @OS

Create a table with these fields

  • Computer Name
  • User Name
  • OS
  • AD Site
  • Domain
Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.
    Blogger Comment

0 comments:

Post a Comment