PowerShell is a command prompt and a scripting environment designed for Windows system administration.

learn more… | top users | synonyms

2
votes
1answer
31 views

Chain nesting XML elements

I have a scenario where I need to chain nest XmlElements, and I got a working solution using a recursive function, but I can't help but feel that it can be made better. Here's my code so far: ...
4
votes
4answers
94 views

Advent of Code Day 6: toggling lights in a grid with Powershell

I am using the "Advent of Code" series to help with my PowerShell education. The Day 6 puzzle has a 1000 × 1000 grid of lights. After processing instructions to turn on, turn off, or toggle rectangles ...
1
vote
0answers
9 views

Optimize Advent of Code Day 6 with Powershell [duplicate]

I am using the "Advent of Code" series to help with my Powershell education. http://adventofcode.com/day/6 I am confident that this script will produce the right answer. However, it is going way too ...
3
votes
1answer
36 views

Script to periodically Identify and act on public IP address

This script checks what the current public IP address is. The plan is for this to run every 5 minutes or so, and then change some host file configuration depending on whether we the IP is identified ...
2
votes
0answers
44 views

Create share folder, AD security group, add descriptions, and apply security to new folder

My goal for this script was to: Create new folder Create AD group FS-TESTSHARE-R Create AD group FS-TESTSHARE-RW Apply both groups to the new share folder Set full read permissions to FS-TESTSHARE-R ...
3
votes
1answer
49 views

Create share folder and AD security group and apply security to new folder

I think I'm finally done with my code and was hoping for some pointers. My goal for this script was to: Create new folder Create AD group FS-TESTSHARE-R Create AD group FS-TESTSHARE-RW Apply both ...
2
votes
1answer
34 views

Is this the cleanest way to Set ACLs?

So this is my full script that I've been working on. My plan is to Create New, Folder, Create AD Group FS-TESTSHARE-R, Create AD Group FS-TESTSHARE-RW, Apply Both groups to the new share folder, Set ...
1
vote
1answer
36 views

Powershell task to poll SQL database for psexec commands to run

We have a requirement for a script which polls an SQL database for scrape commands which need to be run. These commands are added to the SQL database on an ad-hoc basis. The scrape commands themselves ...
6
votes
1answer
68 views

Batch script to make folders hidden

I just wrote a simple script cmd to hide private folders by combining several scripts from the Internet. Can anyone give me suggestions for improvement? This batch file uses a password hidden by ...
9
votes
1answer
53 views

Powershell Script for setting DHCP reservation description & host value

I'm new to Powershell scripting and trying to write a script that will go through printer queues on a print server, get the print queue's port address, then compare the print queues port address to ...
1
vote
0answers
20 views

Grouping all mathematical results using a number sequence with basic math operators

Not sure how to make the title smaller. I was reading the question A truly amazing way of making the number 2016 and some of the answers referred to programatically determining the answer set. What ...
9
votes
1answer
53 views

Bush wanderer console game

I had read the question: Bush Wanderer - code intended for teaching and wanted to play with PowerShell. Including the rules of the game from that same question. Bush Wanderer Task 1 ...
2
votes
1answer
95 views

Get AD Users' Latest Last Logon Dates across Multiple DCs

I was recently asked to help our Spanish BU to audit their AD for inactive accounts. Grabbing a script from online I gave them this: ...
7
votes
2answers
195 views

Power-Guessing The Number

I decided to help @Matt out a bit and ask a PowerShell question. This is a simple guess-the-number game learning how to use functions with and without parameters, and use the input and output ...
5
votes
1answer
73 views

Sherlock is going against the Beast with PowerShell

I ran into this challenge a couple of times today and thought I could tackle it with PowerShell. I refused to look at other peoples approaches to this hoping to complete it on my own. I'm sure the ...
2
votes
0answers
16 views

Non-install based customization for creating windows 7 images

Before I had access to VM's, money or had any PowerShell knowledge I made this script that would do some image customizations for me. I used physical computers and would be reinstalling the OS while I ...
3
votes
1answer
55 views

Find related groups among list of users

I have one of my first PowerShell scripts that will query a list of users in Active Directory. While doing so it will keep a tally in a hashtable that will update for every group increasing it count ...
1
vote
2answers
71 views

Powershell script to iterate through folder and restore SQL backups

I am working on a PowerShell script which will loop through a directory containing SQL Server database backup .bak files; move the files to a different location; restore each of those files to the ...
2
votes
1answer
89 views

Creating a portable encrypted credential store

There have been a few questions over on SO recently about securely storing credentials in Powershell scripts. Because ConvertFrom-SecureString uses DPAPI it makes ...
6
votes
1answer
50 views

SharePoint Online inventory

I'm creating a script to turn into a commandlet we can reuse as part of our custom PowerShell module. This works, but is very slow. I don't suspect it is anything to do with my code. I have to ...
4
votes
1answer
60 views

Delete orphaned SIDS + change to full control

I need to delete all the orphaned SIDs in the ACLs of about 20 shares (between 100GB/6TB) and change full control of users groups to other permissions (modify or read/execute). I have done this script ...
4
votes
1answer
101 views

Batch/PowerShell script that toggles the minimized state of a window

I wrote this script for a user who wants to toggle the minimized state of a window that minimizes to the tray. The user required a .bat script, so I wrote a bat + PowerShell hybrid script in order to ...
9
votes
1answer
84 views

FizzBuzz: A PowerShell Story

After reading way too much into what fizzbuzz was I though PowerShell could easily have its way with this. ...
5
votes
1answer
177 views

Query AD and build CSV based on certain user object properties

My question is about code efficiency. I recently had to write a Powershell 3.0 script which had the following criteria: It had to pull all enabled user objects from active directory It had to pull ...
1
vote
1answer
41 views

