Aide-mémoire des commandes Windows PowerShell – Le guide ultime dont vous avez besoin

Si vous êtes un utilisateur expérimenté de Windows, vous savez et comprenez probablement comment effectuer diverses opérations sur votre PC peut avoir plus d'une approche et que les applications GUI spécialisées sont souvent plus limitatives (et moins satisfaisantes, soyons honnêtes) que la saisie de commandes dans une ligne de commande manuellement. Il y a juste ce sentiment de satisfaction lorsque vous voyez ce mur de texte se dérouler devant vous, et si le résultat n'est pas une erreur, cela en vaut d'autant plus la peine.

Aide-mémoire des commandes Windows PowerShell – Le guide ultime dont vous avez besoin

Sur les PC Windows, il n'y a que deux façons d'y parvenir : via CMD ou PowerShell. Bien que CMD soit un peu plus populaire que PowerShell, il est également moins puissant, étant donné que son homologue vous permet d'effectuer beaucoup plus d'opérations, y compris celles que vous pouvez exécuter via le CMD. On pourrait dire que PowerShell combine la puissance de l'ancien CMD avec des capacités de script et d'applet de commande, vous offrant une pléthore de possibilités concernant les opérations que vous pouvez effectuer avec lui.

Cependant, le grand nombre d'opérations possibles que vous pouvez effectuer en utilisant PowerShell peut être assez intimidant même pour les utilisateurs chevronnés, sans parler des utilisateurs qui n'ont jamais entendu parler de CMD (sans parler de PowerShell) auparavant. Ne vous inquiétez pas, cependant, nous essaierons de vous apprendre quelques astuces faciles que vous pouvez réaliser avec PowerShell et peut-être même mémoriser à long terme. Bien que ce « cours accéléré » ne soit pas un manuel complet pour PowerShell, il vous aidera, espérons-le, à vous repérer dans PowerShell en vous donnant quelques conseils et en expliquant un tas de commandes. Si vous êtes prêt, commençons.

Qu'est-ce que PowerShell ?

Comme nous l'avons brièvement mentionné ci-dessus, PowerShell est un outil puissant que vous pouvez utiliser pour une vaste gamme d'opérations. Plus que cela, PowerShell est une solution d'automatisation des tâches qui comprend plusieurs outils puissants sous son capot, y compris, mais sans s'y limiter, un shell de ligne de commande (tel que CMD), un langage de script, ainsi qu'un cadre de gestion de configuration.

Contrairement aux autres shells qui ne peuvent accepter et renvoyer que du texte, PowerShell peut également accepter et renvoyer des objets .NET grâce à la quantité exceptionnelle de fonctionnalités qu'il englobe. Certaines des fonctionnalités les plus importantes liées au shell de PowerShell sont les suivantes :

  • Prédiction de commande et complétion de tabulation
  • Prise en charge des alias de paramètres et de commandes
  • Historique complet de la ligne de commande
  • La possibilité d'enchaîner les commandes à travers le pipeline
  • Un système d'aide dans la console similaire aux pages de manuel dans les systèmes basés sur Unix

Cependant, cela ne fait qu'effleurer la pointe de l'iceberg car, comme nous l'avons déjà mentionné, PowerShell est plus qu'un simple shell ; vous pouvez l'utiliser comme langage de script puissant pour automatiser les opérations de gestion du système, mais aussi si vous souhaitez créer, analyser, tester et déployer des solutions dans divers environnements.

Étant donné que PowerShell est basé sur le .NET CLR (.NET Common Language Runtime), il est facile de comprendre pourquoi toutes les entrées et sorties avec lesquelles PowerShell fonctionne sont des objets .NET. De plus, il n'est absolument pas nécessaire d'analyser la sortie de texte pour que PowerShell puisse en extraire des informations. Parmi les fonctionnalités de script de PowerShell, vous pouvez trouver les suivantes :

  • Un système de formatage complet qui assure une sortie propre et facile
  • Créez des types dynamiques grâce à un système de types étendu
  • Vous pouvez étendre les capacités de PowerShell via des classes, des fonctions, des modules et des scripts
  • Prise en charge native de divers formats de données, notamment XML, JSON et CSV

Si vous êtes plus intéressé par la gestion et la configuration de votre infrastructure d'entreprise via du code, vous serez heureux d'apprendre que PowerShell vous offre également cette possibilité via son cadre de gestion de configuration de l'état souhaité (DSC). Parmi les opérations que vous pourriez facilement effectuer en utilisant le DSC de PowerShell, nous vous rappelons :

  • Déployez divers schémas de configuration en utilisant des modèles push ou pull
  • Concevoir des scripts personnalisés et des configurations déclaratives que vous pouvez utiliser pour des déploiements reproductibles dans votre environnement
  • Appliquer divers schémas de configuration
  • Rapport sur la dérive de configuration

PowerShell possède une ligne de commande propriétaire fournie avec un langage de programmation propriétaire quelque peu similaire à Perl. Notez qu'au début, PowerShell a été développé pour aider les utilisateurs à gérer les objets sur leurs ordinateurs, mais, comme vous pouvez le constater, il a parcouru un long chemin et est maintenant utilisé pour des tâches plus étendues et complexes.

Par exemple, vous pouvez utiliser le vaste environnement de travail de PowerShell non seulement pour effectuer diverses opérations de gestion du système, mais également pour les automatiser afin que vous n'ayez pas à vous engager dans des tâches fastidieuses et répétitives de temps en temps. Il est également très important de mentionner que vous pouvez accéder à une pléthore de ressources via un seul programme (c'est-à-dire PowerShell), y compris, mais sans s'y limiter :

  • Windows Management Instrumentation
  • API .NET Framework
  • Invite de commandes
  • Modèle d'objet de composant Windows
  • Commandes PowerShell

