Script Explorer for PowerShell

Script Explorer

Why am I writing about Script Explorer?

Because I got to play with it when it was more concept than product.


This is something that the Scripting Guys already talking about.  Now so can I.  I’ve been a part the CAB for Script Explorer and have tried it’s various iterations.  Joshy has been very responsive and kudos out to Mr. Kelly at MS.  So, this will be in my typical fashion.  I’m going run through it, kick the tires and light the fires.

I installed it over the top of another version to see how it was going to play with a previous release and if a hiccup happens…

I was presented with the typical Repair/Uninstall message.  Since this is checking the clean up I went with uninstall.  Once that completed and the install was done I got the new program indicator and:



Then I started to look around, clicked a buttor or two:


Hey, looks like good stuff.  I randomly clicked Browse Categories and Apps, and got right to the scripts. Well, one of the items that ScriptExplorer (SE) does is integrate with the PowerShell ISE.  Guess that’s next.


Sure enough.  Already integrated but does it work?


Leads to:


Bing Search vs Script Explorer

Many technical questions are answered by searching through major search providers.  For this quick test, I chose Bing to go up against ScriptExplorer.  The scenario is that I need to find some scripts to work with the Web Front End of SharePoint.  So, the stage is set and I want to see the results.  First I’ll start out with a simple search string “SharePoint WFE”.  Pretty open right?

With “SharePoint WFE” in the Search Box in Script Explorer only 41 results were returned.  That’s a pretty targeted list.


This included Bing, PoshCode and TechNet in the search.


So, to compare, it’s off to Bing.


So, just typing in “SharePoint WFE” in BING is not very useful and returned the expected mega-million number of results.  A set by and large to big to just scroll through.   But Search is all about the request, so, time to reformat the question.  To be fair to Bing, ScriptExplorer is already looking for PowerShell Scripts exclusively.

Entered: “SharePoint WFE PowerShell Scripts”

The results were a little better.  Down from 5.96 million results to only 29k.  Still a bit a large list but with more filtering, I can probably scope it down further.  There’s enough to get started.

The abstracts are similar (Bing):


To this from ScriptExplorere:


Right away, I get to see much more information about what the script does.  Continuing on through the Bing to Technet connection I get:


Download link and all.  So, using Bing the basic steps are:

  1. Putting in a correctly formatted search request –> this may take several trys to pare down the list to a manageable number.
  2. Getting a lot of results to scan through—> evening after carefully filtering results, you still will have a large list.
  3. Landing on a page that requires further action to get the content

Back to ScriptExplorer

Remember, both started with the Query String SharePoiint WFE

So here we have the same script:


When Selected, I get two options (Save/Insert).


Clicking save presents a warning:


After accepting the license agreement you get:


And then you are presented where to locate it.


Now I went back and clicked insert and ended up with the script inserted right into my PowerShell ISE


Seems like there was a lot of commentary in the script but certainly not in the inserted piece.  So I opened up the downloaded file (stored in C:\Users\<UID>\Documents\Microsoft Script Explorer\

# ——————————————————————
# Title: PowerShell script for monitoring SharePoint WFE’s and SQL Server back-ends
# Author: Margriet Bruggeman
# Description: You may find that this gallery upload is more than you think (wasn’t that the slogan of Office once?). Choosing the correct set of performance counters for monitoring SharePoint WFE’s and back-ends is a daunting task, and this is my attempt.
# Date Published: 11/16/2011 9:09:06 PM
# Source:
# Tags: PowerShell SharePoint 2010 monitoring
# Rating: 3.625 rated by 8
# ——————————————————————

get-counter -counter (get-content mycounters.txt) -MaxSamples 100 -sampleinterval 5 | export-clixml test.xml

So to recap Script Explorer:

  1. Presents detailed information about the script
  2. Simple process to download
  3. Search both local and network resources
  4. Can either store a local copy with all the comments or inserts a minified script into the ISE

Published by


Originally, this was a pretty darn boring post. Kinda like... Well I won't go there. Perhaps its still on the robotic side but... I could say I like music. Safe, generic and non-comittal. Or, I could say that I've been having a blast tuning up my old guitars, getting blisters on my fingers and turning the amp up past 2. Amazaing what a little overdrive and a half pressed wahwah pedal can do for a sound. Get that cool "Money for Nothin" vibe happening. I get a real kick out of reading old Sci Fi. Reading Asimov's vision about the future is really entertaining now. When he wrote much of the material, the items that were futuristic were day to day tools I used in the early part of my career. Microfiche and the like. I also remember that upstart Microsoft and MS DOS...and can you say Lotus 123? So maybe this is a little better than "I like to read and play music". My career is focused on Team Leadership and Technology. Both share the attributes of continual growth and education. Currently, I manage a team of 4 programmers as direct reports. I've been in this role since 08/2007. Prior to that, I was the team lead (on site) for integration with the customer. Customers ranged from local government to manufacturing and medical. Teams ranged in size from one to six additional team members. On the other side is technology. I've been keeping current with .net technologies focusing on C# and Sharepoint (2007/2010). Specialties Team Building and Management Technical Staff Recruiting Microsoft Visual Studio 7 through 2010 (VB.NET and C#.NET) Microsoft SQL Server 6.5-2008R2 (DTS, TSQL, SSIS, SSAS, and SSRS ) SharePoint 2010 (Office Integration, InfoPath, Site Management and planning) Windows Server 2008 R2 AD DS PowerShell Techology analysis Puchasng and working with vendors Microsoft licensing management and compliance Business Systems Analysis Traning plans Mentoring Training coordination.

Leave a Reply

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

You are commenting using your 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