Endpoint Protection

 View Only

  • 1.  SEPM Database Schema for LiveUpdate Policy + Location Use Count

    Posted Aug 20, 2014 04:33 AM
      |   view attached

    Hello,

    I want to know which column in which tables from SEPM database that display <Location Use Count> inside SEPM console (Policy> LiveUpdate).

    Appreciate if anyone knows SQL query that calculates count of machines as mentioned above.

     

    Thank you.



  • 2.  RE: SEPM Database Schema for LiveUpdate Policy + Location Use Count



  • 3.  RE: SEPM Database Schema for LiveUpdate Policy + Location Use Count

    Posted Aug 20, 2014 05:32 AM

    Hi James, 

    This is not what I asked for.
    I am asking from database point of view.

     



  • 4.  RE: SEPM Database Schema for LiveUpdate Policy + Location Use Count

    Posted Aug 20, 2014 05:39 AM

    Please see Database Schema

    Symantec Endpoint Protection Manager 12.1.2 Database Schema

    Article:DOC6039 | Created: 2012-09-25 | Updated: 2014-03-14 | Article URL http://www.symantec.com/docs/DOC6039


  • 5.  RE: SEPM Database Schema for LiveUpdate Policy + Location Use Count

    Posted Aug 20, 2014 07:49 AM

    Perhaps you may find it here:

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

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



  • 6.  RE: SEPM Database Schema for LiveUpdate Policy + Location Use Count

    Posted Aug 21, 2014 03:38 AM

    Hi Brian,

    TQ for your sharing on this. 
    I tried searching in both sites before but still no result found.

    I know BASIC_METADATA table stores details about policies, but i don't know which table they relate to this table, in order to generate the count of GROUP machines in the Location Use Count column.

    Appreciate if anyone have more information on this.

    Thanks.