De nos jours, l'un des objectifs les plus populaires de PowerShell est d'aider les utilisateurs finaux à automatiser les tâches de gestion du système, les aidant ainsi à éviter de s'engager dans une série d'opérations ennuyeuses et répétitives. Il a été prouvé que l'élimination du facteur humain des actions répétitives augmente l'efficacité et réduit les erreurs humaines pour diverses raisons, c'est donc vraiment une solution gagnant-gagnant pour tout le monde.

Vous pouvez utiliser PowerShell pour émettre des commandes simples ou plus complexes, mais ce programme peut également vous aider à créer des scripts basés sur ces commandes, qui seront exécutés automatiquement par PowerShell. De plus, il existe une quantité exceptionnelle de commandes que vous pouvez personnaliser et émettre par la suite, appelées applets de commande.

Il convient de mentionner que PowerShell est multiplateforme et open source, ce qui signifie que vous pouvez également l'utiliser sur d'autres systèmes tels que Mac ou Linux de manière native, sans recourir à des astuces et à des outils d'amélioration de la compatibilité tels que Wine ou Boot Camp.

Liste des commandes PowerShell de base

Nous comprenons que PowerShell peut sembler un peu intimidant, surtout maintenant que vous avez découvert qu'il s'agit de plus qu'une simple invite de commande sur votre ordinateur, et qu'il englobe en fait des fonctionnalités CMD, mais aussi un langage de programmation spécifique et divers scripts que vous pouvez utiliser pour automatiser opérations de gestion du système.

Cependant, si vous vous sentez déterminé à maîtriser PowerShell et tout ce qu'il a à offrir, nous vous suggérons fortement de commencer par ses fonctionnalités les plus basiques. De cette façon, vous n'aurez pas à revenir sur des mois de progrès lorsque vous découvrirez que vous avez accidentellement utilisé la mauvaise fonction et que tout le travail que vous avez effectué entre-temps commence à ressembler davantage à un lointain souvenir.

C'est précisément pourquoi nous avons préparé une liste de commandes de base que vous pouvez utiliser en toute sécurité dans vos sessions PowerShell pour tester les fonctionnalités de ce programme puissant et voir laquelle fait exactement quoi. La liste ci-dessous comprend les noms de commande, leurs alias et une brève description de ce que fait chaque commande.

Notez que vous pouvez utiliser des noms de commandes ou leurs alias, et le résultat sera exactement le même. La raison pour laquelle on préférerait utiliser des alias est qu'ils sont beaucoup plus rapides à saisir et si vous pouvez vous en souvenir correctement et les associer au nom de commande correspondant, cela a plus de sens si vous voulez faire le travail rapidement.

