PS Group-Object Feature

Welcome Forums General PowerShell Q&A PS Group-Object Feature

Viewing 3 reply threads
  • Author
    Posts
    • #25963
      Participant
      Topics: 15
      Replies: 18
      Points: 0
      Rank: Member

      Hello community

      I’m wondering if is there any cool way-tip to group some objects by property of time range.
      Guess that we have eventlog objects and we want to group them by time range of one hour

      Something like the following:
      For example starting from 00:00 “hour”:
      Name Value
      ——– ——–
      01:00 10
      02:00 5
      03:00 15
      04:00 20
      05:00 14

      etc

      Thank you in advance!!!

    • #25968
      Participant
      Topics: 1
      Replies: 114
      Points: 121
      Rank: Participant

      You said it right in your post title! Group-Object!

      For event logs, to group by hour, you can do something like this:

      Get-EventLog -LogName Application -Newest 1000 | Group-Object -Property {$_.TimeWritten.Hour}
      
    • #25969
      Member
      Topics: 9
      Replies: 2322
      Points: 0
      Rank: Member

      Absolutely, but first you have to generate a property with that value to group by (or use a constructed property in the call to Group-Object). Assuming that the objects you want to group have a property named “DateTime”, which is a DateTime object, that might look something like this:

      $objects |
      Group-Object -Property { '{0:D2}:00' -f $_.DateTime.Hour }
      
    • #25973
      Participant
      Topics: 15
      Replies: 18
      Points: 0
      Rank: Member

      Thank you very much!!!

      This really helped !!!

Viewing 3 reply threads
  • The topic ‘PS Group-Object Feature’ is closed to new replies.