Thanks cheldt. I did think about that. We have done custom inventories for many things. Are you aware of reg key that is updated when inventory runs successfully? What I'm really after is a table that is updated when the inventory agent is uninstalled/installed that can be used to then exclude the computer from the uninstall filter once it is uninstalled. OR...if i can simply get the inventory to run immediately after the inventory agent is installed...this might alleviate this issue. Is there a way to force an inventory immediately after the inventory agent is installed?
Here is my query for agents that need to have the agent unintalled/reinstalled.
select * --vc.guid
from vcomputer vc
join Inv_Inventory_Results ir on ir._ResourceGuid = vc.Guid
join Inv_AeX_AC_Identification id on id._ResourceGuid = vc.Guid
join Inv_AeX_AC_Client_Agent ca on ca._ResourceGuid = vc.Guid
where
DATEDIFF(dd,ir.[collection time], getdate()) > '14'
and datediff(dd,id.[Client Date], getdate()) < '14'
and
IsManaged = '1'
and (ir.Agent = 'inventory agent'
and ca.[Agent Name] like '%Altiris Inventory Agent%')
and datediff(dd,id.[Client Date], getdate()) < '2'