How to create DHCP scopes with PowerShell

Recently I was approached by a network engineer who was adding scopes to DHCP for our move to Detroit. He had around 80 of them to configure, including all of the different options for the subnets. I did a little research and couldn’t find a native snapin for PowerShell to handle creating the [...]

How to kill all but the newest Excel process with PowerShell

Excel was the example I used, but you could use anything…Somebody on HardForums.com was asking about a way to kill all but the most recently started Excel process. I came up with this:

get-process | where-object { $_.name -eq “excel” } | sort-object -property “Starttime” -descending | select-object -skip 1 | foreach { taskkill [...]

get-servernames.ps1 – Return a List of Computer Objects from Active Directory

I should have posted this a long, long time ago…but forgot. Until I got a comment from dvdor about it.

In Active Directory, we set the “Managed By” field on all of the servers we manage to our primary, non-admin account. This makes it easy for people to find out who manages what [...]

Importing product descriptions into ZenCart using PowerShell, Excel, and phpmyadmin – Part 2

If you followed the last post, this one is a continuation.

So, you’ve imported all of your products into the products table with the last script. Next, you need to add the information about the products to products_to_categories, so the categories are properly mapped, and to products_descriptions, so you have a name, etc.

 You’ll need the products_id of the FIRST product you inserted with the last script.

Check out this PowerShell script: Continue reading Importing product descriptions into ZenCart using PowerShell, Excel, and phpmyadmin – Part 2

Importing product catalogs into ZenCart using PowerShell, Excel, and phpmyadmin – Part 1

I’ve been busy tonight working on ChaosCollectibles, trying to get all of the products added. Since the first thing I did was grab all of the images, I was done “scanning.” Next, I needed to add them all to the site.

Dave had spent about 5 hours in total adding around 100 cards. We still [...]