More discussions in Orion Network Performance MonitorWhere is this place located?
1 Reply Latest reply: Feb 22, 2012 1:12 PM by njoylif RSS

Server Inventory Reporting

mgibson
mgibson Feb 21, 2012 12:09 PM
Currently Being Moderated

Does anyone have any scripts/reports used to get inventory data from NPM (Hardware) and NCM (Hardware/software)?Because these are typically in different Databases, writing the sql code to mesh up data from both is quite difficult.

  • Re: Server Inventory Reporting
    njoylif
    njoylif Feb 22, 2012 1:12 PM (in response to mgibson)
    Currently Being Moderated

    I've got a few things we could do (check content exchange stuff from me...I've got one where I take static routes from NCM and put into NPM so they show up on the map for a device, also serial numbers).

    Basically if you create a few custom properties in ncm (orionnodeid) in ncm nodes and use that with the IP address to verify uniqueness when joining the tables from the 2 DBs.

    Let me know some specifics if you need further guidance/help.

Actions

More Like This

  • Retrieving data ...