WebNM - ODBC access to Inventory

Denika Performance Trender™ is a 100% web configurable view into the performance of your IT and IS resources. Denika answers: How much of the resource (network bandwidth, CPU, hard drive, etc.) is being consumed? What is the Up-Time of an important application, server and or network device? What is the Response-Time of an important application, server and or network device?

Moderators: scottr, Moderator Team

Locked
kstamand
Posts: 3
Joined: Tue Apr 03, 2007 6:13 am

WebNM - ODBC access to Inventory

Post by kstamand » Wed Feb 10, 2010 7:14 am

Currently running Denika 7.0 and from the "Menu" we also have a link to WebNM | Inventory. From this inventory, we are able to get a list of all our network gear along with key information - IP Address, Host Name, serial number, IOS version, ChassisID, Location, Contact Information. We have also made use of the "Notes" field to give us some categorization capabilities.

Couple of questions;

* Can we access this information via external ODBC (MySQL) calls? If yes, anything you can point me at for reference.

* If WebNM is not the right tool to query for this information, what should I use instead?

Our goal is to be able to give Network Engineers at different Operating Companies, the capability to query and extract into a spread sheet network gear they are responsible for (utilizing the Notes categorization).

Thanks in advance.

mkrygeri
Posts: 97
Joined: Tue Aug 02, 2005 9:47 am

Re: WebNM - ODBC access to Inventory

Post by mkrygeri » Wed Feb 10, 2010 9:40 am

Yes, you can access the information via ODBC. You can download the MySQL ODBC connector from http://dev.mysql.com/downloads/connector/odbc/

Are you familiar with the Schema or do you need a little help there?

Mike K.

kstamand
Posts: 3
Joined: Tue Apr 03, 2007 6:13 am

Re: WebNM - ODBC access to Inventory

Post by kstamand » Wed Feb 10, 2010 9:52 am

It's the schema I need a little help with --> which DB / Table(s) I should be looking at to get the fields of information I noted in my original post.

Thanks much.

mkrygeri
Posts: 97
Joined: Tue Aug 02, 2005 9:47 am

Re: WebNM - ODBC access to Inventory

Post by mkrygeri » Wed Feb 10, 2010 10:16 am

The database is: webnm
The table is: invmgr_inventory


Everything should be pretty self-explanatory as far as the columns go.

Let me know if you have any more questions.

Locked

Who is online

Users browsing this forum: No registered users and 1 guest