How to select values from mulitple Get statementsHow do I start PowerShell from Windows Explorer?How do I get the current username in Windows PowerShell?How do I get only directories using Get-ChildItem?Select the values of one property on all objects of an array in PowerShellHow to get an object's property's value by property name?Exporting Public Folder ClientAccessPermissions to csvHow do I list permissions/owner info for shared folders in outlook/exchange 2010?How do I select the extended properties of an [Active Directory] object?Separating multiple results onto different linesPowerShell script to delete folder in Users on AD computers

Constant Scan spooling

How to trick a fairly simplistic kill-counter?

"DDoouubbllee ssppeeaakk!!"

When did J.K. Rowling decide to make Harry and Ginny a couple?

Were there any unmanned expeditions to the moon that returned to Earth prior to Apollo?

How can flights operated by the same company have such different prices when marketed by another?

Skipping same old introductions

How did Biff return to 2015 from 1955 without a lightning strike?

Why is “deal 6 damage” a legit phrase?

How to prevent a single-element caster from being useless against immune foes?

Can black block with a hanging piece in a back rank mate situation?

Oath of redemption: Does Emmissary of Peace reflect damage taken from Aura of the Guardian?

Feedback diagram

Is there anyway to harden soft braised carrots?

"Fewer errors means better products" or "Fewer errors mean better products"?

mv Command Deleted Files In Source Directory and Target Directory

Could flaps be raised upward to serve as spoilers / lift dumpers?

Can living where magnetic ore is abundant provide any protection from cosmic radiation?

Help me, I hate squares!

How can a class have multiple methods without breaking the single responsibility principle

Why do MS SQL Server SEQUENCEs not have an ORDER parameter like Oracle?

How to avoid a lengthy conversation with someone from the neighborhood I don't share interests with

UX writing: When to use "we"?

Why doesn't this proof show that the operation on a factor group is well-defined?



How to select values from mulitple Get statements


How do I start PowerShell from Windows Explorer?How do I get the current username in Windows PowerShell?How do I get only directories using Get-ChildItem?Select the values of one property on all objects of an array in PowerShellHow to get an object's property's value by property name?Exporting Public Folder ClientAccessPermissions to csvHow do I list permissions/owner info for shared folders in outlook/exchange 2010?How do I select the extended properties of an [Active Directory] object?Separating multiple results onto different linesPowerShell script to delete folder in Users on AD computers






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















I want to select values from multiple get statements, joined via pipe E.g. I want a report, that shows me Identity and MailEnabled fields from Get-PublicFolder and FolderPath and ItemCount from Get-PublicFolderStatistics.



Following is the code I tried:



Get-PublicFolder -Recurse -resultsize unlimited | select Identity,MailEnabled | Get-PublicFolderStatistics | Select FolderPath, TotalItemSize


I know, I can get the results by using 2 different statements like



Get-PublicFolder "Public FolderName" | select Identity,MailEnabled 


and



Get-PublicFolderStatistics "Public FolderName" | Select FolderPath, TotalItemSize


However, this isn't ideal when I need this report for over 500 Public folders. Can someone please advise, if there is any better way to do this?










