Finding the notes table in Dynamics CRM SQL

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Rajkumar Rajaraman on at

Like (0)

Report
Copy link

Link copied!

The table name is 'ANNOTATIONBASE'

Was this reply helpful? Yes No
Verified answer

ashlega 34,477 on at

Like (0)

Report
Copy link

Link copied!

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]

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Rajkumar Rajaraman on at

Like (0)

Report
Copy link

Link copied!

Please verify if it's useful

Was this reply helpful? Yes No