HDS db has configuration data

[rona_venida]

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.

[Gergely Szabo · Accepted solution]

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.