Query showing "last configuration request" and "last inventory received" values?

Products

• IT Management Suite

Issue/Introduction

 What tables hold the last configuration request and last inventory received values?

Environment

ITMS 8.x

Resolution

The last configuration request can be found in the evt_ns_client_config_request table, for example:

select id.name, max(cr._eventTime) as [Last Config Request]
from evt_ns_client_config_request cr
JOIN inv_aex_ac_identification id on id._resourceguid = cr.resourceguid
Group By id.name
Order By [Last Config Request] DESC

The last Inventory received is determined from the ResourceUpdateSummary table, for example:

Select id.name, MAX(rus.ModifiedDate) as [Last Modified Date]
From resourceupdatesummary rus
JOIN inv_aex_ac_identification id on id._resourceguid = rus.resourceguid
Group By id.name
Order By [Last Modified Date] DESC