Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 2Check out the latest updates and new features of Dynamics 365 released from October 2022 through March 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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 ?
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
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
where systemuserid = dbo.fn_FindUserGuid()
if you are looking to get the Guid of a used by name then you can use this script:
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:
and to find the user id by name if you use SA account authentication, then you should query agains table or view:
Hope this helps!
Is your question answered by the above replies.
Business Applications communities