powerShell&Me: July 2007

Tuesday, July 31, 2007

Windows PowerShell Controlling Internet Explorer object from PowerShell

Monday, July 30, 2007

Processing XML with PowerShell

Live Search in Windows PowerShell

powershell blogs superList

from the UK PowerShell Users Group

powershell blogs superList

Sunday, July 29, 2007

Scripting Solutions for SQL Server buck woody

SQL Server Reference Guide Scripting Solutions for SQL Server
SQL Server Reference Guide Powershell and SQL Server - Overview
SQL Server Reference Guide PowerShell and SQL Server - Objects and Providers
SQL Server Reference Guide Powershell and SQL Server - A Script Framework

Saturday, July 28, 2007

ADAM & posh

Active Directory Application Mode (ADAM) technet

Madam, I'm ADAM read & understand before install

Download details Active Directory Application Mode

( --o-- PowerShelled Monad and Adam (and a preview of my to-be AD provider) ADAM)

Friday, July 27, 2007

who_Am_I

http://www.blogger.com/profile/14200477087259525142

Set ANY AD attribute with PowerShell

Set ANY AD attribute with PowerShell

other ad posts by Dmitry Sotnikov using quest's Free PowerShell Commands for Active Directory

Getting a full list of user attributes from AD schema,
Retrieving and manipulating arbitrary AD attributes,
Optimizing retrieval by memory and performance

Thursday, July 26, 2007

Discovering Registry Settings - PowerShell and Process Monitor

Optimizing Performance of Get-Content for Large Files

Keith Hill's Blog Optimizing Performance of Get-Content for Large Files

Windows Server By Command by Scott M. Fulton

Windows Server By Command by Scott M. Fulton @ http://www.informit.com

good info on using powershell to manage windows servers

Wednesday, July 25, 2007

pos & csv files

-o-- PowerShelled working with CSV files in MSH (part one)
--o-- PowerShelled working with CSV files in MSH (part two)
--o-- PowerShelled more Monad scripts, and a bit more CSV

Saving Data as a Comma-Separated Values File

Quick and Dirty Software Inventory with PsInfo and PowerShell

Space Invaders & Big Invaders

Space Invaders

Grrr 1.1 and Big Invaders

-Whatif, -Confirm, -Verbose example

examplle of posh -Whatif, -Confirm, -Verbose – options i.e. try before you buy from the
posh team blog

Wednesday, July 18, 2007

ping a list of servers stored in a file or a subnet

#requires -Version 2.0