Nom de la commande Alias La description
Ajouter du contenu ca Vous permet d'ajouter du contenu (par exemple des mots ou des données) à un fichier
Ajouter-PSSnapIn asnp Vous aide à ajouter plusieurs composants logiciels enfichables Windows PowerShell à la
session en cours
Effacer-Contenu clc Efface le contenu d'un élément sans supprimer l'élément réel
Histoire claire chouette Efface toutes les entrées de l'historique des commandes
Effacer-hôte dégager Efface l'affichage du programme hôte
Effacer-hôte cls Fait la même chose que clair
Effacer-Article cli Supprime le contenu d'un élément sans supprimer l'élément réel
Effacer-ItemProperty clp Efface la valeur d'une propriété sans réellement supprimer la propriété elle-même
Effacer-Variable clv Supprime la valeur d'une variable
Comparer-Objet comparer Vous permet de comparer deux ensembles d'objets
Comparer-Objet différence Fait la même chose que comparer
Connect-PSSession cnsn Vous permet de vous reconnecter aux sessions dont vous vous êtes déconnecté
Convertir-Chemin cvpa Vous permet de convertir un chemin Windows
PowerShell en chemin de fournisseur Windows PowerShell
Copier l'article copie Vous aide à copier un élément d'un emplacement spécifique à un autre
Copier l'article cp Fait la même chose que la copie
Copier l'article cpi Fait la même chose que copy et cp
Copy-ItemProperty cpp Permet de copier une valeur et une propriété d'un emplacement donné vers un
autre
Désactiver-PSBreakpoint dbp Vous aide à désactiver les points d'arrêt dans la console actuelle
Déconnecter-PSSession DNS Vous déconnecte de la session en cours
Activer-PSBreakpoint ebp Permet d'activer les points d'arrêt dans la console actuelle
Entrer-PSSession etsn Vous aide à lancer une session interactive avec un appareil distant
Quitter-PSSession exsn Termine une session interactive avec un appareil distant
Exporter-Alias épal Vous permet d'exporter des informations sur les alias actuellement définis
dans un fichier de sortie
Exporter-Csv epcsv Vous permet de convertir des objets en plusieurs
chaînes séparées par des virgules (CSV) et d'exporter les chaînes vers un document CSV
Exporter-PSSession epsn Importe les commandes d'une autre session et les exporte vers un
module Windows PowerShell
PourChaque-Objet % Effectue une opération spécifique sur chacun des éléments contenus
dans une collection d'objets d'entrée
PourChaque-Objet pour chaque Fait la même chose que %
Format-Personnalisé fc Vous aide à utiliser une vue personnalisée afin de formater la sortie
Format-Liste fl Vous permet de formater la sortie sous forme de liste de propriétés où chaque propriété
est placée sur une nouvelle ligne
Format-Table pi Vous permet de formater la sortie sous forme de tableau
Format-Wide fw Vous aide à formater les objets sous forme de tableaux larges où une seule propriété de
chaque objet est affichée
Obtenir-Alias fille Récupère vos alias pour votre session en cours
Get-ChildItem réal Récupère une liste de tous les fichiers et dossiers dans un lecteur de système de fichiers
Get-ChildItem gci Fait la même chose que dir
Get-ChildItem ls Fait la même chose que dir et gci
Obtenir-Commande gcm Récupère une liste de toutes les commandes que vous pouvez utiliser
Obtenir du contenu chat Affiche le contenu d'un fichier
Obtenir du contenu gc Fait la même chose que le chat
Obtenir-Historique bon sang Récupère une liste de toutes les commandes que vous avez entrées au cours de votre session en cours
Obtenir-Historique h Fait la même chose que ghy
Obtenir-Historique l'histoire Fait la même chose que ghy et h
Obtenir l'article gi Vous permet de récupérer des fichiers et des dossiers
Get-ItemProperty généraliste Récupère les propriétés de l'élément que vous avez spécifié
Obtenir un emploi gjb Récupère une liste de toutes les tâches en arrière-plan Windows PowerShell en
cours d'exécution dans votre session
Obtenir l'emplacement gl Récupère des informations sur votre pile de localisation actuelle ou votre lieu de travail
Obtenir l'emplacement pwd Fait la même chose que gl
Obtenir-Membre gm Récupère toutes les propriétés et méthodes des objets spécifiés
Obtenir-Module organisme génétiquement modifié Retrieves a list of imported modules or modules that can be imported into the
current session
Get-Process gps Fetches a list of all the processes that are running locally or on a remote
computer
Get-Process ps Does the same thing as gps
Get-PSBreakpoint gbp Retrieves all the breakpoints set in your current session
Get-PSCallStack gcs Displays your current call stack
Get-PSDrive gdr Fetches the drives in your current session
Get-PSSession gsn Retrieves a list of local and remote Windows PowerShell sessions
Get-PSSnapIn gsnp Fetches a list of all the Windows PowerShell snap-ins on the computer
Get-Service gsv Lists all the services on a local or remote computer
Get-Unique gu Retrieves unique items from a sorted list
Get-Variable gv Displays a list of all the variables in the current console
Get-WmiObject gwmi Fetches Windows Management Instrumentation (WMI) classes
instances or information about available classes
Group-Object group Lets you group objects that contain the same value for the properties
that you specify
help man Displays more details about Windows PowerShell commands and
concepts
Import-Alias ipal Allows you to import a list of aliases from a file
Import-Csv ipcsv Build table-like custom objects using all the items contained within
a CSV file
Import-Module ipmo Import modules to your current session
Import-PSSes sion ipsn Imports commands from a different session into your current session
Invoke-Command icm Lets you execute commands on local and remote computers
Invoke-Expression iex Lets you execute commands or expressions on the local computer
Invoke-History ihy Executes commands from your session history
Invoke-History r Does the same thing as ihy
Invoke-Item ii Performs the default action on a specified item
Invoke-RestMethod irm Sends either an HTTP or an HTTPS request to a RESTful web service
Invoke-WebRequest curl Retrieves content from a webpage on the Internet
Invoke-WebRequest iwr Does the same thing as curl
Invoke-WMIMethod iwmi Allows you to call Windows Management Instrumentation (WMI)
methods
Measure-Object measure Determines numeric properties of objects, as well as words,
lines, and characters in string objects
mkdir md Creates a new item (directory)
Move-Item mi Allows you to move an item from a specific location to a different one
Move-Item move Does the same thing as mi
Move-Item mv Does the same thing as mi and move
Move-ItemProperty mp Allows you to move a property from a specific location to a different one
New-Alias nal Allows you to create a new alias
New-Item ni Lets you create a new item
New-Module nmo Generates a new dynamic module that exists only in memory
New-PSDrive mount Allows you to create temporary and persistent mapped network drives
New-PSDrive ndr Does the same thing as mount
New-PSSession nsn Establishes a persistent connection to a local or remote computer
New-PSSessionConfigurationFile npssc Creates a session configuration file
New-Variable nv Lets you create a new variable
Out-GridView ogv Allows you to send output to an interactive table in a separate window
Out-Host oh Sends the output to the command line (CMD)
Out-Printer lp Lets you send the output to a printer
Pop-Location popd Modifies your current location to the location that was pushed to the
stack most recently. You can use the Push-Locationcmdlet (pushd) to
pop the location either its default stack or from a stack that you create.
powershell_ise.exe ise Displays an explanation on how you can use the PowerShell_ISE.exe
command-line tool
Push-Location pushd Appends the current location to the top of a location stack
Receive-Job rcjb Fetches the results of current session Windows PowerShell background
jobs
Receive-PSSession rcsn Retrieves results of commands from disconnected sessions
Remove-Item del Removes files and folders
Remove-Item erase Does the same thing as del
Remove-Item rd Does the same thing as del and erase
Remove-Item ri Does the same thing as del, erase and rd
Remove-Item rm Does the same thing as del, erase, rd, and ri
Remove-Item rmdir Deletes folders
Remove-ItemProperty rp Allows you to delete a property and its value from a given item
Remove-Job rjb Lets you delete a Windows PowerShell background job
Remove-Module rmo Helps you remove modules from your current session
Remove-PSBreakpoint rbp Lets you remove breakpoints from the current console
Remove-PSDrive rdr Removes temporary Windows PowerShell drives, as well as disconnects
mapped network drives
Remove-PSSession rsn Lets you close one or more Windows PowerShell sessions (PSSessions)
Remove-PSSnapin rsnp Enables you to remove Windows PowerShell snap-ins from your current
session
Remove-Variable rv Clears a variable and its value
Remove-WMIObject rwmi Lets you delete an instance of an existing Windows Management
Instrumentation (WMI) class
Rename-Item ren Helps you rename an item in a Windows PowerShell provider namespace
Rename-Item rni Does the same thing as ren
Rename-ItemProperty rnp Enables you to rename an item’s property
Resolve-Path rvpa Resolves wildcard characters in a path, as well as displays the contents
of the path
Resume-Job rujb Helps you restart a job that was suspended
Select-Object select Lets you select objects as well as their properties
Set-Alias sal Lets you create or change a cmdlet’s or command element’s alias
(alternate name) in the current Windows PowerShell session
Set-Content sc Allows you to replace a file’s contents with contents that you specify.
Set-Item si Changes an item’s value to a value that’s specified in the command
Set-Location cd Lets you set your current working location to a specified location (changes
the active location)
Set-Location chdir Does the same thing as cd
Set-PSBreakpoint sbp Lets you set a breakpoint on a command, variable, or line
Set-Variable set Enables you to set a variable’s value or generates a variable if one with
the requested name does not exist
Show-Command shcm Displays a list of Windows PowerShell commands in a graphical
command window
Start-Job sajb Starts a background job in Windows PowerShell
Start-Process saps Launches one or more local processes
Start-Service sasv Lets you start one or more stopped services
Stop-Process kill Helps you stop one or more running processes
Where-Object ? Enables you to select certain objects from a collection based on their
property values
Write-Output echo Allows you to send an object to the next command in the pipeline. If it
reaches the last command in the pipeline, the command will display
the objects in the console

