#!/bin/bash

if [ -z "$1" ]; then
    echo "VM name is required"
    exit 1
fi
dbname=$1
dbuser=$2
vmname=$3

psql $dbname -U $dbuser -c "SELECT b.disk_alias, s.description, i.creation_date, s.status as snap, i.imagestatus as img, i.size, i.image_group_id, i.vm_snapshot_id, i.image_guid, i.parentid, i.active FROM images as i JOIN snapshots AS s ON (i.vm_snapshot_id = s.snapshot_id) LEFT JOIN vm_static AS v ON (s.vm_id = v.vm_guid) JOIN base_disks AS b ON (i.image_group_id = b.disk_id) WHERE v.vm_name = '$vmname' ORDER BY creation_date, description, disk_alias"