How to find connections which are using given BO application

sdk development
1

Hi all,
I need to find the list of connections which are currently using given BO application.

This query provides all connected users:

SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'Connection'

And category CI_APPOBJECTS contains all BO application e.g.: CMC, Designer, busobjReporter, InfoView, AppFoundation, ReportConvTool, WebIntelligence, Universe
(SELECT * FROM CI_APPOBJECTS WHERE SI_KIND = ‘CMC’)

So I need to know who are using (which connection) given application. There is any solution, please? Or other idea?

Thanks

tuxer (BOB member since 2009-09-15)