Endpoint Protection

 View Only

  • 1.  SEP 11 - SQL Report which shows when Computers were added and deleted

    Posted Oct 13, 2014 05:46 AM

    Hi,

    I am struggling to find a T-SQL solution to determine when Computers were added and deleted.

    Example of query:

    SELECT
        [COMPUTER_NAME],
        dateadd(s,convert(bigint,TIME_STAMP)/1000,'01-01-1970 00:00:00') as CreatedDate,
        dateadd(s,convert(bigint,TIME_STAMP)/1000,'01-01-1970 00:00:00') as DeletedDate
      FROM [sem5].[sem5].[SEM_COMPUTER]
      where [DELETED] = 1

    Any assistance will be greatly appreciated.

     



  • 2.  RE: SEP 11 - SQL Report which shows when Computers were added and deleted

    Posted Oct 13, 2014 05:50 AM

    See SebastianZ  articles if help you.

    Compilation of SQL queries to the SEPM database

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

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

     



  • 3.  RE: SEP 11 - SQL Report which shows when Computers were added and deleted

    Trusted Advisor
    Posted Oct 13, 2014 05:59 AM

    You also may want to consider upgrading to SEP 12.1 RU5 also as SEP goes end of life 6th January 2015 and all support and definitions for the product will stop being produced.