Video Screencast Help

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

Created: 15 Oct 2012 • Updated: 18 Dec 2012

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.


Santosh Kumar M