1 Reply Latest reply on Feb 22, 2012 2:12 PM by njoylif

    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.

        • Re: Server Inventory Reporting

          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.