Hi,
I'm trying to query on mutliple db in Unity, but looks like 'run cuc dbquery' does not allow it.
admin:run cuc dbquery select map.description, u.alias from unitydirdb.tbl_mailboxmap map,unitymbxdb1.tbl_mailbox m,unitydirdb.tbl_globaluser u where...
Would appreciate if you could share BU's feedback.@b.winter When working with large Citrix environments, it's definitely not as easy as just installing latest version and 5 minutes testing
Finally got this working. Here's the correct syntax:
admin:run cuc dbquery unitydirdb select alias from unitydirdb:tbl_globaluser,unitymbxdb1:tbl_mailbox,unitydirdb:tbl_mailboxmap where mailboxobjectid=mailboxid and objectid=userobjectid and descript...
Hi Anoop,
I'm well aware you need to provide a db name, but as my query joins tables from 2 databases, you can't just put one as database_name. Not working with 2 either.
with one db defined:
admin:run cuc dbquery unitydirdb select map.description, ...
