Hi All,
-----------------------
Script :
SELECT TOP 1000000 SI_NAME from ci_systemobjects where children("si_name= 'usergroup-user'", "si_name = 'xxxx Viewers'")
------------------
We are getting SI_Name and User ID data only with the mentioned script,when we run this script in BO_R4_Query Builder
and we are not getting required data(Rolesand status) for users based on the roles.
I need data with SIName |User Id| Role | Status.
Do we get this kind of data with the mentioned script or do we need to enhance the script?
Kindly check the attached image FYI.
Needdata as shown in 1st table.