02/27/2023 03:17 AM
Hi,
We have use case where manager need to see list of his reportees whose customproperty10 is 'Guest' through Dashboard.
To achieve that, we are creating a report(Runtime Analytics) where manager can login to Saviynt and look the dats through Dashboard.
While creating creating report with below queries through error (PFB image)
select u.userkey as USERCONTEXT,u.username AS 'Username', u.FIRSTNAME as 'First Name', u.customproperty10, u.LASTNAME AS 'Last Name', m.username AS 'Manager Username', m.FIRSTNAME AS 'Manager First Name', m.LASTNAME AS 'Manager Last Name' from users u, users m where u.manager = m.userkey and u.statuskey = 1 and m.userkey= ${users.id}
select u.userkey as USERCONTEXT,u.username AS 'Username', u.FIRSTNAME as 'First Name', u.customproperty10, u.LASTNAME AS 'Last Name', m.username AS 'Manager Username', m.FIRSTNAME AS 'Manager First Name', m.LASTNAME AS 'Manager Last Name' from users u, users m where u.manager = m.userkey and u.statuskey = 1 and m.userkey= $loggedInUser.id
Could you please help how to pass loggdedIn userkey in Analytics.
Regards,
Tejeswar Kalluru
02/27/2023 08:13 AM
Please refer to following document and update the query as per your requirement
: https://docs.saviyntcloud.com/bundle/KBAs/page/Content/Queries-for-generating-User-Login-reports.htm
02/28/2023 12:42 AM
Hi Rakesh,
we need to get the loggedIn user details like, when a manager logs in he should see list of reportees who are not meeting criteria should be seen in the Dashboard.
Thanks.
02/28/2023 01:02 AM
Hi @tej2099
This is not available OOTB, you have to create custom analytics and add the same analytics to Dashboard.
select u.username,u.firstname,u.lastname,ul.logintime from userlogins ul,users u where ul.USERKEY=u.userkey and datediff(curdate(),LOGINTIME) < 1 group by DATE_FORMAT(LOGINTIME, "%Y%m%d")
Please add the required conditions to the above query.
02/28/2023 09:29 AM
thanks Rakesh