+ Reply to Thread
Results 1 to 5 of 5
  1. Go ping yourself... phoeneous's Avatar
    Join Date
    Dec 2008
    Location
    Console.WriteLine("Yo");
    Posts
    2,316

    Certifications
    Pimp status
    #1

    Question CAR database queries through ms sql

    Have only tried basic connectivity through ms sql ssms and odbc, but is it possible to query the car database with ms sql? Need to run some detailed reports on calls and using the car ui isnt exactly the best. Suggestions?
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    May 2009
    Location
    DMV
    Posts
    2,201

    Certifications
    CCNP, CCNP(V), S+ CCIE V(written)
    #2
    what kinda reports are you looking for?
    Currently Reading

    CUCM SRND 9x/10, UCCX SRND 10x, QOS SRND, SIP Trunking Guide, anything contact center related
    Reply With Quote Quote  

  4. Go ping yourself... phoeneous's Avatar
    Join Date
    Dec 2008
    Location
    Console.WriteLine("Yo");
    Posts
    2,316

    Certifications
    Pimp status
    #3
    For now, just a basic one but mgmt will progressively want more detail.

    Calling #, called #, timestamp, duration
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    May 2009
    Location
    DMV
    Posts
    2,201

    Certifications
    CCNP, CCNP(V), S+ CCIE V(written)
    #4
    if you are just looking for is basic, you can just have a dump the files and use excel or SQL to clean them up to get what you want. I usually only recommend quires to advanced users, as you are dealing with potentially large data sets(depending on your settings) which can have some adverse affects to your environment.

    The other option is if they are going want more and more detail, just purchase an 3party app designed to pull the data for you and store it. CUCM can erase that data pretty fast depending on your settings.
    Currently Reading

    CUCM SRND 9x/10, UCCX SRND 10x, QOS SRND, SIP Trunking Guide, anything contact center related
    Reply With Quote Quote  

  6. Senior Member pitviper's Avatar
    Join Date
    May 2008
    Location
    Right Coast, US
    Posts
    1,363

    Certifications
    CCNP:Collaboration, CCNP:R+S, CCNA:R+S, CCNA:V(IIUC), CCNA:S, CCENT, CNSS 4011
    #5
    Check out Sideview's Splunk for Cisco CDR - It's relatively cheap and easy to use.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks