Last Configuration Request in Database
I was looking at creating a report of computers that have their "Last Configuration Request" timestamp greater than 2 weeks ago. The trouble I am having is pinpointing where this is located in the database. I have found last Inventory request and other timestamps, but not this one.
StartTime in Evt_NS_Client_Config_Request does not seem to be the one I am after as the timestamps are different. Also ModifiedDate in ResourceUpdateSummary does not seem to be the one.
What I need is a timestamp of the time the client contacted the Notification Server so that I know when a notebook has gone missing.
The query I am using to match the timestamps is:
SELECT Inv_Operating_System_Summary.Name, MAX(StartTime) as MaxRequestTime FROM Evt_NS_Client_Config_Request INNER JOIN Inv_Operating_System_Summary ON (Evt_NS_Client_Config_Request.ResourceGuid = Inv_Operating_System_Summary._ResourceGuid) GROUP BY Name ORDER BY Name