#!/bin/bash
psql -c "select dir, pipeline_mode, runtime_version, enable32bit from iis_vhost , iis_web_app where iis_vhost.id=iis_web_app.id and iis_vhost.host_id = $1;" -d hsphere | grep -v + | sed -e '1 d' |sed -e 's\ \\g'|head -n -2
