Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2014
    Posts
    3

    Question Unanswered: How to modify this shell script

    I have a script that do:

    1. extract the tags(name,owner,cost.centre) from ec2-describe-instances and write this detail to a file.
    2. Also finds the instances whose any above mentioned tag is missing.

    But it writes detail in a single file.



    #!/bin/bash
    out="Instances"
    ec2-describe-instances | awk -F'\t' -v of="$out" '
    function pr() { # Print accumulated data
    if(id != "") { # Skip if we do not have any unprinted data.
    printf(fmt, id, f[1], f[2], f[3]) > of
    if(f[1] == "") print id > "missing_name"
    if(f[2] == "") print id > "missing_owner"
    if(f[3] == "") print id > "missing_cost.centre"
    }
    # Clear accumulated data.
    id = f[1] = f[2] = f[3] = ""
    }

    BEGIN { # Set the printf() format string for the header and the data lines.
    fmt = "%-12s %-33s %-15s %s\n"
    # Print the header
    printf(fmt, "Instance id", "Name", "Owner", "Cost.centre") > of
    }
    $1 == "TAG" {
    # Save the Instance ID.
    id = $3
    if($4 ~ /[Nn]ame/) fs = 1 # Name found
    else if($4 ~ /[Oo]wner/) fs = 2 # Owner found
    else if($4 ~ /[Cc]ost.[Cc]ent[er][er]/) fs = 3 # Cost center found
    else next # Ignore other TAGs
    f[fs] = $5 # Save data for this field.
    }
    $1 == "RESERVATION" {
    # First line of new entry found; print results from previous entry.
    pr()
    }
    END { # EOF found, print results from last entry.
    pr()
    }'
    if [ -e missing_name ]
    then printf "\nThe following Instance ids are missing names:\n" >> "$out"
    cat missing_name >> "$out"
    rm missing_name
    fi
    if [ -e missing_owner ]
    then printf "\nThe following Instance ids are missing owners:\n" >> "$out"
    cat missing_owner >> "$out"
    rm missing_owner
    fi
    if [ -e missing_cost.centre ]
    then printf "\nThe following Instance ids are missing cost centres:\n" >> "$out"
    cat missing_cost.centre >> "$out"
    rm missing_cost.centre
    fi


    The script is producing the output in a single file:


    Code:
    Instance id Name Owner Cost.centre
    i-c4260db8 Rishi_Win_SAML Rishi Pandey 010-9487
    i-7f4b9300 Sachin_Test Sachin Kumar 010-9487
    i-fb5ca283 CLIQR-DO NOT TOUCH matt 010-9487
    i-44ea8122 sachin_RedHat_VPC
    i-b2f9d8d4 SSO_UBUNTU Gaurav Vinayak 010-9487
    i-07190e28 bacula-server:Harsh harsh 010-9487
    i-9ca559b2 bacula-client:Harsh harsh 010-9487
    i-f637cbd8 Rishi_WindowsMachine Rishi Pandey 010-9487
    i-6879b446 bacula-win-client:Harsh harsh 010-9487
    i-057bb22b Tivoli 1 gaurav vinayak 010-9487
    i-887ab3a6 Tivoli 2 Gaurav Vinayak 010-9487
    i-31b6101f Autoscale_Test_Server Jyoti Bhanot 010-9487
    i-9de654b3 splunk_test_VM Sachin 010-9487
    i-585b2d76 AutoScale_Jyoti Jyoti Bhanot 010-9487
    i-6b0c4645 phywncapp01-prd_AWS Sachin 010-9487
    i-fa1953d4 F5_sachin
    i-e0f1a2ce ecswiki01 matt 010-9487
    i-2da2ff03 Test_sachin_Migration
    i-77c9e859 Sachin_Jenkins_Tomcat
    i-3593b31b CLIQR-DO NOT TOUCH matt 010-9487
    i-7ca28d52 FTP_Test01
    i-e62012c8 SAML_Test Sachin,Rishi 010-9487
    i-e7bab6c9 WA1NETA_SingleDisk_Centos_6_64
    i-b8c1ce96 SingleDisk_Centos_6_64_Migration
    i-58dad076 RDS_Machine (us-east-1d) Jyoti Bhanot 010-9487
    i-73f51252 Win_Ins Rishi Pandey 010-9487
    i-6fca9b3e Chef POC Server Gaurav Vinayak 010-9487
    i-d4411185 Rishi_Win_Okta
    i-bad68beb Test_Script
    i-8dfbc9ac Test_LB_Server_01 Sachin Kumar
    i-ef1524cf Hadoop_test Naveen 010-9487
    i-7446b957 Test_LB_Server_02 Sachin Kumar
    i-551ec976 RDS_Machine (us-east-1c) Jyoti Bhanot 010-9487

    The following Instance ids are missing owners:
    i-44ea8122
    i-fa1953d4
    i-2da2ff03
    i-77c9e859
    i-7ca28d52
    i-e7bab6c9
    i-b8c1ce96
    i-d4411185
    i-bad68beb

    The following Instance ids are missing cost centres:
    i-44ea8122
    i-fa1953d4
    i-2da2ff03
    i-77c9e859
    i-7ca28d52
    i-e7bab6c9
    i-b8c1ce96
    i-d4411185
    i-bad68beb
    i-8dfbc9ac
    i-7446b957


    I want to write the following input in a file that contains the detail of all the instances that have all the tags (name,owner,cost.centre) called
    Code:
    "InstanceDetails_CurrentDate"

    where date is systems current date


    Code:
    Instance id Name Owner Cost.centre
    i-c4260db8 Rishi_Win_SAML Rishi Pandey 010-9487
    i-7f4b9300 Sachin_Test Sachin Kumar 010-9487
    i-fb5ca283 CLIQR-DO NOT TOUCH matt 010-9487
    i-44ea8122 sachin_RedHat_VPC
    i-b2f9d8d4 SSO_UBUNTU Gaurav Vinayak 010-9487
    i-07190e28 bacula-server:Harsh harsh 010-9487
    i-9ca559b2 bacula-client:Harsh harsh 010-9487
    i-f637cbd8 Rishi_WindowsMachine Rishi Pandey 010-9487
    i-6879b446 bacula-win-client:Harsh harsh 010-9487
    i-057bb22b Tivoli 1 gaurav vinayak 010-9487
    i-887ab3a6 Tivoli 2 Gaurav Vinayak 010-9487
    i-31b6101f Autoscale_Test_Server Jyoti Bhanot 010-9487
    i-9de654b3 splunk_test_VM Sachin 010-9487
    i-585b2d76 AutoScale_Jyoti Jyoti Bhanot 010-9487
    i-6b0c4645 phywncapp01-prd_AWS Sachin 010-9487
    i-fa1953d4 F5_sachin
    i-e0f1a2ce ecswiki01 matt 010-9487
    i-2da2ff03 Test_sachin_Migration
    i-77c9e859 Sachin_Jenkins_Tomcat
    i-3593b31b CLIQR-DO NOT TOUCH matt 010-9487
    i-7ca28d52 FTP_Test01
    i-e62012c8 SAML_Test Sachin,Rishi 010-9487
    i-e7bab6c9 WA1NETA_SingleDisk_Centos_6_64
    i-b8c1ce96 SingleDisk_Centos_6_64_Migration
    i-58dad076 RDS_Machine (us-east-1d) Jyoti Bhanot 010-9487
    i-73f51252 Win_Ins Rishi Pandey 010-9487
    i-6fca9b3e Chef POC Server Gaurav Vinayak 010-9487
    i-d4411185 Rishi_Win_Okta
    i-bad68beb Test_Script
    i-8dfbc9ac Test_LB_Server_01 Sachin Kumar
    i-ef1524cf Hadoop_test Naveen 010-9487
    i-7446b957 Test_LB_Server_02 Sachin Kumar
    i-551ec976 RDS_Machine (us-east-1c) Jyoti Bhanot 010-9487




    and the missing tags details in separate file named"MissingTagsInstances_Currentdate"
    with output like this. Even if any tag (name,owner,cost.centre)
    is missing, the script should check and should write missing in there.


    Code:
    Instance id Name Owner Cost.centre

    i-44ea8122 sachin_RedHat_VPC Unknown Unknown
    i-fa1953d4 F5_sachin Unknown Unknown
    i-2da2ff03 Test_sachin_Migration Unknown Unknown
    i-77c9e859 Sachin_Jenkins_Tomcat Unknown Unknown
    i-7ca28d52 FTP_Test01 Unknown Unknown
    i-e7bab6c9 WA1NETA_SingleDisk_Centos_6_64 Unknown Unknown
    i-b8c1ce96 SingleDisk_Centos_6_64_Migration Unknown Unknown
    i-d4411185 Rishi_Win_Okta Unknown Unknown
    i-bad68beb Test_Script Unknown Unknown
    i-7446b957 Test_LB_Server_02 Sachin Kumar Unknown

    SO that i can email these two files to two separate persons.


    any lead is appreciated
    Thanks

  2. #2
    Join Date
    Apr 2014
    Posts
    3

    Question How to modify this script

    This is the actual entire output of
    Code:
    ec2-describe instances is attached in a text file
    Attached Files Attached Files
    Last edited by palakk sharma; 04-03-14 at 01:34.

  3. #3
    Join Date
    Sep 2009
    Location
    Ontario
    Posts
    1,057
    Provided Answers: 1

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •