Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrades.
Please accept our apologies in advance for any inconvenience this might cause.

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