Solved

How to get GUIDs in CRM

Posted on 2010-09-10
7
1,110 Views
Last Modified: 2013-11-24
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
Comment
Question by:MaduKp
7 Comments
 
LVL 7

Accepted Solution

by:
stacko111 earned 167 total points
ID: 33644961
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
 
LVL 11

Expert Comment

by:rakeshAgarwal
ID: 33645271
In sql you can type following query
select accountid
from account
0
 
LVL 10

Author Comment

by:MaduKp
ID: 33652214
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 8

Assisted Solution

by:Aftab_Khateeb
Aftab_Khateeb earned 167 total points
ID: 33658708
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
 
LVL 1

Assisted Solution

by:h3753M
h3753M earned 166 total points
ID: 33662966
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
 
LVL 8

Expert Comment

by:Aftab_Khateeb
ID: 33687899
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
 
LVL 10

Author Closing Comment

by:MaduKp
ID: 33763421
Excellent!
Thanks stacko111, Aftab_Khateeb,  h3753M and rakeshAgarwal.  
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Salesforce.com’s Console is a great tool to view activities, leads, contacts, accounts and opportunities all in one screen. It is particularly effective during call blocks and working numerous activities at a time in a quick, repetitive fashion (suc…
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question