Announcements
No record found.
Hi ,
I need to run a script against the crm database in crm 4.0
and to run that script i need a GUID of a User.
how do i get a Users GUID ?
any idea ?
thanks,
Prabhakar
*This post is locked for comments
if you have access to sql server query system user table to get all the users GUID
select SystemUserid from FilteredSystemUser
or you use advanced find and download data in excel where you will have user guid
Hi Prabhakar,
If you are looking to find current user logged in, for example under SSRS, then you can use:
dbo.fn_FindUserGuid() where it will return the guid
select systemuserid , fullname
from FilteredSystemUser
where systemuserid = dbo.fn_FindUserGuid()
if you are looking to get the Guid of a used by name then you can use this script:
select systemuserid
where fullname= 'Prabhakar'
But using filteredview (filteredsystemuser)
You only can get if you are login to SQL using authorized (windows authentication) CRM User, for example: System Admin of CRM.
If you are using SA, then you cannot find this id using this:
dbo.fn_FindUserGuid()
and to find the user id by name if you use SA account authentication, then you should query agains table or view:
from systemuser
from systemuserbase
Hope this helps!
Thank you.
Is your question answered by the above replies.
Thanks,
Arpita
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Varsha deshpande 5
JS-09031509-0 3
Ciprian P 2
