How can I get a list of active Agents (marked as Login Enabled) from AW sql ?

[acerda]

Hi Team, I am looking for a sql query to show me the agents marked as Login Enabled in CCE Admin, we have about 5000 entries but I just need to know the ones Enables.

Many thanks in advance

PCCE 12.0 2K

[Piyush Verma · Accepted solution]

You'll have to look into the "Person" table (instead of Agent table).

select * from Person
where LoginEnabled = 'Y'