I want to use excel get and transform to query the data

Highlighted
Occasional Contributor

where is the customer manager data kept?  I can query exchange data but cant find this data - either online or on the pc -

3 Replies
Highlighted

where is the customer manager data kept?  I can query exchange data but cant find this data - either online or on the pc -

Highlighted

Hi brett.spector null,

 

OCM data is stored as the mailbox data. For example, OCM contacts are stored as normal contacts in an Exchange Online mailbox.

 

Before moving on, I would like to collect the following information:

  1. How do you use Excel to get the query?
  2. What the exact information do you want to query?
  3. Some screenshots about the current situation will be better.

 

Best Regards,

Lance

 

Highlighted

Hi brett.spector null,

 

There are 3 types of data in OCM, Contacts, Companies and Deals. As Contacts data is stored as normal contacts, currently, only the Contacts data can be queried now. If you want the other two types of OCM data to be queried, I'd like to suggest you submit this point of feedback at our User Voice site so that we can review it for upcoming releases.

 

Thanks for your understanding.
Lance