No I'm using the mySQLQueryBrowser  - sometimes I get results back as expected but I often get hung queries. I have to go in and clear the mysql thread servicing the query to continue. I do also have the WSapi but am not using it for this purpose.

that did work thanksI'm having mixed results querying the views - the thread regularly hangs even when only requesting say 100 records.

HiI am unable to execute /opt/cisco/cpam/import/MySQL_Views.sql - it says permission deniedif I try to su the cpamadmin password does not work to elevate privs. It looks like the script is hardcoded to grant select permissions to cpamuser1 - presumab...