Finding the notes table in Dynamics CRM SQL

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All

I am trying to find the notes field in SQL for any notes or activities notes logged against a fault / case. To clarify, ive found the table "IncidentBase" which contains all my fault tickets, what i now need is the notes and activities (inbound calls/outbound calls) associated to those tickets. The info i need is definitely not stored in the "IncidentBase" table.

Anyone know where this data is stored in SQL ?

*This post is locked for comments

All responses (4)

Answers (1)

Suggested answer

Rajkumar Rajaraman 18,108 on at

Like (0)

Report

RE: Finding the notes table in Dynamics CRM SQL

Please verify if it's useful
Community Member Microsoft Employee on at

Like (0)

Report

RE: Finding the notes table in Dynamics CRM SQL

Thanks to both of you for quick responses ! It was the activityPointerBase i needed but the annotationBase i would have needed at some point anyway, so i appreciated that answer also.
Verified answer

ashlega 34,475 on at

Like (0)

Report

RE: Finding the notes table in Dynamics CRM SQL

Hi,

It's called annotationBase for notes. Activities are more complicated - you will have activityPointerBase, and, then,emailBase, etc.. per activity type.

BTW, you might also want to have a look at the filtered views:

[View:https://technet.microsoft.com/en-us/library/dn531161.aspx]
Suggested answer

Rajkumar Rajaraman 18,108 on at

Like (0)

Report

RE: Finding the notes table in Dynamics CRM SQL

The table name is 'ANNOTATIONBASE'