PowerShell.com – PowerShell Scripts, Tips, Forums, and Resources: Active Threads

Finding Path of file and copy it to the right path

kernelphr34k — Wed, 29 May 2013 22:25:00 GMT

I'm trying to figure out how to determine the full path of files from a compare-object cmdlet.. Here's some of my code:

[xml]$LHotFixes = Get-Content "E:\WSU_REPO\Hotfixes1.xml"

#This command parses an XML file and lists the value of "file" in it.
$LCompareXmlFile = $LHotFixes.SelectNodes("//HF") | Select -ExpandProperty File

#Compare file values from remote and local xml files
$CompareXmlKBDiff = (Compare-object -Ref $RCompareXmlFile -Diff $LCompareXmlFile -SyncWindow 25)

A file value looks like this: File="KB974571.MSU"

The problem with the compare statement is that it lists all the files, but I don't know the path of the file so I can copy it into the right folder. For example the files will be in "c:\temp\x86" or "c:\temp\x64". How do I go about finding the file path, and then copying them into the right folder?

I do have an md5 hash of every file on the remote and local system, but not sure how to use this data to copy it to the right folder. Here's one of the commands to get hash of the local files:

$LocalHashx64 = (dir "E:\WSU_REPO\2008\x64" -Recurse | Where-Object {!$_.psiscontainer} | Get-Hash -StringEncoding ASCII -Algorithm MD5)

Thanks for your help and suggestions. If you need more info, context or script examples please let me know. Thank you!

RSS -> Out-GridView as text

Stan — Sat, 15 Jun 2013 15:53:15 GMT

This works perfectly.

$url='http://rss.nytimes.com/services/xml/rss/nyt/HomePage.xml'
$wc = New-Object Net.WebClient
[xml]$resp = $wc.DownloadString($url)
$resp.rss.channel.item |Select Link,Description |Out-Gridview -Title "NY TIMES RSS"

but I would like the Link and Description columns in the Gridview to be plain text, and is it possible to wrap a column in the Gridview.

still learning....

select lines which contains date & copy them to a new .csv file

priyanka64 — Sun, 16 Jun 2013 11:10:22 GMT

I want to filter csv file on the basis of the lines which starts with date copy them to new .csv file

Date_received,date_occurred,time_to_close,event_handle,CLASS,status,severity,mc_host,tec_class,help_key,msg,mc_object_class,mc_object,mc_parameter,mc_parameter_value,mc_owner,mc_object_owner,mc_origin,mc_origin_key,mc_origin_sev,mc_event_category,ap_id,bao_action,bao_notify,bao_reply_received,delay_action,check_delay,da_instance,da_oncall,da_oncall_group,da_instance_oncall,da_supported,ecc_supported,environment,support_level,disposition,host_os,os_detail,repeat_count,incident_id,renotify,send_email,to_email,send_page,to_page,send_incident,to_incident,send2bao,to_bao,send2console,send2log,to_logfile,thresh_action,thresh_count,thresh_seconds,el_event_id,el_event_type,mc_client_address,adapter_host,snmp_enterprise,snmp_vals,mc_operations

BMC Impact Query 7.3.02.19 (Build 1684421 - 27-Oct-2010),,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

3/9/2013 23:00,3/10/2013 23:00,0,50331328,DATABASE_EVENT,CLOSED,WARNING,THD729SQ,DataBaseEmail,,"DataBaseEmail sqlrebuildix Rebuild index failed on ProfileAbstractionInternal in instance D1XX01, Rebuild Index Skipped. THD729SQ.",,,,,,,,,,,,,,NO,-1,90,,NO,-,none,NO,NO,DEVELOPMENT,0,INSTALLATION,W2K3-X64ENTERPRISE,RTM+SP2,0,,0,NO,,NO,,NO,,NO,,NO,NO,,[],[],[],,,10.40.239.30,THD729SQ,,,[]

BMC Impact Query 7.3.02.19 (Build 1684421 - 27-Oct-2010),,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

