Filter by server name Get-ADComputer -Filter {Name -Like $filter} 1

[Herdrich]

Hello all,

Im trying to sort by servers named SACCTX001 - SACCTX999 but everything I have tried seems to not work. What I have currently brings up some extra servers that I do not need I have tried SACCTX[0-9], SACCTX### and SACCTX/n. Does anyone know what I should be using?

$filter = "SACCTX*" 
$ADDomain = "OU=Citrix,OU=Servers,OU=DDC,dc=deltads,dc=ent"
$servers = Get-ADComputer -SearchBase $ADDomain -Filter {Name -Like $filter} | Sort-Object Name | Select-Object -ExpandProperty Name

Thanks,
Glenn

 

[blister911]

What extra servers names are you getting that you don't want?


Light travels faster than sound. That's why some people appear bright until you hear them speak.

 

[blister911]

What about

SACCTX[0-9][0-9][0-9]


Light travels faster than sound. That's why some people appear bright until you hear them speak.

 

[Herdrich]

I will try the SACCTX[0-9][0-9][0-9] in the morning although I believe I have tried that already. I am trying to get things that are like SACCTX123 and NOT like SACCTXABC.

 

[jkspeed]

Another way to write what you are going to try is SACCTX\d{3}.

 

[Herdrich]

I tried SACCTX[0-9][0-9][0-9] and SACCTX\d{3} but it pulled no servers in my full code. Also found out today that I can run the commands I needed on all of the SACCTX* servers so I will just leave it as is. Thanks for the recommendations. I will still toy around with it to see if I can find a solution. My work around was using

$server = $server | findstr /i SACCTX[0-9] | Sort

after the get-adcomputers was ran. I don't think you can use the \d and [0-9] for the -Like variables. I haven't been able to find anything on it so far.

 

[GrimR]

I was playing around see if this helps, hope i'm on the right track

$Variable = "^SACCTX[0-9]"

write-output "$($Variable)"
Get-ADComputer -properties Name, OperatingSystem -Filter *| ?{$_.name -match "$($Variable)"} | Sort-Object Name | Select-Object -ExpandProperty Name

MCSE NT to 2012, MCITP:EA/SA, MCSA, MCDBA, MCTS, MCP+I, MCP

 

[Herdrich]

Nice that works I knew it had something to do with -match because I only found references to [0-9] about -match and not like.