You would like to create a report based on the Symantec Management Agent (SMA) health or last communication from the agent.
Any version after 7.6 of the Symantec Management Platform (SMP)
The view in SQL to reference is vAC_AgentHealth.
This table returns the following about each known computer resource in the environment: ( In the format: Column Name (expected value) )
ResourceGuid
(Guid)
Name
(varchar)
IsManaged
(Boolean 0 or 1)
Last Agent Communication
(Date\Time, Null)
Last Configuration Reques
t (Date\Time, Null)
Last Basic Inventory Received
(Date\Time, Null)
Communication Health
(HEALTHY,NEEDSATTENTION,UNMANAGED)
Configuration Health
(HEALTHY,NEEDSATTENTION,UNMANAGED)
Basic Inventory Health
(HEALTHY,NEEDSATTENTION,UNMANAGED)
Agent Version Health
(HEALTHY,NEEDSATTENTION,UNMANAGED)
NOTE
: Null and Unmanaged are for computer resources that do not have the SMA installed.