I had quite the collection of SQL queries for the old Unity that were very useful. I am finding it much harder to build queries in Unity Connection. I am looking to build a query in CUDLI that mimics this one that I used in unity:
selects.alias, d.dtmfaccessid, m.alias, m.destinationobjectid, c.alias
fromsubscriber s, menuentry m, callhandler c, dtmfaccessid d
wheres.callhandlerobjectid = m.parentobjectid ands.subscriberobjectid = d.parentobjectid andm.destinationobjectid = c.callhandlerobjectid
order byd.dtmfaccessid
This showed all users caller input settings. If anyone has a similar query for Unity Connection I would appreciate it.
Anyone else think a document on here of useful queries would be handy?
I have been using this one to monitor mailbox sizes now that we are uncoupled from exchange:
Connect to the mailstore database and run
selectdescription, bytesize fromtbl_mailbox order by bytesize
Thanks
Jason
