We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Need to fetch loggedIn userkey in the Runtime Analytics configured to Dashboard

tej2099
New Contributor III
New Contributor III

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

4 REPLIES 4

RakeshMG
Saviynt Employee
Saviynt Employee

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


​Regards

Rakesh M Goudar

tej2099
New Contributor III
New Contributor III

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.

RakeshMG
Saviynt Employee
Saviynt Employee

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.

 


​Regards

Rakesh M Goudar

tej2099
New Contributor III
New Contributor III

thanks Rakesh