NetPerfMon Database Schema?

I'm working with some folks to use Visio Automation to construct system architecture diagrams and pull data about devices and links out of NPM into Visio objects. Our SQL DBA has copied the database and attempted to produce a schema showing table attrributes & relationships using SQL modeler, but the tables don't come across with their FK relationships. I assume that the database isn't completely flat (could be bad assumption), so how do i reveal the NPM schema?

Find more posts tagged with

visio

npm

orion_npm

orion_database

sql_2005_database

Accepted answers

All comments

kweise

Gordoni,

I don't think the Orion database has relationships created between the tables. I'm no DBA, but I seem to remember reading a post at some point here on Thwack that stated there were no relationships built between tables. If I'm wrong, I'm sure someone on here will correct me!

FormerMember

The majority of our tables don't have foreign keys defined. However, it's usually pretty straight forward to figure out the relationships. For example, the Interfaces table has a NodeID column. This links back to the Nodes table. Interfacetraffic_Detail has an InterfaceID column. This links back to the Interfaces table.

As for why they aren't there, let's just say there's a long, long history involved...