3/9/2013 23:00,3/11/2013 23:00,0,50331381,DATABASE_EVENT,CLOSED,WARNING,THQ001SQ,DbmsInitializationFailure,,DbmsInitializationFailure SqlNight Could not initialize SQL Server instance q1rt06. THQ001SQ autosysRun,,,,,,,,,,,,,,NO,0,0,,NO,-,none,YES,YES,QA,2,CERTIFIED,W2K3-ENTERPRISE,RTM+SP1,0,,0,NO,DA_NTGRP_Email_Group,NO,DA_ONCALL_MSSQLServer_Page_Group,NO,,NO,,NO,NO,,[],[],[],,,10.41.247.4,THQ001SQ,,,[]

BMC Impact Query 7.3.02.19 (Build 1684421 - 27-Oct-2010),,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

3/9/2013 23:01,3/9/2013 23:01,1,50331390,

Replace numbers in stings with another number by adding fixed amount to it

space22 — Sun, 16 Jun 2013 12:13:45 GMT

I am a beginner, sorry.

I think I can replace numbers in a file called "Test.txt" like this (correct me if wrong)

(Get-Content C:\Scripts\Test.txt) |
Foreach-Object {$_ -replace "start=\"20\"", "start=\"40\""} |
Set-Content C:\Scripts\Test.txt

However my problem is that I want to replace a number in a string with another number that is a fixed amount less than the number I am replacing.

My strings go like this
start="1342177280"
start="1342439424"
start="1342701568"

And what I need to do is deduct 1342177280 from each number giving me

start="0"
start="262144"
start="524288"

Or, setting each value to "0" then incrementing each by 262144 would also work.

There are other numbers in the strings so it is best to replace the complete start="<number>".

Is this possible in PowerShell? I think Perl can do it, but PowerShell may be more convenient.

Thanks!

Release: AWS Tools for Windows PowerShell 1.1.3

ps2 — Tue, 18 Jun 2013 15:28:22 GMT

This release adds a new Amazon EC2 cmdlet to easily get the latest AMI images using filter name and adds consistent cross-service aliases for parameters that control paging of service results.

PowerShell Scripts for Cluster Management

ps2 — Tue, 18 Jun 2013 15:26:05 GMT

Release Notes

PowerShell Scripts for HDInsight Cluster Management

PowerShell script to download TechEd NA 2013 slides and recordings

ps2 — Tue, 18 Jun 2013 15:23:54 GMT

I had a blast last week at TechEd but because of scheduling conflicts, and me sleeping in the Resource Center I missed some of the sessions I wanted to see. Fortunately this morning my Twitter and blog feed has been sprouting ways do download the scripts like the dandelions sprout in my yard in the spring.

PowerShell Command Line Introduction

ps2 — Tue, 18 Jun 2013 15:21:52 GMT

Here’s a slick PowerShell 3.0 one-liner. If you want to pull down an RSS feed from a blog, displaying only the title and publication date try:

Export-Mailbox exchange 2007

Lior — Mon, 17 Jun 2013 11:06:26 GMT

Hi,

I wrote a script that get users from group in AD, and delete all mails in those users mailbox until specific date. the script is working fine.

In the end the command "Export-Mailbox" generate report via XML file, some of the lines are:

StatusMessage : Messages have been deleted from the source mailbox.

DisplayName : LiorTest1

PrimarySmtpAddress : LiorTest1@yes.co.il

StandardMessagesDeleted : 264

AssociatedMessagesDeleted : 0

DumpsterMessagesDeleted : 0

MoveType : DeleteOnly

MoveStage : Completed

I need two things:

1) to disable this report

2) generate anther report that will include: PrimarySmtpAddress, MoveStage

(exchange 2007)

thanks

Lior

split & paste the lines in different pattern/custom transposed pattern

priyanka64 — Mon, 17 Jun 2013 18:32:22 GMT

I want to split & paste the lines in different pattern , filter the lines which starts with # or junk data present in it this is my text file .

tlprdhwa   base   atlas3
#ggasbkdjkddddbdb
tlprdhwb   base   atlas3
#jbksljs;blmnnf
tlprdhwc   base   atlas3
#23/15/bknlm;;ds;mmsld
tlprdhwd   base   atlas3
tlprdhwe   base   atlas3
tlprdhwf   base   atlas3
tlprdnwa   base   atlas3
tlprdnwb   base   atlas3

output should come like this

tlprdhwa base
tlprdhwb atlas3
tlprdhwc base
tlprdhwc atlas3

