Solved

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

Posted on 2014-12-22
6
263 Views
Last Modified: 2015-02-12
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
Comment
  • 3
  • 3
6 Comments
 
LVL 11

Accepted Solution

by:
marek1712 earned 500 total points
ID: 40514449
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
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 40514458
Marek,

will that works for Win2003 host ?
0
 
LVL 11

Expert Comment

by:marek1712
ID: 40515769
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 40527069
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
 
LVL 11

Assisted Solution

by:marek1712
marek1712 earned 500 total points
ID: 40527823
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.
0
 
LVL 7

Author Comment

by:Senior IT System Engineer
ID: 40528542
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A project that enables an administrator to perform actions within a user session context not just at the time of login but any time later on day(s) or week(s) later.
A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question