share|improve this question






























    0















    I want to select values from multiple get statements, joined via pipe E.g. I want a report, that shows me Identity and MailEnabled fields from Get-PublicFolder and FolderPath and ItemCount from Get-PublicFolderStatistics.



    Following is the code I tried:



    Get-PublicFolder -Recurse -resultsize unlimited | select Identity,MailEnabled | Get-PublicFolderStatistics | Select FolderPath, TotalItemSize


    I know, I can get the results by using 2 different statements like



    Get-PublicFolder "Public FolderName" | select Identity,MailEnabled 


    and



    Get-PublicFolderStatistics "Public FolderName" | Select FolderPath, TotalItemSize


    However, this isn't ideal when I need this report for over 500 Public folders. Can someone please advise, if there is any better way to do this?










    share|improve this question


























      0












      0








      0








      I want to select values from multiple get statements, joined via pipe E.g. I want a report, that shows me Identity and MailEnabled fields from Get-PublicFolder and FolderPath and ItemCount from Get-PublicFolderStatistics.



      Following is the code I tried:



      Get-PublicFolder -Recurse -resultsize unlimited | select Identity,MailEnabled | Get-PublicFolderStatistics | Select FolderPath, TotalItemSize


      I know, I can get the results by using 2 different statements like



      Get-PublicFolder "Public FolderName" | select Identity,MailEnabled 


      and



      Get-PublicFolderStatistics "Public FolderName" | Select FolderPath, TotalItemSize


      However, this isn't ideal when I need this report for over 500 Public folders. Can someone please advise, if there is any better way to do this?










      share|improve this question














      I want to select values from multiple get statements, joined via pipe E.g. I want a report, that shows me Identity and MailEnabled fields from Get-PublicFolder and FolderPath and ItemCount from Get-PublicFolderStatistics.



      Following is the code I tried:



      Get-PublicFolder -Recurse -resultsize unlimited | select Identity,MailEnabled | Get-PublicFolderStatistics | Select FolderPath, TotalItemSize


      I know, I can get the results by using 2 different statements like



      Get-PublicFolder "Public FolderName" | select Identity,MailEnabled 


      and



      Get-PublicFolderStatistics "Public FolderName" | Select FolderPath, TotalItemSize


      However, this isn't ideal when I need this report for over 500 Public folders. Can someone please advise, if there is any better way to do this?







      powershell






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 26 at 23:24









      RaviRavi

      102 bronze badges




      102 bronze badges

























          1 Answer
          1






          active

          oldest

          votes


















          0














          Without testing it, using a foreach and add-member should get you what you are after.



          Get-PublicFolder -Recurse -resultsize unlimited | select Identity,MailEnabled |
          Foreach-Object Select TotalItemSize).TotalItemSize)"






          share|improve this answer
























            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55367613%2fhow-to-select-values-from-mulitple-get-statements%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            Without testing it, using a foreach and add-member should get you what you are after.



            Get-PublicFolder -Recurse -resultsize unlimited | select Identity,MailEnabled |
            Foreach-Object Select TotalItemSize).TotalItemSize)"






            share|improve this answer





























              0














              Without testing it, using a foreach and add-member should get you what you are after.



              Get-PublicFolder -Recurse -resultsize unlimited | select Identity,MailEnabled |
              Foreach-Object Select TotalItemSize).TotalItemSize)"






              share|improve this answer



























                0












                0








                0







                Without testing it, using a foreach and add-member should get you what you are after.



                Get-PublicFolder -Recurse -resultsize unlimited | select Identity,MailEnabled |
                Foreach-Object Select TotalItemSize).TotalItemSize)"






                share|improve this answer













                Without testing it, using a foreach and add-member should get you what you are after.



                Get-PublicFolder -Recurse -resultsize unlimited | select Identity,MailEnabled |
                Foreach-Object Select TotalItemSize).TotalItemSize)"







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Mar 26 at 23:48









                DrewDrew

                1,9161 gold badge5 silver badges19 bronze badges




                1,9161 gold badge5 silver badges19 bronze badges





















                    Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.







                    Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.



















                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55367613%2fhow-to-select-values-from-mulitple-get-statements%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

                    Swift 4 - func physicsWorld not invoked on collision? The Next CEO of Stack OverflowHow to call Objective-C code from Swift#ifdef replacement in the Swift language@selector() in Swift?#pragma mark in Swift?Swift for loop: for index, element in array?dispatch_after - GCD in Swift?Swift Beta performance: sorting arraysSplit a String into an array in Swift?The use of Swift 3 @objc inference in Swift 4 mode is deprecated?How to optimize UITableViewCell, because my UITableView lags

                    Access current req object everywhere in Node.js ExpressWhy are global variables considered bad practice? (node.js)Using req & res across functionsHow do I get the path to the current script with Node.js?What is Node.js' Connect, Express and “middleware”?Node.js w/ express error handling in callbackHow to access the GET parameters after “?” in Express?Modify Node.js req object parametersAccess “app” variable inside of ExpressJS/ConnectJS middleware?Node.js Express app - request objectAngular Http Module considered middleware?Session variables in ExpressJSAdd properties to the req object in expressjs with Typescript