Don’t let the sheer amount of basic PowerShell commands intimidate you. Although we called them basic, there’s absolutely no need for you to start memorizing them. In fact, that’s the exact reason why we created the table above so that you can go on about your work without worrying about having to remember each and every command we mentioned above.

You can use it as a quick refresher or even use your browser’s search feature to locate a specific command, its alias, and what it does if you’re confused. Although we already included this piece of information in the table above, if you’re ever confused while working in PowerShell, using the help command will display a few helpful details on how you can use this program and its commands more efficiently.

You can also pair the help command with another command or alias if you want more details about that specific command. For instance, this is what PowerShell displays when you type help Add-Computer:

Aide-mémoire des commandes Windows PowerShell – Le guide ultime dont vous avez besoin

However, you can use help with any other of the commands or their aliases in our table above. Make sure you understand that the same command can have multiple aliases, which means that you can achieve the same result by using various aliases. Although this may sound confusing, it actually gives you plenty of flexibility in case you can’t remember one command alias, but you remember another one that can help you achieve the same goal.

Using PowerShell

Naturally, the first thing you’d want to do is locate PowerShell and launch it. One sure way to launch PowerShell from just about anywhere you are on your PC is to hold down the Shift button on your keyboard, right-click any empty spot on your screen (not a menu, icon, button, or similar object), and select Open PowerShell window here from the context menu.

In addition to giving you quick access to the PowerShell console anywhere on your PC, doing so will automatically switch the default working directory for PowerShell to the one you’re currently located at. If you’re on a Windows 10 PC, you can also launch PowerShell by pressing the Win key on your keyboard, typing PowerShell in the Start menu, and selecting PowerShell when it becomes visible in the list of results.

On older versions of Windows, you’ll need to manually locate the PowerShell executable, which you can either find in the Accessories or System folders in your Start menu. Furthermore, seeing how older systems (such as Windows 7) don’t provide you with PowerShell by default, you’ll also have to install it on your computer, along with all of its dependencies.

Notice how launching PowerShell from the Start menu will set your active working directory to C:\Users\[your username here]. By comparison, using the Shift + Right-click method we’ve presented above will set PowerShell’s active directory to the one you’re currently at when you spawn the console. For instance, if you use Shift + right-click and open PowerShell from your desktop, you’ll notice that the active directory will be C:\Users\[your username here]\Desktop. For obvious reasons, the [your username here] part will be different depending on your username.

Although you can keep PowerShell for home usage just fine, it’s better if you could make use of all that it has to offer. Incidentally, these features make PowerShell awesome for corporate usage, where you need to perform a large number of operations in a short time, and most likely on a huge number of devices.

Thus, instead of running each command manually on every single machine, you could simply create an automation script in PowerShell and receive the information you need automatically, without having to physically interact with the devices in case or even be near them. Just as CMD, PowerShell can be used through command lines. However, unlike its more rudimentary counterpart (i.e. the CMD), PowerShell also lets you summon scripts and cmdlets, which makes it more powerful, but also more complicated to use.

How to use cmdlets

We’ve used the term cmdlets quite a few times in our guide, so you’re probably left wondering whatever they mean. Well, to start at the beginning, it’s worth reminding you that CMD works with commands. A cmdlet, which is pronounced command-let, is also a command, but unlike traditional CMD commands, cmdlets are specific to PowerShell and let you perform single specific operations, such as copying files, moving items from one place to another, changing the active directory, or see the contents of an item.

Simply put, cmdlets are single function commands that you can type directly in PowerShell’s command line. If you have any prior experience with the CMD, you’ll find PowerShell somewhat intuitive to work with. One interesting thing about PowerShell is that it shares plenty of commands with CMD. Therefore, using CD with PowerShell will still change your active directory, DIR will still display the contents of the current folder, and CP will still let you copy an item from one place to another.

It’s quite worth mentioning that PowerShell is not case sensitive, unlike many other shells, which return errors if you miss using the correct case when typing your commands in them. Thus, copy-item will work just as well as Copy-Item, and if you remember neither one of them you can also use Copy, CP, and CPI (but also copy, COPY, cp, or cpi).

Most PowerShell cmdlets are written in C# and are specially built to perform operations that will return a .NET object as their result. At the time being, you could find more than a couple of hundred cmdlets you can use in PowerShell, which, let’s be fair, gives you more than just a little elbow room as far as performing operations goes.

Although it will be difficult to remember all the cmdlets you may have to work with (remember that you can use the table above), there are a few that you’ll use more frequently, which will make them incredibly easy to remember. Not to mention the fact that some of them are intuitive enough that their name actually gives away their purpose (e.g. copy is used to copy items, move can be used to move files, compare helps you compare sets of objects, etc).

