and more in a single search tool across platforms. Read the announcement here. |
04/04/2024 10:00 AM - last edited on 04/08/2024 11:56 PM by Sunil
I am trying to get the list of updates shown in update history in analytic report by querying on userrulerundata_archive table for a specific user where userkey in 9180 using below query (Attaching the resultset)
select USERRULERUNDATA_ARCHIVEKEY,BIRTHRIGHT,CHANGEMAP,COMMENTS COMMENT,DETECTIVE,EVENTSOURCE,JOBGROUP,JOBID,NEWDATA,OLDDATA,PARENTJOBID,PROCESSED,RULEACTIONFAILED,RULEACTIONSUCCESSFUL,RULEACTIONTOBEFIRED,RULETYPE,TRAIL,UPDATEDATE UPDATEDAT ,USERHISTORYKEY,USERKEY,USERRULERUNDATAKEY,WSBATCHIDENTIFIER from userrulerundata_archive where userkey=9180
You can check "UPDATEDAT" column in attached report, to show the updates on a particular day.
I have couple questions
[This message has been edited by moderator to remove attached files with sensitive info]
04/04/2024 10:46 AM
Do you see information on UI? under audit trail ?
04/04/2024 12:12 PM
What information @rushikeshvartak you want me to check on UI ?
The screenshot I posted above in my earlier comment where status is changing from inactive to active is from UI only.
And When you say audit trail, is it a different database table I need to look into ?
04/04/2024 09:11 PM
04/08/2024 08:35 AM - last edited on 04/08/2024 09:12 AM by Dave
Hello @rushikeshvartak,
I did check and I dont see anything in audit logs.
[This post has been edited by a Moderator to remove sensitive information.]
04/08/2024 07:08 PM
Then it won't be available in database table also. Use userhistory table for same.
04/09/2024 07:08 AM
userrulerundata_archive table for this user is still giving some records as said it my first comment, but not complete data. Where as audit trail is not giving anything. As far as I know audit trail shows data whichever was changed on that user profile manually from UI and not through any jobs or custom queries. If audit trail is not giving anything, I can understand all the userhistory updates happened through jobs and no manual intervention.
So my question was again the same as initially asked, why we are not seeing all the updates happening on userprofile in userrulerundata_archive table, Even though a rule ran when user status was changed.
Regarding user history, can you give an example. How can I use userhistory table, we are on 5.5 and getting from userhistory table changemap column BLOB data is not available.
Please let me know if this not what your suggesting me to do, and you are talking about using userhistory table in different way.
04/09/2024 07:12 AM
5.5 you can’t read blob data upgrade to EIC
check if data exists in userrulerundata. Do you see data under execution trail ?
how rule was triggered via file upload manually or job?
04/09/2024 07:53 AM
@rushikeshvartak What are different columns in userrulerundata table. I don't see this table in https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...
Can you ping me a URL where we have these details about this tables.
The rule was triggered through workday job.
04/09/2024 09:15 AM
select USERRULERUNDATAKEY,USERKEY,JOBGROUP,CHANGEMAP,RULETYPE,DETECTIVE,BIRTHRIGHT,PROCESSED,COMMENTS,JOBID,PARENTJOBID,UPDATEDATE,EVENTSOURCE,NEWDATA,OLDDATA,RULEACTIONFAILED,RULEACTIONSUCCESSFUL,RULEACTIONTOBEFIRED,TRAIL,USERHISTORYKEY from userrulerundata