1 2 Previous Next 20 Replies Latest reply: Aug 22, 2014 7:47 PM by Bruce Rosenberg RSS

    BLCLI commands with-in Perl script

    Richard McLeod

      Goal: Populate extended server properties from CMDB export

       

      Background: I wrote several versions of this with NSH/ZSH found that they take forever(2+ hours) to complete for ~20 servers. I have two other environments; ~2000 servers and ~27000 servers respectively. I attempted to run the NSH/ZSH script for the 2000 servers, the job spanned 3 days (weekend) and wasn't finished when I came back to it. NSH/ZSH is a bit messy so I decided to recode it in perl.

       

      Problem: Cannot figure out how to execute the following blcli commands within the perl script:

       

      blcli_connect

      blcli_execute

       

      I've tried assigning to a variable and array, no luck. Any help is appreciated

       

      AppServer=8.0sp6

      NSH Script=Type 4

      dbibexport=full export from cmdb with containing specified fields

       

      Logic: Rather than read each line of the export and looking for a servername match, I am taking each server from BL and grep for that line in the export, reading the line into variables, checking for null variables and then setting the variables to their associative extended property.

       

      Scripts below, thoughts???

      #what i want to do with perl

      #!/usr/bin/perl

       

      $dbibExport="/tmp/dbib_exports/dbib20120316.csv";

      blcli_connect;

      @serverlist=`blcli_execute Server listAllServers`;

      foreach $blservername(@serverlist) {

      $ciProperties=`cat $dbibExport | grep $blservername`;

      @blProperties=split (/,/, $ciProperties);

       

      #blcli_execute commands to set extended properties

       

      }

       

       

       

      #An easier way with while loop - still long and the array indexes seem to point incorrectly

      #!/bin/bash

      oldIFS=$IFS

      dbibExport=/tmp/dbib_exports/dbib20120316.csv

      serverlist=`blcli_execute Server listAllServers`

       

      for blserverName in $serverlist

       

      do

      ciProperties=`cat $dbibExport | grep $blserverName`

      while IFS="," read -A properties; do

      #Setting extended properties

       

      blcli_execute Server setPropertyValueByName $blserverName dbS_HOST_TYPE ${properties[1]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_CLASSIFICATION ${properties[2]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_LIFECYCLE_STATUS ${properties[3]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_SERVER_SUPPORT_GROUP ${properties[4]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_IN_DMZ ${properties[5]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_BRAND ${properties[6]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_MODEL ${properties[7]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_LOCATION ${properties[8]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_CITY ${properties[9]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_COUNTRY ${properties[10]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_REGION ${properties[11]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_HCL_ACCESS ${properties[12]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_SECONDARY_SUPPORT_GROUP ${properties[13]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_TR_SUPPORT_STATUS_HW ${properties[14]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_TR_SUPPORT_STATUS_OS ${properties[15]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_SLA ${properties[16]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_SERVICE_TIER ${properties[17]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_CONSOLE_SERVER_PORT ${properties[18]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_ASSOCIATED_BUS_AREA ${properties[19]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_CC_CODE ${properties[20]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_SERIALNO ${properties[21]}

      blcli_execute Server setPropertyValueByName $blserverName dbS_DISCOVERED_SERIALNO ${properties[22]}

       

      #properties are set, exiting read loop

       

      done <<< "$ciProperties"

      IFS=$oldIFS

      done

       

      #The Easy but long way

      #

      dbibExport=/tmp/dbib_exports/dbibexport-20120316.csv

       

      SERVER_LIST=`blcli_connect; blcli_execute Server listAllServers`

      for bl_serverName in $SERVER_LIST

      do

      ciProps=`cat $dbibExport | grep $bl_serverName`

      IFS="," read dbS_SERVER_NAME dbS_HOST_TYPE dbS_CLASSIFICATION dbS_LIFECYCLE_STATUS dbS_SERVER_SUPPORT_GROUP dbS_IN_DMZ dbS_BRAND dbS_MODEL dbS_LOCATION dbS_CITY dbS_COUNTRY dbS_REGION dbS_HCL_ACCESS dbS_SECONDARY_SUPPORT_GROUP dbS_TR_SUPPORT_STATUS_HW dbS_TR_SUPPORT_STATUS_OS dbS_SLA dbS_SERVICE_TIER dbS_CONSOLE_SERVER_PORT dbS_ASSOCIATED_BUS_AREA dbS_CC_CODE dbS_SERIALNO dbS_DISCOVERED_SERIALNO <<<"${ciProps}"

      if [ -z "${dbS_HOST_TYPE}" ] ; then dbS_HOST_TYPE=MISSING ; fi

      if [ -z "${dbS_CLASSIFICATION}" ] ; then dbS_CLASSIFICATION=MISSING ; fi

      if [ -z "${dbS_LIFECYCLE_STATUS}" ] ; then dbS_LIFECYCLE_STATUS=MISSING ; fi

      if [ -z "${dbS_SERVER_SUPPORT_GROUP}" ] ; then dbS_SERVER_SUPPORT_GROUP=MISSING ; fi

      if [ -z "${dbS_IN_DMZ}" ] ; then dbS_IN_DMZ=MISSING ; fi

      if [ -z "${dbS_BRAND}" ] ; then dbS_BRAND=MISSING ; fi

      if [ -z "${dbS_MODEL}" ] ; then dbS_MODEL=MISSING ; fi

      if [ -z "${dbS_LOCATION}" ] ; then dbS_LOCATION=MISSING ; fi

      if [ -z "${dbS_CITY}" ] ; then dbS_CITY=MISSING ; fi

      if [ -z "${dbS_COUNTRY}" ] ; then dbS_COUNTRY=MISSING ; fi

      if [ -z "${dbS_REGION}" ] ; then dbS_REGION=MISSING ; fi

      if [ -z "${dbS_HCL_ACCESS}" ] ; then dbS_HCL_ACCESS=MISSING ; fi

      if [ -z "${dbS_SECONDARY_SUPPORT_GROUP}" ] ; then dbS_SECONDARY_SUPPORT_GROUP=MISSING ; fi

      if [ -z "${dbS_TR_SUPPORT_STATUS_HW}" ] ; then dbS_TR_SUPPORT_STATUS_HW=MISSING ; fi

      if [ -z "${dbS_TR_SUPPORT_STATUS_OS}" ] ; then dbS_TR_SUPPORT_STATUS_OS=MISSING ; fi

      if [ -z "${dbS_SLA}" ] ; then dbS_SLA=MISSING ; fi

      if [ -z "${dbS_SERVICE_TIER}" ] ; then dbS_SERVICE_TIER=MISSING ; fi

      if [ -z "${dbS_CONSOLE_SERVER_PORT}" ] ; then dbS_CONSOLE_SERVER_PORT=MISSING ; fi

      if [ -z "${dbS_ASSOCIATED_BUS_AREA}" ] ; then dbS_ASSOCIATED_BUS_AREA=MISSING ; fi

      if [ -z "${dbS_CC_CODE}" ] ; then dbS_CC_CODE=MISSING ; fi

      if [ -z "${dbS_SERIALNO}" ] ; then dbS_SERIALNO=MISSING ; fi

      if [ -z "${dbS_DISCOVERED_SERIALNO}" ] ; then dbS_DISCOVERED_SERIALNO=MISSING ; fi

       

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_HOST_TYPE "${dbS_HOST_TYPE}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_CLASSIFICATION "${dbS_CLASSIFICATION}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_LIFECYCLE_STATUS "${dbS_LIFECYCLE_STATUS}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_SERVER_SUPPORT_GROUP "${dbS_SERVER_SUPPORT_GROUP}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_IN_DMZ "${dbS_IN_DMZ}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_BRAND "${dbS_BRAND}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_MODEL "${dbS_MODEL}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_LOCATION "${dbS_LOCATION}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_CITY "${dbS_CITY}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_COUNTRY "${dbS_COUNTRY}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_REGION "${dbS_REGION}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_HCL_ACCESS "${dbS_HCL_ACCESS}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_SECONDARY_SUPPORT_GROUP "${dbS_SECONDARY_SUPPORT_GROUP}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_TR_SUPPORT_STATUS_HW "${dbS_TR_SUPPORT_STATUS_HW}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_TR_SUPPORT_STATUS_OS "${dbS_TR_SUPPORT_STATUS_OS}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_SLA "${dbS_SLA}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_SERVICE_TIER "${dbS_SERVICE_TIER}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_CONSOLE_SERVER_PORT "${dbS_CONSOLE_SERVER_PORT}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_ASSOCIATED_BUS_AREA "${dbS_ASSOCIATED_BUS_AREA}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_CC_CODE "${dbS_CC_CODE}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_SERIALNO "${dbS_SERIALNO}"

      blcli_execute Server setPropertyValueByName $dbS_SERVER_NAME dbS_DISCOVERED_SERIALNO "${dbS_DISCOVERED_SERIALNO}"

      unset IFS

      done <"$ciProps"

       

        • 1. BLCLI commands with-in Perl script
          Bill Robinson

          are you running these in bash or nsh when you use the blcli execute?

           

          also, there is a Server bulkSetPropertyValues command that takes a csv file as input that you should consider using.

           

          w/ perl, if you are calling a exec on the blcli_execute, it's not going to work - it's going to open a new jvm for every call to the blcli.  the only way the performance commands work w/ the performance benefit is to have them run from w/ in the same nsh shell or nsh script.

           

          there are webservices available in 8.1.x that you could access from your perl script.

           

          doing the get and then the set is kind of expensive.  just reset all the values everytime. it should be faster.

          • 2. BLCLI commands with-in Perl script
            Richard McLeod

            Ok so perl is off the table then, thanks for clearing that up.

             

            The scripts are being run via NSH Script Job through the console.

             

            Does the Server bulkSetPropertyValues command parse at all? My CSV has 80000+ lines of server records from the CMDB (values are seperated by commas) the infrastructure I'm importing to has 20 servers. Just don't want to have the script read everyline of the export file.

            • 3. Re: BLCLI commands with-in Perl script
              Bill Robinson

              The bulk import should still work and you may need to bump up the java heap size. also there were some people having problems w/ it recently that posted in this community.

               

              Do you really need to track all of these properties on your server objects – are they actually being used?

               

              Also, is there a way to get only the deltas from the cmdb and load only the changes?  It might be faster to save the last output from the cmdb dump and do a diff instead of trying to pull from bsa.

              • 4. BLCLI commands with-in Perl script
                Richard McLeod

                The Bulk Import seems like a waste of time if you can only set one value per line, I am still going to have to add some processing around the export file to format it as BL requires. I'll give it a go and see what I come up with but I think it is going to add more overhead than I already have.

                 

                As for the number of properties that are being imported, most likely these will be reduced in the future but would rather ensure the method of value delivery works prior to pulling out any unnecessary properties.

                • 5. Re: BLCLI commands with-in Perl script
                  Bill Robinson

                  The bulk import is a single command that processes the whole file.  what is the issue w/ having a single value per line?

                  • 6. BLCLI commands with-in Perl script
                    Richard McLeod

                    I rewrote the script for bulk import... it's running now and conceptually works out of bash shell

                     

                     

                    #!/bin/bash

                    oldIFS=$IFS

                    dbibExport=/tmp/dbib_exports/dbib20120316.csv

                    consolidatedServers=/tmp/dbib_exports/consolidatedservers.csv

                     

                    servlist=`blcli_execute Server listAllServers`

                     

                    for blserverName in $serverlist

                    do

                    ciProperties=`cat $dbibExport | grep $blserverName`

                    while IFS="," read -A properties; do

                    echo $blserverName",dbS_HOST_TYPE,"${properties[1]} >> $consolidatedServers

                    echo $blserverName",dbS_CLASSIFICATION,"${properties[2]} >> $consolidatedServers

                    echo $blserverName",dbS_LIFECYCLE_STATUS,"${properties[3]} >> $consolidatedServers

                    echo $blserverName",dbS_SERVER_SUPPORT_GROUP,"${properties[4]} >> $consolidatedServers

                    echo $blserverName",dbS_IN_DMZ,"${properties[5]} >> $consolidatedServers

                    echo $blserverName",dbS_BRAND,"${properties[6]} >> $consolidatedServers

                    echo $blserverName",dbS_MODEL,"${properties[7]} >> $consolidatedServers

                    echo $blserverName",dbS_LOCATION,"${properties[8]} >> $consolidatedServers

                    echo $blserverName",dbS_CITY,"${properties[9]} >> $consolidatedServers

                    echo $blserverName",dbS_COUNTRY,"${properties[10]} >> $consolidatedServers

                    echo $blserverName",dbS_REGION,"${properties[11]} >> $consolidatedServers

                    echo $blserverName",dbS_HCL_ACCESS,"${properties[12]} >> $consolidatedServers

                    echo $blserverName",dbS_SECONDARY_SUPPORT_GROUP,"${properties[13]} >> $consolidatedServers

                    echo $blserverName",dbS_TR_SUPPORT_STATUS_HW,"${properties[14]} >> $consolidatedServers

                    echo $blserverName",dbS_TR_SUPPORT_STATUS_OS,"${properties[15]} >> $consolidatedServers

                    echo $blserverName",dbS_SLA,"${properties[16]} >> $consolidatedServers

                    echo $blserverName",dbS_SERVICE_TIER,"${properties[17]} >> $consolidatedServers

                    echo $blserverName",dbS_CONSOLE_SERVER_PORT,"${properties[18]} >> $consolidatedServers

                    echo $blserverName",dbS_ASSOCIATED_BUS_AREA,"${properties[19]} >> $consolidatedServers

                    echo $blserverName",dbS_CC_CODE,"${properties[20]} >> $consolidatedServers

                    echo $blserverName",dbS_SERIALNO,"${properties[21]} >> $consolidatedServers

                    echo $blserverName",dbS_DISCOVERED_SERIALNO,"${properties[22]} >> $consolidatedServers

                    done <<< "$ciProperties"

                    IFS=$oldIFS

                    done

                    blcli_execute Server bulkSetServerPropertyValues /tmp/dbib_exports consolidatedservers.csv

                    • 7. BLCLI commands with-in Perl script
                      Richard McLeod

                      The above script runs but returns the following error:

                       

                      Error Mar 28, 2012 2:16:59 PM Command execution failed. com.bladelogic.app.remote.BlRemoteException: com.bladelogic.mfw.util.BlAppServerException: bad record MAC

                       

                      Not sure what this means yet but I suspect it has to do with the bulksetserverproperty command and blank values

                      • 8. Re: BLCLI commands with-in Perl script
                        Bill Robinson

                        Use two double-quotes for blank values.

                        • 9. BLCLI commands with-in Perl script
                          Richard McLeod

                          The script is working 99% all the way up until the last blcli_execute server bulksetserverpropertyvalues command. Not sure if I'm formatting the csv correctly but I keep receiving this error:

                           

                          Error Mar 28, 2012 5:58:04 PM Command execution failed. com.bladelogic.mfw.util.BlException: need 3 entries in add row

                           

                          Is there an example csv file I could view?

                           

                          Here is the current version of the script

                           

                          #Write CMDB CI Properties to BL Extended Properties
                          oldIFS=$IFS
                          rm /tmp/dbib_exports/consolidatedservers.csv
                          touch /tmp/dbib_exports/consolidatedservers.csv
                          echo "consolidated file created"

                          dbibExport=/tmp/dbib_exports/dbib20120316.csv
                          consolidatedServers=/tmp/dbib_exports/consolidatedservers.csv
                          serverlist=`blcli_execute Server listAllServers`

                          echo "serverlist set"

                          #echo "Servername,Property Name,Property Value" >> $consolidatedServers

                          for blserverName in $serverlist
                          do
                          ciProperties=`cat $dbibExport | grep $blserverName`
                          echo "server found" $blservername
                          IFS="," read -A properties <<< "$ciProperties"
                          #Setting extended properties
                          echo "getting properties"
                          echo "$blserverName"",dbS_HOST_TYPE,""${properties[1]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_CLASSIFICATION,""${properties[2]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_LIFECYCLE_STATUS,""${properties[3]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_SERVER_SUPPORT_GROUP,""${properties[4]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_IN_DMZ,""${properties[5]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_BRAND,""${properties[6]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_MODEL,""${properties[7]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_LOCATION,""${properties[8]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_CITY,""${properties[9]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_COUNTRY,""${properties[10]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_REGION,""${properties[11]}""," >> $consolidatedServers
                          echo "$blserverName"",dbS_HCL_ACCESS,""${properties[12]}""," >> $consolidatedServers
                          echo "${blserverName}"",dbS_SECONDARY_SUPPORT_GROUP,""${properties[13]}""," >> $consolidatedServers
                          echo "${blserverName}"",dbS_TR_SUPPORT_STATUS_HW,""${properties[14]}""," >> $consolidatedServers
                          echo "${blserverName}"",dbS_TR_SUPPORT_STATUS_OS,""${properties[15]}""," >> $consolidatedServers
                          echo "${blserverName}"",dbS_SLA,""${properties[16]}""," >> $consolidatedServers
                          echo "${blserverName}"",dbS_SERVICE_TIER,""${properties[17]}""," >> $consolidatedServers
                          echo "${blserverName}"",dbS_CONSOLE_SERVER_PORT,""${properties[18]}""," >> $consolidatedServers
                          echo "${blserverName}"",dbS_ASSOCIATED_BUS_AREA,""${properties[19]}""," >> $consolidatedServers
                          echo "${blserverName}"",dbS_CC_CODE,""${properties[20]}""," >> $consolidatedServers
                          echo "${blserverName}"",dbS_SERIALNO,""${properties[21]}""," >> $consolidatedServers
                          echo "${blserverName}"",dbS_DISCOVERED_SERIALNO,""${properties[22]}""," >> $consolidatedServers
                          echo "properties writtent to output file"
                          #properties are set, exiting read loop
                          IFS=$oldIFS
                          echo "out of the internal loop, IFS reset"
                          done
                          echo "bulk update should be occuring now"
                          blcli_execute Server bulkSetServerPropertyValues /tmp/dbib_exports consolidatedservers.csv


                          • 10. Re: BLCLI commands with-in Perl script
                            Bill Robinson

                            what do you mean 'last blcli_execute bulkSetServerProperties' ?

                             

                            you should only need one call to that command.

                            • 11. BLCLI commands with-in Perl script
                              Tim Biron

                              I just responded to you in the ticket we have on this, but I thought I would update the thread as well for Bill's sake.

                               

                              The problem is likely the extra comma at the end of the line is making the command think there are 4 columns instead of 3.  I've just tested this and got the same error.  Please remove it the extra command at the end of the line from your script and it should clear up the error.

                              • 12. BLCLI commands with-in Perl script
                                Richard McLeod

                                Tim - I've tried removing the commas, still receiving this error

                                 

                                Error Mar 29, 2012 1:35:18 PM Command execution failed. com.bladelogic.shared.csv.ParseException: Encountered "P" at line 6, column 43.

                                 

                                I assume this is occuring during execution of the blcli_execute command (line 57).

                                • 13. Re: BLCLI commands with-in Perl script
                                  Tim Biron

                                  Can you post the generated csv file to the ticket we have open?  This error is a data parsing problem with what is supplied in the csv file, so we just need to see what is at line 6 column 43 and see if there is a formatting issue.

                                  • 14. BLCLI commands with-in Perl script
                                    Richard McLeod

                                    Figured I would add an update and close this thread out.

                                     

                                    The issue with data parsing was caused by spaces in the property values, fixed by using "\"${properties[x]}\"" when writing to the output file.

                                     

                                    Additionally I broke the script out into two parts (pre-processing) and (execution), this was done because NSH's read command does not assign data to an array sequentially (odd implementation), anyway anything that could be done using bash was moved to the pre-processing script which is stored locally on the application server. the execution script creates the serverlist and calls the pre-processing script and then actions the bulk update command. Both attached below if you're interested in the madness

                                     

                                     

                                    #Execution - NSH Script

                                    rm /tmp/dbib_exports/servers.txt

                                    serverlist=`blcli_execute Server listAllServers`

                                    echo $serverlist >> /tmp/dbib_exports/servers.txt

                                    command /tmp/wdsp3.sh

                                    echo "Finished Pre-processing"

                                    echo "bulk update should be occuring now"

                                    blcli_execute Server bulkSetServerPropertyValues /tmp/dbib_exports consolidatedservers.csv


                                     

                                    #Pre-processing - Bash Script

                                    #!/bin/bash

                                    oldIFS=$IFS

                                    rm /tmp/dbib_exports/consolidatedservers.csv

                                    dbibExport=/tmp/dbib_exports/dbib20120316.csv

                                    touch /tmp/dbib_exports/consolidatedservers.csv

                                    consolidatedServers=/tmp/dbib_exports/consolidatedservers.csv

                                    serverlist=`cat /tmp/dbib_exports/servers.txt`

                                    for blserverName in $serverlist

                                    do

                                    ciProperties=`cat $dbibExport | grep $blserverName`

                                    IFS="," read -a properties <<< "$ciProperties"

                                    echo "${blserverName},dbS_HOST_TYPE,""\"${properties[1]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_CLASSIFICATION,""\"${properties[2]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_LIFECYCLE_STATUS,""\"${properties[3]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_SERVER_SUPPORT_GROUP,""\"${properties[4]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_IN_DMZ,""\"${properties[5]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_BRAND,""\"${properties[6]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_MODEL,""\"${properties[7]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_LOCATION,""\"${properties[8]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_CITY,""\"${properties[9]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_COUNTRY,""\"${properties[10]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_REGION,""\"${properties[11]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_HCL_ACCESS,""\"${properties[12]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_SECONDARY_SUPPORT_GROUP,""\"${properties[13]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_TR_SUPPORT_STATUS_HW,""\"${properties[14]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_TR_SUPPORT_STATUS_OS,""\"${properties[15]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_SLA,""\"${properties[16]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_SERVICE_TIER,""\"${properties[17]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_CONSOLE_SERVER_PORT,""\"${properties[18]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_ASSOCIATED_BUS_AREA,""\"${properties[19]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_CC_CODE,""\"${properties[20]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_SERIALNO,""\"${properties[21]}\"" >> $consolidatedServers

                                    echo "${blserverName},dbS_DISCOVERED_SERIALNO,""\"${properties[22]}\"" >> $consolidatedServers

                                    unset properties

                                    done

                                    IFS=$oldIFS

                                     


                                    Tim/Bill - Thanks for the all the help, much appreciated!

                                    1 2 Previous Next