Get-SQLServerVersion.ps1

1. <# 
2. .SYNOPSIS 
3.     This script displays the versions of SQL Server running on a system 
4. .DESCRIPTION 
5.     This script uses WMI to get the SQLServiceAdvancedProperty class from 
6.     the ComputerManagement namespace to print out the versions. This  
7.     script is an adaptation of the VBS script on MSDN. 
8. .NOTES 
9.     File Name  : Get-SQLServerVersion.ps1 
10.     Author     : Thomas Lee - tfl@psp.co.uk 
11.     Requires   : PowerShell V2 CTP3 
12. .LINK 
13.     This script posted to: 
14.         http://www.pshscripts.blogspot.com 
15.     MSDN Sample posted at: 
16.         http://msdn.microsoft.com/en-us/library/ms186353.aspx 
17. .EXAMPLE 
18.     PSH [C:\foo]: .\Get-SQLVersion.ps1' 
19.     You are running the following versions of SQL: 
20.     Service Name            Version 
21.     ------------            ------- 
22.     MSSQL$MICROSOFT##SSEE   9.3.4035.00 
23.     MSSQL$SQLEXPRESS        9.3.4035.00 
24. #> 
25.  
26. ## 
27. # Start of script 
28. ## 
29.  
30. # Get the versions of SQL from WMI 
31. $Versions = Get-WmiObject -Namespace root\Microsoft\SQLServer\computerManagement -Class SqlServiceAdvancedProperty | where {$_.SqlServiceType -eq 1 -and $_.PropertyName -eq "VERSION"} 
32.  
33. # Now display results 
34. "You are running the following versions of SQL:" 
35. "Service Name            Version" 
36. "------------            -------" 
37. foreach ($version in $versions) { 
38. "{0} `t{1}" -f $version.servicename,$version.propertystrvalue 
39. } 
40. #End of script 

Technorati Tags: SQL,PowerShell,Code,SMO

New-Ou.PS1

1. <# 
2. .SYNOPSIS 
3.     This script uses ADSI to add a new OU to a domain. 
4. .DESCRIPTION 
5.     This script creates a pointer to the domain, then 
6.     uses the Create method to create a new OU under 
7.     the root of the domain. 
8. .NOTES 
9.     File Name  : New-Ou.ps1 
10.     Author     : Thomas Lee - tfl@psp.co.uk 
11.     Requires   : PowerShell V2 CTP3 
12. .LINK 
13.     This script posted to: 
14.         http://www.pshscripts.blogspot.com 
15. .EXAMPLE 
16.     PSH [C:\foo]: .\New-OU.PS1' 
17.     Created OU: PowerShell 
18.      
19.     distinguishedName : {OU=PowerShell,DC=cookham,DC=net} 
20.     Path              : LDAP://ou=PowerShell,dc=Cookham,dc=Net 
21. #> 
22. ## 
23. # Start of Script 
24. ## 
25.  
26. #Set variables 
27. $OuName = “PowerShell” 
28. $Domain = [ADSI]“LDAP://dc=Cookham,dc=Net” 
29.  
30. # Create the OU 
31. $Ou = $Domain.Create(”OrganizationalUnit”, “ou=” + $OuName) 
32. $Ou.SetInfo() 
33.  
34. # Display results 
35. "Created OU: {0}" -f $OUName 
36. $OU 

Technorati Tags: PowerShell,code,ADSI,Create an OU

Get-SpecialFolders.ps1

