Search results for '(app:forums OR groupid:24)' matching tag 'scripts'

Powershell from ASP.net

Swapnil Gangrade — Thu, 28 Mar 2013 05:00:00 GMT

Hi,

I have to design a Panel on ASP.net as the user come to it there will be a button on which if it click a remote server powershell script will run automatically and revert back result to the ASP.net page . Is it possible to do that. Can any one please help out on this.

Powershell Hourly trigger

f.lemanie — Tue, 19 Mar 2013 05:00:00 GMT

Hello, I have been readed this link : http://blogs.technet.com/b/heyscriptingguy/archive/2012/09/18/create-a-powershell-scheduled-job.aspx to create a scheduled job.

But I did not find the answer to my issue : I need to repeat a task every 2 hours.

-Hourly parameter does not exist ?

Thanks for your help !

copy last modified files and folders using batch or shell script from one location of server to other

himanshuk — Thu, 14 Mar 2013 05:00:00 GMT

@echo on

set SOURCE=\\sourceservername\c$\temp

set DESTINATION=\\destinationservername\c$\temp

xcopy %SOURCE%* %DESTINATION%* /s /e /i /Y

PAUSE

I want to paste last modified file from source to multiple destinations every 2 hrs, but I expect at least above script should work

How to get around access denied errors in powershell?

jwhite — Sun, 16 Dec 2012 06:00:00 GMT

I'm having this issue in powershell where I can't access the contents of one folder to search via powershell. If I go into the console and go to the folder and open a text file I am able to see the logs on the server. However if I do the same thing in powershell, I get the error "access denied". I find it interesting that I can access the folder contents in console but not shell. I am running a small function to search the same folder across a cas array. Any ideas?

I also notice that if i do a cd and go to the path of the folder and run a get-content I can see the list of files in the folder, problem is just being able to read them.

NEw-service is correctly created but does not start

f.lemanie — Sat, 08 Dec 2012 06:00:00 GMT

hi !

I used this command : new-service, like it is shown in the Posh help. The service is correctly installed but it can't start, or it starts and stops quickly...

EventLog returns :

-Error event 7009 : the overrun of delay has achieve 3000 millisecond...

-Error event 7000 : the service hasn't respond quickly to the request...

the scipt :

new-service -name TestService -binaryPathName "C:\tmp\mysoft.exe"

I tried too like this :

new-service -name TestService -binaryPathName "C:\tmp\mysoft.exe -k netsvcs"

My executable file is a script compilated with PowerGuiPro...

Building pauses in-between objects in commands

i255d — Mon, 03 Dec 2012 06:00:00 GMT

I am runnin a script that is deleting backup over 4 days old. The files are so large that it is casuing problems on my storage when it starts to delete to many at once. I want to build a pause into my script inbetween objects ($_.) as they are piped through the commands. I hope I am explainin this well.

$CURRENTDATE = Get-Date
$TODATE = $CURRENTDATE.AddDays(-4)
get-childitem "\\gha01sdp333\BigBackups\" *.bak -recurse | where {$_.LastWriteTime -le "$TODATE"} | Remove-Item
get-childitem "\\gha01sdp333\BigBackups\" *.trn -recurse | where {$_.LastWriteTime -le "$TODATE"} | Remove-Item

Each *.bak file is hundreds of GB, so I have been asked to find a way to create a delay between each Item before or after it is put in the "where {$_.LastWriteTime -le "$TODATE"}"

Powershell Scripts to Look for Excel file types( .xlsx and .xls )

baykes75 — Wed, 10 Oct 2012 05:00:00 GMT

Hi Experts,

I have an already written scripts which looks for ONLY an excel file with .xls extension. Now,

1. I want the same scripts to look for either .xls or .xlsx which ever it finds in that particular location and use it......

2. The old scripts search for files in the F column only on the excel sheet/file.....This makes the search takes forever, so I would like it to search the files in the F column which ONLY have this path:root_project/Fut_DB_Projects in the E column of the excel sheet.

