Reporting Group

Hello All,

I have been asked to prepare a report that would show all the computers that are Pending Reboot, after Patch Installation. The columns that are required are:

1. User ID
2. Computer Name
3. OS
4. User Name (Display Name)
5. Reboot Required (y/n)

The preconfigured report in Altiris does not provide the additional information that I need, any help / suggestion would be greatly appreciated.

Thanks in advance

Wert.

Hope it help

https://www-secure.symantec.com/connect/forums/querying-find-computers-requiring-restart-patch-management#comment-7947611

One more article

Reboot status appears inaccurate after installing Updates through Patch Management Solution.

http://www.symantec.com/docs/TECH140529

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