Hello Raju123.
Thanks for your reply and the links, the first link does provide sql query to get the computers requiring reboot but this only does half the job for me is there a way that we can tweak the query to get the additional information such as, User ID, OS, User Name to this query, (I am just a beginer in sql) any suggestions, guidance would be much appreciated.
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
Regards
Wert