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.
Does anyone know of a SQL Query that will provide us with a timestamp of when a device was created.For example, you type in the device name of 'CSF123456789' it would spit out the timestamp (date and time) of when it was created?
Hello, does anyone have a SQL query that will export all User Device Profiles in a way that mirrors the BAT tool? The BAT tool, while nice, does not help automate anything. I'm looking for something that mirrors Export User Device Profiles - All Deta...
I know a lot of people have discussed dynamically setting user prompt directories inside a Prompt variable by concatenating two Strings together. I'm trying to do something a little different. In CCE, when a call enters the first scrip you can define...
Does anyone know of a way to run a DB Query in UCCX CLI to see what documents are used? Maybe what prompts are used as well? We are wanting to clean up our old server and see what all is being used.
Thanks!
Does anyone know of a SQL Query that will help us see all current logged in agents for a specific teams? We are converting to UCCE from 3x UCCX clusters and were site gathering now. We have a bunch of different teams and we would like to perform SQL...
So yeah, I couldn't find anything in the Schema. But, then I thought to myself "What kind of developer would not want to include a timestamp for the creation date of anything in a database." It seems pretty neglectful to not have that information, so...
The BAT export tool for getting that data out is so cumbersome and not really fast... The goal is having a higher level view on standardizing things and making sure we have everything in line. I guess as a start, we could only query against the UDP's...
We are running version 12.5.1.15049-1 with devicepack12.5.1.14041-1 installed. We are also running into this issue and the CLI commands do not fix the issue. When you run the query, there is no actual SSH Password there. I blanked it out anyways and ...
@floatingpurrif you're on UCCX, I do not have the fix. For CCE, the fix is below. 1. SSH Into the CUIC Publisher2. Run the below SQL Queryrun sql select * from cuic_data:cuicuser cuic, (select t.ADLoginName, t.personid from cuic_data:cuicuser as c, c...
