How do get CRM username from GUID (SQL)

(0) Share

Report

Posted on by Joe Woltering

12,163

I know I've done thisbefore but I forgot the statement. If I have the guid of a CRM user how to look it up in the database in order to get the 'friendly' name of the user?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

jlattimer 24,562 on at

Like (0)

Report

Something like:

SELECT fullname
FROM systemuser
WHERE systemuserid = 'guid here'

Was this reply helpful? Yes No
Verified answer

Satish Tiwari - CRM on at

Like (0)

Report

You can also look in SystemUserBase table by executing below query against Org_MSCRM

select FullName, * from SystemUserBase where SystemUserId = 'Guid'

Was this reply helpful? Yes No
Verified answer

Guido Preite 54,086 Moderator on at

Like (0)

Report

If it is possible it's better to use the filtered views

SELECT fullname FROM FilteredSystemUser WHERE systemuserid = 'GUID VALUE'

Was this reply helpful? Yes No
Joe Woltering 12,163 on at

Like (0)

Report

Thanks all! It's a very useful query. Comes in handy more often than u think.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

SQL need the CRM user name to enter in this it was the new technique that we use in this it has all the friction on it. I need to get guide of this that was available on writing paper services this was the company who develop this software and they have its manual on it.

Was this reply helpful? Yes No
Faiz Ul Hassan 5 on at

Like (0)

Report

I was getting some errors with the Dynamic Connector trying to sync CRM accounts to NAV customer cards.The first error I had was Country has to be a country code otherwise it errors. Please Suggest on 9anime

Was this reply helpful? Yes No