Can I query the Termination CallDetail table from the AW/HDS machine? I understand that it is not advisable to do so from the Logger machines. Will the performance get affected in any way when this TCD table is queried in the AW/HDS machine?
I was trying to lead you in the right direction. The HDS is the historical store - that's where you should look. Why look in the AW database? That holds config data and real-time data.
The poster above is indicating that if you need to "translate" the data coming from the TCDs into config data you need to join across the databases.
I just call the tables like so:
At the beginning of the query I do =
"use ssc_hds" (no quotes)
and when I call tables from the AW db =
ssc_awdb.dbo.t_Agent" (no quotes)