Powershell for SQL Script Execution

vysakhv90 — Mon, 17 Jun 2013 09:26:48 GMT

I am new to powershell. Even I dont think I know the basics..But now I am assigned a work to do the execution of sql scripts residing in a remote server.

1) we have to connect to that particular database/server using ip and the credentials--For this I need powershell to ask user to give the required parameters(such like server/database name/ip and credentials)

2) The next step is to get the sql scripts from 3 different folders based on 3 different inputs from user--Here I need powershell to ask user to enter the parameters(Eg:a=1st folder, m=2nd folder and x=3rd folder)

3) Then the execution of the script.After the execution, then it should again ask user to continue or exit.

The 3 steps described above is my requirement. Someone please help on this..Any help would be really appreciated..I am new to powershell. Even I dont think I know the basics..But now I am assigned a work to do the execution of sql scripts residing in a remote server.

1) we have to connect to that particular database/server using ip and the credentials--For this I need powershell to ask user to give the required parameters(such like server/database name/ip and credentials)

2) The next step is to get the sql scripts from 3 different folders based on 3 different inputs from user--Here I need powershell to ask user to enter the parameters(Eg:a=1st folder, m=2nd folder and x=3rd folder)

3) Then the execution of the script.After the execution, then it should again ask user to continue or exit.

The 3 steps described above is my requirement. Someone please help on this..Any help would be really appreciated..

Browse to a directory and assign to a variable

TheBishopOfSligo — Fri, 14 Jun 2013 10:20:21 GMT

I would like to be able to browse to a local directory and then assign the path to a variable.

Ideally it would be by using the windows browse function or something similar.

I would imagine this would be fairly easy to achieve.

I'm still fairly new to PS and am finding myself lost and confused a lot of the time.

Ray

find number of drafts per document in sharepoint?

jokke — Mon, 17 Jun 2013 06:21:37 GMT

i´m trying to help a colleague of mine with some sharepoint administration, i dont know alot about sharepoint and she doesnt know a lot about powershell (neither do i, but i know more then her at least)

The problem that we are facing is a sharepoint system that has been allowed to grow wild for a few years, the content database is almost 500gb in size and we think it is a result of users always saving documents as drafts and never as major versions

It seems it is impossible to control the number of drafts that is allowed per document, only the number of major versions.

is there a way to list the number of draft / minor versions that is saved for each document?

Call Powershell script from VBA using Shell() function

leknowlton — Thu, 13 Jun 2013 02:10:31 GMT

Hello,

I'm trying to pull a path string variable from the following VBA code into a PS script:

:VBA CODE:

