Endpoint Protection

 View Only

  • 1.  Table for Latest Definitions in SQL Server

    Posted Sep 29, 2012 04:07 AM

    Hello,

       I wanted to know which table in SQL Server contains information for latest definitions installed on each client? Please help.

     

     

     



  • 2.  RE: Table for Latest Definitions in SQL Server



  • 3.  RE: Table for Latest Definitions in SQL Server
    Best Answer

    Broadcom Employee
    Posted Sep 29, 2012 04:21 AM

    select i.computer_name
    , agent_version
    , pat.version as vd_version
    , dateadd(s,convert(bigint,LAST_UPDATE_TIME)/1000,'01-01-1970 00:00:00') lastupdatetime
    , g.name as group_name
    , OPERATION_SYSTEM
    , i.CURRENT_LOGIN_USER
    , i.MAC_addr1
    , i.ip_addr1_text
    , i.DELETED
    from sem_agent as sa with (nolock) left outer join pattern pat on sa.pattern_idx=pat.pattern_idx
    inner join v_sem_computer i on i.computer_id=sa.computer_id
    inner join identity_map g on g.id=sa.group_id
    inner join identity_map p on p.id=sa.last_server_id
    inner join identity_map s on s.id=sa.domain_id
    inner join identity_map q on q.id=sa.last_site_id
    where
    (sa.agent_type='105' or sa.agent_type='151') and sa.deleted='0' and I.DELETED = 0
    order by group_name, operation_system, i.COMPUTER_name



  • 4.  RE: Table for Latest Definitions in SQL Server

    Posted Sep 30, 2012 03:56 AM

    HI Tabish1,

    You can check this thread

    https://www-secure.symantec.com/connect/forums/generate-report-about-virus-definition-installed-all-sep-clients-managed-sepm#comment-6155491

    Check Ian_C Comments

      select i.computer_name
    , agent_version
    , pat.version as vd_version
    , dateadd(s,convert(bigint,LAST_UPDATE_TIME)/1000,'01-01-1970 00:00:00') lastupdatetime
    , g.name as group_name
    , OPERATION_SYSTEM
    , i.CURRENT_LOGIN_USER
    , i.MAC_addr1
    , i.ip_addr1_text
    , i.DELETED
    from sem_agent as sa with (nolock) left outer join pattern pat on sa.pattern_idx=pat.pattern_idx
    inner join v_sem_computer i on i.computer_id=sa.computer_id
    inner join identity_map g on g.id=sa.group_id
    inner join identity_map p on p.id=sa.last_server_id
    inner join identity_map s on s.id=sa.domain_id
    inner join identity_map q on q.id=sa.last_site_id
    where
    (sa.agent_type='105' or sa.agent_type='151') and sa.deleted='0' and I.DELETED = 0
    order by group_name, operation_system, i.COMPUTER_name



  • 5.  RE: Table for Latest Definitions in SQL Server

    Broadcom Employee
    Posted Sep 30, 2012 10:32 PM

    did the query helped?



  • 6.  RE: Table for Latest Definitions in SQL Server

    Posted Oct 03, 2012 01:12 AM

    Yes. It helped. Thanks.