View Part 2 View Part 4 Help and Commands ( Get-help, Get-Command) Get-help  Powershell has most comprehensive help feature that help us figure out how well we can use the commands. Help feature can be used with different switches to figure out how those commandlets can be used To display every help topic use "Get-Help … Continue reading Learn PowerShell (my way)!! Part 3

View Part 1 View Part 3 Lesson 2 : Variables, Parameter/Arguments "Thumb rule" for my scripts, I do use variables as much possible I can, so that script will not be tough for someone to decode it themselves! Use variable for reading, displaying, passing values within my scripts. All variables preceded with a $ sign … Continue reading Learn PowerShell (my way)!! Part 2

Lesson 1 : Learn it yourself! Check out Part 2 Folks, though I am not an expert I managed to automate the stuff i require, many of my friends wonders 'how to learn powershell scripting'. To me there is no one else other than you teach you better, you will get the scripting fire on … Continue reading Learn PowerShell (my way)!! Part 1

Folks below are some help with working on password on Powershell. Most of this time, I have face issue using plain password while working with plink.exe, psexec.exe or robocopy. Below script help you to 'input' password in secure format and convert it in to plain format ot call it on a psexec.exe or other command … Continue reading Working with Passwords and SecureStrings on Powershell

Below script  wrote it for moving the computers with in the same domain as part of some OU re-consolidation, whole script must not be use it as whole since this was for my unique requirement. I want the server computer object moved from various location to a common OU place (you can mention actual OU … Continue reading Move Computers between OUs- Using Powershell

Other one I have taken from my old Blog site "https://vipinvasudevan.blogspot.com/" Situation is, Our organization decided to implement a solution to implement certificate level authentication for a system used in-house  We have had almost around 2000+ roaming laptop users who never connect to intranet but need certificate to be downloaded. We have no option left but … Continue reading Powershell script to request and export Certificates with Private Key (PFX)

Taken from my old blog site "Vipinvasudevan.blogspot.com" Below script help you to convert any excel files in to csv format #--------------Script Start----------------------------- #Convert Excel file to CSV $xlCSV=6 $Excelfilename = "C:\Temp\file.xlsx" $CSVfilename = "C:\Temp\file.csv" $Excel = New-Object -comobject Excel.Application $Excel.Visible = $False $Excel.displayalerts=$False $Workbook = $Excel.Workbooks.Open($ExcelFileName) $Workbook.SaveAs($CSVfilename,$xlCSV) $Excel.Quit() If(ps excel){kill -name excel} #--------------Script End----------------------------- In … Continue reading Powershell Script to convert Excel files to CSV

Below script, used I used in a situation, where we are using LAPS (Local Administrator Password Solution https://technet.microsoft.com/en-us/library/security/3062591.aspx ) used and computer object deleted from  active directory. Either need to restore the Local admin password  (https://vipinvasudevan.com/2016/11/21/how-to-reset-lostadministrator-password-using-dvd/), I would recommend restoring the AD computer object with below script and recover old known password. # ————              Restore AD … Continue reading RESTORE COMPUTER OBJECT AND RETRIEVE LOCAL ADMIN PASSWORD USING POWERSHELL