This article explains how to unzip a file in Powershell, we need to compress the script output or one just wants to unzip file using Powershell script. When there are large files zipped or you want to unzip any reports that are archived then we can do with Powershell, here are simple code performs the unzip function. Expand-Archive This … [Read more...] about How to unzip a file in Powershell
Scripts
How to List All Local User Accounts on System
Powershell Script List All Local User Accounts on windows operating system and get the report in an excel CSV file to work further. Every system administrator must keep track of all local user accounts on the windows machines, or windows servers to manage the infrastructure. These local system accounts have administrative privileges meaning they … [Read more...] about How to List All Local User Accounts on System
Powershell Copy Files | Single | Multiple Computers
If you are looking for a simple script to copy files across multiple remote computers then you are at the right place, in this article we explain with a simple powershell code. when user or administrator wants to copy the files from a source location to a remote location or remote computer then you are at the right place, it's easy, this article … [Read more...] about Powershell Copy Files | Single | Multiple Computers
Test Database Connectivity
Powershell Test Database Connectivity, if you are looking for how quickly one can test the database status using Powershell script then you are at the right place, here are the simple steps. There are many situation database administrators who have to test the database connection or database availability. When there is an update, removal, or … [Read more...] about Test Database Connectivity
Powershell export csv
Using Powershell we can export the output of the script or the data that you need into Excel .CSV file, this article explains how to write the output of any script into CSV file and how to import CSV file data into the script and perform the defined action. The Excel comma-separated value (CSV) file is a simple text file, Powershell easily reads … [Read more...] about Powershell export csv
Connect to SQL database server from Powershell
Connect to SQL database server from Powershell, when there is a need to use Powershell script to connect the database and validate something or run any other script then here is the simple Powershell code. If you want to test or connect and run a database query by using a Powershell script, yes, it is simple with the below code, you just need to … [Read more...] about Connect to SQL database server from Powershell