This content has been marked as final. Show 3 replies
The AWS job, on verbose, might track at that level.
I have a group which was modified yesterday..some users were removed from the group. Today I want to know which users were deleted from this group yesterday.
I checked the Audit Manager but thier was no record and also their is no record in database plumtree.ptauditmsgs table...I can understand the reason of no records as in audit Manager->MainSetting-> Inside Message Type- no object was selected for audit..I selected them now and its showing the audit report for changes made after this modification....
I wanted to know is their any way I can get the audit history of the group for yesterday ..of which membership was changed ..does this value get stored at any other location..may be in any log file?
Thanks for your help!!
I came up with the following query using the following:
SELECT AUDITMSGID, CLASSID, OBJECTID, NAME, USERID, SERVERNAME, AUDITMSGTYPE, AUDITMSGTIME, AUDITMSGCONTENT
where classid='2' and auditmsgcontent like '%removed%'
Classid 2 is the groups and if you look at that in their it shows activity that's why I added the like.
Hope this helps@!