creationDate.sh

#!/bin/bash

# get list of VMs
VMLIST=`azure vm list --json |jq '. | .[].name'`


for v in $VMLIST
do
    v=`echo $v | sed 's/"//g'`
    echo "looking up $v..."
    # get RG
    rg="$(azure vm list --json |jq '.[] | select( .name == "'"$(eval echo $v)"'") | .resourceGroupName')"

    # get creation time zulu
    creation="$(azure vm get-instance-view --json $(eval echo $rg) $(eval echo $v) |jq '. | .instanceView.statuses[0].time')"

    echo "host: $v creation date: $creation resource group: $rg"
done