Powershell 3.0 – out-GridView

It’s often frustrating to trawl through a lengthy display of text when calling up Lync data such as an output from get-csuser. To be fair I often just dump the results to a csv file with some formatting. That does however mean that I now need to open the xml file to view the results.

An alternative is to simply pipe your query to out-gridview

…and the result:

 But wait..there is more…you can search for numerous details within the grid output. This could be a range or specific search item. Below I have searched for the last 4 digits of my LineURI (it also searched by extension number!). And yes you can search for PrivateLine as well.

Still more, you can add a list of search criteria, I have added a search for all Users that are Enterprise Voice Enabled and have the digits 270 in their LineURI as below:

Another really useful aspect is that you can right click on the column header to select only the columns you want to see (or drag the columns into a sequence that suits your requirements) as below:

Here I removed all and then selected just the columns I wanted:-

And the output looks like this:-


About Paul B

My name is Paul Bloem and I am employed at Lexel Systems in New Zealand as a Principal Consultant for Unified Communications. I have been working on enterprise voice solutions for over 20 years. My first 10 years were spent working for a Telco in South Africa (Telcom SA). This is where all the groundwork happened as I was exposed to just about every aspect of telecommunication you could imagine. I develop an interest in PBX technologies and eventually became the go-to guy. Next, I had a 10 year run at Siemens South Africa, most of my time there was as a Technical Trainer. During this time VoIP hit the world stage, I had the privilege of introducing VoIP both as H.323 and later SIP across the Siemens HiPath 4000 solution stack. In 2008 I immigrated to New Zealand with my newly attained MCSE, I was ready to go where no PBX Techie had gone before. I was employed to explore OCS 2007 and that was pretty much the beginning of the end for me. I have been working on OCS and Lync ever since. My current role focuses exclusively on Lync and associated technologies.. That includes pre-sales, consulting, architecture and design, training and support. I even get to play in the development space from time to time - focus on play ;-) I was nominated as a Microsoft VTSP for Lync early in 2013 and also awarded Microsoft's MVP award for Lync in 2014.
This entry was posted in Lync Server Management Shell, out-gridview, Powershell, Powershell 3.0. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s