FQDN with test-connection

well, yesterday I was stumbling over an interesting issue. I used the cmdlet "test-connection" and expected either to get the FQDN (Full Qualified Domain Name)  automatically or be able to use some sort of switch in order to get the FQDN. Apparently there is no switch and I must admit I never needed test-connection providing the FQDN.

so that's my solution I came up with and it works pretty well:

$ComputerName = 'MyComputer'
test-connection ([System.Net.Dns]::GetHostByName($ComputerName)).Hostname

If someone has a shorter/quicker/better solution leave a comment

get rid of parts in your string in MSSQL

this little snippet will help you to get rid of parts in strings.  in this case I wanted to get rid of the domain in the following string: 'domain\user'
 

declare @UserNameWithDomain varchar(32)

set @UserNameWithDomain = 'domain\user'

select replace(@UserNameWithDomain, left(@UserNameWithDomain, PATINDEX('%\%',@UserNameWithDomain)),'') as UsernameWithoutDomain

so, the result should be 'user' 

short explanation:

• PATINDEX will find the '\'
• LEFT will use the string from the beginning till the '\' found by PATINDEX
• REPLACE will replace the defined left-string in the variable @UserNameWithDomain with nothing ('')

Download a file from an ftp server in powershell

Define the file you’d like to download and where to save:

$ftpfile = "ftp://ftp.adobe.com/pub/adobe/reader/win/10.x/10.1.2/en_US/AdbeRdr1012_en_US.exe"

$localfile = "C:\temp\AdbeRdr1012_en_US.exe"

Create new-objects. Click on the corresponding links to get information about “system.net.webclient” and “system.uri”

$ftpclient = New-Object system.Net.WebClient

$uri = New-Object System.Uri($ftpfile)

And finally, download the file:

$ftpclient.DownloadFile($uri,$localfile)

Create a message box in powershell

Today I’d like to show how to create a message box in a very simple way:

What we need is some text, a title, the definition of our buttons and an icon for our window.

$text = "This is just a test"

$title = "Testbox"

$Buttons = [System.Windows.Forms.MessageBoxButtons]::OK

$Icon = [System.Windows.Forms.MessageBoxIcon]::Information

So now we got everything we need to pop this window up and we do it with this little command:

[System.Windows.Forms.MessageBox]::Show($text,$title,$Buttons,$Icon)

And that’s the result:

start or create a process in powershell

These are three possibilities to start a process in Powershell. The goal in this particular example is to open a text file called “test.txt” under “C:\temp” with notepad.

First solution -  cmdlet:

start-process -FilePath "$($env:SystemRoot)\notepad.exe" -ArgumentList 'C:\temp\test.txt'

Second solution – dot net:

[System.Diagnostics.Process]::Start("$($env:SystemRoot)\notepad.exe",'C:\temp\test.txt')

Third solution - wmi:

$process = [wmiclass]'Win32_Process'

$process.Create("$($env:SystemRoot)\notepad.exe C:\temp\test.txt")