1. <# 
2. .SYNOPSIS 
3.     This script lists the special folders enumerated in System.Environment.SpecialFolder 
4. .DESCRIPTION 
5.     This script first enumerates the SpecialFolder Enum. for each member, the script 
6.     then looks up, and displays, the value of that folder. 
7. .NOTES 
8.     File Name  : Get-SpecialFolders.ps1 
9.     Author     : Thomas Lee - tfl@psp.co.uk 
10.     Requires   : PowerShell V2 CTP3 
11. .LINK 
12.     This script posted to: 
13.         http://www.pshscripts.blogspot.com 
14.     MSDN Sample posted at: 
15.         http://msdn.microsoft.com/en-us/library/system.environment.specialfolder.aspx 
16. .EXAMPLE 
17.     PSH [C:\foo]: . 'E:\PowerShellScriptLib\System.Environment\Get-SpecialFolders.PS1' 
18.     Folder Name            Path 
19.     -----------            ----------------------------------------------- 
20.     Desktop                C:\Users\tfl\Desktop 
21.     Programs               C:\Users\tfl\AppData\Roaming\Microsoft\Windows\Start Menu\Programs 
22.     Personal               C:\Users\tfl\Documents 
23.     Personal               C:\Users\tfl\Documents 
24.     Favorites              C:\Users\tfl\NetHood\Favorites 
25.     Startup                C:\Users\tfl\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup 
26.     Recent                 C:\Users\tfl\AppData\Roaming\Microsoft\Windows\Recent 
27.     SendTo                 C:\Users\tfl\AppData\Roaming\Microsoft\Windows\SendTo 
28.     StartMenu              C:\Users\tfl\AppData\Roaming\Microsoft\Windows\Start Menu 
29.     MyMusic                C:\Users\tfl\Music 
30.     DesktopDirectory       C:\Users\tfl\Desktop 
31.     MyComputer 
32.     Templates              C:\Users\tfl\AppData\Roaming\Microsoft\Windows\Templates 
33.     ApplicationData        C:\Users\tfl\AppData\Roaming 
34.     LocalApplicationData   C:\Users\tfl\AppData\Local 
35.     InternetCache          C:\Users\tfl\AppData\Local\Microsoft\Windows\Temporary Internet Files 
36.     Cookies                C:\Users\tfl\AppData\Roaming\Microsoft\Windows\Cookies 
37.     History                C:\Users\tfl\AppData\Local\Microsoft\Windows\History 
38.     CommonApplicationData  C:\ProgramData 
39.     System                 C:\Windows\system32 
40.     ProgramFiles           C:\Program Files (x86) 
41.     MyPictures             C:\Users\tfl\Pictures 
42.     CommonProgramFiles     C:\Program Files (x86)\Common Files 
43. #> 
44.  
45. ## 
46. # Start of Script 
47. ## 
48.  
49. # Get the list of special folders 
50. $folders = [system.Enum]::GetValues([System.Environment+SpecialFolder])  
51.  
52. # Display these folders 
53. "Folder Name            Path" 
54. "-----------            -----------------------------------------------" 
55. foreach ($folder in $folders) { 
56. "{0,-22} {1,-15}"  -f $folder,[System.Environment]::GetFolderPath($folder) 
57. } 
58. #End of Script 

Technorati Tags: System.Environment.SpecialFolder,PowerShell,Code,script

Get-Thursday

1. <# 
2. .SYNOPSIS 
3.     This script checks of a particular date in the past was a Thurday. 
4. .DESCRIPTION 
5.     This script creates a DateTime object set for 1st May, 2003. The 
6.     script then check to see if that day is a Thursday then displays
7.     the day of week for that date (which is a Thursday). This script
8.     is a copy of the MSDN sample, written in PowerShell.   
9. .NOTES 
10.     File Name  : Get-Thursday.ps1 
11.     Author     : Thomas Lee - tfl@psp.co.uk 
12.     Requires   : PowerShell V2 CTP3 
13. .LINK 
14.     This script posted to: 
15.         http://pshscripts.blogspot.com/2009/08/get-thursday.html
16.     MSDN Sample posted at: 
17.         http://msdn.microsoft.com/en-us/library/system.dayofweek(VS.71).aspx 
18. .EXAMPLE 
19.     PSH [C:\foo]: . 'E:\PowerShellScriptLib\System.DateTime\get-thursday.ps1' 
20.     Is Thursday the day of the week for 5/1/2003?: True 
21.     The day of the week for 5/1/2003 is Thursday. 
22. #> 
23.   
24. ## 
25. # Start of script 
26. ## 
27.   
28. # Create a DateTime for the first of May, 2003. 
29. $dt = New-Object System.DateTime 2003, 5, 1 
30.   
31. # Now - is it Thursday? 
32. "Is Thursday the day of the week for {0:d}?: {1}" -f $dt,($dt.DayOfWeek -eq [system.DayOfWeek]::Thursday) 
33. "The day of the week for {0:d} is {1}." -f $dt, $dt.DayOfWeek 
34. # End of Script 

