and more in a single search tool across platforms. Read the announcement here. |
04/12/2022 01:05 PM
I am understanding $(userEmail} is someone mentioned username in query but it seems not working with new report I made even if it's working with another report.
SELECT
u.username
,u.firstname
,u.lastname
,u.email AS 'User Email'
,u.username AS 'User Username'
,a.name AS 'Account Name'
,a.accountkey as acctKey
,e.endpointkey
,'disableAccount' AS Default_Action_For_Analytics
,u.employeeid AS 'Employee Number'
,u.customproperty17 AS 'Displayname'
Here is part of SELECT Statement I made. could you please tell me what's wrong.
Solved! Go to Solution.
04/12/2022 02:20 PM
Hi
You have to use USERNAME as alias for the u.username and this is case sensitive so only USERNAME will work.