[gold-users] list accounts with no active allocations
scottmo at adaptivecomputing.com
Wed Dec 21 16:32:39 MST 2011
No, there is not a one-liner in Gold to do this -- it is hard enough to do in SQL. But try this SQL query:
psql gold -c "select g_id from g_account except select distinct g_account from g_allocation where g_active='True' order by g_id"
----- Original Message -----
> From: "Kevin Van Workum" <vanw at sabalcore.com>
> To: "gold-users" <gold-users at supercluster.org>
> Sent: Wednesday, December 21, 2011 2:32:34 PM
> Subject: [gold-users] list accounts with no active allocations
> "goldsh Account Query Active:=True" will list accounts with active
> allocations and "goldsh Account Query Active:=False" will list
> accounts with inactive allocations. But is there a oneliner to list
> account with no active allocations?
> Kevin Van Workum, PhD
> Sabalcore Computing Inc.
> Run your code on 500 processors.
> Sign up for a free trial account.
> 877-492-8027 ext. 11
> gold-users mailing list
> gold-users at supercluster.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the gold-users