[gold-users] list accounts with no active allocations

[Scott Jackson]

Kevin, 

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" 

Scott 

----- 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.
> www.sabalcore.com

> 877-492-8027 ext. 11

> _______________________________________________
> gold-users mailing list
> gold-users at supercluster.org
> http://www.supercluster.org/mailman/listinfo/gold-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.supercluster.org/pipermail/gold-users/attachments/20111221/cc9d613b/attachment.html