02/14/2023 06:42 AM
Hi team,
select u.userkey,u.username,a.accountkey,a.name,E.endpointname,EV.entitlement_value from user_accounts UA, accounts A,users U,endpoints E,account_entitlements1 AE,entitlement_values EV where u.userkey=UA.userkey and UA.accountkey=A.accountkey and A.accountkey = AE.accountkey and AE.entitlement_valuekey=EV.entitlement_valuekey and a.status='1' and u.statuskey='1' and a.endpointkey=E.endpointkey and a.endpointkey='2';
When I run the above query in Analytics-> Analytics Configurations -> using the SQL query option it shows max 10 records only. When I run the same query in Data Analyzer it shows 100+ records.
I need the Analytics option to be worked to extract the records in an excel file.
What could be the issue here?
Thanks,
Gopi.
Solved! Go to Solution.
02/14/2023 06:58 AM
Are you seeing 10 records when you run the analytics or you are talking about preview mode?
02/14/2023 06:59 AM
Hi Gopi,
Try removing the single quotes for endpointkey, status, statuskey columns,
select u.userkey,u.username,a.accountkey,a.name,E.endpointname,EV.entitlement_value from user_accounts UA, accounts A,users U,endpoints E,account_entitlements1 AE,entitlement_values EV where u.userkey=UA.userkey and UA.accountkey=A.accountkey and A.accountkey = AE.accountkey and AE.entitlement_valuekey=EV.entitlement_valuekey and a.status=1 and u.statuskey=1 and a.endpointkey=E.endpointkey and a.endpointkey=2
02/14/2023 07:19 AM
Thanks for helping team. Now its working based on your corrections.
Thanks,
Gopi