Getting Audit logs via report for Usergroup owner addition

[manisha9084]

Hi Team,

We have a report which is designed to show who have added or removed whom from usergroup or savroles.

I need help in a particular case where owner addition to usergroup is not in same Url. So I cannot get both usergroup details and userkey of user added in same line. Can someone please help me.

I am using below query

select distinct t1.AccessTime as 'Access Time', t1.email, t1.Username as 'Username', t1.AccessDetails as 'Access Details', sysdate() as 'Timestamp' from ( select u.email,u.username, accesstime, case
when(access_url like '/user_GroupDetail/saveusergroup/%') then concat('User added to UserGroup via Usergroup Page - Updated Object: ',detail)
when(access_url like '/user_GroupDetail/removeuserfromgroup/%') then concat('User removed from UserGroup via Usergroup Page - Updated Object: ',detail)
when(access_url like '/user_GroupDetail/addOwnerToUserGroup/%') then concat('owner added to UserGroup via Usergroup Page - Updated Object: ',detail)
when(access_url like '/user_GroupDetail/setuserGroupOwnerKeyInSessionSet/%') then concat('owner added to UserGroup via Usergroup Page - Updated Object: ',substring_index(substring_index(QUERY_PARAM,"userkey",-1),",",1),' Updated Object -' ,query_param)
when(access_url like '/user_GroupDetail/removeOwnerFromUserGroup/%') then concat('owner removed from UserGroup via Usergroup Page - Updated Object: ',detail)
end as AccessDetails from users u , userlogin_access ua, userlogins l where l.loginkey = ua.LOGINKEY and l.USERKEY = u.userkey) as t1 where t1.AccessTime >= (NOW() - INTERVAL 10 day) and Accessdetails is not null;

I have added two url to get data, one for owner key , and other for group key. But I need both in same.

Above snapshot, yellow is the correct one, which is properly coming for user member addition, But the red ones are coming in 2 lines.

Thanks

Manisha

[pruthvi_t]

Hi @manisha9084 ,

Greetings.

This is the expected as per the current product behavior. Among the two entries when an owner is added, one entry is to show that the user group as a whole (meta data is being updated) is updated and the second entry is for the change that is made. 

If you have noticed any different behavior in any other version or environment, please let us know so that we can look further into it.

Thanks ,

[manisha9084]

Hi Pruthvi,

For usergroup member addition, we get all details in single line, Group name or key and userkey which was added or removed. 

So why this behaviour is not in Owner addition or removal ?

Thanks

Manisha