Computer summary report with last communication detail

[Migration User]

Hello

Looking for Computer summary report with last Communication detail.

Anyone having SQL query for the same???

[Igor Perevozchikov]

Hi CBZ9104,

please check information from this thread:

• https://www-secure.symantec.com/connect/forums/where-last-updated-configuration-table

Thanks,

IP.

[Migration User]

Hi,

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 = '%'

SELECT
	ident.Name
	,MAX(conf_req._eventTime)
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

 

Regards

[sdmayhew]

Igor 

The reports posted by me and others give a better response 

https://www-secure.symantec.com/connect/forums/inactive-machines-report-primary-user

 

[Igor Perevozchikov]

sdmayhew, I didn't want to brake copyrights of your report :- )

[sdmayhew]

if i posted it - it was for the greater good of the community. =) 

[Migration User]

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.

[sdmayhew]

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. 

 

[Migration User]

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