Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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