Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Pls help on this analytics report

Growit
New Contributor
New Contributor

Request you to please provide the user modification Saviynt report for the Production systems - X and y for the period from 30 July’2024 (00:00:00) to 02 September’2024 (23:59:59) along with IPE screenshots.

Important Note: this report should contain all the following details:

TASK TYPE should contains below details:

1. ADD ACCESS

2. NEWACCOUNT

3. REMOVE ACCESS

4. UPDATE ACCOUNT

5. CHANGEPASSWORD

6. UPDATE USER

7. DELETE ACCOUNT

And, the report should contains all the following columns:

TASK ID

TASK TYPE

PARENT TASK

USER

ACCOUNT

SECURITY SYSTEM

ENDPOINT

ENTITLEMENT

REQUEST ID

REQUESTED FOR

REQUESTED BY

DATE OF REQUEST

USER NAME

USER EMAIL

DOMAIN AD SAM

APPROVED DATE AND TIME

APPROVED BY

APPROVAL TYPE

OWNER

CREATION DATE

TASK STATUS

TASK UPDATE DATE AND TIME

PROVISIONING COMMENTS

Can anyone help for the query

 

 

 

 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

Please share draft query you have prepared.

Refer sample query - https://forums.saviynt.com/t5/identity-governance/reporting-about-request-history/m-p/49124#M29323

https://forums.saviynt.com/t5/tag/SQL_RequestHistory/tg-p


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.