Endpoint Protection

 View Only
Back to discussions
Expand all | Collapse all

Required unique increasing column in Symantec End Point 12.x SQL database

  • 1.  Required unique increasing column in Symantec End Point 12.x SQL database

    Posted Oct 15, 2012 08:27 AM

    Hi All,

     

          I am using Symantec End Point 12. I had a requirement in which I need to write all latest SQL Database records to a file. I wrote a small executable which fetches records from database and writes to files, but I got confused to what column do I need to use as a LastRecordId. I saw that LOG_IDX in v_agent_behavior_log view is the only one which is unique, not in increasing order which cannot be used as lastrecord ID so, can I use it for next fetch which can be used as starting ID.

       So, please suggest me the column which can take it as an Unique Ever Increasing ID.

     

    Thanks

    Santosh Kumar M