Search results for 'sectionid:230' matching tag 'Remote PowerShell'

I have bitten off more than I can chew and can't see the forest for the trees...HELP!!!

Oseis — Tue, 21 Aug 2012 05:00:00 GMT

I have written the following script but each fix I do breaks 2 other things. For instance I am loading variable data to an .xlsx and it errored that the object was not a string. So I added .ToString method and it now says my passed variable ($computer) loaded using the Get-Content cmdlet is null!

Prior to using .ToString it went had no issues with the variable.

I am frustrated, stuck and out of time. Please help!

Oh yeah and the excel formulation broke as well.

$computers = Get-Content -Path H:\Computer.txt
$Ping = Test-Connection -ComputerName $computer -Count 1 -ErrorAction SilentlyContinue
Foreach ($computer in $computers)
    {
        #Check if machine is online
        if ($Ping)
            {
                #begin Row count for Excel
                $Row=3
                #Start WinRM Services
                $service = Get-WmiObject -ComputerName $computer -Class Win32_Service -Filter "Name='WinRM'"
                $service
                $service.StartService()

                #If Online eq true Get Environment Variables
                $Build = Invoke-Command -ComputerName $computer -ScriptBlock {$env:bldver}
                $Domain = Invoke-Command -ComputerName $computer -ScriptBlock {$env:userdomain}
                $DNSDomain = Invoke-Command -ComputerName $computer -ScriptBlock {$env:userdnsdomain}
                $LogonServer = Invoke-Command -ComputerName $computer -ScriptBlock {$env:logonserver}
                $NLTest = Invoke-Command -ComputerName $computer -ScriptBlock {([System.DirectoryServices.ActiveDirectory.Domain]::GetCurrentDomain()).FindDomainController()}
                $OnlineStatus = "Online"
                $OS = (Get-WmiObject Win32_OperatingSystem).Version
                $SID = Invoke-Command -ComputerName $computer -ScriptBlock {$env:username}
                $UAT = Invoke-Command -ComputerName $computer -ScriptBlock {$env:uatdata}


                #Determin if PC is logged onto Domain
                if ($Logonserver -eq $computer)
                    {
                        $Loggedin = "Locally"
                    }
                else
                    {
                        $Loggedin = "Domain"
                    }

                #Get IP and NIC Info
                $NICItems = gwmi -class "Win32_NetworkAdapterConfiguration" -name "root\CimV2" -comp $computer | Where-Object {$_.defaultIPGateway -ne $null}
                    ForEach ($NICItem in $NICItems)
                    {
                        $MAC = $NICItem.MacAddress | select-object -first 1
                        $IP = $NICItem.IpAddress | select-object -first 1
                        $Subnetmask = $NICItem.ipsubnet | select-object -first 1
                    }

                #Create Excel Spreadsheet
                $Excel = new-object -comobject Excel.Application
                $Workbooks = $Excel.Workbooks.Add()
                $Worksheets = $Workbooks.worksheets
                $Worksheet = $Worksheets.Item(1)
                $Worksheet.Name = “Clientside Commonality ”
                $Excel.Visible = $True
                $Cells = $Worksheet.Cells

                #Create Title and Column Headers
                $Cells.Item(1,1) = "Commonality Tracker"
                $Cells.Item(1,7) = Get-Date
                $Cells.Item(2,1) = "Computer Name"
                $Cells.Item(2,2) = "Online Status"
                $Cells.Item(2,3) = "Domain"
                $Cells.Item(2,4) = "DNSDomain"
                $Cells.Item(2,5) = "UAT"
                $Cells.Item(2,6) = "MAC Address"
                $Cells.Item(2,7) = "IP Address"
                $Cells.Item(2,8) = "Subnet Mask"
                $Cells.Item(2,9) = "Logged In User"
                $Cells.Item(2,10) = "Operating System"
                $Cells.Item(2,11) = "Build Version"
                $Cells.Item(2,12) = "Netsh results location"
                $Cells.Item(2,13) = "Authenticated"
                $Cells.Item(2,14) = "NLTest DC"

                #Format Cell Headers
                $Cells.Item(1,1).Font.Bold = $True
                $Cells.Item(1,1).Font.Size = 22
                $Cells.Item(1,7).Font.Bold = $True
                $Cells.Item(1,7).Font.Size = 20
                $range.ColumnWidth = 50
                $range.Font.Bold = $True
                $range.Font.Size = 14
                $range.HorizontalAlignment = 3
                $range = $excel.Range("A2",”L2")
                $range.ColumnWidth = 50
                $range.Font.Bold = $True
                $range.Font.Size = 14
                $range.HorizontalAlignment = 3

                #Begin populating Excel
                $Cells.Item($Row,1) = $computer.ToString()
                $Cells.Item($Row,2) = $OnlineStatus.ToString()
                $Cells.Item($Row,3) = $Domain.ToString()
                $Cells.Item($Row,4) = $DNSDomain.ToString()
                $Cells.Item($Row,5) = $UAT.ToString()
                $Cells.Item($Row,6) = $MAC.ToString()
                $Cells.Item($Row,7) = $IP.ToString()
                $Cells.Item($Row,8) = $Subnet.ToString()
                $Cells.Item($Row,9) = $User.ToString()
                $Cells.Item($Row,10) = $OS.ToString()
                $Cells.Item($Row,11) = $Build.ToString()
                $Cells.Item($Row,13) = $Loggedin.ToString()
                $Cells.Item($Row,14) = $NLTest.Name



                #Check OS version and Run boot trace if Windows 7
                $Acct = "System"
                $Netsh = Invoke-Command -ComputerName $computer -scriptblock {$Trace}
                $Reboot = Invoke-Command -ComputerName $computer -scriptblock {"Shutdown /r /c "+"This computerwill restart in 10 Minutes to capture essential data to troubleshoot your issues. Please save your work and pardon the interruption."+" /t:600"}
                $Schedule = Invoke-Command -ComputerName $computer -scriptblock {$Task}
                $Task = "schtasks.exe /create /s $computer /ru $Acct /tn $TaskName /tr $TaskRun /sc $Schedule /F"
                $TaskName = "Stop netsh"
                $TaskRun = "netsh trace stop"
                $Trace = "netsh trace start capture=yes persistent=yes report=yes tracefile=C:\bootcap.etl"



                If ($OS -eq "6.1.7601")
                    {
                        $OSType = "Windows 7"
                 #       $Netsh
                 #       $Schedule
                 #       $Cells.Item($Row,12) = "C:\bootcap.etl"
                 #       $reboot
                    }
                else
                    {
                        $OSType = "Windows XP"
                    }
                #Increment Row
                $Row += 1
            }
        else
            {
                $OnlineStatus = "Offline"
            }

        #Populate Excel for offline machines

        $Cells.Item($Row,1) = $computer
        $Cells.Item($Row,2) = $OnlineStatus

        #Increment Row
        $Row += 1



     }

#Stop WinRM Services
$service.StopService()

#Autosize Columns
$Worksheets.UsedRange.EntireColumn.AutoFit() |out-null

#Save your work
$Workbooks.SaveAs("H:\Troubleshooting.xlsx")
$Excel.quit()

#EOF

Compressing files remotely

Grifter — Sun, 29 Jul 2012 05:00:00 GMT

Hi,

I'm building an application for work that backups et restore a software with Powershell and winforms. There is some databases and core files to backup/restore. Now the SQL part works fine using SMO but my remote file compression doesn't fully work. It does not grab all the files, some are missing (7 MB out of 105 MB zip file). If I use the same script locally with the same user, used to create the PSsession, it works. The user has admin rights on both systems.

Here the compression script used:

$securePassword = ConvertTo-SecureString "$SolabsAdminpwd" -AsPlainText -force

$SolabsAdminuserLongName = "$Domain\$SolabsAdminuser"

$credential = New-Object System.Management.Automation.PsCredential("$Domain\$SolabsAdminuser",$securePassword)

$session = New-PSSession -computername $combobox1.SelectedItem -credential $credential

$ServiceObj = Get-Service -ComputerName $combobox1.SelectedItem $ServiceName

If ($ServiceObj.Status -eq 'Running') {

$ServiceObj.Stop()

}

$waitInterval = new-timespan -seconds 5

$ServiceObj.WaitForStatus('Stopped', $waitInterval)

$Arguments = @($SolabsInstancePath, $TaskPath)

$Job = Invoke-Command -session $session -ArgumentList $Arguments -AsJob -JobName Zip -ScriptBlock {

Param ([string]$SolabsInstancePath, [string]$TaskPath)

$InstallDir = Get-item -Path $SolabsInstancePath -Force

$ZipFileName = "$TaskPath\SOLABS.zip"

set-content $ZipFileName ("PK" + [char]5 + [char]6 + ("$([char]0)" * 20))

(dir $ZipFileName).IsReadOnly = $false

$ZipFile = (new-object -com shell.application).NameSpace($ZipFileName)

$ZipFile.CopyHere($InstallDir.FullName)

}

Is there something in the PSSession I should configure to see those files ?

Thank You

Powershell- Associate Mount Point to Physical Disk

dbisseg — Tue, 10 Jul 2012 05:00:00 GMT

I need to be able to associate mount points (Get-WmiObject -Class Win32_MountPoint) with the physical drive on which it resides.

Scenario: I have physical disks (SAN LUNs) mounted as folders on an E: drive (also a SAN LUN) of a server. I need to be able to, via a PowerShell script, associate the "folder" name to the physical disk (i.e., Harddisk4 or PhysicalDrive4).

I can get Mount Point associated with the Volume, etc., but can't make the link to the physical disk.

Any help is appreciated.

Streaming In PowerShell

ash.cash — Mon, 09 Jul 2012 05:00:00 GMT

Is there any way of Streaming Data or specially Strings in Powershell Cmdlets using the WriteOutput function

Re: Call Exchange shell/cmdlets from Quest Shell - Proper method?

virtuallynothere — Tue, 03 Jul 2012 05:00:00 GMT

Thanks, so the tools are installed on the system I need to run this script from, and I got this to work, so is this not recommended either?

c:\program files\Microsoft\Exchange\V14\bin\RemoteExchange.ps1 ; connect-ExchangeServer - Auto

Is that OK or do I need to do the Remote session noted in your reply above?

Re: Call Exchange shell/cmdlets from Quest Shell - Proper method?

virtuallynothere — Fri, 29 Jun 2012 05:00:00 GMT

I tried to do that, but when I run the get-pssnapin - registered the exchange tools don't come back as registered.

Then I've read it's not "supported" to add the snapin for the exchange tools in another shell aside from the exchange shell, so you should use a remote connection, and then I found another thread about using a command like the one below, but that fails as well as connect-exchangeserver is "unknown".

'C:\Program Files\Microsoft\Exchange Server\V14\bin\RemoteExchange.ps1'; Connect-ExchangeServer <target server>"

Call Exchange shell/cmdlets from Quest Shell - Proper method?

virtuallynothere — Thu, 28 Jun 2012 05:00:00 GMT

Hello,
I now know the best methods of remoting thanks to Don & the folks here.

But I have to use the Quest shell as we utilize their Active Role solution and I need to write a script that runs when something is done to users accounts through that system.

I know how to set it up and what commands I need to run, I am not sure of how to call the Exchange shell which installed locally or connect to Exchange in order to run the commands I need.

Can anyone help me out?

Thanks!

Re: Remote Powershell - options to run commands?

virtuallynothere — Thu, 21 Jun 2012 05:00:00 GMT

Don,

So I've read a fair amount since this post and I bought your last book, but I'm looking at the new "lunches series", and I think I'm still a beginner, but do I need to know powershell 1 or 2 before ordering the powershell 3 book series?

I've read about 20 contradicting threads or articles on the right & wrong way to do remote powershell in terms of executing commands for Exchange Admin, AD Admin, or Microsoft OCS tasks, and using powershell remotely for anything.

Here's the latest article I read, so is it actually "wrong" to think that I could setup a system that has all the modules/snapins that I need, such as Exchange, AD, OCS, Quest, etc, then remote into that machine from my laptop, and perform whatever admin tasks or run scripts that I want to?

It seems like the "right" way is to do it as this article states, but I've read quite a bit about how people use "remote powershell" profiles, and at the very least it seems like there's no reason I couldn't run the powershell commands from my laptop if I have the AD tools, Exchange, and OCS tools installed locally. So essentially I'm confused, if you can help I would really appreciate it.

I couldn't get the training videos right now do to budget and work not covering them.

http://blogs.technet.com/b/heyscriptingguy/archive/2012/01/23/learn-how-to-use-powershell-to-run-exchange-server-commands-remotely.aspx

Start-Process challenge at my work.

chrisdonals1 — Sat, 28 Apr 2012 05:00:00 GMT

I've been trying this and I haven't seen it work how I want yet.
Can I run Start-Process on a remote machine?

invoke-command -computername $computername -scriptblock {
   try {
      start-process "c:\program files\xxxx\xxxx\xxx\xxx\wswc.exe"
      wait-process -name wswc
      write-host "session has terminated"
      (gwmi win32_operatingsystem -computername $computername).InvokeMethod("Win32Shutdown",0)
   }
   catch {
   Write-Warning $_.Exception.Message
   }
}

Script to delete home folders for list of users

virtuallynothere — Tue, 17 Apr 2012 05:00:00 GMT

I am trying to find a way to modify the script below or if anyone has a script that will delete home folders for a list of users if the user names are specified in a text or csv file, can anyone help?

I would like to delete the user accounts as well, but the home folders is fine for now. I want to do this for users in a specific ou and they have a stamped attribute on them from the Quest ActiveRole server, if i could query for users that have the attribute which is a date value, then return the list of users and delete the home folders if the date is within a specific time frame, IE: 7 days, then that would be ideal.

The starting script I have will delete a folder for a single user:

$psSession = New-PSSession -ComputerName HyperV -Credential nwtraders\administrator

Invoke-Command -Session $PSSession -ScriptBlock {
  $HD=$PD=$null
  $Filter = "(&(ObjectCategory=user)(Name=helpme testuser))"
  $Searcher = [adsiSearcher]($Filter)
  $Searcher.Findall() |
    ForEach-Object {
      $HD = $_.properties.homedirectory
      $PD = $_.properties.profilepath
      $PD = "$PD.V2"
   } #end foreach-object
} #end scriptblock

"Taking ownership of $hd"
  Invoke-Command -Session $PSSession -ScriptBlock `
    { Invoke-Expression "takeown /f $HD /r /d y" }
"Taking ownership of $pd"
  Invoke-Command -Session $PSSession -ScriptBlock `
    { Invoke-Expression "takeown /f $PD /r /d y" }
"Adding Administrator Rights to $hd"
  Invoke-Command -Session $PSSession -ScriptBlock `
    { Invoke-Expression "icacls $HD /grant administrators:F /t" }
"Adding Administrator Rights to $PD"
  Invoke-Command -Session $PSSession -ScriptBlock `
    { Invoke-Expression "icacls $PD /grant administrators:F /t" }
"Removing folder $hd"
  Invoke-Command -Session $PSSession -ScriptBlock `
    { Invoke-Expression "Remove-Item -Path $HD -Recurse -Force" }
"Removing Folder $PD"
  Invoke-Command -Session $PSSession -ScriptBlock `
    { Invoke-Expression "RD $PD -Recurse -Force" }

Remove-PSSession -Session $psSession