2 Replies Latest reply on Mar 10, 2015 1:31 PM by Brian Soefje

    How to get a csv report of Load Balancer Configuration

    Brian Soefje
      Share This:

      On the Detail page for the Network Device for a load-balancer there is a section called Services -> Load Balancer.

      I have been trying to duplicate that report using search queries but my attempts so far have failed to eliminate all the repeating data if I attempt to use EXPLODE. I have a customer that wants this data extracted to a csv format. My search abilities are novice. Example picture attached.

      2015-03-09_18-07-45.jpg

        • 1. Re: How to get a csv report of Load Balancer Configuration
          Andrew Waters

          You are not really going to be able to do that. It combines multiple searches together with various formatting. You can start with something like

          SEARCH LoadBalancerInstance

          SHOW

            name,

            #Container:Containment:ContainedService:LoadBalancerService.name AS "Services",

            #Container:Containment:ContainedPool:LoadBalancerPool.name AS "Pools",

            #Container:Containment:ContainedPool:LoadBalancerPool.

              #Container:Containment:ContainedMember:LoadBalancerMember.name AS "Members",

            #Container:Containment:ContainedPool:LoadBalancerPool.

              #Container:Containment:ContainedMember:LoadBalancerMember.

              #Service:SoftwareService:ServiceHost:Host.name AS "Hosts"

          which gets basic information. It is simple to extend a little depending upon what you need.

          1 of 1 people found this helpful
          • 2. Re: How to get a csv report of Load Balancer Configuration
            Brian Soefje

            Thanks Andrew - I figured that was the case.