find_org-STAGING.sh

#!/usr/bin/env bash

INPUT=$1

QUERY="select o.id as 'ID', o.slug as 'Slug', o.name as 'Name', b.tier as 'Product Tier', case o.enabled when 1 then 'Enabled' when 0 then 'Disabled' end as 'Org status', b.state as 'State', b.seats_credit as 'Credits', b.seats_prepaid as 'Prepaid', o.created_on as 'Creation Date', b.trial_end as 'Trial End Date', o.last_login as 'Last Login', o.sso_idp as 'SSO IDP entityID' from vo_hier.Organizations o join vo_hier.OrganizationBilling b on b.organization_id = o.id where o.slug LIKE '$INPUT' order by o.enabled desc"


mysql -h hadatabase.stg.den02.victorops.net -D vo_hier -u rouser -v -v -p -e "$QUERY"