Endpoint Protection

 View Only

  • 1.  Search using SQL

    Posted Feb 02, 2015 06:10 AM

    Hello Folks,

    Im looking if someone can post me a sql query which will return Client online status, last time status changed for the specifc clients.

     

    Env: 

    12.1.5

    SQL 2008



  • 2.  RE: Search using SQL

    Posted Feb 02, 2015 06:12 AM

    ► Computer Status check - query for listing the computers with either offline (STATUS = 0) or online status (STATUS = 1). Results give the client computer ID and name.

    select SEM_AGENT.COMPUTER_ID, SEM_COMPUTER.COMPUTER_NAME, SEM_AGENT.STATUS
from SEM_AGENT
left join SEM_COMPUTER on SEM_AGENT.COMPUTER_ID = SEM_COMPUTER.COMPUTER_ID
where sem_agent.STATUS = 0

    See SebastianZ articles

    https://www-secure.symantec.com/connect/articles/compilation-sql-queries-sepm-database

    See below thread

    SQL Querys to the database

    https://www-secure.symantec.com/connect/forums/sql-querys-database



  • 3.  RE: Search using SQL

    Posted Feb 02, 2015 06:13 AM

    SebastianZ posted an article on SQL queries

    https://www-secure.symantec.com/connect/articles/compilation-sql-queries-sepm-database