Database location for Resource Manager summary agent details

[SnappyJY]

Hello,

I am trying to find the location of the Symantec Management Agent Details values in the cmdb database. 

The Values are the dates displayed in the Resource Manager under the Symantec Management Agent Details page.

Last Configuration Request

Last Basic Inventory Sent

Last Event Sent

Does anyone know which tables and field names for each value or have a query with this detail in it?

I attached a pic for refernce. 

[Alex Hedley]

If you filter the Tables by “AeX” you’ll get a list of useful ones, ”Inv_AeX_Identification” has some info. I think it was 8.1 added an “AgentSummary” table that contained more of the flipboard information

[Alex Hedley]

SQL Query for machines with Outdated Agents https://www.symantec.com/connect/articles/sql-query-machines-outdated-agents vAC_AgentHealth —- Symantec Management Agent status showing Need Attention https://www.symantec.com/connect/forums/symantec-management-agent-status-showing-need-attention

[Alex Hedley]

You can use the following Stored Procedure

EXECUTE spGetAltirisAgentDetailsSection @resourceGuid='RESOURCEGUID', @serverTime=0

Get the Resource Guid from the Properties of the Computer.

Example output

CreateTime	RequestTime	UpdateTime	EventTime
First Discovered	Last Configuration Request	Last Basic Inventory Sent	Last Event Sent

You can look into the Stored Procedure to see which Tables this information is being retrieved from.

[TeleFragger]

silly question - how do you look inside a stored procedure?

[Alex Hedley]

Do you use SSMS?

https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/view-the-definition-of-a-stored-procedure

[WDRAIN1]

Here's a sql query that will give you that info!

select
    vc.name [Computer Name]
    ,vc.CreatedDate [First Discovered]
    ,ah.[Last Configuration Request]
    ,ah.[Last Basic Inventory Received]
    ,'Lan ' + convert(varchar,acc.Lan) + '%, WAN ' + convert(varchar,acc.Wan) + '% & Disconnected ' + convert(varchar,acc.None) + '%' Connectivity
    ,agt.Agents
from vcomputer vc
join vAC_AgentHealth ah on ah.ResourceGuid = vc.guid
join Inv_AeX_AC_Client_Connectivity acc on acc._ResourceGuid = vc.Guid
join (  -- agnts
    select _ResourceGuid,
        stuff((select ', ' + [Agent Name] + ' (Version=' + [Product Version] + ')' 
        from Inv_AeX_AC_Client_Agent ag2
        where ag2._ResourceGuid = ag1._ResourceGuid
        for xml path ('') ), 1,1,'') as [Agents]
    from Inv_AeX_AC_Client_Agent ag1
    group by _ResourceGuid
) agt on agt._ResourceGuid = vc.Guid
where vc.name = 'computername'