1 2 Previous Next 16 Replies Latest reply: Apr 4, 2012 1:20 PM by lobsters RSS

BLCLI commands with-in Perl script

lobsters

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
    lobsters

    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
    lobsters

    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
    lobsters

    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
    lobsters

    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
    lobsters

    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
    lobsters

    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
    lobsters

    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