ANI database and dbReader

[GeorgeLarson]

LMS 2.2

When I use dbreader to show tables for ANI database, I get no tables. I do not get an error message, just the header but no tables. What should I be seeing?

Also, where does it store the Campus Manager data, is it in the ANI database?

[yjdabear]

username: dba/cmfDBA/cwsiSA (ANI)

db name: rme/cmf/ani

The last pair returns this:

Table Information for database: ani

Name Owner Type

...

EmbuPhoneTracking cwsiSA TABLE

EmbuTrafficParamTmpl cwsiSA TABLE

EmbuUserTracking cwsiSA TABLE

...

[GeorgeLarson]

OK, but how about my second question. What I am trying to do is run validation between what is in RME to what is in Campus Manager(Topology Groups).

Which database holds the Campus Manager (Topology Group Data)?

[yjdabear]

In the same ani db, there're a lot Wbu* groups, including a couple of WbuTopo* groups, but I can't make sense of the data with what I see in the Topology Groups in Campus Manager GUI.

Don't know what kind of validation you're looking to do. As you may be aware, there're a couple of tabs in Server Config -> Setup -> ANI Server Admin, to enable "device synchronization" between RME to Campus Manager.

[nhabib]

Topology Groups are in the cmf database.

[GeorgeLarson]

Yes, we do the sync every night, but we want to be able to run a manual (via excel/access) validation between the hosts in the RME and the host that show up in the ANI/Campus Manager.