Execution trail - failed rule extract

[Jaya]

Hi Team,

I have attached a screenshot from execution trail, where we can see there are 31,000+ failed rules.

So can we have an extract of this report for further analysis via analytics as there is no option in UI to get this extract.

[This message has been edited by moderator to mask Company name from an image]

[rushikeshvartak]

Currently feature may not be supported Please submit idea ticket

[Manu269]

@Jaya can you please check this post :

This will generate report  of Audit trail information for all the events in Saviynt

Solved: Saviynt Audit Trail report generation - Saviynt Forums - 40958

[rushikeshvartak]

The ask and above suggestion is different. Ask is about Execution trails for rules and not for Audit Trail

[Manu269]

my bad... this is regarding audit trail.

Lets wait for other folks to respond.

[Jaya]

Thanks for your response @rushikeshvartak @Manu269 

Can we fetch this with analytics query, I think these will be stored somewhere in database.

[rushikeshvartak]

SELECT userrulerundatakey,
       userkey,
       jobgroup,
       changemap,
       ruletype,
       detective,
       birthright,
       processed,
       comments   COMMENT,
       jobid,
       parentjobid,
       updatedate AS UPDATEDAT,
       eventsource,
       ruleactionfailed,
       ruleactionsuccessful,
       trail,
       ruleactiontobefired,
       userhistorykey,
       newdata,
       olddata,
       wsbatchidentifier
FROM   userrulerundata