Reporting value of UCCE User Variable

[bruce.finney]

All,

Using SQL, where can I find the current value of an ICM User Variable?  I use these for many things including open hours in admin scripts and when special helpdesk messages are ative.  I've been reading the database schema document and it's telling me to look in the t_Persistent_Variable table and yet it is blank.

Thanks in advance for the help

UCCE version 8.5

[bill.king1]

Thanks @dndillon for posting, but in your case what is the "bad" SQL statement that is causing this issue, did TAC say? Like is it some code from another CUIC report definition or something?