garfaldo,

Just to clarify - are Reboot Notifications with Reboot Deferral option also do not suite Your needs?

They can be set in Settings -> Agents/Plugins -> Software -> Patch Management -> Windows -> Default Software Plugin Policy, Notification tab.

You can, for example, set 'Allow user to defer' for couple of days, and 'Show Pending Message'. In this case, User will be presented with 'Reboot Deferral' notification, allowing to defer reboot up to specified period, and when 'Reboot Deferral' is over - Reboot Pending message will be displayed - on this stage, reboot is inevitable.

This would allow affected users be aware of the upcoming reboot.

However, if this method is not that appropriate for Your case, possibly You could use the following query to retrieve list of machines, that require reboot:

set rowcount 0;
select DISTINCT
 cn.Name as [Computer Name]
from Inv_AeX_SWD_Execution_Summary ex  
 join ItemReference ir on ex.AdvertisementId = ir.ParentItemGuid
  and ir.Hint = 'swu' 
 join dbo.vSoftwareUpdateInventoryRuleAssociations ira on ir.ChildItemGuid = ira.SWUGuid    
 join dbo.vRM_Computer_Item cn  on ex._ResourceGuid = cn.Guid  
  and cn.OwnerNSGuid = (select tns.Guid from dbo.vThisNS tns)
 inner join vPMCore_ComputersPendingRebootByPackage prp on prp._ResourceGuid = ex._ResourceGuid
   and prp.PackageId = ex.PackageId 
where ira.SupersededBy is null  
order by cn.Name               

This query can be used in Automation Policy, for example.

Regards,

Sergej