This is a bit of a evolution from my last post around dumping the CUCM database into a SQLite DB for offline parsing. Now that I have all of the data in a raw format from CM we can start playing with joining other stuff to it. I built a quick CDR script that parses out a CDR export into a SQLite DB as well and started joining those databases for reports. Next I built out a "crawler" type script that steps through the APIs on UCCX and Unity and pushes those results into a DB structure as well. Let the joining begin.