Database Schema Documentation for Fastpath?

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)