• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1271
  • Last Modified:

Dynamics CRM 4.0, SSRS Activities Report, Phone Call, Appointment Fields

I am writing a SSRS Activities report to import into CRM on Email, Phone Call and Appointment activities.  Can anyone tell me where to find the Recipient field for a Phone call activity and the Required field for an Appointment activity.
Thanks.
0
sbdt8631
Asked:
sbdt8631
1 Solution
 
processguruCommented:
The following query will return all names who are any type of recipient for phone calls, and all required attendees for appointments:

SELECT person.partyidname,
     person.participationtypemaskname,
     CRMAF_activity.activitytypecodename
FROM FilteredActivityParty AS person
INNER JOIN FilteredActivityPointer AS CRMAF_activity ON person.activityid = CRMAF_activity.activityid
WHERE CRMAF_activity.activitytypecodename IN ('Phone Call', 'Appointment') 
     AND person.participationtypemaskname IN ('To Recipient','CC Recipient','BCC Recipient','Required attendee')

Open in new window

0
 
sbdt8631Author Commented:
Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now