[gold-users] list accounts with no active allocations

Kevin Van Workum vanw at sabalcore.com
Thu Dec 22 09:34:49 MST 2011


On Wed, Dec 21, 2011 at 6:32 PM, Scott Jackson <
scottmo at adaptivecomputing.com> wrote:

> 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:
>

That's what I figured.


>
> 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"
>

This seems to list accounts with no active projects and no active
allocations. I actually want accounts with active projects and no active
allocations.


> Scott
>
>
>
> ------------------------------
>
> *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
>
>
>
> _______________________________________________
> gold-users mailing list
> gold-users at supercluster.org
> http://www.supercluster.org/mailman/listinfo/gold-users
>
>


-- 
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.supercluster.org/pipermail/gold-users/attachments/20111222/54076dc7/attachment.html 


More information about the gold-users mailing list