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

How to get GUIDs in CRM

I wanted to get a set of GUIDs of the customers that i have just imported. to explain my requirement,
Let's say i have just inserted 1000  records of customers(accounts). Now I need to export the customers details along the each customer GUID. Is this possible? If possible please explain how to achieve this task.

0
MaduKp
Asked:
MaduKp
3 Solutions
 
stacko111Commented:
The easiest way is to do an Advanced Find for the records then Export them to Excel. The GUIDs will be automatically exported in the first column (Excel sometimes hides this column).

This is for onpremise CRM 4.0 with at least rollup 9 installed.
0
 
rakeshAgarwalCommented:
In sql you can type following query
select accountid
from account
0
 
MaduKpAuthor Commented:
Thanks stacko111, give me some time to check this out.
rakeshAgarwa, Sorry, I don't get you. How can i use SQL to this task? Could you please elaborate the solution?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Aftab_KhateebCommented:
Hi MaduKp

Generally the data that gets imported is stored in one of the database which starts with organization name so it would "<OrganizationName>_MSCRM". In order to extract the data that you have imported with GUIDs the easiest apporach would be to fetch details from the database.

Now I am not sure how your infrastructure is, but i would make an assumption that you have access to SQL Server.
In order to fetch the details of the 1000 accounts you could use any of the below queries to fetch the GUIDS

Make sure you select  your organization_MSCRM database before you execute this query

select name as 'Account Name',accountid as 'Account GUID', createdon as 'CREATED ON'
from filteredaccount
order by name


You can try to fetch using date as well, I am substituting with a dummy date here, so substitute with the date that you have imported those records

select name as 'Account Name',accountid as 'Account GUID', createdon as 'CREATED ON'
from filteredaccount
where createdon between '2010-07-07 00:00:00' and '2010-07-07 23:59:59'
order by name

Once you have done this in SQL you can export the results in a CSV or excel, select all the results  "Ctrl +A' and then right click on the results window. You would see an option called "Save results as" and this would allow you to save the results in to a file


Hope this helps. Let me know if you need any further clarification
0
 
h3753MCommented:
An easy way from the interface would be to do an advanced narrow down to find the records you created and then export the records as a dynamic worksheet.
 When you export as a dynamic worksheet, the guid of the records are on the spreadsheet in a HIDDEN column at the end of the data set.
Unhide the column, save the file as a .csv (to break the dynamic link to CRM), open the file in excel and save as an excel file.
wes
0
 
Aftab_KhateebCommented:
Hi would like to know if you were able to execute the steps i mentioned? If you require any further help let me know
0
 
MaduKpAuthor Commented:
Excellent!
Thanks stacko111, Aftab_Khateeb,  h3753M and rakeshAgarwal.  
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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