OpenFire has a nice html document supporting the field level definition of the database schema. Is there anything available like that for the Fastpath Schema? Hunted and googled around for a bit but was unable to locate.
No there currently is not. I’m working on one however.
We are trying to find out which Fastpath workgroups have a particular agent. A Fastpath database schema might be helpful in this regard. How is your work on one going, Ninjatek?
Our DBA used the following query to find the workgroups of which agents are members:
Select
a1.jid,
d1.AGENTJID,
a1.workgroupid,
e1.emailaddress
from FPWORKGROUP a1
left
join FPOFFLINESETTING e1
on ( e1.workgroupid = a1.workgroupid)
join FPQUEUE b1
on ( b1.workgroupid = a1.workgroupid)
join FPQUEUEAGENT c1
on ( c1.queueid = b1.queueid)
join FPAGENT d1
on ( d1.agentid = c1.objectid)