Syntax to let PowerShell read an object name based on current month name

Question

I am trying to let PowerShell filter a number of objects from a cmdlet and pick an object that has a specific name format.

The name format is always going to be same like below: current Month Name + Year + Workstations

For example the format for current month looks like below: August 2021 Workstations

I tried the below but didn't succeed getting the desired output.

$currentMonth = 
    (Get-UICulture).DateTimeFormat.GetMonthName((Get-Date).Month.ToString())
$LatestSUG = 
    Get-CMSoftwareUpdateGroup | 
        Select-Object LocalizedDisplayName  | 
            Where-Object -Property LocalizedDisplayName -EQ '$currentMonth'

The cmdlet is Get-CMSoftwareUpdateGroup The object name I am trying to filter is LocalizedDisplayName

Thanks very much for any help on this.

You don't need the `Select-Object` and you should use `-match` instead of `-eq` — Olaf, Aug 18 '21 at 09:09

notjustme · Answer 1 · 2021-08-18T09:16:01.820

1

Try removing the single quote around $currentMonth and see if that works better for you.

$currentMonth = (Get-UICulture).DateTimeFormat.GetMonthName((Get-Date).Month.ToString())
    
$LatestSUG = Get-CMSoftwareUpdateGroup | Select-Object LocalizedDisplayName | Where-Object -Property LocalizedDisplayName -match $currentMonth

edited Aug 18 '21 at 09:16

answered Aug 18 '21 at 08:36

notjustme

2,376
2
20
27

How would that help if the `LocalizedDisplayName` is actually much more than just the `$CurrentMonth` and you use the comparison operator `-eq`? ;-) – Olaf Aug 18 '21 at 09:12
When you use `-like` you have to add at least a `*` in front and in the end to get the result you want. ;-) – Olaf Aug 18 '21 at 09:15
Fair enough, on the phone and missed that bit as well as messed the formatting up. Changed to match – notjustme Aug 18 '21 at 09:15
Yes, I know... ;-) – notjustme Aug 18 '21 at 09:17

score 0 · Accepted Answer · answered Aug 18 '21 at 09:14

0

Instead for equality you should check if the LocalizedDisplayName matches the $CurrentMonth ... like this maybe:

$currentMonth = 
    (Get-UICulture).DateTimeFormat.GetMonthName((Get-Date).Month.ToString())
$LatestSUG = 
    Get-CMSoftwareUpdateGroup | 
        Where-Object -Property LocalizedDisplayName -Match $currentMonth

answered Aug 18 '21 at 09:14

Olaf

4,690
2
15
23

Thanks for taking time to look into this question. It helped ! Sorry I came back late. – Mark Aug 26 '21 at 03:08

Syntax to let PowerShell read an object name based on current month name

2 Answers2