Archive
Posts Tagged ‘logged in user id’
Getting logged in user’s GUID in CRM reports
July 27, 2012
Leave a comment
We can get the logged in user GUID in the custom reports deployed in CRM using “fn_FindUserGuid()” function
Below is the sample query for the same
DECLARE @currUserId UNIQUEIDENTIFIER
SELECT @currUserId=dbo.fn_FindUserGuid()
PRINT @currUserId
🙂
Categories: CRM, SQL, SSRS
CRM 2011, fn_FindUserGuid, logged in user id, reports, SSRS