Technorati Tags: PowerShell,code,System.DateTime,System,DayOfWeek

Get-DNSAddress.ps1

1. <# 
2. .SYNOPSIS 
3.     This script uses the System.Net.Networkinginformation.Networknterface class 
4.     to get all network interface detais and displays the DNS addresses configured. 
5. .DESCRIPTION 
6.     This script first gets all the interface objects, then iterates throught them to  
7.     get the DNS address(es) configured for each one. 
8. .NOTES 
9.     File Name  : Get-DNSAddress.ps1 
10.     Author     : Thomas Lee - tfl@psp.co.uk 
11.     Requires   : PowerShell V2 CTP3 
12. .LINK 
13.     This script posted to: 
14.     http://www.pshscripts.blogspot.com 
15.     MSDN Sample posted at: 
16.     http://msdn.microsoft.com/en-us/library/system.net.networkinformation.ipaddressinformation(VS.85).aspx 
17. .EXAMPLE 
18.     PSH [C:\foo]: . 'C:\Users\tfl\AppData\Local\Temp\Untitled11.ps1' 
19.     NETGEAR FA311v2 PCI Adapter - Virtual Network 
20.       DNS Servers ............................. : 10.10.1.101 
21.     Broadcom NetXtreme Gigabit Ethernet 
22.       DNS Servers ............................. : 10.10.1.101 
23.     Software Loopback Interface 1 
24.       DNS Servers ............................. : fec0:0:0:ffff::1%1 
25.       DNS Servers ............................. : fec0:0:0:ffff::2%1 
26.       DNS Servers ............................. : fec0:0:0:ffff::3%1 
27.     isatap.cookham.net 
28.       DNS Servers ............................. : 10.10.1.101 
29. #> 
30.   
31. ## 
32. # Start of Script 
33. ## 
34.  
35. # Get set of adapters 
36. $adapters  = [System.Net.NetworkInformation.NetworkInterface]::GetAllNetworkInterfaces() 
37.   
38. # For each adapter, print out DNS Server Addresses configured 
39. foreach ($adapter in $adapters) { 
40.   $AdapterProperties = $Adapter.GetIPProperties() 
41.   $dnsServers        = $AdapterProperties.DnsAddresses 
42.   if ($dnsServers.Count -gt 0){ 
43.     $adapter.Description 
44.     foreach ($IPAddress in $dnsServers) { 
45.         "  DNS Servers ............................. : {0}" -f $ipaddress.IPAddressToString 
46.             } 
47.     } 
48. }    
49. # End of Script 

Technorati Tags: PowerShell,Script,System.Net.NetworkInformation.NetworkInterface,GetIPProperties

Get-System.Environment.ps1

