Where in SQL is the Agent Health or Last Agent Communication stored

Products

• IT Management Suite

Issue/Introduction

You would like to create a report based on the Symantec Management Agent (SMA) health or last communication from the agent.

Environment

Any version after 7.6 of the Symantec Management Platform (SMP)

Resolution

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)
  • The unique identifier for the computer

• Name                (varchar)
  • Name of the computer

• IsManaged         (Boolean 0 or 1)
  • Is the computer managed (1 = managed) 

• Last Agent Communication  (Date\Time, Null)
  • Date/Timestamp for the last communication from the SMA of any type

• Last Configuration Request    (Date\Time, Null)
  • Date/Timestamp for the last configuration update request from the SMA

• Last Basic Inventory Received  (Date\Time, Null)
  • Date/Timestamp for the last Basic Inventory sent from the SMA  

• Communication Health    (HEALTHY,NEEDSATTENTION,UNMANAGED)
  • Calculated value based on the associated Date/Timestamp above and the threshold assigned in the Targeted Agent Settings Health tab for the group this SMA is a part of.

• Configuration Health    (HEALTHY,NEEDSATTENTION,UNMANAGED)
  • Calculated value based on the associated Date/Timestamp above and the threshold assigned in the Targeted Agent Settings Health tab for the group this SMA is a part of.

• Basic Inventory Health  (HEALTHY,NEEDSATTENTION,UNMANAGED)
  • Calculated value based on the associated Date/Timestamp above and the threshold assigned in the Targeted Agent Settings Health tab for the group this SMA is a part of.  

• Agent Version Health (HEALTHY,NEEDSATTENTION,UNMANAGED)
  • Calculated value based on the versions of the SMA and Plug-ins sent by a Basic Inventory from the SMA and the current version expected Based on the version of SMP that is installed.
     

NOTE: Null and Unmanaged are for computer resources that do not have the SMA installed.