cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
908
Views
0
Helpful
1
Replies

UCCE SQL database real time table no data

bo liu
Level 4
Level 4

i have a question

i look my UCCE AW sql , the history database like half_hour table have data

but all real time DB no data....but the WEBVIEW real time table is OK......

where the WEBVIEW get the data 

1 Reply 1

Gergely Szabo
VIP Alumni
VIP Alumni

Hi,

there are two databases:

  1. [instance]_awdb;
  2. [instance]_hds.

The first one contains configuration data and realtime data.

The second one contains historical data.

You might want to adjust your SQL queries like this:

SELECT * FROM myicm_awdb.dbo.Agent_Skill_Group_Real_Time

SELECT * FROM myicm_hds.dbo.Agent_Skill_Group_Half_Hour

G.