1. <#
2. .SYNOPSIS
3. This script demonstrates the use of System.Environment
4. .DESCRIPTION
5. This script Uses a variety of the members of System.Environment and is
6. a re-write of a MSDN Sample Script
7. .NOTES
8. File Name : Get-System.Environment
9. Author : Thomas Lee - tfl@psp.co.uk
10. Requires : PowerShell V2 CTP3
11. .LINK
12. This script posted to:
13. http://www.pshscripts.blogspot.com
14. MSDN Sample posted at:
15. http://msdn.microsoft.com/en-us/library/system.environment.aspx
16. .EXAMPLE
17. PSH [C:\foo]: .\Get-System.Environment.ps1' foo1 foo2 foo3
18. My system drive is C: and my system root is C:\Windows
19. -- Environment members --
20. CommandLine : "C:\Users\tfl\Desktop\psp\PowerShellPlus.exe"
21. GetCommandLineArgs: C:\Users\tfl\Desktop\psp\PowerShellPlus.exe
22. CurrentDirectory : C:\Users\tfl\Desktop\psp
23. ExitCode : 0
24. HasShutdownStarted: False
25. MachineName : COOKHAM8
26. NewLine :
27. first line
28. second line
29. third line
30. OSVersion : Microsoft Windows NT 6.0.6001 Service Pack 1
31. StackTrace : ' at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
32. at System.Environment.get_StackTrace()
33. at getter(Object )
34. at System.Management.Automation.DotNetAdapter.PropertyGet(PSProperty property)
35. at System.Management.Automation.Adapter.BasePropertyGet(PSProperty property)
36. at System.Management.Automation.PSProperty.GetAdaptedValue()
37. at System.Management.Automation.PSProperty.get_Value()
38. at System.Management.Automation.PropertyReferenceNode.GetValue(PSObject obj, Object property, ExecutionContext context)
39. at System.Management.Automation.PropertyReferenceNode.Execute(Array input, Pipe outputPipe, ExecutionContext context)
40. at System.Management.Automation.ExpressionNode.Execute(Array input, Pipe outputPipe, ExecutionContext context)
41. at System.Management.Automation.ParseTreeNode.Execute(Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)
42. at System.Management.Automation.StatementListNode.ExecuteStatement(ParseTreeNode statement, Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)
43. at System.Management.Automation.StatementListNode.Execute(Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)
44. at System.Management.Automation.ParseTreeNode.Execute(Array input, Pipe outputPipe, ExecutionContext context)
45. at System.Management.Automation.ScriptCommandProcessor.ExecuteWithCatch(ParseTreeNode ptn, Array inputToProcess)
46. at System.Management.Automation.ScriptCommandProcessor.RunClause(ParseTreeNode clause, Object dollarUnderbar, Object inputToProcess)
47. at System.Management.Automation.ScriptCommandProcessor.Complete()
48. at System.Management.Automation.CommandProcessorBase.DoComplete()
49. at System.Management.Automation.Internal.PipelineProcessor.SynchronousExecuteEnumerate(Object input, Hashtable errorResults, Boolean enumerate)
50. at System.Management.Automation.PipelineNode.Execute(Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)
51. at System.Management.Automation.StatementListNode.ExecuteStatement(ParseTreeNode statement, Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)
52. at System.Management.Automation.StatementListNode.Execute(Array input, Pipe outputPipe, ArrayList& resultList, ExecutionContext context)
53. at System.Management.Automation.ParseTreeNode.Execute(Array input, Pipe outputPipe, ExecutionContext context)
54. at System.Management.Automation.ScriptCommandProcessor.ExecuteWithCatch(ParseTreeNode ptn, Array inputToProcess)
55. at System.Management.Automation.ScriptCommandProcessor.RunClause(ParseTreeNode clause, Object dollarUnderbar, Object inputToProcess)
56. at System.Management.Automation.ScriptCommandProcessor.Complete()
57. at System.Management.Automation.CommandProcessorBase.DoComplete()
58. at System.Management.Automation.Internal.PipelineProcessor.SynchronousExecuteEnumerate(Object input, Hashtable errorResults, Boolean enumerate)
59. at System.Management.Automation.Internal.PipelineProcessor.SynchronousExecute(Array input, Hashtable errorResults)
60. at System.Management.Automation.Runspaces.LocalPipeline.InvokeHelper()
61. at System.Management.Automation.Runspaces.LocalPipeline.InvokeThreadProc()
62. at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
63. at System.Threading.ExecutionContext.runTryCode(Object userData)
64. at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
65. at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
66. at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
67. at System.Threading.ThreadHelper.ThreadStart()'
68. SystemDirectory : C:\Windows\system32
69. TickCount : 98385431
70. UserDomainName : COOKHAM
71. UserInteractive : True
72. UserName : tfl
73. Version : 2.0.50727.3074
74. WorkingSet : 49385472
75. ExpandEnvironmentVariables:
76. My system drive is C: and my system root is C:\Windows
77. GetEnvironmentVariable:
78. My temporary directory is C:\Users\tfl\AppData\Local\Temp.
80. GetEnvironmentVariables:
82. Name Value
83. ---- -----
84. Path C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Program Files (x86)\Microsoft SQL Server\90\Tools\b...
85. TEMP C:\Users\tfl\AppData\Local\Temp
86. SESSIONNAME Console
87. PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.PSC1
88. USERDOMAIN COOKHAM
89. PROCESSOR_ARCHITECTURE x86
90. ProgramW6432 C:\Program Files
91. APPDATA C:\Users\tfl\AppData\Roaming
92. windir C:\Windows
93. LOCALAPPDATA C:\Users\tfl\AppData\Local
94. CommonProgramW6432 C:\Program Files\Common Files
95. TMP C:\Users\tfl\AppData\Local\Temp
96. USERDNSDOMAIN COOKHAM.NET
97. USERPROFILE C:\Users\tfl
98. ProgramFiles C:\Program Files (x86)
99. CommonProgramFiles(x86) C:\Program Files (x86)\Common Files
100. FP_NO_HOST_CHECK NO
101. HOMEPATH \Users\tfl
102. COMPUTERNAME COOKHAM8
103. CLASSPATH .;C:\Program Files (x86)\Java\jre6\lib\ext\QTJava.zip
104. PROCESSOR_ARCHITEW6432 AMD64
105. ProgramData C:\ProgramData
106. NUMBER_OF_PROCESSORS 8
107. PROCESSOR_IDENTIFIER Intel64 Family 6 Model 23 Stepping 6, GenuineIntel
108. SystemDrive C:
109. SystemRoot C:\Windows
110. ComSpec C:\Windows\system32\cmd.exe
111. LOGONSERVER \\COOKHAM1
112. ProgramFiles(x86) C:\Program Files (x86)
113. PSMODULEPATH C:\Users\tfl\Documents\WindowsPowerShell\Modules;C:\Windows\SysWOW64\WindowsPowerShell\v1.0\Modules
114. CommonProgramFiles C:\Program Files (x86)\Common Files
115. PROCESSOR_LEVEL 6
116. PROCESSOR_REVISION 1706
117. QTJAVA C:\Program Files (x86)\Java\jre6\lib\ext\QTJava.zip
118. ALLUSERSPROFILE C:\ProgramData
119. VS90COMNTOOLS C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\Tools\
120. PUBLIC C:\Users\Public
121. USERNAME tfl
122. OS Windows_NT
123. HOMEDRIVE C:
124. GetFolderPath: C:\Windows\system32
125. GetLogicalDrives: C:\, D:\, E:\, F:\, G:\, H:\, I:\, J:\, K:\, L:\, Q:\, X:\
126. .PARAMETER
127. None, but if any are provided, they are displayed above
128. #>
130. ##
131. # Start of Script
132. ##
134. # Setup two variables for later use
135. [String] $str;
136. [string] $nl = [System.Environment]::NewLine
138. # Now display members of the environment class
139. "-- Environment members --"
140. # Assume: You Invoke this sample with an arbitrary set of command line arguments.
141. "CommandLine : {0}" -f [system.environment]::CommandLine
142. $arguments = [System.Environment]::GetCommandLineArgs()
143. "GetCommandLineArgs: {0}" -f [system.string]::join(", ", $arguments)
144. # <-- Keep this information secure! -->
145. "CurrentDirectory : {0}" -f [System.Environment]::CurrentDirectory
146. "ExitCode : {0}" -f [System.Environment]::ExitCode
147. "HasShutdownStarted: {0}" -f [System.Environment]::HasShutdownStarted
148. # <-- Keep this information secure! -->
149. "MachineName : {0}" -f [System.Environment]::MachineName
150. "NewLine : {0} first line{0} second line{0} third line" -f [System.Environment]::NewLine
151. "OSVersion : {0}" -f [System.Environment]::OSVersion.ToString()
152. "StackTrace : '{0}'" -f [System.Environment]::StackTrace
153. # <-- Keep this information secure! -->
154. "SystemDirectory : {0}" -f [System.Environment]::SystemDirectory
155. "TickCount : {0}" -f [System.Environment]::TickCount
156. # <-- Keep this information secure! -->
157. "UserDomainName : {0}" -f [System.Environment]::UserDomainName
158. "UserInteractive : {0}" -f [System.Environment]::UserInteractive
159. # <-- Keep this information secure! -->
160. "UserName : {0}" -f [System.Environment]::UserName
161. "Version : {0}" -f [System.Environment]::Version.ToString()
162. "WorkingSet : {0}" -f [System.Environment]::WorkingSet
163. # No example for exit(exitCode) because doing so would terminate this example.
164. # <-- Keep this information secure! -->
165. $query = "My system drive is %SystemDrive% and my system root is %SystemRoot%";
166. $str = [System.Environment]::ExpandEnvironmentVariables($query)
167. "ExpandEnvironmentVariables: {0} {1}" -f $nl,$str
168. "GetEnvironmentVariable: {0} My temporary directory is {1}." -f $nl,[System.Environment]::GetEnvironmentVariable("TEMP")
169. ""
170. "GetEnvironmentVariables: "
171. [System.Environment]::GetEnvironmentVariables()
172. "GetFolderPath: {0}" -f [System.Environment]::GetFolderPath([System.Environment+SpecialFolder]::System)
173. [String[]] $drives = [System.Environment]::GetLogicalDrives()
174. "GetLogicalDrives: {0}" -f [System.String]::Join(", ", $drives)
175. #End of Script

