Page 1 of 1
Query 4760 accounting tickets with SQL
Posted: 06 Feb 2007 02:39
by gemayel
Does someone know if it is possible and how to access the 4760 SYBASE accounting database and to query accounting CDR's for users without using the accounting application of the omnivista 4760.
So we can use for example SQL to query.
Posted: 16 Feb 2007 13:18
by mgoegel
This is possible.
You can try to connect to ASA with "Interactive SQL" under Start->Programs->Sybase (+ some Submenu)
You have to connect with the DBA user (+ password) to the NMC50 Database.
I can't tell you the complete connection parameters at the moment. In R3.0 i had to use a ODBC connection. I don't know if this is still needed in later releases. In R2.1 i could directly connect to the database.
Which Release do you use?
Posted: 17 Feb 2007 05:31
by gemayel
i am using release 4.0 and 4.1
can you even query archived ticket, the files with archz extension.
Thanks
Posted: 18 Feb 2007 12:53
by frank
Ok, I found my notes about this..
Under START menu, selet Sybase SQL / Adaptive Server / Interative SQL
Login is dba , password is the one that you used when installing the 4760
Under the advanced tab, select JDBC-OBCC bridge (should be selected by default).
Click on CONNECT, and here you go.
Now you can do select * from ticket if you want all tickets..
Hope this helps