However, if you’re not exactly in the mood to bookmark this article to use it later, you could also type in the Get-Command cmdlet in PowerShell, or gcm, if you want to keep things short. Doing so will display a full list of commands that are available to you, and you can use that list to plan ahead on whatever it is you’re trying to do.

Unlocking custom cmdlets

On the downside, Microsoft doesn’t just give you full access to the whole array of cmdlets that you can use in PowerShell by default, so you’ll have to jump through a bunch of extra hoops to unlock this feature and use it at your leisure. The good news is that the unlocking process doesn’t take long, and then there’s the fact that it can also be done through the PowerShell, which will make great practice for you. Without any further ado, let’s see how you can unlock custom cmdlets privileges in PowerShell.

  1. Log in to an Administrator account (it won’t work without Admin rights)
  2. Launch PowerShell with Administrator rights (Run as administrator)
  3. Type the following command in PowerShell and press Enter:
    • Set-ExecutionPolicy
  4. If done right, PowerShell will prompt you with a dialog, asking you for the new ExecutionPolicy value
  5. Type RemoteSigned in the PowerShell command prompt and press Enter
  6. PowerShell will give you a heads up on the risks of modifying the value of the ExecutionPolicy
  7. Type Y and press the Enter keyAide-mémoire des commandes Windows PowerShell – Le guide ultime dont vous avez besoin
  8. If you need to turn custom cmdlets off, just follow steps 1-4, and when PowerShell asks you to type the value, type Restricted and confirm your choice as you did at step 7

If you want to streamline the whole process and not waste time typing everything down in PowerShell’s command prompt, you’ll be glad to learn that there’s an even simpler way to achieve the same result. Launch PowerShell with Administrator rights as you did at step one, and instead of typing each command and waiting for the prompt, you’re gonna pipeline everything up until the confirmation by typing this:

  • Set-ExecutionPolicy -ExecutionPolicy RemoteSigned

Naturally, you will still need to confirm your choice by typing Y and hitting Enter on your keyboard, but you just skipped a step and performed a series of operations at the same time. This is exactly why advanced PowerShell users create automation scripts to perform various management operations automatically: to save time and hassle. If you want, you can use the same command above to disable custom cmdlets on your system, but you’ll have to replace RemoteSigned with Restricted and also confirm your choice at the end.

You can also use AllSigned and Unrestricted to grant yourself even more privileges when it comes to running potentially unsafe scripts on your Windows PowerShell. The AllSigned option will let you run all scripts that were created by trusted publishers, whereas the Unrestricted option will enable PowerShell to run any script, regardless of its provenience and trustworthiness. Naturally, the Unrestricted option is also the most dangerous, so try to avoid it as best as you can, if possible, especially if you are a PC novice.

See? PowerShell is already starting to look a lot more accessible than it did just a few minutes back.

How to create and use scripts in PowerShell

As we’ve mentioned before and we’re positively sure you remember, you can use PowerShell to run automation scripts. However, you can’t just yell at PowerShell “Hey you, create this script for me!” and expect it to magically work, so you’ll have to put in some elbow grease and get it done yourself. However inconvenient this may sound right now, trust us, you’ll be thankful in the long run, considering all the work you won’t need to do anymore.

Although most of us rely on specialized software such as IDEs to create scripts or programs in a specific programming language, truth be told you can use any text editor as long as it can save files to the right extension. And even if it can’t, you can just navigate to the file you created and modify its extension manually by renaming it, but let’s get back to our sheep.

If you’re interested in creating a script that can work in PowerShell, you’ll be thrilled to learn that this script you’ve probably heard a lot of, is merely a text document with an extension that makes it compatible with PowerShell, PS1. Therefore, it’s easy to see why creating these scripts can be actually handled from within virtually any text editor, as long as you save it with the right (PS1) extension.

Write-host "Please enter your name:"

$Name = read-host

"Hello $Name! Visit TipsWebTech360.com for more awesome tutorials and guides!"

Now for the actual creation part:

  1. Launch Notepad (or any other text editor for that matter)
  2. Copy the code above (the script you’ll be creating and running)
  3. Paste it into your new Notepad document
  4. Use CTRL + S to save the document
  5. Type script.ps1 as the file name
  6. Save the file somewhere accessible
  7. Open a PowerShell instance with administrator rights (very important)
  8. Make sure you’ve enabled custom scripts on your system (check sections above)
  9. Navigate to the location where you saved the script
  10. Type the full path of the script to run it
    • For instance, if your script is in a Scripts folder on your C drive, your command will be C:\Scripts\script.ps1
    • Alternatively, you could simply navigate to the location of your script and use this command to run it: .\script.ps1

If you can’t run the script and PowerShell returns an error, make sure you’ve enabled PowerShell to run custom scripts on your system, and that you’re running PowerShell as an administrator. Not doing any or both things that we’ve specified in our instructions will most likely result in an error and you won’t be able to run your script.

Remember that this is merely a basic script that is somewhat similar to the classic “Hello, world!” one. It puts a spin on it by interacting with you (i.e. asking what your name is) and letting you interact with it (i.e. typing your name which will be used to print a message for you). However, PowerShell is capable of running far more complex scripts, ranging from collecting data from an array of machines to intricate data management, advanced system configuration operations, and even creating backups of SQL databases in a blink of an eye.

How can I backup SQL databases with PowerShell?

We’re glad you asked. As we’ve mentioned countless times in our guide, there are almost endless possibilities when it comes to operations that PowerShell can help you perform. One of the most popular ones is backing up an SQL database without having to go great lengths or possess extraordinary database management capabilities. All you have to do is fire up an elevated instance of PowerShell (with Administrator privileges) and use the Backup-SqlDatabase command. However, things are a bit more complicated than that, but we’ll get to that in a few.

