I used to work with Call Manager 4.0 & 4.1(3). I was able to login to the server, jump into SQL, and query whatever I needed. The main thing I queried was CDR's. I am now at a company that runs 7.1(2). I am seeing that since 5.x the CDR table hasn't existed. I tried using the GUI CDR through the web page but it just doesn't get all of what I want to see. I found in one location that the CDR files are now stored in another location due to not being pulled into a database.
Currently to get what I want for anythig other than CDR's I am logging into the Publisher via SSH and querying with "run sql". However I can't do this for CDR.
So my questions are:
1. Is there anything easier to query with these days? I tried the AXL\SOAP Toolkit but it seems to be a waste of time.
2. How can I get my CDR information without using the Web Page GUI? I would rather get the raw output and look at it in Excel.