locked
Parse Selected String From Variable RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    I have a script that generates mailbox averages. The following PS command:

    Get-Mailbox -Resultsize Unlimited | Get-MailboxStatistics | %{$_.TotalItemSize.Value.ToGB()} | Measure-Object -Average

    Gives an output like this: 

    Count    : 1563
    Average  : 3.30550621669627
    Sum      :
    Maximum  :
    Minimum  :
    Property :

    How do I take only the "3.30550621669627" and save is as a variable for use elsewhere? 
    Tuesday, February 20, 2018 3:47 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Averaging Gb will give a very inaccurate answer.  It throws away a large part of the number.

    $justthenumber = (Get-Mailbox -Resultsize Unlimited |
           Get-MailboxStatistics |
          %{$_.TotalItemSize.Value.ToGB()} | Measure-Object -Average).Average

    \_(ツ)_/


    • Edited by jrv Tuesday, February 20, 2018 4:28 PM
    • Marked as answer by shadreamer Tuesday, February 20, 2018 5:31 PM
    Tuesday, February 20, 2018 4:27 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote 
    $average = Get-Mailbox -Resultsize Unlimited | Get-MailboxStatistics | 
      %{$_.TotalItemSize.Value.ToGB()} | Measure-Object -Average | Select Average

    If you find that my post has answered your question, please mark it as the answer. If you find my post to be helpful in anyway, please click vote as helpful. (99,108,97,121,109,97,110,50,64,110,121,99,97,112,46,114,114,46,99,111,109|%{[char]$_})-join''


    • Edited by clayman2 Tuesday, February 20, 2018 3:49 PM edit script
    Tuesday, February 20, 2018 3:49 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for the amazingly fast response. Your answer pares it down nicely, but I just want the number, not the "Average" text. 

    This number will change with each run, but should be a consistent length. 

    Tuesday, February 20, 2018 4:04 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Averaging Gb will give a very inaccurate answer.  It throws away a large part of the number.

    $justthenumber = (Get-Mailbox -Resultsize Unlimited |
           Get-MailboxStatistics |
          %{$_.TotalItemSize.Value.ToGB()} | Measure-Object -Average).Average

    \_(ツ)_/


    • Edited by jrv Tuesday, February 20, 2018 4:28 PM
    • Marked as answer by shadreamer Tuesday, February 20, 2018 5:31 PM
    Tuesday, February 20, 2018 4:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    That worked perfectly. Thanks. 
    Tuesday, February 20, 2018 5:31 PM