Witness Database

[tonmanda]

Is there any existing documentation (or possibly database diagrams) of the Database used by Witness?

Im trying to automate a report that gets the number of recordings given a range of dates. I have access to the DB (MSSQL) but no idea what tables to look at.

Thanks a bunch.

 

[ChadStellar]

what version? the structure changes dramatically depending on the version. Support will provide you with a table layout if you ask.

 

[andybond]

Could I please ask a question regarding ContactStore.
I am kinda new to it and would like to know the type of database it is and how you are connecting to it.

Hope that is ok

 

[hartwell]

ill second that andrewhadnett