Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

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.

 

Thanks

Santosh Kumar M