• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 524
  • Last Modified:

using Powershell, How to list all servers with region format other than English (Australia) ?

Hi,

Can anyone here please assist me how to modify the script below to display the servers Locale and Regional settings in the domain ?

$path = "C:\temp\"
$serverlist = Get-QADComputer -SearchRoot 'mydomain.local/Servers/Production Servers' -OSName "Windows*Server*" -ShowProgress -Activity
 
foreach ($server in $serverlist){
    $result = Test-Connection $server -Count 1 -Quiet
    if ($result -eq "True") {
         # I need some help here.....
    }
    else {
        Add-Content "$path\OfflineServers.txt" -Value $server
    }
}

Open in new window


because for some servers, I received confusing timestamp MM/DD/YYYY instead of DD/MM/YYYY as the standard in our country.

Thanks,
0
Senior IT System Engineer
Asked:
Senior IT System Engineer
  • 3
  • 3
2 Solutions
 
marek1712Commented:
You can check for this property:
$Host.CurrentCulture

Open in new window

i.e.:
$computers = Get-Content C:\servers.txt
$cred = Get-Credential
foreach ($item in $computers)
{
Invoke-Command -Command {$Host.CurrentCulture} -ComputerName $item -Credential $cred
}

Open in new window

Make sure WinRM is working properly in your company.

THEN, based on the LCID you can do some substring swapping in the conditional statement to get the date in the correct format.
0
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Marek,

will that works for Win2003 host ?
0
 
marek1712Commented:
If it has PowerShell 2.0 installed - yes. Make sure to enable WinRM though (i.e. through winrm quickconfig).
Alternatively - you can check this WMI class, especially Locale and OSLanguage properties.
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Hi marek,

for some server, I got  the following error with WinRM:

[DomainController01-VM] Connecting to remote server failed with the following error message : The client cannot connect to the destination specified in
 the request. Verify that the service on the destination is running and is accepting requests. Consult the logs and documentation for the
WS-Management service running on the destination, most commonly IIS or WinRM. If the destination is the WinRM service, run the following c
ommand on the destination to analyze and configure the WinRM service: "winrm quickconfig". For more information, see the about_Remote_Trou
bleshooting Help topic.
    + CategoryInfo          : OpenError: (:) [], PSRemotingTransportException
    + FullyQualifiedErrorId : PSSessionStateBroken

how to perform Try catch to change the error message into just the server name only that needs to be enabled rahter than the full detailed error message ?

this is your script that I have modified:

$computers = Get-QADComputer -SearchRoot "domain.com/Servers/DC Servers" | Where-Object {(Test-Connection $_.Name -Count 1 -Quiet)}
$cred = Get-Credential -Credential "DOMAIN\Administrator"
ForEach ($item in $computers) {
	try {
		Invoke-Command -ScriptBlock {$Host.CurrentCulture} -ComputerName $item.Name -Credential $cred
	} catch [Exception] {    
	    If ($_.Exception -is [System.Management.Automation.Remoting.PSRemotingTransportException]) {
	        Write-Host "Error while sending command to the " $item.Name " server"
	    } Else {
	        $_.Exception.GetType().FullName
	    } 
	}
}

Open in new window

0
 
marek1712Commented:
What happens when you try to issue winrm quickconfig on these machines by hand?
You can use $ErrorActionPreference variable to handle errors or ErrorVariable to store it in another variable.
You could also use the Split method to cut through the error message and get only the computer name. Try doing it yourself - shouldn't be too hard. If it is - let me know and I'll help you with the script itself.
1
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Marek,

Yes with the winrm quickconfig command it enables the Powershell.

About hundreds of the server is not running so it is going to take very long time to enable it manually one by one.

But as for splitting the error, I'm not sure how to so that since I'm just a beginner in Powershell. I appreciate any help and suggestion so that I can export it to csv for easy read.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

How do you know if your security is working?

Protecting your business doesn’t have to mean sifting through endless alerts and notifications. With WatchGuard Total Security Suite, you can feel confident that your business is secure, meaning you can get back to the things that have been sitting on your to-do list.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now