Looking for Computer summary report with last Communication detail.
Anyone having SQL query for the same???
please check information from this thread:
maybe it is not beautiful query, but helps me a lot.
It is just last config request per host:
DECLARE @comp_name nvarchar(50)
SET @comp_name = '%'
FROM Evt_NS_Client_Config_Request AS conf_req
JOIN Inv_AeX_AC_Identification AS ident
ON conf_req.ResourceGuid = ident._ResourceGuid
WHERE ident.Name LIKE '%'+@comp_name+'%'
GROUP BY ident.Name
ORDER BY ident.Name
The reports posted by me and others give a better response
sdmayhew, I didn't want to brake copyrights of your report :- )
if i posted it - it was for the greater good of the community. =)
In ITMS 7.6 there are some views allowing to collect information about agent connectivity with Notification Server.
vAC_AgentHealth and based on it
vAC_AgentCommunicationHealth - view returning latest communication time from agent to Notification Server ,
vAC_AgentConfigurationHealth - view returning latest time when agent requested configuration policy from Notification server
vAC_AgentBasicInventoryHealth - view returning latest time when Notification Server received basic inventory from agent.
The views pull from the same fields I have in my sql query.
the issue with the agent health in V7.6 is it does not return the Full inventory time. Which is driven by a policy - so i put in for a field someplace that tracks the last full inventory cycle time.
Its one of those things if you actually use the Inventory reports to the depth of the information provided - you must have full inventories.
This is kind of a cheat but I use the client date field from basic inventory.
This is a field that reports what time the computer believed it was when sending basic inventory. It is not 100 percent infallible but on the other hand it does not require processing for the MAX value.
AEX AC Identdification.Client Date