and more in a single search tool across platforms. Read the announcement here. |
11/14/2023 11:55 PM - last edited on 11/15/2023 05:54 AM by Sunil
Hi Team,
Client is looking for active accounts who are not utilizing CPAM license (basically not performing Check-out). To find the same,
We would need help in providing data which client is looking for, unique A- account and last used (timestamp)
Thanks!
Regards,
Naren
[This message has been edited by moderator to disable URL hyperlink]
11/15/2023 08:47 PM - edited 11/15/2023 08:48 PM
Hi Naren,
Based on your requirement, you are looking to identify if any request is created for accounts which are of the type "Credential" and perform analysis if any request was raised in last 6 months.
You can try the below query in data analyzer which combines request, task and accounts table to identify if there is any request raised for account of the type credential and will give you the requestID and request date.
You can tailor the query further with date ranges or download report into an excel.
select JBPMPROCESSINSTANCEID,requestdate from ars_requests where requestkey in (select requestkey from arstasks where accountname in (select name from accounts where accountconfig like "%\"pamtype\":\"Credential\"%"))
Regards,
Nirav
11/17/2023 02:57 AM
Hi Nirav,
The requirement is to get list of all users who have not performed password check-out for past 1 year(12 months)
Thanks!
Regards,
Naren
11/22/2023 11:11 PM - last edited on 11/22/2023 11:34 PM by Sunil
Hi @Nirav , Team,
Any updates?
Thanks!
Regards,
Naren
[This message has been edited by moderator to add @ mention]
11/26/2023 08:58 PM
Hi Team,
Any updates?
Thanks!
Regards,
Naren
11/30/2023 01:02 AM
Hi Team,
Any updates pls?
Thanks!
Regards,
Naren
12/04/2023 09:45 PM
Hi Naren,
As per your forum subject "Need to generate report which could give active account not checked-out for last 12 months" - you need account that is not checked out right? You can just reverse the above query to get a list of all accounts not checked out for 'X' months. Please edit the query as per your requirement.
select name from accounts where accountconfig like "%\"pamtype\":\"Credential\"%" and name not in (select accountname from arstasks where requestkey not in (select requestkey from ars_requests where requestdate > "Please specify your duration condition here")));
Regards,
Nirav