This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Server Inventory Reporting

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.

  • 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.