Shell("powershell.exe -ExecutionPolicy Unrestricted -File <pathname>\Convert_To_Tab_Delimited.ps1 -path """ & pathVariable & """", 1)

:END OF VBA CODE:

I then have the string variable parameter set as a param in the PS script:

:PS CODE:

param([String]$FileToOpen)

gc $FileToOpen| % { $_ -replace ' +',"`t" } | set-content "<my path>\temp.txt"

:END OF PS CODE:

I am using full paths outside of the path variable. Does anyone have any ideas?

Desired State Configuration in Windows Server 2012 R2 – Online hands on lab

ps2 — Mon, 17 Jun 2013 18:56:41 GMT

I am sure you all must have already looked at the Desired State Configuration (DSC) feature announcement by Jeffrey Snover and Kenneth Hansen at TechEd 2013. This exciting change is coming up in Windows Server 2012 R2 and with PowerShell version 4. But, none of these are available yet for a public preview.

It's In the Mail Part 2: Sending Rich Messages

ps2 — Mon, 17 Jun 2013 18:54:50 GMT

Last time we looked at using Send-MailMessage to distribute PowerShell data through email messages. In the first part we looked at essentially plain text messages. But where's the fun in that? Why not send rich messages from PowerShell using HTML? Here's one way.

Deleting Active Directory User Accounts with Remove-ADUser

ps2 — Mon, 17 Jun 2013 18:44:39 GMT

Account deletion is a task to approach very carefully, and PowerShell gives us a safe method.

Installing a SQL server on a remote system using Powershell 3

THT — Mon, 17 Jun 2013 08:08:00 GMT

Hello,

I am trying to make a skript which installs the SQL Server (2013 Express) remote on another mashine (Server 2012). The first thought was, to use the Invoke-command:

Invoke-Command -ComputerName $SRV1 -Credential $cred2 -Script {

Start-Process -FilePath "c:\install\sql\SQLEXPRADV_x64_DEU.exe" -ArgumentList " /Q `
/INDICATEPROGRESS `

/IACCEPTSQLSERVERLICENSETERMS=1 `

...

/TCPENABLED=1 `
}

This starts the EXE on the remote system. But it seems that the EXE cannot launch other processes, so this command stops quite soon.

Is there a trick, to start it another way (and waiting until its finished)?

I got a workarround which has a strange behavior on passwords:

I put everything in one line :

$SQL="c:\install\sql\SQLEXPRADV_x64_DEU.exe /Q /INDICATEPROGRESS /IACCEPTSQLSERVERLICENSETERMS=1 /SQLSYSADMINACCOUNTS=$ad\SQLM ...

and write it to the remote system using the Inwoke-Command and start the script:

Invoke-Command -ComputerName $SRV1 -Credential $cred2 -Script {

Set-Content -Path d:\sql.ps1 -Encoding Unicode -Value $sql

Start-Process powershell.exe -ArgumentList "-file d:\sQL.ps1" -Wait

}

The strange thing on this solution is, that if I put any User-Informattion like

/SQLSVCACCOUNT=sbsrv\SQLSVC `
/SQLSVCPassword= P@ssw0rd `

in this commandline, it will work only , if I execute the SQL.PS1 directly on the computer (console) or use an interactive session on this mashine. But if I use the invoke-Command the script stops after a while, with the error that Username or Password are not correct.

Without any user parameter the installation will be completed without any errors.

Do you know, why?

Many thanks in advance

Thorsten

Removing Insecure Wireless Connections with PowerShell

ps2 — Mon, 17 Jun 2013 18:40:56 GMT

All devices let you "forget" a network when you are in range, and Windows 7 (and before) even had an interface that let you delete networks when they were out of range.

This dialog was removed in Windows 8, although the ‘netsh’ command still lets you accomplish it from the command line.

Building up Hash Tables avoiding key name conflicts

EBrant — Sat, 15 Jun 2013 10:51:29 GMT

Hello All

Can someone please assist me with the following question :)
In the past when creating hash tables I have mistakenly specified the same key name and therefore get an error saying that key name already exists in the hash table. Therefore I was trying to think of a way to take data from a pipeline with may contain duplicate values and create a hash table but automatically skip duplicates as they arise (using PosH 2 at the moment)

I came up with the following solution (do not worry about the values at this time, just keeping it simply and thinking about the keys)

My question is, is there an easier/more elegant way to achieve this,

Thanks all

Ernie

cls
$HT = @{"John Smith" = 0;"Jane Brown" = 0}
$X = "Ernest Brant","Bert Jackson","Jack Brown","Jane Brown","Ernest Brant","Bert Jackson"

foreach ($element in $X)

{

if (($HT.Keys | % {$_.ToString()}) -match $element) {continue} else

{$HT.Add($element,0)}

}

$HT

how to not concern invoke commad 's return?

testmanps — Thu, 23 May 2013 10:02:28 GMT

thanks nohandle ,i will question the net map question.

now i have a new question:
env:pc1/2/3 use xp , all installed powershell v2

pc1 want to use invoke pc2,pc3 for change ip address

after run script,pc1's script wait a long time to stop (about 3min)

perhaps the reason is pc2/3's ip changed ?

remote script last 2 comand:

$nic.EnableStatic($newip,"255.255.255.0")

Restart-Computer -force

how i can set only send script and no concern about the remote execute ?

how to tell pc1 ,the script run over?

how to set invoke timeout?

IT Professionals are Invited to Complimentary Webinar on Advanced Scripting Using PowerShell & SharePoint Online Presented by NetCom Learning

ps2 — Sun, 16 Jun 2013 00:04:35 GMT

NetCom Learning announces a forthcoming free webinar on Advanced Scripting Using PowerShell and SharePoint Online. The interactive webinar will take place on Friday, June 21, 2013 from 1:00 – 2:00 PM EST. The webinar which will be conducted by Microsoft MVP, Jerry Yasir, in conjunction with IT and business skills training leader, NetCom Learning, will look at the use of SharePoint cmdLets for PowerShell, and the creation and management of both web and service applications in PowerShell.

How The Hyper-V Extensible Switch Can Transform Your Network

ps2 — Sat, 15 Jun 2013 21:57:16 GMT

Grappling with a virtualised network architecture that’s difficult to manage? The Hyper-V Extensible Switch running on Windows Server 2012 can simplify your management workload, letting you add capabilities to your virtualised network to meet your exact needs.

AD group member count - Memory issue

ddan — Fri, 24 May 2013 02:30:54 GMT

Hi Guys,

Im attempting to write a script that does a count of users in specific groups & regions. So basically if the group is part of specific OU then do a Get-QADGroupMember and increment the number of users for that region.

My script works fine but I seem to be running out of memory and the the processing slows right down, I end up having to stop it.

I tried to put a [System.GC]::Collect() in my loop but that didnt seem to help, unless im using it incorrectly, can you pls advise how to make this more efficient memory wise.

Thanks!

Here is a cut down version of my code:

foreach ($Group in $GroupMembers){

switch ($Group)

{

{[Regex]::IsMatch($Group.DN,"(?i)OU=A,OU=X,DC=Y,DC=Z$")} {Get-QADGroupMember -Identity $Group.sAMAccountName -Indirect -Connection $conn -ShowProgress -SizeLimit 0 -DontUseDefaultIncludedProperties -type user | ForEach-Object {$Region1++}}

{[Regex]::IsMatch($Group.DN,"(?i)OU=B,OU=X,DC=Y,DC=Z$")} {Get-QADGroupMember -Identity $Group.sAMAccountName -Indirect -Connection $conn -ShowProgress -SizeLimit 0 -DontUseDefaultIncludedProperties -type user | ForEach-Object {$Region2++}}

{[Regex]::IsMatch($Group.DN,"(?i)OU=C,OU=X,DC=Y,DC=Z$")} {Get-QADGroupMember -Identity $Group.sAMAccountName -Indirect -Connection $conn -ShowProgress -SizeLimit 0 -DontUseDefaultIncludedProperties -type user | ForEach-Object {$Region3++}}

{[Regex]::IsMatch($Group.DN,"(?i)OU=D,OU=X,DC=Y,DC=Z$")} {Get-QADGroupMember -Identity $Group.sAMAccountName -Indirect -Connection $conn -ShowProgress -SizeLimit 0 -DontUseDefaultIncludedProperties -type user | ForEach-Object {$Region4++}}

{[Regex]::IsMatch($Group.DN,"(?i)OU=E,OU=X,DC=Y,DC=Z$")} {Get-QADGroupMember -Identity $Group.sAMAccountName -Indirect -Connection $conn -ShowProgress -SizeLimit 0 -DontUseDefaultIncludedProperties -type user | ForEach-Object {$Region5++}}

{[Regex]::IsMatch($Group.DN,"(?i)OU=F,OU=X,DC=Y,DC=Z$")} {Get-QADGroupMember -Identity $Group.sAMAccountName -Indirect -Connection $conn -ShowProgress -SizeLimit 0 -DontUseDefaultIncludedProperties -type user | ForEach-Object {$Region6++}}

{[Regex]::IsMatch($Group.DN,"(?i)OU=G,OU=X,DC=Y,DC=Z$")} {Get-QADGroupMember -Identity $Group.sAMAccountName -Indirect -Connection $conn -ShowProgress -SizeLimit 0 -DontUseDefaultIncludedProperties -type user | ForEach-Object {$Region7++}}

default {$UnknownRegion += Get-QADGroupMember -Identity $Group.sAMAccountName -Indirect -Connection $conn -ShowProgress -SizeLimit 0 -type user | select {$_.name}, {$_.sAMAccountName}}

}

How to Get All Workflow History List data from the site which is older then 3 months or years.

deepeshyevle — Sat, 15 Jun 2013 05:28:42 GMT

HI,

many of admins - works for SharePoint workflow history list data status which is completed and not deleted long time. because of ids not mat .

IS there power-shell scrip for huge workflow history data first check status completed then deleted the data which has older then a 3 months or a year.

Regards,

Deepesh