Function Ping-Subnet {

#.Synopsis

# Ping a subnet returning all alive hosts.

#.Example

# Ping-Subnet -IP 192.168.1.0 -Netmask /24

#.Example

# Ping-Subnet -IP 192.168.1.128 -Netmask 255.255.255.128

Param(

[string]

$IP,

[string]

$netmask

)

Begin {

$IPs = New-Object System.Collections.ArrayList

$Jobs = New-Object System.Collections.ArrayList

$max = 50

Function Get-NetworkAddress {

#.Synopsis

# Get the network address of a given lan segment

#.Example

# Get-NetworkAddress -IP 192.168.1.36 -mask 255.255.255.0

Param (

[string]

$IP,

[string]

$Mask,

[switch]

$Binary

)

Begin {

$NetAdd = $null

}

Process {

$BinaryIP = ConvertTo-BinaryIP $IP

$BinaryMask = ConvertTo-BinaryIP $Mask

0..34 | %{

$IPBit = $BinaryIP.Substring($_,1)

$MaskBit = $BinaryMask.Substring($_,1)

IF ($IPBit -eq '1' -and $MaskBit -eq '1') {

$NetAdd = $NetAdd + "1"

} elseif ($IPBit -eq ".") {

$NetAdd = $NetAdd +'.'

} else {

$NetAdd = $NetAdd + "0"

}

if ($Binary) {

return $NetAdd

} else {

return ConvertFrom-BinaryIP $NetAdd

}

Function ConvertTo-BinaryIP {

#.Synopsis

# Convert an IP address to binary

#.Example

# ConvertTo-BinaryIP -IP 192.168.1.1

Param (

[string]

$IP

)

Process {

$out = @()

Foreach ($octet in $IP.split('.')) {

$strout = $null

0..7|% {

IF (($octet - [math]::pow(2,(7-$_)))-ge 0) {

$octet = $octet - [math]::pow(2,(7-$_))

[string]$strout = $strout + "1"

} else {

[string]$strout = $strout + "0"

}

$out += $strout

}

return [string]::join('.',$out)

}

Function ConvertFrom-BinaryIP {

#.Synopsis

# Convert from Binary to an IP address

#.Example

# Convertfrom-BinaryIP -IP 11000000.10101000.00000001.00000001

Param (

[string]

$IP

)

Process {

$out = @()

Foreach ($octet in $IP.split('.')) {

$strout = 0

0..7|% {

$bit = $octet.Substring(($_),1)

IF ($bit -eq 1) {

$strout = $strout + [math]::pow(2,(7-$_))

}

$out += $strout

}

return [string]::join('.',$out)

}

Function ConvertTo-MaskLength {

#.Synopsis

# Convert from a netmask to the masklength

#.Example

# ConvertTo-MaskLength -Mask 255.255.255.0

Param (

[string]

$mask

)

Process {

$out = 0

Foreach ($octet in $Mask.split('.')) {

$strout = 0

0..7|% {

IF (($octet - [math]::pow(2,(7-$_)))-ge 0) {

$octet = $octet - [math]::pow(2,(7-$_))

$out++

}

return $out

}

Function ConvertFrom-MaskLength {

#.Synopsis

# Convert from masklength to a netmask

#.Example

# ConvertFrom-MaskLength -Mask /24

#.Example

# ConvertFrom-MaskLength -Mask 24

Param (

[int]

$mask

)

Process {

$out = @()

[int]$wholeOctet = ($mask - ($mask % 8))/8

if ($wholeOctet -gt 0) {

1..$($wholeOctet) |%{

$out += "255"

}

$subnet = ($mask - ($wholeOctet * 8))

if ($subnet -gt 0) {

$octet = 0

0..($subnet - 1) | %{

$octet = $octet + [math]::pow(2,(7-$_))

}

$out += $octet

}

for ($i=$out.count;$i -lt 4; $I++) {

$out += 0

}

return [string]::join('.',$out)

}

Function Get-IPRange {

#.Synopsis

# Given an Ip and subnet, return every IP in that lan segment

#.Example

# Get-IPRange -IP 192.168.1.36 -Mask 255.255.255.0

#.Example

# Get-IPRange -IP 192.168.5.55 -Mask /23

Param (

[string]

$IP,

[string]

$netmask

)

Process {

iF ($netMask.length -le 3) {

$masklength = $netmask.replace('/','')

$Subnet = ConvertFrom-MaskLength $masklength

} else {

$Subnet = $netmask

$masklength = ConvertTo-MaskLength -Mask $netmask

}

$network = Get-NetworkAddress -IP $IP -Mask $Subnet

[int]$FirstOctet,[int]$SecondOctet,[int]$ThirdOctet,[int]$FourthOctet = $network.split('.')

$TotalIPs = ([math]::pow(2,(32-$masklength)) -2)

$blocks = ($TotalIPs - ($TotalIPs % 256))/256

if ($Blocks -gt 0) {

1..$blocks | %{

0..255 |%{

if ($FourthOctet -eq 255) {

If ($ThirdOctet -eq 255) {

If ($SecondOctet -eq 255) {

$FirstOctet++

$secondOctet = 0

} else {

$SecondOctet++

$ThirdOctet = 0

}

} else {

$FourthOctet = 0

$ThirdOctet++

}

} else {

$FourthOctet++

}

Write-Output ("{0}.{1}.{2}.{3}" -f `

$FirstOctet,$SecondOctet,$ThirdOctet,$FourthOctet)

}

$sBlock = $TotalIPs - ($blocks * 256)

if ($sBlock -gt 0) {

1..$SBlock | %{

if ($FourthOctet -eq 255) {

If ($ThirdOctet -eq 255) {

If ($SecondOctet -eq 255) {

$FirstOctet++

$secondOctet = 0

} else {

$SecondOctet++

$ThirdOctet = 0

}

} else {

$FourthOctet = 0

$ThirdOctet++

}

} else {

$FourthOctet++

}

Write-Output ("{0}.{1}.{2}.{3}" -f `

$FirstOctet,$SecondOctet,$ThirdOctet,$FourthOctet)

}

Process {

#get every ip in scope

Get-IPRange $IP $netmask | %{

[void]$IPs.Add($_)

}

#loop untill we've pinged them all

While ($IPs.count -gt 0 -or $jobs.count -gt 0) {

#if we have open spots kick off some more

IF ($jobs.count -le $max) {

# determin how many to kick off

$addjobs = ($max - $jobs.count)

Foreach ($IP in ($IPS | Select -first $addjobs)) {

#save the job id, and move on

[VOID]$Jobs.Add((gwmi -q "SELECT Address,StatusCode FROM Win32_Pingstatus WHERE Address = `'$IP`'" -asjob).Id)

#remove the IP from our pool

$IPs.Remove($IP)

}

#we'll use this array to track what's comeback

$Clean = @()

Foreach ($J in $jobs) {

# If this job is done get the results

if ((Get-Job -id $j).JobStateInfo.state -eq 'Completed') {

# if the ping was sucessfull return the IP Address

write-output (Receive-Job -id $j) | ?{$_.StatusCode -eq 0}| select -expand Address

# dispose of the job

remove-job -id $j

$clean += $j

}

Foreach ($c in $Clean) {

#remove the jobs that we just processed

$jobs.remove($c)

}

=================================

filter Validate-IPAddress {
trap{continue;}
[System.Net.IPAddress]::Parse(_).IPAddressToString;
}

filter Ping-Host{
begin{ ping = new-object System.Net.NetworkInformation.Ping; }
process{ if(ping.Send(_).status -eq "Success") {_;} }
}

cat ip.txt | Validate-IPAddress | Ping-Host | foreach {
write-host "_ is ALIVE, run some code" -f green -b black
}

Yes, you can resolve the IP to name, for example:

PS > [system.net.dns]::GetHostEntry("192.168.1.1").HostName

======================
Test things out for yourself using the measure-command cmdlet to see which is faster, especially when the ping will fail.

measure-command {gwmi "select * from win32_pingstatus where address='foobar'"}

$ping=New-Object system.Net.NetwokInformation.Ping
Measure-Command {$ping.send("foobar")}
foreach ($server in (get-content servers.txt))
{
gwmi -query "Select * from win32_pingstatus where address='$server'" select Address,Statuscode

}

If you remove the pipe and the select statement, you can see all the available properties.

To add the IP address use Select Address,StatusCode,ProtocolAddressThe order you select them is the order they'll display.

must b run from a win xp or 2003 box

from ScriptingAnswers.com Forums Ping instead of WMI

Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4

PowerShell Convert To Date Time Method - Don Hite

write your own commandlets

Windows PowerShell Visual Studio 2005 Templates (C# and VB.NET)

Windows PowerShell SDK

Hosting Windows PowerShell Part 1 2 & 3

The DFO Show - Hosting Windows PowerShell Part 1
The DFO Show - Hosting Windows PowerShell Part 2
The DFO Show - Hosting Windows PowerShell Part 3

Tuesday, July 17, 2007

webcasts

current script directory

http://blogs.msdn.com/powershell/archive/2007/06/19/get-scriptdirectory.aspx

function Get-ScriptDirectory{$Invocation = (Get-Variable MyInvocation -Scope 1).ValueSplit-Path $Invocation.MyCommand.Path}

Monday, July 16, 2007

Benp's Guide to Stuff Benp’s Basic Guide to Managing Active Directory Objects with PowerShell

active directory user info

#list all properties of a user object
Get-QADUser -ReturnPropertyNamesOnly -IncludeAllProperties

# Get a list of properties and store it in an array$properties = Get-QADUser -ReturnPropertyNamesOnly -IncludeAllProperties# Get the actual user object and the outputGet-QADUser "jane doe" -IncludeAllProperties Format-List $properties

(instead of the user name you can use DN, SID, GUID, UPN, username or Domain\username).

thanks to Dmitry Sotnikov

# output for joe user displayname,sAMAccountName,mail,scriptPath,Department

Get-QADUser 'User Joshph P' Format-List displayname,sAMAccountName,mail,scriptPath,Department
Get-QADUser joeuser1Format-List displayname,info,sAMAccountName,mail,scriptPath,Department

# Updating user properties

#Set Notes/info the Joe Useruser account:

cls
Get-QADUser joeuser1Format-List displayname,info,sAMAccountName,mail,scriptPath,Department
Set-QADUser joeuser1-info 'Elvis Rules!!!'
Get-QADUser joeuser1Format-List displayname,info,sAMAccountName,mail,scriptPath,Department

All information gathered from here PowerGUI Community : A quick intro to the Management Shell ...

#--------------------------------------------------------------------------------------
Function GetUserDetails ([adsi]$user){
$user=[ADSI](get-wmiobject -class ds_user -namespace root\directory\ldap -filter "DS_samaccountname='$env:username'").adsipath
write-host "Hello " + $user.givenname}
#--------------------------------------------------------------------------------------

Function Start { trap {reportError} $btnExit.Text = "close" GetUserDetails $user write-host "Bye " + $user.sn #(1 / $null)}
#---------------------------------------------------

$aDSPath=(
get-wmiobject -class ds_user
-namespace root\directory\ldap
-filter "DS_samaccountname='$env:username'"
).adsipath

The above is NOT an ADSI query. It's a WMI query - notice the "getWMIObjecti". Open WBEMTEST and connect to the "root\directory\ldap" namespave then browse to the "ds_user" wmi class and you will see all of the properties as named by WMI.

Finding the static methods of a class

powershell & dns

Using PowerShell to script DNS with WMI
Glen's Exchange Dev Blog Powershell DNS Utility script for querying MX, PTR and SPF records
-n software inc - NetCmdlets for Windows PowerShell
The PowerShell Guy Add Extended DNS support to PowerShell in 5 minutes

unanswered ?
Sandbox Calling FolderBrowserDialog from a ...

powerGUI

PowerGUI Community Main
Introduction to PowerGUI demo
Extending PowerGUI
PowerGUI Community A quick intro to the Management Shell ...
PowerGUI Hands-On Labs
PowerGUI Hands-On Labs Manual.

Sunday, July 15, 2007

A quick intro to the Management Shell for AD from Quest Software by Andrei Polevoi

originally posted here
this is a terrific post unfortunately being legally blind i find the print too small so i redid it and you can find it here

get maching info What’s that machine called

“Captain Literal”.NET » What’s that machine called

D:\PsScripts]36> . .\networkTools.ps1# Create a CSV file, just like Mamood has[D:\PsScripts]38> “MachineName”, “machine1″, ” machine2″, ” machine3″, ” machine4″ > machineList.csv# Get machine information from DNS[D:\PsScripts]40> $machines = @();[D:\PsScripts]41> import-csv machineList.csv % { $machineInfo = resolve-hostByName $_.MachineName; $machines += New-MachineObject $machineInfo.Hostname $machineInfo.AddressList[0] }# Ping each host to get alive status[D:\PsScripts]43> $machines % { $_.Alive = Get-AliveStatus $_.HostName }# Get MAC Address for each alive host[D:\PsScripts]45> $machines ? { $_.Alive } % { $_.MacAddress = Get-MacAddressForHost $_.HostName $_.IpAddress }# Finally, output as a table (or you could export to CSV if you prefer)[D:\PsScripts]47> $machines ftHostName IpAddress MacAddress Alive——– ——— ———- —–machine1.captainliteral.net 192.168.8.3 00:04:FF:0B:23:B2 Truemachine2.captainliteral.net 192.168.8.8 Falsemachine3.captainliteral.net 192.168.7.1 Falsemachine4.captainliteral.net 192.168.8.5 00:16:17:0E:23:B2 True
And that’s that.

Group Policy Administration with Windows PowerShell

SDM gpo Software

Simplify Group Policy Administration with Windows PowerShell

Saturday, July 14, 2007

oh the places i'v gone

active directory

MOW has a number of blog postings on AD:http://thepowershellguy.com/blogs/posh/archive/2007/02/09/ad-infrastructure-management-with-powershell.aspx http://thepowershellguy.com/blogs/posh/archive/2007/02/09/ad-infrastructure-management-with-powershell.aspx

Another thing you can do is install the PowerShell community extensons which include an Active Directory provider:http://www.codeplex.com/PowerShellCX

There are a variety of PowerShell extensions available on CodePlex:http://www.codeplex.com/Project/ProjectDirectory.aspx?TagName=powershellThe

Exchange team has a library of examples at:http://www.exchangeninjas.com/PSSCategorieshere's one that has uses AD:http://www.exchangeninjas.com/ExchangeActiveSyncMonitoring

You can also use the WMI classes to get started AD if you're familiar with them. For example:get-wmiobject -class Win32_NTDomain

scripts

myItforum
Windows PowerShell Tip of the Week
The Script Center Script Repository Sample Windows PowerShell Scripts
ScriptingAnswers.com - PowerShell samples
Sample Monad-MSH Scripts
codePlex-PowerShell Scripts - Home
Scripting for Exchange
The Exchange 2007 Wiki - PowerShell Scripts
F5 DevCentral Labs PowerShell with iControl use PowerShell to manage your BIG-IP.
myITforum posh scripts

Friday, July 13, 2007

powershell setup

first steps
How to Download Windows PowerShell 1.0
Download details Windows PowerShell 1.0 English-Language Installation Package for Windows XP (KB926139)
Download details Windows PowerShell 1.0 Installation Package for Windows Vista (KB928439)
install the appropriate package
get and install the community extensions
PowerShell Community Extensions - Home

next steps
get and install
PowerShell Analyzer
PowerGUI Community Main
PowerShell Commands for Active Directory Quest Software
powershell cheat sheet PDF
PowerShell Posters

To get started using posh

Windows PowerShell course book and demo files available for download

Mastering PowerShell in your Lunch Break : Day 1: Getting Organized

Mastering PowerShell in your Lunch Break : Day 2: Writing Scripts and Translating VBScript

Links for days 3-7 are on the right hand side

Scripting with Windows PowerShell - ms script center

powerShell&Me webcasts

Thursday, July 12, 2007

scripting method

http://www.codeplex.com/PsObject/Wiki/View.aspx?title=WMI&version=4
http://powershelllive.com/blogs/feed-powershellguy/archive/2007/03/01/hey-powershell-guy-how-can-i-get-the-uptime-of-a-service.aspx
http://thepowershellguy.com/blogs/posh/archive/2007/03/26/powershell-wmi-explorer-part-2.aspx
PS> $w1 = Get-WmiObject -class Win32_OperatingSystem
PS> $w1 Get-Member
ConvertFromDateTime ScriptMethod System.Object ConvertFromDateTime();ConvertToDateTime ScriptMethod System.Object ConvertToDateTime();Delete ScriptMethod System.Object Delete();GetType ScriptMethod System.Object GetType();Put ScriptMethod System.Object Put();
PS> $w1.ConvertToDateTime($w1.LastBootUpTime)08 April 2007 10:05:35

Wednesday, July 11, 2007

Working With Text and Files in Windows PowerShell

Working With Text and Files in Windows PowerShell (Part 1)

Working With Text and Files in Windows PowerShell (Part 2)

Windows PowerShell in Action Working With Text and Files in Windows PowerShell (Part 3)

UPDATED!!! Get-Uptime (The Custom Object extravaganza!!!)

posh functions

posh function syntax explained

Birth of a Script/Function

C# to PowerShell Translation Thought Process

BS on PoSH - Blog » C# to PowerShell Translation Thought Process

Tuesday, July 10, 2007

Invoking Generic Methods on Non-Generic Classes in PowerShell

posh & .NET

.NET types

How do I easily load assemblies, when LoadWithPartialName has been deprecated?

BS on PoSH - Blog » A Powershell Adventure Chpt2 ‘Using .NET in Powershell’

posh & .net who ate my disk

Skip the PowerShell Tutorials and Take a Test Drive Instead

powershell on codplex

gui box with powershell

gui box with powershell?

Exchange SMTP Log file DNS Test tool Powershell script

Using System.Windows.Forms.MessageBox in PowerShell

Accessing Database And Displaying Images Using Windows PowerShell

posh N wmi

thinking in powershell

thanks to Dennis Verweij and his blog Just Powershell it for this informative information on how to begin thinking in powershell

code using commandletts

#-- Get-ChildItemForEach-Object {if (test-path ./$_/rapporten){$dirname=$_.name;Get-ChildItem ./$dirname/reports}}Select-Object @{e={$dirname};n="homedir"},@{e={$_.name};n="report"}Export-Csv $env:systemroot\temp\reports.csv
#--

same code using aliases

#-- ls% {if (test-path ./$_/rapporten){$dirname=$_.name;ls ./$dirname/reports}}select @{e={$dirname};n="homedir"},@{e={$_.name};n="report"}export-csv $env:systemroot\temp\reports.csv
#--

thinking in powershell example referencing the above code

This may look like a lot of typing, but believe me, after a while, you'll type it in the command line as if it is you're native language.

Just type what you're thinking and it will all fall in place :

I want a directorylisting = ls
With the output I want to .. =
For every childitem it want.. = % {
If the directory exists If want to do the following = if (test-path ......){
remember the directory you search = $dirname=$_.name
and list the content of the report directory in this directory = ls ./$dirname/reports
End the "if" = }
End the "foreach"= }
With the output I want to .. =
and from this output only select the homedirectory and the name of the report in the report directory and name these "homedir" and "report" = select @{e={$dirname};n="homedir"},@{e={$_.name};n="report"}
With the output I want to .. =
export this data to a csv file in systemroot\temp and name it reports.csv = export-csv $env:systemroot\temp\reports.csv

Working with Active Directory

Active Directory

Managing Active Directory with Windows PowerShell

other blogs of mine

XoomAndMe

webSightings websites i find interesting as well as personal thoughts

powershell&me my powershell journey

miscITfinds miscellaneous info i have found useful in my work

music&me info i have found useful in my music hobby

Windows Live™ Spaces blog info i have found useful in my work as well as other interests

setting up powershell environment

this purpose of this blog is to document my experiences with ms powershell aks posh

if you want to be a part of the future of windows administration you need to be familiar with and able 2 use posh

use the information below to setup you posh environment

first steps
How to Download Windows PowerShell 1.0

Download details Windows PowerShell 1.0 English-Language Installation Package for Windows XP (KB926139)

Download details Windows PowerShell 1.0 Installation Package for Windows Vista (KB928439)
install the appropriate package

get and install
PowerShell Community Extensions - Home
PowerShell Analyzer
PowerGUI Community Main

To get started using posh
Mastering PowerShell in your Lunch Break : Day 1: Getting Organized
Mastering PowerShell in your Lunch Break : Day 2: Writing Scripts and Translating VBScript Links for days 3-7 are on the right hand side

Windows PowerShell course book and demo files available for download

Scripting with Windows PowerShell - ms script center

learn to think in powershell

powershell 101 course on a disk if you can't go to a live don jones training it is the next best thing

additional resources
PowerGUI Hands-On Labs Manual. word doc powerGUI page on this blog PowerShell Commands for Active Directory Quest Software powershell cheat sheet PDF powershell PDF posters Microsoft Windows PowerShell 1.0 DeskSheet PDF
Windows PowerShell Tip of the Week
powerShell&Me webcasts
powershell Blogs

Tuesday, July 31, 2007

Monday, July 30, 2007

Sunday, July 29, 2007

Saturday, July 28, 2007

Friday, July 27, 2007

Thursday, July 26, 2007

Wednesday, July 25, 2007

Wednesday, July 18, 2007

Tuesday, July 17, 2007

Monday, July 16, 2007

Sunday, July 15, 2007

Saturday, July 14, 2007

Friday, July 13, 2007

Thursday, July 12, 2007

Wednesday, July 11, 2007

Tuesday, July 10, 2007

Topics

Blog Archive

resourses