4 Replies Latest reply on Nov 5, 2010 9:29 AM by Ciag

    NCM Reports in NPM Web

    Ciag

      Hi folks,

       I would love to have the ability to include NCM inventory data in Orion NPM reports. Using Report writer as it is much more flexible than the report builder in NCM - would be amazing to be able to able to create queries that would have the ability to combine data from tables in both databases.

      I know things like NODEID's might not be the same in both DB's - in some cases maybe even different IP's are used for node management between NPM and NCM in which case custom properties could be used. We already have shared custom properties in both databases that would be common to each other and given the right facilities would be able to combine data using INNER JOINs.

      Even for the time being if there was the ability to  created combined NPM-NCM reports using the 'Advanced SQL' reports in the report writer that would be great.

      thanks

        • Re: NCM Reports in NPM Web
          christineb

          Hi Ciag - I'll enter this as a feature request. We are looking at several ways to tighten the relationship between NPM and NCM's database, so this is great input for us. 

          --Christine 

          • Re: NCM Reports in NPM Web
            njoylif

            I've got this working, see Make external DB query through web resource thread or the url at bottom.

            I did add custom properties in NCM "orionNodeID" and have some SQL jobs that copy those over BASED ON IP ADDRESS (for node is same).

            I think the NCM import nodes will allow you to import the nodeID from NPM to NCM column of your choice based on IP address as well.

             

             

            Make external DB query through web resource

              • Re: NCM Reports in NPM Web
                christineb

                Hi Larry - thank you for your help!

                --Christine

                • Re: NCM Reports in NPM Web
                  Ciag

                  Thanks for your input it's definitely pointed me inthe right direction. Unfortunately my databases are on different servers so there is one bit of info missing for the query to work and that's where my next question comes in.

                  The missing step I'm talking about is the 'linked servers' option. I would like to 'Link' the NCM server's Dtabase to the NPM Db. I just want to know about the behaviour between the databases if I were add the NCM database as a linked server to my NPM database. Because some of the tables in the two databases share the same names I would like to rule out any possibility of unintentional mix ups due to identical table names.

                  I know that the exsisting queries and paths for the servers/databases/tables should prevent any such mix up but I'm just a little paranoid about these things.