Alan's Blog

"Yeah. I wrote a script that will do that."

Menu
  • About My Blog
Menu

Upgrading from Server 2008 to Server 2012 R2 – Lessons Learned

Posted on August 16, 2014February 4, 2023 by Alan

I am a member of a terrific IT User group, Carolina IT Professional Group.  This group is focused on educating its members, and giving back to the community.  But what really keeps people to the end are the terrific door prizes.  At the July meeting, I won a copy of Server 2012 R2.  I had…

Read more

PowerShell GUI for AD Recycle Bin

Posted on June 14, 2014October 1, 2014 by Alan

This blog post has been replaced by my guest appearance in the Hey, Scripting Guy blog.  Please follow it to find my post and link to the script.

Read more

Get the Long File Name from the Short File Name

Posted on April 24, 2014November 29, 2014 by Alan

I get some reports which give the path to files as an 8.3 DOS “short” file name, filled with tildes and numbers, such as “c:\progra~2\wid6e1~1\v3.5\sqmapi.dll” for the file “c:\Program Files (x86)\Windows Identity Foundation\v3.5\SqmApi.dll”.  It is easy to go from the long file name to the short file name with a script.  What is less easy…

Read more

Finding the Renamed Domain Admin Account

Posted on April 7, 2014November 29, 2014 by Alan

A good practice is to rename the domain administrator account in an Active Directory domain.  When doing auditing, you will want to know what the name of that account really is.  Get-DomainAdmin.ps1 is a script which will give you this information for any domain in your forest.  It requires the ActiveDirectory module to run.

Read more

Get Holidays for Any Year and Any Country as PowerShell Object

Posted on March 8, 2014February 11, 2022 by Alan

This script started out as a project to figure out how to automate Excel web queries in PowerShell, so MS Excel is a prerequisite for this script.  If you have Excel, but have never used query tables, it is accessible by going to the Data tab, and then choosing “From Web”.  An overview from TechRepublic…

Read more

Combine Multiple Excel Spreadsheets

Posted on March 5, 2014November 29, 2014 by Alan

I create a lot of Excel audit reports in a multi-domain environment.  When they go out, I need to combine the reports from each domain into a single Excel workbook with multiple worksheets.  I found some VBA code on mrexcel.com which was pretty easy to port to vbscript.  I put the script on the desktop…

Read more

Remote Windows Update 3.1

Posted on March 5, 2014April 23, 2014 by Alan

Looking for a script to run Windows Update remotely?   WindowsUpdate.hta version 3.1 is an HTML application which allows you to connect to a remote machine, determine what patches it requires from Windows Update, and install the patches.  You can schedule a reboot time. This version allows you to look at he Windows Update log,…

Read more

Get Distinguished Name of Many computers in PowerShell (Revised)

Posted on February 15, 2014November 29, 2014 by Alan

Getting the DN for an individual computer is not a difficult task in PowerShell, ex: Import-Module activedirectory $(Get-ADComputer $env:COMPUTERNAME).distinguishedName Doing this fast for a long list of machines in a big forest is less easy.  Get-ComputerDN.ps1 gets the distinguished name of a list of computers using WorkFlows. I spent some time trying out how to figure…

Read more

A Cookie is Not a Virus — A BitDefender Rant

Posted on February 15, 2014 by Alan

I can only guess that BitDefender is trying to make itself look good by falsely identifying cookies as malware.  They may be annoying, they may affect your privacy, but they aren’t “infected”.  Crap like this will make me buy a from a different vendor next time.

Read more

Batch file to Run PowerShell Scripts

Posted on February 13, 2014March 1, 2014 by Alan

I have a couple of PowerShell scripts which I run daily, and the number keeps growing.  I wanted a quick way to run scripts which support alternate credentials.  Drag and drop a PowerShell script onto  the RunPS.cmd  batch and you are prompted to run with it with your current credentials, alternate credentials, using RunAs, or…

Read more
  • Previous
  • 1
  • …
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • …
  • 42
  • Next

Search

Please Note

All the scripts are saved as .txt files. Newer files have a “View Script” button which will let you save or open a script in notepad. For earlier posts, the easiest way to download with IE is to right click on the link and use “Save Target As”. Rename file from Name_ext.txt to Name.ext.

To see a full post after searching, please click on the title.

PowerShell Scripts were written with version 3 or later.

https connections are supported.

All new users accounts must be approved, as are comments. Please be patient.  If you find a post error or a script which doesn’t work as expected, I appreciate being notified.  My email is my first name at the domain name, and you are welcome to contact me that way.

Tags

1E ACLS Active Directory ActiveDirectory ADSI Advanced Functions Audit Change Administrator Password COMObject Computer Groups DateTime Desktop DNS Excel FileScriptingObject Forms General GPO GPS Group Policy Hacks ISE Lockout logons NAV740 Nessus OU OU permissions Outlook Pick Folder Power PowerShell Powershell Scriptlets RDP SCCM schedule reboot Scripting Security Shell.Application user information VBA Windows Update WMI WordPress WPF

Categories

akaplan.com

  • Back to Home Page

Archives

Scripting Sites

  • A Big Pile of Small Things
  • Adam, the Automator
  • Art of the DBA
  • Ashley McGlone
  • Boe Prox
  • Carlo Mancini
  • DexterPOSH
  • Doug Finke
  • Jaap Brasser's Blog
  • JeffOps The Scripting Dutchman
  • Jonathan Medd's Blog
  • Keith Hill's Blog
  • LazyWinAdmin
  • Nana Lakshmanan
  • PowerShell Magazine
  • PowerShell Team Blog
  • PowerShell.org
  • PwrShell.net
  • Richard Siddaway's Blog
  • Ryan Yates' Blog
  • Skatterbrainz
  • The Lonely Administrator

SQL Site

  • Art of the DBA

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
©2025 Alan's Blog | Theme by SuperbThemes

Terms and Conditions - Privacy Policy