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

HDS db has configuration data

rona_venida
Level 1
Level 1

We're having an issue that whenever we try to run an SQL query like this to both AW and HDS db:

select * from t_Agent

we're getting a different data like 624 data on AWdb while 477 on HDS db.

I was advised by Cisco TAC that configuration data is only being stored on AWdb but if that's the case I just want to know why HDS db has 447 configuration data?

Thanks in advance.

1 Accepted Solution

Accepted Solutions

Gergely Szabo
VIP Alumni
VIP Alumni

Hi,

that's correct. The _hds database t_Agent table should be empty.

Actually, it looks like someone was being smart and added filled the t_Agent table manually in the _hds database.

One more thing. It's the Agent table/view you want to use. Never, ever use the t_ tables. They are leaf nodes (real tables) and they are for the ICM's internal use only.

G.

View solution in original post

1 Reply 1

Gergely Szabo
VIP Alumni
VIP Alumni

Hi,

that's correct. The _hds database t_Agent table should be empty.

Actually, it looks like someone was being smart and added filled the t_Agent table manually in the _hds database.

One more thing. It's the Agent table/view you want to use. Never, ever use the t_ tables. They are leaf nodes (real tables) and they are for the ICM's internal use only.

G.