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.