Hello folks
We are running CMS 7.6 HF7. I have 2 questions regarding asset status and the interaction with licenses.
1) What does the IsManaged Column mean in the vRetiredAsset view? I have a mixture of retired computers that are both IsManaged=1 or IsManaged=0. I was under the impression that all retired assets would become IsManaged=0.
2) What have others used to discover retired assets becoming active active? Is querying the Evt_NS_Item_Management table appropriate?
Select im.ItemName
,im.Action
,im._eventTime
from
Evt_NS_Item_Management im
join vRetiredAsset vra
on im.ItemGuid = vra.Guid
where im.ResourceTypeGuid in ('493435F7-3B17-4C4C-B07F-C23E7AB7781F', '2C3CB3BB-FEE9-48DF-804F-90856198B600')
and im._eventTime >= DATEADD(day, -7, GETDATE())
order by 3 desc
Thanks