Pls let me know exactly where to insert it in the scripts. I'm very new to Powershell and your answers would be very much appreciated.

-----------------------------------------------------------------------------------------------------------------

# Creating an object for the Excel COM addin
$excelfile = $args[0]
$folder = $args[1]

echo $excelfile
echo $folder

if($excelfile -ne $Null -and $excelfile.Contains(".xls") -and (Test-Path $excelfile) -eq $True)
{
    if($folder -ne $Null -And $folder.Contains("\") -and (Test-Path $folder) -eq $True)
    {
        $ExcelObject = New-Object -ComObject Excel.Application
        # Opening the Workbook
        $ExcelWorkbook = $ExcelObject.Workbooks.Open($excelfile)
        # Opening the Worksheet by using the index (1 for the first worksheet)
        $ExcelWorksheet = $ExcelWorkbook.Worksheets.Item(1)
        #The folder where the files will be copied/The folder which will be zipped later
        $a = Get-Date
        $targetfolder = "C:\"+$a.Month+"_"+$a.Day+"_"+$a.Year+"_"+$a.Hour+$a.Minute+$a.Second
        #Check if the folder already exists. Command Test-Path $targetfolder returns true or false.
        if(Test-Path $targetfolder)
        {
            #delete the folder if it already exists. The following command deletes a particular directory
            Remove-Item $targetfolder -Force -Recurse -ErrorAction SilentlyContinue
        }

        #The following command is used to create a particular directory
        New-Item -ItemType directory -Path $targetfolder
        echo "Temp folder created"
        #Declaration of variables, COlumn value = 6 for Column F
        $row = 1
        $col = 6

        # Read a value from the worksheet with the following command
        $filename = $ExcelWorksheet.Cells.Item($row,$col).Value2
        $filename
        #change the folder value below to specify the folder where the powershell needs to search for the filename that it reads from excel file.
        $null = ""

        # Loop through each row in the excel file.
        do
        {
            $filename = $ExcelWorksheet.Cells.Item($row,$col).Value2

            #Checking if value read from Excel is Null
            #In powershell operator for NOT EQUAL TO is -ne not <>
            if($filename -ne $Null)
            {
                $filepath = $folder+$filename
                #Check if the filepath read from excel is a real filepath OR check if the file exists.
                if(Test-Path $filepath)
                {
                    #If the file exists, move it to the folder declared above
                    # Change the below command to Move-Item if you want to Move the file and not Copy...
                    Copy-Item $filepath $targetfolder
                }
                else
                {
                    #$Allfiles = Get-ChildItem -Recurse $folder
                    #You add the folders to the following list that you want the script to skip as it searches
                    #for the files through directory and its subdirectories
                    #eg. $xdir = @("Folder1","Folder2","Folder3")
                    $xdir = @("Tables","Views","Update","Synonyms","BES","ADTLTransit","Fut_DB_Jobs","Triggers","Scripts")
                    $remove = [string]::join("|",$xdir)

                    $Allfiles = Get-ChildItem -Recurse $folder | ? { $_.DirectoryName -notmatch $remove}
                    Write-Host -Fore Yellow ("Looking through subfolders now")

                    foreach ($file in $Allfiles)
                    {
                        $testpath = $file.FullName
                        if($testpath.Contains($filename))
                        {
                            Write-Host -Fore Yellow ("Found the file in a subfolder at location:" + $testpath)
                            Move-Item $testpath $targetfolder
                        }
                    }
                }
            }
            #incrementing the row variable by 1 to move to the next available row in excel.
            $row = $row + 1
        }
        #while condition evaluates if value read from the excel is null. If null, then the loop breaks.
        while($filename -ne $Null)

        # Important: The object needs to quit and the variables release, otherwise
        # an Excel.exe will remain open.
        $ExcelObject.Quit()

        $ExcelObject = $null
        $ExcelWorkbook = $null
        $ExcelWorksheet = $null

        [GC]::Collect()
        do
        {
        }
        while((Test-Path -path $targetfolder) -ne $True)
        $targetfolderinfo = Get-ChildItem -Recurse $targetfolder | Measure-Object
        $targetfolderfilecount = $targetfolderinfo.count

        if($targetfolderfilecount -ne 0)
        {
            #Following command calls the function to zip all the files moved from source folder to target folder
            $directory = [IO.DirectoryInfo] $targetfolder

            If ($directory -eq $null)
            {
                Throw "Value cannot be null: directory"
            }

            Write-Host ("Creating zip file for folder (" + $directory.FullName + ")...")
            [IO.DirectoryInfo] $parentDir = $directory.Parent
            [string] $zipFileName

            If ($parentDir.FullName.EndsWith("\") -eq $true)
            {
                # e.g. $parentDir = "C:\"
                $zipFileName = $parentDir.FullName + $directory.Name + ".zip"
            }
            Else
            {
                $zipFileName = $parentDir.FullName + "\" + $directory.Name + ".zip"
            }

            If (Test-Path $zipFileName)
            {
                Remove-Item $zipFileName -Force -Recurse -ErrorAction SilentlyContinue
            }

            Set-Content $zipFileName ("PK" + [char]5 + [char]6 + ("$([char]0)" * 18))

            $shellApp = New-Object -ComObject Shell.Application
            $zipFile = $shellApp.NameSpace($zipFileName)

            If ($zipFile -eq $null)
            {
                Throw "Failed to get zip file object."
            }

            [int] $expectedCount = (Get-ChildItem $directory -Force -Recurse).Count
            $expectedCount += 1 # account for the top-level folder

            $zipFile.CopyHere($directory.FullName)

            Write-Host -Fore Green ("Successfully created zip file for folder (" `
                + $directory.FullName + ").")
        }
        else
        {
            Write-Host -Fore Red ("There are no files to be zipped")
        }

        [System.Threading.Thread]::Sleep(10000)
        Remove-Item $targetfolder -recurse
    }
    else
    {
        Write-Host -Fore Red ("Target folder path not specified correctly")
    }
}
else
{
    Write-Host -Fore Red ("Excel file path not specified")
}

Adding users to a group based on custom attributes

gelmera — Thu, 30 Aug 2012 05:00:00 GMT

Team,

Have an intresting script i am trying to develop and need guidance. I am trying to automate distribution group membership using custom attributes. Currently i am able to add users to a group based on a custom attribute i set example below:

#Get-QADUser -Enabled -SearchAttributes @{extensionattribute5 = 905} | Add-QADGroupMember -Identity "Sales - Districttest"

Before the above script is run i am removing all the membership of the group as the custom attribute number will change for users if they are transfered, disabled, etc... see below snippet:

#Get-QADGroup -SearchAttributes @{extensionattribute5 = 905} | Set-QADGroup -Member $null

So now i need to do this on a larger scale and i am going to do this using a csv file. Note also the extension data attibute number is also set to the distribution group.

I want to be able to add users to the group where that group extension data attribute = the user extension data attribute.

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.

The term xyz is not recognized as the name of a script file ???

adove — Fri, 06 Jul 2012 05:00:00 GMT

I am new to PowerShell, however, I have created a script file to iterate through all users in a site collection. I have placed the script file in a directory C:\_scripts\ and the name of the file is "get_all_users_site_collection.ps1". The problem I am having is when I try to call this script file I am getting an error telling me that this file does not exist. So, I have confirmed the following:

tried accessing file by ".\get_all_users_site_collection.ps1"
tried accessing file by "C:\_scripts\get_all_users_site_collection.ps1"
determined it was there by writing command "dir" and it was there

I don't know what I am doing wrong??? Can someone help?