Technorati Tags: PowerShell,Script,Code,System.Environment

Convert-Double.ps1

1. <# 
2. .SYNOPSIS 
3.     This script is an updated MSDN sample showing converstion to int32, boolean, string 
4.     and char. The sample is written using PowerShell 
5. .DESCRIPTION 
6.     This script 
7. .NOTES 
8.     File Name  : convert-double.ps1 
9.     Author     : Thomas Lee - tfl@psp.co.uk 
10.     Requires   : PowerShell V2 CTP3 
11. .LINK 
12.     This script posted to: 
13.         http://www.pshscripts.blogspot.com 
14.     MSDN Sample posted at: 
15.         http://msdn.microsoft.com/en-us/library/system.convert.aspx 
16. .EXAMPLE 
17.     PSH [C:\foo]: .\convert-double.ps1' 
18.     Converting 23.15 to an int32 = 23 
19.     Converting 23.15 to an Boolean = True 
20.     Converting 23.15 to a String = 23.15 
21.     Converting 1st char of "23.15" to a char = 2 
22. #> 
23.  
24. ## 
25. # Start of sample 
26. ## 
27.   
28. # Create double to convert 
29. [system.double] $dNumber = 23.15 
30.  
31. # convert to int32 
32. [int32] $iNumber = [System.Convert]::ToInt32($dNumber) 
33. "Converting $dnumber to an int32 = $inumber" 
34.   
35. # convert to bool 
36. [bool] $bNumber = [System.Convert]::ToBoolean($dNumber); 
37. "Converting $dnumber to an Boolean = $bNumber" 
38.   
39. # convert to string 
40. [string] $strNumber = [System.Convert]::ToString($dNumber) 
41. "Converting $dnumber to a String = $strNumber" 
42.   
43. # convert a single char in the string to a char 
44. [char] $chrNumber = [System.Convert]::ToChar($strNumber[0]); 
45. "Converting 1st char of `"$strnumber`" to a char = $chrNumber" 
46. # End of script