{"id":37,"date":"2019-11-11T15:47:35","date_gmt":"2019-11-11T15:47:35","guid":{"rendered":"https:\/\/www.practicalpowershell.com\/post\/get-out-gridview"},"modified":"2020-03-06T19:35:50","modified_gmt":"2020-03-06T19:35:50","slug":"get-out-gridview","status":"publish","type":"post","link":"https:\/\/practicalpowershell.com\/get-out-gridview\/","title":{"rendered":"Get Out! (-GridView)"},"content":{"rendered":"

One of the more interesting cmdlets that was pointed out to me recently is Out-GridView. I found that for a script I wrote, being able to visually display choices and allowing those choices to be selected and acted on was an enormous benefit for certain functions. Specifically, when using the Out-GridView cmdlet with the -PassThru switch, we are enabling users to select objects from a list (prepopulated or gathered locally with variables) and pass those selections for a script. Let’s walk through a couple examples to help you visualize the benefits. <\/p>\n

Example 1 <\/strong><\/p>\n

Take an environment that has a lot of mailboxes, say over 100,000 and there are many name conflicts due to the same first name and last name combinations. However, by looking at other details we can differentiate the users. Then, by knowing who is who, we can then select those mailboxes and review their sizes. For this example we have three mailboxes and our differentiating factor is the Office Location. So when we query these mailboxes we pull the DisplayName, Alias, and Office Location:
\n[sourcecode language=”powershell”]
\n$Mailboxes = Get-Mailbox | Select DisplayName,Alias,Office
\n$Mailboxes | Out-GridView
\n[\/sourcecode]
\nIf we run the two lines above we can view a list of all mailboxes and then filter for mailboxes in the list:
\n\"\"<\/a>
\nHowever, we cannot do anything with this information. Selecting names does nothing and nothing is returned to the script. The question is then, how do we return selections? ‘-Passthru’:
\n[sourcecode language=”powershell”]
\n$Mailboxes | Out-GridView -Passthru
\n[\/sourcecode]
\nNow we can select a mailbox:
\n\"\"<\/a>
\nBy selecting a mailbox, we can see output returned to PowerShell:
\n\"\"<\/a>
\nWe can also collect this information in a variable for later use like so:
\n[sourcecode language=”powershell”]
\n$SelectedMailboxes = $Mailboxes | Out-GridView -Passthru
\n[\/sourcecode]
\nWhen this is run, we can verify the variable contents like so:
\n\"\"<\/a>
\nExample 2 <\/strong><\/p>\n

Imagine you need to remove a list of files, either from a local on-premises file server or from a user’s one drive, being able to validate that the files you need to delete are correct would be useful. In the below example Out-GridView, a list of files was provided via CSV and now we are using PowerShell to first validate the files and display which ones that were found. <\/p>\n

From there we can select which ones we want to remove:
\n\"\"<\/a>
\nThen, once the files are selected we can process each file and double-check that the file selected is to be deleted:
\n\"\"<\/a>
\nAs we can see from the above examples, Out-GridView can provide a more user-friendly interface for those executing the scripts. Give it a try and comment if you find this tip useful. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"

One of the more interesting cmdlets that was pointed out to me recently is Out-GridView. I found that for a script I wrote, being able to visually display choices and allowing those choices to be selected and acted on was an enormous benefit for certain functions. Specifically, when using the Out-GridView cmdlet with the -PassThru […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":[],"rop_publish_now_history":[],"rop_publish_now_status":"pending","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-37","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nGet Out! (-GridView) - Practical PowerShell<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/practicalpowershell.com\/get-out-gridview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Get Out! (-GridView) - Practical PowerShell\" \/>\n<meta property=\"og:description\" content=\"One of the more interesting cmdlets that was pointed out to me recently is Out-GridView. I found that for a script I wrote, being able to visually display choices and allowing those choices to be selected and acted on was an enormous benefit for certain functions. Specifically, when using the Out-GridView cmdlet with the -PassThru […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/practicalpowershell.com\/get-out-gridview\/\" \/>\n<meta property=\"og:site_name\" content=\"Practical PowerShell\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-11T15:47:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-06T19:35:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/practicalpowershell.com\/wp-content\/uploads\/2019\/11\/OutGridView02a.jpg\" \/>\n<meta name=\"author\" content=\"damian\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"damian\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/\"},\"author\":{\"name\":\"damian\",\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/#\\\/schema\\\/person\\\/4d0733c81966e744aabbb49f56d64deb\"},\"headline\":\"Get Out! (-GridView)\",\"datePublished\":\"2019-11-11T15:47:35+00:00\",\"dateModified\":\"2020-03-06T19:35:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/\"},\"wordCount\":437,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/#\\\/schema\\\/person\\\/4d0733c81966e744aabbb49f56d64deb\"},\"image\":{\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/practicalpowershell.com\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/OutGridView02a.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/\",\"url\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/\",\"name\":\"Get Out! (-GridView) - Practical PowerShell\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/practicalpowershell.com\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/OutGridView02a.jpg\",\"datePublished\":\"2019-11-11T15:47:35+00:00\",\"dateModified\":\"2020-03-06T19:35:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/practicalpowershell.com\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/OutGridView02a.jpg?fit=606%2C302&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/practicalpowershell.com\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/OutGridView02a.jpg?fit=606%2C302&ssl=1\",\"width\":606,\"height\":302},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/get-out-gridview\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/practicalpowershell.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get Out! (-GridView)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/#website\",\"url\":\"https:\\\/\\\/practicalpowershell.com\\\/\",\"name\":\"Practical PowerShell\",\"description\":\"PowerShell books written by experts\",\"publisher\":{\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/#\\\/schema\\\/person\\\/4d0733c81966e744aabbb49f56d64deb\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/practicalpowershell.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/practicalpowershell.com\\\/#\\\/schema\\\/person\\\/4d0733c81966e744aabbb49f56d64deb\",\"name\":\"damian\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d5a8cc64a5aa27558a897b108e3be1a89859511a3fd26176dac292f26e7a4ae4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d5a8cc64a5aa27558a897b108e3be1a89859511a3fd26176dac292f26e7a4ae4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d5a8cc64a5aa27558a897b108e3be1a89859511a3fd26176dac292f26e7a4ae4?s=96&d=mm&r=g\",\"caption\":\"damian\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d5a8cc64a5aa27558a897b108e3be1a89859511a3fd26176dac292f26e7a4ae4?s=96&d=mm&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Get Out! (-GridView) - Practical PowerShell","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/practicalpowershell.com\/get-out-gridview\/","og_locale":"en_US","og_type":"article","og_title":"Get Out! (-GridView) - Practical PowerShell","og_description":"One of the more interesting cmdlets that was pointed out to me recently is Out-GridView. I found that for a script I wrote, being able to visually display choices and allowing those choices to be selected and acted on was an enormous benefit for certain functions. Specifically, when using the Out-GridView cmdlet with the -PassThru […]","og_url":"https:\/\/practicalpowershell.com\/get-out-gridview\/","og_site_name":"Practical PowerShell","article_published_time":"2019-11-11T15:47:35+00:00","article_modified_time":"2020-03-06T19:35:50+00:00","og_image":[{"url":"https:\/\/practicalpowershell.com\/wp-content\/uploads\/2019\/11\/OutGridView02a.jpg","type":"","width":"","height":""}],"author":"damian","twitter_card":"summary_large_image","twitter_misc":{"Written by":"damian","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/practicalpowershell.com\/get-out-gridview\/#article","isPartOf":{"@id":"https:\/\/practicalpowershell.com\/get-out-gridview\/"},"author":{"name":"damian","@id":"https:\/\/practicalpowershell.com\/#\/schema\/person\/4d0733c81966e744aabbb49f56d64deb"},"headline":"Get Out! (-GridView)","datePublished":"2019-11-11T15:47:35+00:00","dateModified":"2020-03-06T19:35:50+00:00","mainEntityOfPage":{"@id":"https:\/\/practicalpowershell.com\/get-out-gridview\/"},"wordCount":437,"commentCount":0,"publisher":{"@id":"https:\/\/practicalpowershell.com\/#\/schema\/person\/4d0733c81966e744aabbb49f56d64deb"},"image":{"@id":"https:\/\/practicalpowershell.com\/get-out-gridview\/#primaryimage"},"thumbnailUrl":"https:\/\/practicalpowershell.com\/wp-content\/uploads\/2019\/11\/OutGridView02a.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/practicalpowershell.com\/get-out-gridview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/practicalpowershell.com\/get-out-gridview\/","url":"https:\/\/practicalpowershell.com\/get-out-gridview\/","name":"Get Out! (-GridView) - Practical PowerShell","isPartOf":{"@id":"https:\/\/practicalpowershell.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/practicalpowershell.com\/get-out-gridview\/#primaryimage"},"image":{"@id":"https:\/\/practicalpowershell.com\/get-out-gridview\/#primaryimage"},"thumbnailUrl":"https:\/\/practicalpowershell.com\/wp-content\/uploads\/2019\/11\/OutGridView02a.jpg","datePublished":"2019-11-11T15:47:35+00:00","dateModified":"2020-03-06T19:35:50+00:00","breadcrumb":{"@id":"https:\/\/practicalpowershell.com\/get-out-gridview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/practicalpowershell.com\/get-out-gridview\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/practicalpowershell.com\/get-out-gridview\/#primaryimage","url":"https:\/\/i0.wp.com\/practicalpowershell.com\/wp-content\/uploads\/2019\/11\/OutGridView02a.jpg?fit=606%2C302&ssl=1","contentUrl":"https:\/\/i0.wp.com\/practicalpowershell.com\/wp-content\/uploads\/2019\/11\/OutGridView02a.jpg?fit=606%2C302&ssl=1","width":606,"height":302},{"@type":"BreadcrumbList","@id":"https:\/\/practicalpowershell.com\/get-out-gridview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/practicalpowershell.com\/"},{"@type":"ListItem","position":2,"name":"Get Out! (-GridView)"}]},{"@type":"WebSite","@id":"https:\/\/practicalpowershell.com\/#website","url":"https:\/\/practicalpowershell.com\/","name":"Practical PowerShell","description":"PowerShell books written by experts","publisher":{"@id":"https:\/\/practicalpowershell.com\/#\/schema\/person\/4d0733c81966e744aabbb49f56d64deb"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/practicalpowershell.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/practicalpowershell.com\/#\/schema\/person\/4d0733c81966e744aabbb49f56d64deb","name":"damian","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d5a8cc64a5aa27558a897b108e3be1a89859511a3fd26176dac292f26e7a4ae4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d5a8cc64a5aa27558a897b108e3be1a89859511a3fd26176dac292f26e7a4ae4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d5a8cc64a5aa27558a897b108e3be1a89859511a3fd26176dac292f26e7a4ae4?s=96&d=mm&r=g","caption":"damian"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/d5a8cc64a5aa27558a897b108e3be1a89859511a3fd26176dac292f26e7a4ae4?s=96&d=mm&r=g"}}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/practicalpowershell.com\/wp-json\/wp\/v2\/posts\/37","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/practicalpowershell.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/practicalpowershell.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/practicalpowershell.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/practicalpowershell.com\/wp-json\/wp\/v2\/comments?post=37"}],"version-history":[{"count":1,"href":"https:\/\/practicalpowershell.com\/wp-json\/wp\/v2\/posts\/37\/revisions"}],"predecessor-version":[{"id":264,"href":"https:\/\/practicalpowershell.com\/wp-json\/wp\/v2\/posts\/37\/revisions\/264"}],"wp:attachment":[{"href":"https:\/\/practicalpowershell.com\/wp-json\/wp\/v2\/media?parent=37"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/practicalpowershell.com\/wp-json\/wp\/v2\/categories?post=37"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/practicalpowershell.com\/wp-json\/wp\/v2\/tags?post=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}