SCCM Reporting - Computers with a Pending Reboot

Ever want to see what computers in SCCM need to reboot due to patching? If you use this query in SCCM reporting, you will be able to see this:

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

• This was tested in SCCM Current Branch 1706
• Query is modified from the source posted here