Agents list and in wich campaigns and inbound they can see.

[florin198]

Hello Vicidial forum ! My name is Florin, for about a week I help maintaining a Vicidial box, I need to compile a list with all the agents that have accounts on the box and in this list I must see in which campaigns and inbound groups they can log in, it's easy to compile such a list when you have 10 agents, but when you have 100 or maybe 1000 ? My question is if exists a way to do this task in a reasonable amount of time ?
I also took a look in the Reports section, but I did not succeed to find what I need.
I hope that I made my problem easy to understand

[williamconley]

i do not believe that such a list exists in that manner precisely.

remember, of course, that ingroups membership is partially controlled by campaigns. and campaigns membership is controlled by user groups.

essentially, then, user group pretty much controls all of this and every agent has a usergroup assignment easily viewed on the list of agents all at once.

of course, building a comprehensive list would not be very difficult, but no one has done so as yet.

[florin198]

Thank you William, then I'm out of luck I needed something like in the Reports section to generate this list, something automated because is a Sisyphus work to take each user by hand and verify what they can do and what can't, I will start rolling the rock uphill then.

[williamconley]

Thank you William, then I'm out of luck I needed something like in the Reports section to generate this list, something automated because is a Sisyphus work to take each user by hand and verify what they can do and what can't, I will start rolling the rock uphill then.

if you are in any way adept at mysql, it's not that hard a task. find the settings you activate to allow users into ingroups and then create a mysql query to identify those settings.

[florin198]

I have another problem, I don't have root access to the box or ssh access, I have only web administration privileges, I don't know anything about the box, just "VERSION: 2.6-380a" I'm decent in the usage of the Linux cli, but until now I don't have shell access, I don't know if the provider of the solution could give me such a access type.

[williamconley]

I have another problem, I don't have root access to the box or ssh access, I have only web administration privileges, I don't know anything about the box, just "VERSION: 2.6-380a" I'm decent in the usage of the Linux cli, but until now I don't have shell access, I don't know if the provider of the solution could give me such a access type.

add /phpMyAdmin instead of "/vicidial" to your URL and see if phpMyAdmin is available. if so, your user/pass is "cron/1234". direct db access.

[florin198]

It's not available, any other suggestion ?