XML editing and merging

I have only started working with XML files and PowerShell. I feel that while there are many ways to accomplish the same thing that I might be doing the following inefficiently. This is all based on ...
4
votes
1answer
230 views

Powershell zip subfolders recursively, conditionally

This is a progression of the script I posted here: Zip the contents of subfolders, conditionally It does this: Determines all subfolders recursively Checks each subfolder for files older than 31 ...
4
votes
1answer
44 views

Powershell to break apart large flat files (e.g. csv)

I created the below script to help break apart large flat files; to save myself effort opening files which are several gigs in a text editor and manually split them. So far I've only tested on sample ...
2
votes
1answer
43 views

Enforcing Paired Statements Using ScriptBlock

I really like c#'s Using statement as it allows you to pair Open statements with their corresponding ...
2
votes
1answer
50 views

Oneliner to extract External IP from IFCONFIG.CO

I wrote a small function in powershell that works fine, however I feel its extremely hacky and I'm sure there must be a smarter way to do this. In the interests of learning, what can I do to improve ...
1
vote
1answer
105 views

Zip the contents of subfolders, conditionally

I've written a script in Powershell for zipping files into new folders. This script performs the following steps: Check whether each subfolder contains non-zip files which are older than 31 days If ...
4
votes
0answers
149 views

PowerShell GUI to display information about users

I have a GUI file which is currently being ran by VBS, but I have a few issues: PowerShell v2 is what is being run on every machine and I cant change that, runs very slow on first time launch. it ...
3
votes
2answers
141 views

Powershell function to get hash value of a file

I created a function to get the hash value of a file. Normally the output is 3 lines. My function does 3 things: extracts the hash value removes the spaces in between the hash value prints hash ...
1
vote
0answers
62 views

PHP to Powershell - Transport Function

I had previously made a script for an Active directory password changer but i wanted to compress the main component into a function by itself to keep it small. ...
5
votes
1answer
40 views

Querying list of servers with PS to report on Scheduled Tasks

I work in a Windows environment where Scheduled Tasks have never been documented or kept up with, leaving us with about 150 servers that have a random smattering of tasks. I am attempting to construct ...
5
votes
1answer
181 views

Terminating an Active Directory user

I'm writing an AD Termination script for work. I'm new to PowerShell and was wondering if multiple commands within PowerShell switch statement is okay to do: ...
1
vote
1answer
930 views

Powershell to Convert HTML Table to Array of PSCustomObject

I created the below script to sent a request to a website, then convert the table in the results to an array of PSObjects which I can work with in PowerShell. This uses some nasty hacks (e.g. using a ...
1
vote
1answer
196 views

Tree-view of Active Directory group memberships using recursion

Using Powershell, I've created a script to create a tree-view of a group/s' memberships in Active Directory. I originally had layers of nested loops, but I wanted a more algorithmic solution. The ...
16
votes
1answer
489 views

Powershell to quickly ping a number of machines

I came up with the below code to improve the peformance of pinging a large number of machines. At present it's fairly basic, but thought I should see what people thought before proceeding further. ...
2
votes
1answer
78 views

PowerShell Unpivot Object

Based on a question on SO I thought I'd knock up a cmdlet to perform an unpivot on an object. I've not yet considered all the options (e.g. what happens when objects with empty lists are passed), so ...
5
votes
1answer
291 views

Import Excel, unpivot data, output tab-delimited for SQL Import

I have a client GL file (Excel) that needs to be regularly imported to SQL Server (as tab-delimited txt). Sample (simplified): ...
4
votes
1answer
4k views

Delete folder if it exists in PowerShell

In my PowerShell script I'm trying to delete a folder, but only if it exists: if (Test-Path $folder) { Remove-Item $folder -Recurse; } I find myself repeating ...
4
votes
1answer
416 views

Getting a list of all computer objects in each AD domain

So I wrote this script and although it does work I can't help but think that it can be more efficient with all the repetitive code. Can anyone offer any suggestions on making it fewer lines and ...
2
votes
1answer
103 views

Powershell photo sorter/mover

I'm just beginning in Powershell - This will be my first full project, start to finish, and it's quite small. I have already had experience in C#, which helps in this .Net based language. This ...
2
votes
1answer
989 views

Convert list of UTC to Current TimeZone

I found myself with a list of UTC timestamps and wanted to convert them into the local time zone. Using this web post as a starting point, I modified the script to grab a text file containing UTC ...
8
votes
1answer
231 views

MD5 hash comparison for two folders

Using this page for a starting point into comparing MD5 hash values from files in two different folders, I've put something together that outputs either Copied if ...
-2
votes
1answer
49 views

Extracting first initial and last name [closed]

How can I do this better? $a = "Tom Smith" ; $e = $a.substring(0,1) $ee = ($a).split(" "); $y = $e + $ee[1]; $y TSmith
8
votes
1answer
1k views

PowerShell within HTA

I've put some code together that helps me search an internal ticket system using an HTA application with some TextBoxes and some embedded VBScript that runs PowerShell scripts. The PowerShell scripts ...
1
vote
1answer
428 views

Write to the event log without needing to check whether or not it exists by use of a `-Force` parameter

Below is some powershell to write to the event log; if the -Force parameter is specified this saves you the effort of writing additional code to first check whether ...
3
votes
1answer
102 views

Backing up single-user PC data

I wrote a PS script to backup data from single user pcs to their network homedrive. The purpose of this tool is to save some time and ensure process consistency when reimaging/replacing machines. I ...
8
votes
1answer
2k views

Powershell search millions of files as fast as possible

I once asked a similar question but in C#. Now I have the same problem in powershell.. What is the fastest way, to search files newer than 15 minutes, in a file system with more than 1 million files? ...