Backing up an SQL database isn’t as easy as simply copying files from your PC to a safe location and hope they stay safe for whenever you may need them to perform data restoration operations, but on the bright side, using PowerShell can make it look like a walk in the park. Although there are several ways to achieve this, using the command we’ve mentioned above is the fastest, simplest way to backup an SQL database.

Among the capabilities of the Backup-SqlDatabase command, it’s possible to find full database backups, database file backups, as well as transaction log backups, so you got the full package within a single command-line tool. By default, using this command will perform a full database backup, so you will need to specify if you want it to follow a certain set of rules by using the BackupFile parameter.

Note that some versions of PowerShell won’t feature this command by default, so you’ll either have to import it or install it. The good news is that installing the SQL module isn’t exactly rocket science and can be accomplished even by novices. Here’s what you’ll have to do if you can’t use the Backup-SqlDatabase command in your PowerShell session:

  1. Launch PowerShell with administrator rights
  2. Type the following command:
    • install-module sqlserver
  3. When asked to confirm your actions, type Y and hit Enter on your keyboard
  4. Confirm the untrusted repository once more by typing Y and EnterAide-mémoire des commandes Windows PowerShell – Le guide ultime dont vous avez besoin
  5. Once the installation is complete, type the following command:
    • import-module sqlserver
  6. Try running the Backup-SqlDatabase command by typing it in the PowerShell command-line
    • If it works, you should see that PowerShell is asking you to supply values for some parameters
    • If it doesn’t work, make sure that you’ve set PowerShell’s permission to allow it to run custom scripts

1. Complete SQL database backup

  • Backup-SqlDatabase -ServerInstance "Computer\Instance" -Database "Tips.WebTech360"

The command we’ve exemplified above will generate a full database backup of a database called TipsWebTech360 and save it to the default backup location of the “Computer\Instance” server instance as ‘Tips.WebTech360.bak’.

2. Perform a location-based database backup

  • Set-Location "SQLSERVER:\SQL\Computer\Instance"
  • PS SQLSERVER:\SQL\Computer\Instance> Backup-SqlDatabase -Database "Tips.WebTech360"

The first command above will change your location to the active directory within the server instance on which the backup will occur. Essentially, this technique works almost like the full database backup we’ve exemplified above, but in this example, you get to change the working directory in order to locate the server instance where the backup occurs.

This operation will also create a full backup of a database called Tips.WebTech360 and export it as an ‘Tips.WebTech360.bak’ file in the default location of the server instance you’re connected to.

3. Perform a transaction log backup

  • Backup-SqlDatabase -ServerInstance "Computer\Instance" -Database "Tips.WebTech360" -BackupAction Log

If you only need to backup the transaction log of a specific database, PowerShell can also help you do that through a single command you can input straight in its command-line interface. The command above will generate a backup copy of the ‘Tips.WebTech360’ database’s transaction log and export it to the default location of the ‘Computer\Instance’ server instance as a file named ‘Tips.WebTech360.trn’.

4. Create an encrypted SQL database backup

  • $EncryptionOption = New-SqlBackupEncryptionOption -Algorithm Aes256 -EncryptorType ServerCertificate -EncryptorName "BackupCert"
  • Backup-SqlDatabase -ServerInstance "." -Database "Tips.WebTech360" -BackupFile "Tips.WebTech360.bak" -CompressionOption On -EncryptionOption $EncryptionOption

If you’re worried that your database backup may fall in the wrong hands, PowerShell can also help you create ready-encrypted backup files. Naturally, you’ll have to specify some parameters such as the encryption algorithm, the encryption type (i.e. certificate), server instance, database name, backup file, and whether or not you want the output to be compressed.

The example above will create a backup of a certain ‘Tips.WebTech360’ database, encrypt it with AES-256 encryption and a server certificate, compress it, and save the resulting ‘Tips.WebTech360.bak’ file on the server instance’s default backup location. This is quite important if you plan a migration and have no surefire way to transport all backup files without risking estranging any single one of them.

5. Perform a backup on all databases in a server instance

  • Get-ChildItem "SQLSERVER:\SQL\Computer\Instance\Databases" | Backup-SqlDatabase

Another tool that may come in handy is PowerShell’s ability to backup all the databases on a server instance at the same time. Regardless of their number, you just fire up PowerShell, type an adaptation of the command above, and wait for the backup process to come to an end. Note that since this will backup all the databases within the server instance, you may have to wait for a while, so be patient.

The command above will back up all the databases located on the ‘Computer\Instance’ server instance and export the resulting files to the default backup location on the same server instance. The names of the backup files will be generated automatically according to each one’s corresponding database followed by the BAK extension (i.e. .bak).

Although there are several more methods to perform SQL backup with PowerShell in various ways, we’ve only presented a few that we felt were more important. Note that the commands we used in our examples above are not likely to work on your environment in their current form, so you will have to adapt them to your current situation.

For instance, you will have to change the ‘Computer\Instance’ parameter to match your own server instance and modify the name of your database to reflect the name of your own database. Remember that you can always turn to the help command in PowerShell if you ever feel that the command you’re trying to run is confusing or doesn’t work as it should.

Must-know PowerShell commands

1. Get-Help

We can’t stress this enough, but the Get-Help command should be the first one you ever learn, as it can seriously get you out of numerous sticky situations where you’re not exactly sure if you’re using the correct command, or exactly what you can achieve with the command that you’re trying to deploy.

Now that you’ve installed the sqlserver module on your system, you can try the Get-Help command now and see how Backup-SqlDatabase works. Just type Get-Help Backup-SqlDatabase in the command-line of PowerShell and brush up your PowerShell SQL database backup skills.

Aide-mémoire des commandes Windows PowerShell – Le guide ultime dont vous avez besoin

