Ahh yes, Extended Queries was what I saw, and it doesn’t seem to work the way I misremembered it did.

Of course, you could always use a shell script with nested SSHs and some awk magic or PowerShell to accomplish the same thing, but sometimes it would be nice to not leave the cDOT CLI.


--
Ian Ehrenwald
Senior Infrastructure Engineer
Hachette Book Group, Inc.
1.617.263.1948 / ian.ehrenwald@hbgusa.com



On 4/10/17, 3:02 PM, "tmac" <tmacmd@gmail.com> wrote:

    On the netapp CLI, you can only include as part of the extended queries subcommands to the command you are working.
    Typically, used with a modify:


    volume modify {-volume *tmp*} -state offline
    -> any volume with tmp in the name, make offline


    --tmac


    Tim McCarthy, Principal Consultant
    Proud Member of the #NetAppATeam <https://twitter.com/NetAppATeam>
    I Blog at TMACsRack <https://tmacsrack.wordpress.com/>

















    On Mon, Apr 10, 2017 at 2:42 PM, Weber, Mark A
    <mark-a-weber@uiowa.edu> wrote:

    Maybe you are thinking of extended queries?
    https://erailine.com/2014/11/20/tours-of-the-black-prompt-clustered-netapp-data-ontap-part-4/ <https://erailine.com/2014/11/20/tours-of-the-black-prompt-clustered-netapp-data-ontap-part-4/>

    you can do what you want from powershell:
    get-ncvolclone | get-ncvolfootprint | select -Property totalfootprint

    but I believe extended queries are just within the same command (and only for modify/delete commands)

    The closest I could get to was:
    vol show -clone-volume true -fields physical-used,size-used-by-snapshots

    but those numbers don't match vol show-footprint

    m

    -----Original Message-----
    From: toasters-bounces@teaparty.net [mailto:toasters-bounces@teaparty.net] On Behalf Of Ehrenwald, Ian
    Sent: Monday, April 10, 2017 1:00 PM
    To: toasters@teaparty.net
    Subject: Subselect-ish behavior?

    Conceptually this is what I’d like to do:

    volume show-footprint -fields total-footprint { volume show -clone-volume true -fields volume }

    Eg, show the total on disk footprint of all FlexClones.

    I could have sworn I saw a very brief example of this on Justin Parisi’s blog, taking the output of one command and feeding it into another.  At the time, I thought “oh that’s cool” and moved on, but now can’t find reference to it.

    Either I don’t remember the syntax, it isn’t supported in 8.3.2, or it never happened and I’m slowly going crazy?


    --
    Ian Ehrenwald
    Senior Infrastructure Engineer
    Hachette Book Group, Inc.
    1.617.263.1948 <tel:1.617.263.1948> /
    ian.ehrenwald@hbgusa.com <mailto:ian.ehrenwald@hbgusa.com>



    This may contain confidential material. If you are not an intended recipient, please notify the sender, delete immediately, and understand that no disclosure or reliance on the information herein is permitted. Hachette Book Group may monitor email to and from
     our network.

    _______________________________________________
    Toasters mailing list
    Toasters@teaparty.net
    http://www.teaparty.net/mailman/listinfo/toasters <http://www.teaparty.net/mailman/listinfo/toasters>

    _______________________________________________
    Toasters mailing list
    Toasters@teaparty.net
    http://www.teaparty.net/mailman/listinfo/toasters <http://www.teaparty.net/mailman/listinfo/toasters>











This may contain confidential material. If you are not an intended recipient, please notify the sender, delete immediately, and understand that no disclosure or reliance on the information herein is permitted. Hachette Book Group may monitor email to and from our network.

_______________________________________________
Toasters mailing list
Toasters@teaparty.net
http://www.teaparty.net/mailman/listinfo/toasters