0%
0/1 Lessons
Course Introduction • 5min
0 / 2 lessons complete
Course Introduction
Free Preview Lesson
Video | 3 min min
PowerShell System Requirements
Free Preview Lesson
Video | 2 min min
Getting Started with Windows PowerShell • 56min
0 / 8 lessons complete
The Basics of PowerShell
Free Preview Lesson
Video | 7 min min
Installing and Updating PowerShell
Free Preview Lesson
Video | 7 min min
The Text Based Console Part 1- An Overview
Full Access Account Required
Video | 7 min min
Text Based Console Part 2 - An Overview
Full Access Account Required
Video | 5 min min
The ISE (Intelligent Scripting Environment) Part 1
Full Access Account Required
Video | 5 min min
The ISE (Intelligent Scripting Environment) Part 2
Full Access Account Required
Video | 5 min min
Setting up Visual Studio Code for PowerShell
Full Access Account Required
Video | 14 min min
Use the OGV Command to Easily View console data!
Full Access Account Required
Video | 6 min min
Getting Help and Finding Commands • 39min
0 / 6 lessons complete
Getting Help and Finding Commands Part 1
Full Access Account Required
Video | 7 min min
Getting Help and Finding Commands Part 2
Full Access Account Required
Video | 3 min min
Getting Help and Finding Commands Part 3
Full Access Account Required
Video | 4 min min
Help System LAB Questions
Full Access Account Required
Video | 6 min min
Help System Lab Answers 1-4
Full Access Account Required
Video | 9 min min
Help System Lab Answers 5-9
Full Access Account Required
Video | 10 min min
PowerShell Command Syntax • 33min
0 / 5 lessons complete
Command Syntax Part 1
Full Access Account Required
Video | 8 min min
Command Syntax Part 2
Full Access Account Required
Video | 8 min min
Command Syntax Part 3
Full Access Account Required
Video | 5 min min
Command Syntax Lab Questions
Full Access Account Required
Video | 4 min min
Command Syntax Lab Answers
Full Access Account Required
Video | 8 min min
PowerShell Objects and Properties • 35min
0 / 6 lessons complete
Objects, Properties and Methods Part 1
Full Access Account Required
Video | 3 min min
Objects, Properties and Methods Part 2
Full Access Account Required
Video | 8 min min
Objects, Properties and Methods Part 3
Full Access Account Required
Video | 7 min min
Questions 1-9 for Objects, Properties and Methods
Full Access Account Required
Video | 2 min min
Answers to Questions 1-7 O-P-M
Full Access Account Required
Video | 11 min min
Answers to Questions 8,9 O-P-M
Full Access Account Required
Video | 4 min min
The PowerShell Pipeline • 24min
0 / 2 lessons complete
The Pipeline Part 1
Full Access Account Required
Video | 11 min min
The Pipeline Part 2
Full Access Account Required
Video | 13 min min
PowerShell Providers • 30min
0 / 5 lessons complete
What are PowerShell Providers
Full Access Account Required
Video | 3 min min
Using PS Drive
Full Access Account Required
Video | 6 min min
PowerShell Provider CMDlets -1
Full Access Account Required
Video | 12 min min
PowerShell Providers CMDlets -2
Full Access Account Required
Video | 7 min min
Student Assignments
Full Access Account Required
Text | 2 min min
PowerShell Arrays and Variables • 28min
0 / 4 lessons complete
PowerShell Variables
Full Access Account Required
Video | 9 min min
PowerShell Arrays
Free Preview Lesson
Video | 12 min min
PowerShell Variables Challenge
Full Access Account Required
Video | 2 min min
PowerShell Variables Solution
Full Access Account Required
Video | 5 min min
PowerShell Loops • 19min
0 / 3 lessons complete
For Loops
Free Preview Lesson
Video | 7 min min
While Loops
Free Preview Lesson
Video | 7 min min
For Each Loop
Free Preview Lesson
Video | 5 min min
PowerShell Conditional Statements • 11min
0 / 1 lessons complete
On Premises Lab Setup • 36min
0 / 8 lessons complete
Should You Watch This Section?
Full Access Account Required
Video | 2 min min
Downloading and Installing VirtualBox
Full Access Account Required
Video | 2 min min
Downloading Windows Server 2019
Full Access Account Required
Video | 3 min min
Creating Your Virtual Network
Full Access Account Required
Video | 2 min min
Creating Your Virtual Machines
Full Access Account Required
Video | 7 min min
Installing VirtualBox Guest Additions
Full Access Account Required
Video | 2 min min
Installing Windows Server
Full Access Account Required
Video | 8 min min
Installing the Active Directory Domain Services Role
Full Access Account Required
Video | 10 min min
Basic Domain Administration with Windows PowerShell • 2hr 27min
0 / 10 lessons complete
Configuring PowerShell Execution Policy with Group Policy
Full Access Account Required
Video | 13 min min
Installing Windows Server Roles and Features with Powershell
Full Access Account Required
Video | 6 min min
Running Powershell Scripts as Scheduled Tasks
Free Preview Lesson
Video | 8 min min
Creating Organizational Units with Powershell
Full Access Account Required
Video | 11 min min
Creating and Managing Active Directory User Accounts with PowerShell
Full Access Account Required
Video | 19 min min
Move all AD Users in a Group to a Specific Organizational Unit
Full Access Account Required
Video | 7 min min
Generate a list of AD Users and their OU
Full Access Account Required
Video | 5 min min
PowerShell Splatting
Full Access Account Required
Video | 5 min min
Bulk Install Windows MSU Files Automatically with PowerShell
Full Access Account Required
Video | 13 min min
Lab: Domain Administration with Windows PowerShell
Full Access Account Required
Lab | 60 min min
Send Emails with PowerShell • 22min
0 / 2 lessons complete
Send Emails from Gmail with PowerShell
Full Access Account Required
Video | 9 min min
Create Password Expiration Notification Script
Full Access Account Required
Video | 13 min min
PowerShell Desired State Configuration (DSC) Basics • 1hr 48min
0 / 6 lessons complete
DSC Overview
Full Access Account Required
Video | 9 min min
Enabling PSRemoting with Group Policy
Full Access Account Required
Video | 9 min min
The DSC Resource Kit
Full Access Account Required
Video | 7 min min
Configuring The Local Config Manager for DSC Push
Free Preview Lesson
Video | 14 min min
Uninstalling Windows Features with DSC
Full Access Account Required
Video | 9 min min
Lab: Desired State Configuration (DSC)
Full Access Account Required
Lab | 60 min min
PowerShell Modules • 58min
0 / 7 lessons complete
Finding and installing PowerShell modules
Free Preview Lesson
Video | 17 min min
Creating a Custom PowerShell Module: Files and Folders
Full Access Account Required
Video | 5 min min
Writing the New-Greeting Function
Full Access Account Required
Video | 4 min min
Writing the Get-GreetingMessage Function
Full Access Account Required
Video | 3 min min
Creating the PSM1 PowerShell Module File
Full Access Account Required
Video | 9 min min
Creating a PowerShell Module Manifest and Importing our Custom Module
Full Access Account Required
Video | 8 min min
Writing automated module tests with Pester
Full Access Account Required
Video | 12 min min
Powershell Challenges • 1hr 55min
0 / 23 lessons complete
Section Overview
Full Access Account Required
Video | 5 min min
The Trusted Hosts List Challenge
Full Access Account Required
Text | 5 min min
The Trusted Hosts List Answer
Full Access Account Required
Video | 5 min min
Starting a Remote Session Challenge
Full Access Account Required
Text | 5 min min
Starting a Remote Session Answer
Full Access Account Required
Video | 5 min min
Rename a Computer Challenge
Full Access Account Required
Text | 5 min min
Rename a Computer Answer
Full Access Account Required
Video | 5 min min
Change a Password on a Remote Computer Challenge
Full Access Account Required
Text | 5 min min
Change a Password on a Remote Computer Answer
Full Access Account Required
Video | 5 min min
How to Copy Files To-From a Remote Machine Challenge
Full Access Account Required
Text | 5 min min
How to Copy Files To-From a Remote Machine using VSC Answer
Full Access Account Required
Video | 5 min min
How to Export Logs to a CSV File Challenge
Full Access Account Required
Text | 5 min min
How to Export Logs to a CSV File Answer
Full Access Account Required
Video | 5 min min
How to Create Multiple Folders on the Host Machine using Powershell
Full Access Account Required
Text | 5 min min
How to Create Multiple Folders on the Host Machine using Powershell Answer
Full Access Account Required
Video | 5 min min
Who Rebooted the Server ID1074 Challenge
Full Access Account Required
Text | 5 min min
Who Rebooted the Server
Full Access Account Required
Video | 5 min min
How can you get Info on all your Hard Drives Challenge
Full Access Account Required
Text | 5 min min
How can you get Info on all your Hard Drives Answer
Full Access Account Required
Video | 5 min min
How can I get a list of CPU's and Installed Printers, Last Boot-up Time Challenge
Full Access Account Required
Text | 5 min min
How can I get a List of CPU's and Installed Printers, Last Boot-up Time Answer
Full Access Account Required
Video | 5 min min
How can I Automate Tasks with Task Scheduler Challenge
Full Access Account Required
Text | 5 min min
How can I Automate Tasks with the Task Scheduler Answer
Full Access Account Required
Video | 5 min min
Course Conclusion • 1min
0 / 1 lessons complete
Resources
There are no resources for this lesson.
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.
The videos are excellent, but it would be nice if we could spin up a lab directly from any given lecture so that we can follow along.
Hi
Christian Sanchez
Paul Hill
Thank you for the feedback. We will review your suggestion with
Ricardo
I love this idea… Let me think about how we can implement it.