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.
Query 4760 accounting tickets with SQL
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?
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?
-
gemayel
-
frank
- Alcatel Unleashed Certified Guru
- Posts: 3405
- Joined: 06 Jul 2004 00:18
- Location: New York
- Contact:
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
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
Code Free Or Die
