Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
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, ...