Note that if you just recently installed the sqlserver module on your system, the Help database may still be outdated, and you may need to run an update on it so that it can catch up on any new scripts. By default, PowerShell will detect that the content you’re trying to reach is available online, but you can’t access it locally, and even offer to update the database for you. In this case, all you need to do is type Y when prompted and hit the Enter key on your keyboard.

However, if PowerShell just prompts you with an error stating that there’s no help manual available for the command you’re interested in, you can update it manually by typing Update-Help and hitting the Enter key on your keyboard. After the update process comes to an end, you should be able to check available help documentation for the command you’re interested in.

2. Get-Process

Get-Process is paramount if you want to discover more about the system you’re currently working on. To be more specific, although you might’ve guessed what this command does already by merely looking at it, Get-Process will provide you with a list of all the processes that are currently running on the system you’re working on.

By default, Get-Process will retrieve a list of every process running on the current system you’re working on, so you may need to append some extra parameters to this command if you want more specific information and narrow the list of results. Check out in the screenshots below what you get when you run the Get-Process command by itself versus how it looks if you’re more specific and format the results.

  • Get-Process

Aide-mémoire des commandes Windows PowerShell – Le guide ultime dont vous avez besoin

  • Get-Process explorer | Format-List *

Aide-mémoire des commandes Windows PowerShell – Le guide ultime dont vous avez besoin

The second command can be customized to display additional details about any active process on your system. You can replace explorer with svchost or Chrome or any other active process on your system that you’re interested in. As we’ve mentioned above, using Get-Processes by itself can help you with that (i.e. finding a list of all running processes).

3. Stop-Process

This command is pretty much self-explanatory,  as you may already have figured out that it can help you stop processes that are currently running on your system. The most common reason for doing that from PowerShell and not by using the Windows Task Manager is that sometimes processes can freeze and make GUI apps barely usable.

PowerShell users can easily identify a troublesome process using the Get-Process command we’ve previously explained, then using Stop-Process to terminate it, thus unclogging the system. Running Stop-Process by itself (without any additional parameter) in your PowerShell command-line interface will prompt you to input the ID of the process you’re trying to terminate.

However, you can also terminate a process by its name (if you know it) by appending the -Name parameter to the cmdlet, like in the example below:

  • Stop-Process -Name "explorer"

The command above will terminate the Explorer process, which can be useful especially if it freezes or crashes on you and refuses to load properly. Note that you’ll need to use quotes when specifying the name of the process you’re trying to terminate. If a process is stubborn and refuses to terminate (usually higher clearance processes do that), you can “convince” it by appending a -Force parameter to your command. Say, for instance, that you can’t terminate your Explorer process. In this case, you can simply type the command below:

  • Stop-Process -Force -Name "explorer"

Furthermore, it’s worth mentioning that using the -Force parameter in your Stop-Process command won’t ask for confirmation, as opposed to running the command without this option. If you want to find out more about this cmdlet, make sure to use the Get-Help command.

4. Get-Service

This command is among the essential command list for a good reason: it can provide you with a list of all the services that are currently installed on the system you’re working on, regardless of whether they’re running or not. As with many other cmdlets, you can customize Get-Service to provide you with more specific information, either regarding a certain service or even displaying a list of all running (or stopped) services on your machine.

You can go ahead and type Get-Service in your PowerShell command line. Doing so should provide you with a list of all the services available on your computer, as well as their display names and statuses. If you append an additional command to the original cmdlet, you can change the output, making it display only results that you’re interested in.

  • Get-Service "W*"

For instance, typing the command above should return a list of all services available on your computer that start with the letter ‘W’. However, you can go even further and customize your command in order to narrow the list of results even more.

  • Get-Service | Where-Object {$_.Status -eq “Running”}

The command above will let you see a list of all the available services on your computer that are also running at the time you’re running the cmdlet. Appending the “W*” as we did in the previous example will display a list of all the running services on your computer that start with the letter ‘W’, and the command should look like this:

  • Get-Service "W*" | Where-Object {$_.Status -eq "Running"}

Aide-mémoire des commandes Windows PowerShell – Le guide ultime dont vous avez besoin

5. Get-EventLog

Every responsible system administrator should know its way around working with event logs, seeing that these documents can provide you with useful knowledge about what happened on your system, at what time did it occur, and sometimes even what triggered that specific event.

Therefore, we can safely assume that PowerShell’s Get-EventLog command is not something you want to be missing from your toolbelt, especially if you plan on honing your system administration skills. If you know everything there is to know about event logs and their names, you can go ahead and type Get-EventLog directly in your PowerShell’s command line. Note that PowerShell will prompt you to input the name of the log you’re trying to view.

If you type the name of an empty event log (one with no entries), PowerShell will prompt you with an error and return you to the command-line interface. Therefore, it would be easier if you just used the command below, which will provide you with a list of Event Logs on your system, along with additional details about each one, such as the default overflow action, and the number of entries.

  • Get-EventLog -List

One of the most popular use cases for event logs is checking for errors, especially if they occurred silently, were shortly followed by a system crash, or lead to a BSOD, which we all know how cryptic can be. However, you will need to be more specific with the Get-EventLog cmdlet if you want to narrow down the list of results, which oftentimes can be huge.

  • Get-EventLog -LogName Security -EntryType Error

Typing the command above in your PowerShell’s command-line interface should provide you with a list of all the errors registered in your Security event log. Note that you can use the -List parameter to see all the log types in your system and replace Security in the command above with any other log type that you find on your list, just as long as it has more than zero entries.

If you want to learn more about using the Get-EventLog command in PowerShell, feel free to use the Get-Help command we’ve talked about in the first section of this subchapter. 

6. ConvertTo-HTML

Sometimes when you’re using PowerShell, you may stumble upon certain information that you want to extract and keep for future reference, create reports, or simply import it from a different application. One of the most frequently-used ways to extract this data from PowerShell and export it to an external file on your computer is the ConvertTo-HTML command.

