HistoryDB - Query specific attribute value

Hello,

I have a custom attribute 'termdate' being backed to history DB since the last 3 years. I can see the value updated when i see the timetrace view on primary DB and also in history DB manager. From which table do i retrieve this value for a user? I got as far as getting the updates to 'termdate' value from watchoperation and watchproperty tables. However it doesnt give the exact value of the termdate. How do i retrieve that?

Thanks in advance for your help,

Sri

Parents Reply Children