It combines fixes for the issues addressed here
KB24764 KB24537 KB25767 KB27776 KB26457 KB26458
KB26459 KB26460 KB26463 KB26464 KB27777 KB26466
KB27778 KB27779 KB28017
Release Notes: http://kb.altiris.com/article.asp?article=25133&p=3
Blog site to provide a quick way to find solutions on problems encountered during a day to day work. Some articles are just copies of KB or Forums, but they might come in handy.
It combines fixes for the issues addressed here
KB24764 KB24537 KB25767 KB27776 KB26457 KB26458
KB26459 KB26460 KB26463 KB26464 KB27777 KB26466
KB27778 KB27779 KB28017
Release Notes: http://kb.altiris.com/article.asp?article=25133&p=3
SELECT vC.[Name], vC.[Domain], vC.[OS Name], vC.[OS Type], a.LastConfig, vC.[Guid]
FROM vComputerEx vC
INNER JOIN Inv_AeX_AC_Client_Agent acca
ON vC.[Guid] = acca.[_ResourceGuid]
INNER JOIN (
SELECT ResourceGuid, LastConfig = datediff(dd,MAX([StartTime]),GETDATE()),
LastConfigDate = MAX([StartTime])
FROM Evt_NS_Client_Config_Request
GROUP BY ResourceGuid
HAVING DATEDIFF(dd,MAX([StartTime]),GETDATE()) <= 30 --change to a lower number if desired
) AS a
ON a.ResourceGuid = vc.Guid
WHERE 1 = 1
AND vC.[Guid] NOT IN (
SELECT DISTINCT _ResourceGuid
FROM Evt_Inventory_Rule_Summary
)
AND acca.[Agent Name] = 'Altiris Software Update Agent'
________________________________
The results of this report will be all machines which have requested configuration from the NS within the last 30 days but have not sent an Inventory Rule summary (or the Inventory was rejected by the NS for some reason due to some problem).