Vista Forums - PowerShell

remote executtion of a batch file

makaman — Fri, 20 Nov 2009 16:25:41 GMT

Hello,

Im on server 1 trying to execute a .bat on server 2. All the .bat does is create a folder called "test". I've tried a couple different ways and neither seems to work:

1) Invoke-Command -computer $server -scriptBlock {"C:\sqltest\test.bat"}

I have powershell V2, and part of the reason to going to PS2 vs PS1 was for this command, and when i try the above i also get the following error:
PS P:\> Get-Help Invoke-Command
Get-Help : Cannot find Help for topic "Invoke-Command".
At line:1 char:9
+ Get-Help <<<< Invoke-Command

2) $job = "cmd.exe /c cscript C:\sqltest\test.bat",$null,$null,1
$result = (Get-WmiObject -List -Computer $server | where{$_.Name -eq "Win32_Process'}).Create($job)

any ideas on what may be going wrong?

thank you!
makani

How to clear the Manager attribute for a user

TPGBrennan — Wed, 18 Nov 2009 20:43:02 GMT

supposedly I can use the set-qaduser cmdlt to clear the manager attribute and
not just change it. the following command runs without error but does not
clear the attribute:
set-qaduser a054100 -manager $Null

Is there anyway to clear this attribute?

Change AD User Password

Ben — Wed, 18 Nov 2009 20:35:01 GMT

I am not AD admin. Give a user's current password, how to change his/her
password in powershell?

Thanks

Powershell as a Java Scripting Language

Gary Furash — Wed, 18 Nov 2009 17:02:01 GMT

Just to add some details - Mono-based Powershell is called Pash and you can
find some details here:
http://pash.sourceforge.net/

As far as I know, it was not completely abandoned, even thought its not very
active this year :(

Martin

"Marco Shaw [MVP]" wrote in message
news:OzOnTSIaKHA.5300@newsgroup

Quote:

> There was a port for Mono that started up, but quickly stalled.
>
> I'm going to say 99.9% "NO" on someone working on jPowerShell... Without
> the underlying .NET, I can't see the "fun" in porting...
>
> Marco
>
> "Gary Furash" wrote in message
> news:2F6A1C8D-C953-44FD-A56C-87782820E15F@newsgroup

Quote:

>> Does anyone know if there is an open source project to port PowerShell as
>> a
>> Java scripting language like Jython, Jruby, and Jperl?

Background Job Hung

Ben — Wed, 18 Nov 2009 16:43:02 GMT

I want to use background jobs to manipulate SQL data. I have a PS script
JobName.ps1 as the following:

param([string]$instance, [string]$database)

$destinationConnection = New-Object System.Data.SqlClient.SqlConnection
$destinationConnection.ConnectionString =
"Server=$instance;Database=$database;Integrated Security=True"
$destinationConnection.Open()

$sqlCmd = New-Object System.Data.SqlClient.SqlCommand
$sqlCmd.Connection = $destinationConnection
$sqlCmd.CommandText = "TRUNCATE TABLE MyTable ;"
$sqlCmd.ExecuteNonQuery()

$destinationConnection.Close()

exit

In the main script, I use Start-Job command to call JobName.ps1.

$inst = "MySQLServer"
$db = "MyDB"

Invoke-Expression "Start-Job -ScriptBlock {powershell.exe -File
C:\Scripts\JobName.ps1 $inst $db}"

This background job never completes (always in Running state) even though
every statement inside JobName.ps1 is done. Oddly, if there are only same
simple statements in JobName.ps1, it will complete.

What is wrong? Thanks

Re: Mount Exchange 2003 databases using Powershell

Marco Shaw [MVP] — Wed, 18 Nov 2009 13:31:39 GMT

> However I cannot mount them by issuing the Mount-Database cmdlet. Anyone

Quote:

> got
> the equivalent code to achieve this result? I am not a coding expert by
> any
> means so if someone has the code I need could they please post it?

Mount-Database may not support Exchange 2003.

If you need to do this using PowerShell, you'll need to look at the WMI
methods or some other way to do this.

For example, I wonder if this would help somewhat:
http://www.windowsnetworking.com/kba...mmandLine.html

Marco

Set security DACL issues

Jason Ferguson — Wed, 18 Nov 2009 08:54:01 GMT

Hi Jason,

Apologies, it should have been $SD.Properties["DACL"]. However, if
you're creating a security descriptor you need the ManagementObject not
the ManagementClass.

Extending that with a bit of an example we end up with:

# A shortcut to create the management class
$SDClass = [WMIClass]"Win32_SecurityDescriptor"
# Create a new instance of the management object from the class.
$SD = $SDClass.CreateInstance()

# Create an Access Control Entry - shorter version of creation
$ACE = ([WMIClass]"Win32_ACE").CreateInstance()
# Create a Trustee
$Trustee = ([WMIClass]"Win32_Trustee").CreateInstance()
# Assign a username and password. Setting a SID is an alternative here.
$Trustee.Name = "someone"
$Trustee.Domain = "domain"

# Assign the trustee to the ACE
$ACE.Trustee = $Trustee

# These need values according to the rights you wish to grant
# An Allow ACE:
$ACE.AceType = [Security.AccessControl.AceType]::AccessAllowed
# Full Control:
$ACE.AccessMask = [Security.AccessControl.FileSystemRights]::FullControl

# Add the new ACE to the (currently blank) DACL
$SD.DACL = $ACE

# etc...

You're trying to create a Security Descriptor for use with the Create
method under Win32_Share?

AccessMask values are here:

http://msdn.microsoft.com/en-us/libr...temrights.aspx

AceTypes here:

http://msdn.microsoft.com/en-us/libr...l.acetype.aspx

AceFlags aren't really relevant for shares, they tend to be nothing.

HTH

Chris

Slow?

Al Fansome — Wed, 18 Nov 2009 07:13:15 GMT

Having a quick peek at your code, I would write it little bit different and
use RegEx replace instead:
http://msdn.microsoft.com/en-us/libr...x.replace.aspx

Martin

"Al Fansome" wrote in message
news:INKdnSG6dLcWA57WnZ2dnUVZ_j6dnZ2d@newsgroup

Quote:

> I have a set of about 230 files that I want to modify. I use the following
> script:
>
> rm tmp.tmp
>
> foreach ($file in dir *exitlc.cfg)
> {
> echo $file.name
> mv $file tmp.tmp
>
> foreach ($line in cat tmp.tmp)
> {
> if ($line -match "^#.+version")
> {
> $line = $line -replace "version[ \t]+[^ \t]+",
> "version 1.03"
> }
>
> if ($line -match "(.+DS60_[^ \t]+[ \t]+[^ \t]+[ \t]+)")
> {
> $line = $matches[1] + "25 25"
> }
>
> $line | add-content -encoding ascii $file
> }
> rm tmp.tmp
> }
>
> The script works just fine, but it takes between 1.5 and 2.0 seconds to
> execute for each file. Each of these files are simple ASCII text, of about
> 300 lines. At first blush this seems like a very long time to process such
> small files. I'd appreciate comments as to whether I could do better, and
> as to why this script takes so long.
>
> This is using PS 2.0. My OS is Windows XP SP3. CPU is 2.6 ghz, and RAM is
> 1 gigabyte. Disk is a Promise Raid 1 array of two 120 gb drives.
>
> Thanks,
>
> Al

Re: How do I get absolute path of a file?

Larry__Weiss — Wed, 18 Nov 2009 06:12:28 GMT

Except for a typo where you have $docss I don't see why that would not work.

I've recoded as

copy-item $doc c:\ -whatif

to see exactly how the paths are defined for the copies and I see what you are
saying. It seems like a bug to me.

Even recoding as

$docs | % { copy-item $_ c:\ -whatif }

does not help. I don't see what default property would cause it to lose a node
in the path during the copy from the items in subfolders.

- Larry

Megaton wrote:

Quote:

> I would like to copy a collection of .doc files to C:\ one by one and print
> out on screen.
>
> What I am doing is first getting a collection of doc files:
> $docs = get-childitem -recurse d: | where-object {$_.Name -like "*.doc"}
>
> then I use a foreach loop to go through these .doc files
>
> foreach ($doc in $docss)
> {
> copy-item $doc c:\
> write-host "Copied file ""$doc"" to directory: C:\"
> }
>
> but the problem is that the copy-item statement looks for files under the
> current working directory so I get lots errors. How do I get the path for
> each $doc?

converting 1.0 snap-ins to 2.0 modules

Darren Mar-Elia $Group Policy MVP$ — Wed, 18 Nov 2009 03:06:20 GMT

Per the subject line, is this documented anywhere? I did a search on MSDN
and Google and didn't find anything particularly clear. I have some C#
snap-ins that I'd like to convert to 2.0 modules and am looking for
developer best practices, tips, hints, etc..

Thanks!

Darren

Re: How do I get absolute path of a file?

Al Fansome — Wed, 18 Nov 2009 02:34:27 GMT

Because default property to return is Name, not FullName...

You will get fullname by calling other .NET functions thought (retrieval of
files or subfolders returns array of strings)

Martin

"Larry__Weiss" wrote in message
news:OCC6zPAaKHA.5852@newsgroup

Quote:

> I'm wondering why you have to refer to a file's fullname property
> explicitly.
>
> I thought that the object itself would have been defined well enough to
> resolve it to a specific file resident at a specific location.
>
> Isn't that the point of collecting the objects and not just the names?
>
> - Larry
>
>
> Al Fansome wrote:

Quote:

>> Oops, actually
>> copy-item $doc.fullname c:\
>> works. Sorry.
>>
>> Megaton wrote:

Quote:

>>> Hi
>>> I would like to copy a collection of .doc files to C:\ one by one and
>>> print out on screen.
>>>
>>> What I am doing is first getting a collection of doc files:
>>> $docs = get-childitem -recurse d: | where-object {$_.Name -like "*.doc"}
>>>
>>> then I use a foreach loop to go through these .doc files
>>>
>>> foreach ($doc in $docss)
>>> {
>>> copy-item $doc c:\
>>> write-host "Copied file ""$doc"" to directory: C:\"
>>> }
>>>
>>> but the problem is that the copy-item statement looks for files under
>>> the current working directory so I get lots errors. How do I get the
>>> path for each $doc?

parse logs with multiple variables

jlo — Mon, 16 Nov 2009 18:58:03 GMT

What's the format of your log file?

"jlo" wrote:

Quote:

>
> i am trying to parse log files (text files) by searching multiple
> variables and i cant seem to tie them all together through regex or
> pipelining properly.
> here are all the things i am trying to parse through:
> - log date entry- i want to only accept entries between certain hours
> of the day (i.e - 9am to 5pm (17:00:00)
> - if between those hours then i want search for a keyword and output
> all lines with both these positive conditions of hour and keyword to a
> text file then...
> - count all entries per hour and output seperate hour count
> - count all entries per day and out day count.
>
> is this possible :)
>
>
> --
> jlo
> .
>