How to find all files were uploaded for rulesets changes(new/update)

[RakeshMG]

Use Case / Problem Statement

To find all files uploaded for rulesets changes(new/update)

Application Version

All

Steps to be performed

• Below query can be used to find out the location of all the files uploaded for ruleset changes. 
• This specifically helps because you can identify which file was uploaded along with its server upload location when the file was uploaded and by whom. 
• The consolidated view helps immensely in audits where rulesets changes upload files need to be provided as evidence quickly as ruleset change history is not captured within Saviynt.  

SELECT 

    u.username,

     CONCAT(u.FIRSTNAME, ' ', u.LASTNAME) AS 'Display Name',

    ua.ACCESSTIME AS 'UPLOADEDTIME',

    ua.DETAIL

FROM

     userlogin_access ua

        LEFT JOIN

    userlogins ul ON ul.LOGINKEY = ua.loginkey

        LEFT JOIN

    users u ON ul.userkey = u.userkey

WHERE

    access_url = '/rulesets/execute'

        AND DETAIL IS NOT NULL;

Below is sample output of the query: