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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.