Using this command will help you build comprehensive reports that can help you analyze extracted information and insights in a more effective manner by providing you with HTML tables that you can customize later by adding custom styles and color-coded data. As with many other PowerShell commands, ConvertTo-HTML doesn’t work by itself, and you’ll need to pair it up with an additional command which it will use as an input (or a source of data).

For instance, if you’re trying to print a report consisting of every service that starts with the letter ‘W’ and is currently running on your computer, you can type the command below:

  • Get-Service "W*" | Where-Object {$_.Status -eq "Running"} | ConvertTo-HTML

This will provide you with an HTML code of the data you fed to the ConvertTo-HTML function, which you can simply copy directly from the PowerShell’s command-line interface, paste it in your favorite text editor and save it as an HTML file, which you can use to view the result in any web browser.

You can use ConvertTo-HTML with virtually any PowerShell command, as long as the command you’re using as a data source will generate output. You can try it with other cmdlets, such as Get-Process, Get-EventLog, or Get-Help. Note that aside from HTML conversions, the ConvertTo cmdlet can also be used to generate JSON, CSV, and XML files. You just have to replace HTML in the command syntax with the format you’re interested in.

7. Export-CSV

If you’re working with various objects that you feel may fit way better in a table, you can use PowerShell to convert the items you’re currently handling into a series of CSV (comma-separated value) strings and export the strings to a file in one swift motion through the Export-CSV cmdlet.

As with ConvertTo-HTML, Export-CSV needs an input that it can convert to CSV strings, as it can’t just work on its own. Thus, you will need to pair it with a command that can be used to generate data, such as the Get-Service or Get-Process ones we’ve explained earlier.

Essentially, Export-CSV does almost the same thing as the ConvertTo-HTML cmdlet we’ve discussed above, aside from one important aspect that shouldn’t be overlooked: this cmdlet actually generates a file and saves it on your computer, as opposed to the ConvertTo command, which only gives you the output and lets you create the file on your own.

Let’s assume, for instance, that you’d like to turn the list of services running on your computer into a CSV file so that you can process the file further with third-party software, or put it in a spreadsheet for further reference. All you’d have to do is type the Get-Service command followed by the Export-CSV one, and mention a location where you’d like the CSV file to be generated, like in the example below:

  • Get-Service | Export-CSV c:\Tips.WebTech360.csv

The command above will fetch a list of all the services that are available on your computer, running or not, convert them into a series of CSV strings, and save the result as a CSV file named ‘Tips.WebTech360’ in the root of your C drive. You can then open the file in a third-party software solution, convert it into a fully-fledged table, or just store it for future usage.

PowerShell cheatsheet – CONCLUSION

Although there’s still a lot of people advocating for CMD, truth be told PowerShell is more versatile, way more powerful, but at the same time more complicated to work with than its traditional CMD counterpart. The sheer amount of features, combined with the fact that you can create automation scripts in PowerShell and perform complicated system management operations just leaves CMD in a cone of shadow.

Si vous commencez tout juste à découvrir PowerShell et que vous avez du mal à comprendre ce que fait chaque commande, comment pipeliner plusieurs commandes ou comment créer et exécuter vous-même des scripts PowerShell simples, notre guide est un excellent point de départ. Pour simplifier votre voyage de découverte de PowerShell.

Leave a Comment

Les 7 meilleurs outils de gestion dadresses IP

Les 7 meilleurs outils de gestion dadresses IP

Pour mettre de l

Ingress Vs Egress - Quelle est la différence

Ingress Vs Egress - Quelle est la différence

Découvrez les concepts clés de l\

Les 10 meilleurs outils et logiciels de scanner réseau à utiliser

Les 10 meilleurs outils et logiciels de scanner réseau à utiliser

Découvrez les meilleurs outils d

5 meilleurs outils de test et de mesure QoS

5 meilleurs outils de test et de mesure QoS

Découvrez les meilleurs outils pour tester et mesurer la qualité de service (QoS) et garantir l

Les 8 meilleurs scanners IP pour Linux en 2021

Les 8 meilleurs scanners IP pour Linux en 2021

Découvrez les meilleurs scanners IP pour Linux en 2023. Des outils essentiels pour les administrateurs réseau souhaitant analyser et gérer les adresses IP efficacement.

Surveiller le trafic du routeur : 7 meilleurs outils et logiciels de surveillance

Surveiller le trafic du routeur : 7 meilleurs outils et logiciels de surveillance

Découvrez les meilleurs outils et logiciels pour surveiller le trafic des routeurs. Que ce soit pour une analyse quantitative ou qualitative, nous avons ce qu

10 meilleurs outils de balayage de ping pour vous en dire plus sur votre réseau

10 meilleurs outils de balayage de ping pour vous en dire plus sur votre réseau

Les balayages de ping peuvent être utilisés à votre avantage de nombreuses façons. Continuez à lire pendant que nous discutons de la façon dont nous présentons les 10 meilleurs outils de balayage Ping que vous pouvez trouver.

6 meilleurs outils pour surveiller les sites Web

6 meilleurs outils pour surveiller les sites Web

Les sites Web sont importants et doivent être constamment surveillés de près pour des performances adéquates. Voici quelques-uns des meilleurs outils de surveillance des sites Web.

6 meilleurs outils de gestion de réseau qui suivent les performances

6 meilleurs outils de gestion de réseau qui suivent les performances

Le marché des logiciels de gestion de réseau est très encombré. Raccourcissez votre recherche en suivant nos recommandations des meilleurs outils de gestion de réseau.

Meilleurs outils de déploiement de logiciels pour les équipes de développement en 2022

Meilleurs outils de déploiement de logiciels pour les équipes de développement en 2022

Voici un aperçu de certains des meilleurs outils de déploiement de logiciels pour faciliter la gestion d'un nombre illimité de machines