I needed to modify some text somewhere in a file. The file looks like this ## start file This is some text. I want to change something. But not this. ## end file I was playing around with various options. The simplest I found was this: £> $txt = Get-Content .\test.txt £> […]
KB3000850 – the November roll up for Windows 2012 R2 contains some very useful updates. I’ve installed it on some machines in my lab but not all. The update is huge so I’m installing it manually rather than through WSUS. I need to test a remote machine to determine if the update is installed. […]
I was working on some code that accesses a SQL database this afternoon. I only needed to pull back a single column from a single row but which column to pull back is variable depending on other data. That’s OK $query = “SELECT $colname FROM tablename WHERE x = ‘y’” Invoke-SQLcmd –server <server> –database <database> […]
Most PowerShell users will have done something like this: £> Get-WmiObject -ClassName Win32_ComputerSystem Domain : WORKGROUP Manufacturer : Microsoft Corporation Model : Surface Pro 2 Name : RSSURFACEPRO2 PrimaryOwnerName : TotalPhysicalMemory : 8506093568 Or you can use a computername to access a remote system £> $computer = $env:COMPUTERNAME £> Get-WmiObject -ClassName Win32_ComputerSystem -ComputerName $computer […]
There are a number of AD properties such as MemberOf and directrports that consist of a collection of distinguisednames. Sometimes you need the name of the object rather than the distinguished name: function getname { [CmdletBinding()] param ( [string]$dn ) $name = Get-ADObject $dn | select -ExpandProperty Name return $name } Get-ADUser -Filter * -SearchBase […]
There are times when you want to filter the results based on whether a user has an AD property set. You could do this: Get-ADUser -Filter * -Properties Title | Where Title | select Name, Title However, that involves pulling back all of the users and then filtering. Not very efficient especially across the […]
Spent some time today dealing with a situation where there were special characters – namely [ ] in folder a file names £> Get-ChildItem -Path C:\Test Directory: C:\Test Mode LastWriteTime Length Name —- ————- —— —- d—- 21/01/2015 17:58 Awkward [One] d—- 21/01/2015 17:59 Simple One Each folder has 3 files: File 1.txt […]
We’ve had to make some minor changes to the Summit agenda – the revised schedule is shown on the event web site – http://eventmgr.azurewebsites.net/event/home/PSNA15
Powershell.org has announced the 2015 list of PowerShell Heroes- http://powershell.org/wp/2015/01/17/announcing-our-2015-powershell-heroes/ These are people who have made an outstanding contribution to the PowerShell community but have not been recognised in other ways (such as an MVP award) Please join me in congratulating them
You can use Get-EventLog to query the event logs on you system Get-EventLog -LogName System One frequent task is to check if events occurred during a specific timespan. You may feel that you need to use a where-object filter to do this but there is a simple method. Get-EventLog -LogName System -After (Get-Date -Date […]