7 Replies Latest reply: Aug 28, 2012 2:10 PM by Andrew Waters RSS

    ADDM- not to show a column

    gal sonnenfeld

      Hello!

      Is there an option to make a query and ask the ADDM not to show a column?

       

      I made the following query:

       

      LOOKUP 'b069ab4a1654abc0315104506e47726f7570' TRAVERSE Container:Containment:ContainedItem:Host PROCESS WITH  TRAVERSE InferredElement:Inference:Associate:DiscoveryAccess TRAVERSE DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:NetworkConnectionList TRAVERSE List:List:Member:DiscoveredNetworkConnection PROCESS WITH networkConnectionInfo

       

      But now I can't use the "Customize Columns" option under "Customize" option.

      And I want to edit the columns and the view I got.

       

      For example, I don't want to see the "Local arguments" column.

      How can I do that?

       

      Thanks!

        • 1. Re: ADDM- not to show a column
          Duncan Grisby

          First of all you don't need the first "process with". It doesn't really hurt, but it makes the search a bit less efficient. The query builder sometimes unnecessarily puts them in where it shouldn't.

           

          Anyway, the reason you cannot customize the columns is that the networkConnectionInfo function builds a special kind of result set that cannot be modified the way normal ones can.What you can do is change the columns it chooses to display in the first place. See the documentation at http://discovery.bmc.com/confluence/display/83/Results+Post-Processing#ResultsPost-Processing-networkConnectionInfo

          • 2. Re: ADDM- not to show a column
            gal sonnenfeld

            The "process with" changed two things.

             

            1. Without it, I can customize the table.

            2. With the original query I get 12 columns, without "process with" I get only 5. And, there are columns that I can't reach through (as Remote host name, local host name, local arguments, remote arguments).

             

            Finally, the columns that I do want to see are:

            * Local host name

            * Remote host name

            * Logged in user

             

            Thake you!

            • 3. Re: ADDM- not to show a column
              Brice-Emmanuel Loiseaux

              Trying to use networkConnectionInfo parameters as explained in the doc, here is what I was able to obtain

               

              networkConnectionInfo.jpg

               

              with the following search

               

              Search Host where name like "agni1" TRAVERSE InferredElement:Inference:Associate:DiscoveryAccess TRAVERSE DiscoveryAccess:DiscoveryAccessResult:DiscoveryResult:NetworkConnectionList TRAVERSE List:List:Member:DiscoveredNetworkConnection PROCESS WITH networkConnectionInfo (["name"], ["host name"], [], [])

               

              Hope this helps.

              • 4. Re: ADDM- not to show a column
                gal sonnenfeld

                I am sorry, but it didn't help me at all.

                when I use networkConnectionInfo

                 

                1. I can NOT customize the table.

                2. I get 12 columns, without "process with" I get only 5. And, there are columns that I can't reach through (as Remote host name, local host name, local arguments, remote arguments).

                 

                How can I see a table ONLY with the columns

                * Local host name

                * Remote host name

                * Logged in user

                ???

                • 5. Re: ADDM- not to show a column
                  Andrew Waters

                  You can perform some customisation on the output, exactly as Brice has already indicated.

                   

                  No attempt is made to discover the logged in user, you will need to write a pattern to recover this information.

                  • 6. Re: ADDM- not to show a column
                    gal sonnenfeld

                    Thanks for the information about "Logged in users".

                     

                    Can I customize the output to show me only two columns (Local host name, Remote host name), if I use "PROCESS WITH networkConnectionInfo"?

                    (Please notice that in the picture that Brice sent, there is no "customize" button).

                    How can I do it?

                     

                    Thank you very much for your help.

                    • 7. Re: ADDM- not to show a column
                      Andrew Waters

                      You cannot customise the output using the query builder - as mentioned previously it networkConnectionInfo builds a special kind of result set that cannot be modified in this way.

                       

                      It is not possible to get only local and remote host name out of networkConnectionInfo.

                       

                      You can use hostToHostCommunication but it is most useful if you are starting from a single host as the originating host is not shown.