Share
ReportHow can I search by GUID in CRM On Premise 2016?
*This post is locked for comments
You’re offline. This is a read only version of the page.
How can I search by GUID in CRM On Premise 2016?
*This post is locked for comments
Hi Michael,
There is many way you could found if you know the Entity name(WEB API , FetchXML , Query Expression , Organization Service etc ) . I believe you are not aware the entity name in that case you can search in you database as you are on-premise . Try to execute below reference query , which will search complete database .
www.sqlmatters.com/.../Searching%20all%20columns%20in%20all%20tables%20in%20a%20database.aspx
Hope this helps.
I've written a little bookmarklet for that opens a record by guid.
Just add the following code as a bookmark (tested in chrome only)
All responses (
Answers (
javascript:var loc = window.location; var crmurl = loc.protocol + "//" + loc.host + loc.pathname; var entity = prompt("Enter the records entity typecode or internalname (1 / account)", 1); var etcetn = isDigit(entity) ? "?etc=" : "?etn="; var guid = prompt("Enter the records GUID"); var fullurl = crmurl + etcetn + entity + "&id=" + guid + "&pagetype=entityrecord"; console.log("Opening " + fullurl); window.location = fullurl;
You have to be on any side of your CRM, first it asks for entity typecode or entity name (like 1 or account) then for the guid.
You would need to add a new field to your form. Then populate this field using an on-demand workflow on all records for your entity.
There are a few tools to help you populate this field.
Once the field is populated, you will be able to search it using Advanced Find.
Are you just want to check it one time ?? you have access to Db, you can look for related entity table and search for GUID.
you cant in frontend but you will have to use webAPI to get the required field in javascript from that record.
or a simple way below : crmtipoftheday.com/.../find-a-record-using-id
#1
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
#2
Community Member
54
#3
dkrishna
6
