Load Balance SQL tables

[Patty_Delmott]

Can someone tell me what the names of the Load Balance tables are in SQL?  Specifically, in Studio, if we make a queue load balanced, we select Match Keyword to User Name, and I want to know the table (and associated tables) where the value of that user name is stored.

Thanks.  Patty

[Larissa_Armand]

https://community.hyland.com/forum/threads/57211-sql-query-to-see-load-balanced-members-of-a-queue#R...

[Patty_Delmott]

We are SQL Server, but when I run a query with an & in it, it thinks it's a variable and says Enter Substitution Variable: Enter Value for 0x3000 when I run this query:

select s.statenum, s.statename, u.rolenum, u.rolename
from hsi.lcstate s
left outer join hsi.lcstatexuser x
on s.statenum = x.statenum
left outer join hsi.rolestable u
on u.rolenum = x.usernum
where s.queuetype & 0x3000 = 0x3000

These queries would be helpful if they would run for me, but at the top of the link you provided, it says

This Query should give you all the users assigned to load balancing queues whose members are Users rather than User Groups or Roles  (excluding Match Keyword to User Name load balancing, because that does not define load-balancing members)

Patty