March 2010 – Page 2 – Knowledgebase

To combine (join) physical and relative filesystem paths in PowerShell, use Join-Path

25 March, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to combine the physical path C:\ with a relative path “Temp” in PowerShell, Use Join-Path PS C:\Users\rLisdonk> Join-Path "C:\" "\Temp" C:\Temp PS C:\Users\rLisdonk> Join-Path "C:\" "Temp" C:\Temp PS C:\Users\rLisdonk> Join-Path "C:"

How to grant “Log on as a service” rights to an user account, using PowerShell

24 March, 2010 Roel van Lisdonk 10 Comments 1 category

If you want to grant “Log on as a service” rights to a user account, using PowerShell you can use the secedit.exe tool, using a *.inf security template file. [Script] secedit /import /db secedit.sdb

Show password in plaintext, by using Get-Credential in PowerShell

23 March, 2010 Roel van Lisdonk 2 Comments 1 category

To show the password from the Get-Credentials cmdlet in plaintext, use the following PowerShell script: $credential = Get-Credential [Runtime.InteropServices.Marshal]::PtrToStringAuto([Runtime.InteropServices.Marshal]::SecureStringToBSTR($credential .Password))

Create local user account with [User must change password at next logon] and [Password never expires] set in PowerShell

23 March, 2010 Roel van Lisdonk 2 Comments 1 category

If you want to create service accounts with PowerShell and the result must be like: Use this PowerShell script: # To run this script use: & "C:\Users\rLisdonk\Desktop\ToServer\Test.ps1" $computerName = "MyComputerName” $serviceAccountWebName = "saAsaWeb"

How to determine the program files folder with PowerShell, by using enums and nested types

19 March, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to use the systems “%PROGRAMFILES%” folder in PowerShell, use: $rootInstallationFolder = [System.Environment]::GetFolderPath([System.Environment+SpecialFolder]::ProgramFiles) $rootInstallationFolder Result C:\Program Files (x86) Note Because SpecialFolders is a nested type in System.Environment, you must use the “+”

Script SQL Server database, including lookup tables content, by using Microsoft.SqlServer.Management.Smo

19 March, 2010 Roel van Lisdonk 4 Comments 1 category

If you want to script a SQL Server database and want to include content for the lookup tables, you can use Microsoft.SqlServer.Management.Smo in C#: Add reference to Microsoft.SqlServer.Smo Add reference to Microsoft.SqlServer.ConnectionInfo Add reference to

Use VSCmdShell to run a PowerShell script from within Visual Studio 2008

18 March, 2010 Roel van Lisdonk 0 Comments 1 category

You can use VSCmdShell to run a PowerShell script from within Visual Studio 2008. After installing VSCmdShell you can change the startup folder (working folder) of the powershell window: Tools > Options > Power Toys

How to install and un-install *.msi package with PowerShell and msiexec

18 March, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to install a *.msi package by first un-installing the product and then installing, you can use the following PowerShell script: Use System.Diagnostics.Process.Start function and the WaitForExit function to make sure the product

Copy files with or without directory structure based on file extensions (.txt or .msi) wildcard search in PowerShell

18 March, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to copy all *.txt files in folder C:\Source to C:\Destination preserving the directory structure: Source files C:\Source\Test1.cmd C:\Source\Test1.txt C:\Source\Dir1\Test2.txt PowerShell statement Copy-Item "C:\Source" "C:\Destination" -filter "*.txt" -recurse –force Result

General development performance tips and tricks

17 March, 2010 Roel van Lisdonk 0 Comments 1 category

This post will be changed, when I find new performance tricks during daily work Product Tip VMware 7 General Fit all virtual machine memory into reserved host RAM ·Edit ·Preferences ·Memory Fit all virtual

Month: March 2010