11-03-2015 03:28 PM - edited 03-17-2019 04:47 AM
Hi Everyone,
I need to get the list of application users with their assigned persmision group using SQL query.
For example I would like to see something as below:
AppUser Permission Group
********* *********************
user1 Standard CCM Admin Users
user2 Standard CCM Read Only
I would really appriciate if anyone can help me to do this. Thanks
Regrds
BholaS
11-03-2015 11:13 PM
you can use this query filter later based on your requirement but here you will Appuser along with device and permissiongroup.
run sql select au.name as ApplicationUser, d.name as Device, d.description as DeviceDescription, dg.name as PermissionGroup from applicationuser as au inner join applicationuserdevicemap as audm on audm.fkapplicationuser=au.pkid and isstandard ='f' inner join ApplicationUserDirGroupMap as audgm on audgm.fkapplicationuser=au.pkid inner join DirGroup as dg on audgm.fkdirgroup=dg.pkid inner join device as d on d.pkid=audm.fkdevice order by au.name
Br,
Nadeem
PS;Please rate all useful post.
11-03-2015 11:15 PM
I just modified the query now you will get the required result which you are looking for. Test in my lab too. Cheers
applicationuser permissiongroup
=============== =========================================
cuejtapi Standard CTI Enabled
cuejtapi Standard CTI Allow Control of All Devices
cuejtapi Standard CTI Allow Control of All Devices
cuejtapi Standard CTI Enabled
run sql select au.name as ApplicationUser, dg.name as PermissionGroup from applicationuser as au inner join applicationuserdevicemap as audm on audm.fkapplicationuser=au.pkid and isstandard ='f' inner join ApplicationUserDirGroupMap as audgm on audgm.fkapplicationuser=au.pkid inner join DirGroup as dg on audgm.fkdirgroup=dg.pkid inner join device as d on d.pkid=audm.fkdevice order by au.name
Br,
Nadeem Ahmed
PS: Please rate all useful post.
11-04-2015 02:13 PM
Thanks Nadeem,
Above statement is only displaying the application users with device/or CTI Route point associated with it. What I would like is to display all the application users regardless if has got device/ CTI Route Point or not. Would you be able to assist?
Thanks in advance.
BholaS
04-25-2018 05:46 PM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide