Administration and Automation with Windows PowerShell
Course Introduction • 5min
0 / 2 lessons complete
Getting Started with Windows PowerShell • 42min
0 / 7 lessons complete
The Basics of PowerShell
Video | 7 min
Installing and Updating PowerShell
Video | 7 min
The Text Based Console Part 1- An Overview
Video | 7 min
Text Based Console Part 2 - An Overview
Video | 5 min
The ISE (Intelligent Scripting Environment) Part 1
Video | 5 min
The ISE (Intelligent Scripting Environment) Part 2
Video | 5 min
Use the OGV Command to Easily View console data!
Video | 6 min
Getting Help and Finding Commands • 39min
0 / 6 lessons complete
Getting Help and Finding Commands Part 1
Video | 7 min
Getting Help and Finding Commands Part 2
Video | 3 min
Getting Help and Finding Commands Part 3
Video | 4 min
Help System LAB Questions
Video | 6 min
Help System Lab Answers 1-4
Video | 9 min
Help System Lab Answers 5-9
Video | 10 min
PowerShell Command Syntax • 33min
0 / 5 lessons complete
Command Syntax Part 1
Video | 8 min
Command Syntax Part 2
Video | 8 min
Command Syntax Part 3
Video | 5 min
Command Syntax Lab Questions
Video | 4 min
Command Syntax Lab Answers
Video | 8 min
PowerShell Objects and Properties • 35min
0 / 6 lessons complete
Objects, Properties and Methods Part 1
Video | 3 min
Objects, Properties and Methods Part 2
Video | 8 min
Objects, Properties and Methods Part 3
Video | 7 min
Questions 1-9 for Objects, Properties and Methods
Video | 2 min
Answers to Questions 1-7 O-P-M
Video | 11 min
Answers to Questions 8,9 O-P-M
Video | 4 min
The PowerShell Pipeline • 24min
0 / 2 lessons complete
PowerShell Providers • 30min
0 / 5 lessons complete
What are PowerShell Providers
Video | 3 min
Using PS Drive
Video | 6 min
PowerShell Provider CMDlets -1
Video | 12 min
PowerShell Providers CMDlets -2
Video | 7 min
Student Assignments
Text | 2 min
PowerShell Arrays and Variables • 28min
0 / 4 lessons complete
PowerShell Variables
Video | 9 min
PowerShell Arrays
Video | 12 min
PowerShell Variables Challenge
Video | 2 min
PowerShell Variables Solution
Video | 5 min
PowerShell Loops • 19min
0 / 3 lessons complete
PowerShell Conditional Statements • 11min
0 / 1 lessons complete
On Premises Lab Setup • 36min
0 / 8 lessons complete
Should You Watch This Section?
Video | 2 min
Downloading and Installing VirtualBox
Video | 2 min
Downloading Windows Server 2019
Video | 3 min
Creating Your Virtual Network
Video | 2 min
Creating Your Virtual Machines
Video | 7 min
Installing VirtualBox Guest Additions
Video | 2 min
Installing Windows Server
Video | 8 min
Installing the Active Directory Domain Services Role
Video | 10 min
Basic Domain Administration with Windows PowerShell • 2hr 27min
0 / 10 lessons complete
Configuring PowerShell Execution Policy with Group Policy
Video | 13 min
Installing Windows Server Roles and Features with Powershell
Video | 6 min
Running Powershell Scripts as Scheduled Tasks
Video | 8 min
Creating Organizational Units with Powershell
Video | 11 min
Creating and Managing Active Directory User Accounts with PowerShell
Video | 19 min
Move all AD Users in a Group to a Specific Organizational Unit
Video | 7 min
Generate a list of AD Users and their OU
Video | 5 min
PowerShell Splatting
Video | 5 min
Bulk Install Windows MSU Files Automatically with PowerShell
Video | 13 min
Lab: Domain Administration with Windows PowerShell
Lab | 60 min
Send Emails with PowerShell • 22min
0 / 2 lessons complete
Send Emails from Gmail with PowerShell
Video | 9 min
Create Password Expiration Notification Script
Video | 13 min
PowerShell Desired State Configuration (DSC) Basics • 1hr 48min
0 / 6 lessons complete
DSC Overview
Video | 9 min
Enabling PSRemoting with Group Policy
Video | 9 min
The DSC Resource Kit
Video | 7 min
Configuring The Local Config Manager for DSC Push
Free lesson
Video | 14 min
Uninstalling Windows Features with DSC
Video | 9 min
Lab: Desired State Configuration (DSC)
Lab | 60 min
Course Conclusion • 1min
0 / 1 lessons complete
Sign up to access this lesson
Click here to sign up and get access to this lesson!

Saving Progress...
In this lecture, you’re going to learn about the Out-GridView or the OGV command within PowerShell. This is a command that sends the output from a command to a grid view where it will provide an interactive table that you can use to filter and manipulate data.
On SADC01 click the start button and type PowerShell. Right-click on the Windows PowerShell icon from the list of applications and select Run as administrator.

We should have the PowerShell window open.

Out-GridView or the OGV command works in Windows 10 and Windows Server, however, we are going to be running some Windows Server-specific commands like Get-WindowsFeature. This will not run on Windows 10.
Type the command Get-WindowsFeature and press Enter.
This will show all the Installed and Available Windows Server Roles that we have in Windows Server.

There’s a better way to look at all this data. If we want to filter for something we have to type Get-WindowsFeature -Name MSQ for example. QUickly, you will notice that it is not that easy to work with these filters.
Let’s pipe the command to Out-GridView. Type Get-WindowsFeature | ogv and press Enter.
The previous command will make a new window popup appear with the output of Get-WindowsFeature as we can see here:

This is the same exact data as we had before in PowerShell, however it is an interactive table.
Let’s say we want to find the feature for SMB. In the filter textbox, we type the word smb and it will filter down to the Roles and Features that include that search filter.

We can perform a search for IIS to see if it is Installed or Available.

Also, we can search for just the Installed Roles and Features by typing the word installed.

We can perform some more searches by adding criteria. Click on the Add criteria drop-down list to see the options.

We can select the checkbox Install State and click the Add button

Next, type the word installed.

We can combine the criteria by typing on the Filter text box DNS.

We can close the window and return to PowerShell by typing some other commands.
Type Get-Module and press Enter.

We can pipe it to OGV so let’s type Get-Module | ogv and press Enter.

We see we get the same exact output in a New Window.
We will focus on the ExportedCommands column to the right.
Close the window and type Get-Module | Select-Object ExportedCommands and press Enter to select just that column.

We can output the command to OGV but we will see the same result and that’s not what we want.
Now, what we want to do is type the following command outputting the result to OGV. Type Get-Module | Select-Object -ExpandProperty ExportedCommands | OGV and press Enter.

That is how you can use the OGV to find, view, and filter your PowerShell data.
You can do this with any command even the ones that don’t make sense like ipconfig | ogv

Now, it does not work really well when you use string-type objects, but you can still filter the information.
So again, you can use the OGV command on just about anything, but on some, it might not work like when you type Write-Host “Test” | ogv, but there’s no reason why you want to do that.
That is how you use the OGV Command to Easily View console data.
Sign up to access the rest of this lesson
You must either log in or sign up to access this lesson.

Saving Progress...