CW LMS 3.2 DB Views Integration with HP DDM

[daudette]

Our DDM admin would like to pull device information from LMS. I've enabled DB Views (ODBC) access and tested from my desktop that I can query the data successfully. The DDM admin is telling me DDM requires access to several master tables - sysservers, sysdatabases, syslogins, etc..before he can query the RME/ANI device data. Does anyone know if these master system tables are available, exposed or even exist in LMS? I can't find them.

[Martin Ermel]

The master tables have to exist, otherwise the database would not work.... They automatically gets created when a user database is created.

What I am wondering about is why he needs access to these tables? The information provided in the DB views can be access in the way it is documented here (and you obviously managed to do it)

LMS 3.2:

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/3.2/database_schema/guide/dbviews.html

LMS 4.1

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_lan_management_solution/4.1/database_schema/dbviews_41.html

If you (or the DDM admin) is refering to p.4 of the features of the "Additional Content Pack 10" for DDM here:

http://h20195.www2.hp.com/v2/GetPDF.aspx/4AA3-8538ENW.pdf

the JDBC connect you provided seems ok...