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

book

Article ID: 179642

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Question
Which tables hold the last configuration request and last inventory received values?

Answer

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

The Last Inventory Received date can be slightly misleading, especially if you use Active Directory, as importing from AD and other such activities are considered a type of inventory.

You can look at when the last inventory was collected by Inventory Solution using the Inv_AeX_AC_Inventory_Results table:

select id.Name, ir.[Collection Time] from Inv_AeX_AC_Inventory_Results ir
Join inv_aex_ac_identification id on ir._resourceguid = id._resourceguid
Order by [Collection Time] DESC