Dear All, How we can get user firstname, user last name, manager firstname,manager lastname.I tried to create this query but not getting any data however data exist in database. select u1.firstname,u1.lastname,u1.username,u2.firstname,u2.lastname,u2....
Hi Team,I have to create one recon report for specific one endpoint but in that we are also getting null values from user data, Can anybody help me out in correcting the one of getting only active and inactive data of users.I am using below query for...
HI Team,I need to get those roles which dont have any entitlements tagged to it for particular security systems. I tried to get data but it is showing no data found, I am able to get the roles listed under security systems,endpoints but not those rol...
Hi Everyone,I am new to learn how we are connecting with Saviynt Api using JAVA connection and how we are fetching tasks of particular endpoint and tasks type and to process them in Saviynt using Java code So Is there any resources available to learn...
Hey,@rushikeshvartak : I have shared the data in attachment, it is available under my first post of this thread, please have look on this one and let me know is there any solution to avoid null values.Regards,Gagan
Hey @rushikeshvartak : did you get a chance to review my last query. Kindly suggest what we can do next to eliminate such null values from current report.Regards,Gagan
@rushikeshvartak :Below find the latest queryselect ss.SYSTEMNAME as 'Security_System',ep.endpointname as 'Endpoint_Name',r.role_name as 'Rolename',ev.ENTITLEMENT_VALUE as 'Entitlemenet name',u.username as 'USERNAME',u.displayname as 'DISPLAYNAME',CA...
but We are getting account details for all these null data.Requirement is to remove these null data from report. may be due to left join it is causing issue.requirement is to get data for specific endpoint with below mentioned fields,Security_SystemE...
Hey,I tried to made changes at global configuration level for multi User requests, Requests are following mentioned workflow but how will I need to identify the requests are submitted by Admin those request should be auto-approved.what needs to be do...
