SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL
SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL

Blog

MOVIE – Awesome Admin Grid Scripts

Following up on my earlier post about the popularity of VBScript.  Again, I love new technology but we sometimes need the older tools to “git r done” today.   Please watch the 18 minute screen cast video for a real demo of each script.  Also, the download is available right here:

  SharePoint Dashboard.zip

   Vimeo – Watch Now

image

This demo covers my “dashboard” and “grid” script collection.

  • Explore C$
  • Free disk
  • GAC listing
  • Grid install apps
  • Grid file version
  • Grid windows service
  • Grid SPN
  • Grid WMI query
  • HOSTS compare
  • Kerberos (NTAuthenticationProvider)
  • Registry get/push
  • Web.config compare
  • WMI reboot

The design is simple yet powerful.  Drag and drop (noun to verb) from server to script.  Examples: 

  • explore c$ on these 5 machines 
  • push this reg key to 6 machines
  • compare windows services on these 12 machines
  • show me the Kerberos settings for these 7 machines

I began this family of short and simple VBS scripts back when I first deployed MOSS to production and have built them up over the years.  They have completely changed the way I work.  No more slow implementation.  No more uncertainty about configs.   Implement change quickly, spend your time on the whiteboard, and be 100% sure the configs are consistent across the board … every time.

Please take 5 minutes to watch the below video and glance over the screenshots.  Then download the ZIP and build your own RDP files for your servers.   If you find this useful or write new scripts please leave a comment or hit me up on Twitter.   I’m always  looking for ways to improve.  Thanks for reading.

SharePower + ShareMusic = Road Warrior

 

image

    

image

I don’t travel nearly as much as many of you but I have two indispensible mini hardware items I bring along each time.  These splitters are cheap but handy.  I’ve made many friends and networked new business contacts too.   Electrical outlets at the airport are notoriously hard to find and disappearing fast.   During the recession airlines are looking for every cost cut including yanking power from general consumption to reduce the electrical bill.  If I find somebody already plugged in I simply ask if I can add a splitter and I’m now able to find power almost anywhere. 

Smile

 

For music the same idea applies but in the give (not take) direction.   Somebody I’m having a conversation with that might be stranded and bored.    I can offer them music and let them choose the song so we get to talk more about things we like.   Anyway, nothing SharePointy but still fun.   It seems to work better on the younger iPod generation.

Maybe you’ll find these tips useful and … as always … safe travels!

PS – I wrote this while stuck at Hartsfield (ATL) for weather delays using a shared outlet.

VBScript is cool?!? Yeah, I said it.

So everybody is talking about PowerShell and that’s great.  I love object oriented languages for scripting too.  PS is amazing.  But what about our old friend VBScript?   Our workhorse for the past decade?

Reasons why VBScript can be cool

  • Great samples.   Across the blogosphere we have thousands of articles, snippets, and walkthroughs to pull from.  Save time, copy and reuse.
  • Wide compatibility.   Even Server 2003 or Windows XP RTM will be able to run this stuff.   No Windows Update, no prep work, no doubts.
  • Familiar/proven.   There are many people that know this tool and how to use it.  As we learn new tools we need the old ones for our day jobs.
  • Quick edits.     While true of any scripting language “right click edit” is very handy and I generally dislike compiling dot net for admin work.
  • Editors.   Even SharePoint Designer 2007 can read and colorize VBS.  With PowerShell 2.0 we now have ISE and I really like it.   Using a GUI is required to get the work done quickly and correctly no matter what the language.

After a few years in the server admin business I’ve realized the tools evolve and so do we.   But ultimately our creativity and awareness of “fit” between tool and goal are what get things done.   So if the shoe fits … pull out an old script, dust it off, and give it new life!    A production outage is no time to read a reference book.

I’ll follow up by posting the code of my favorite VBScripts I use today in a real live production MOSS 2007 environment.  It gets the job done.  Yes, it should be re-written in PowerShell for SP2010 and Server 2008.   The “grid” scripts are my favorite and present on a single page configuration across machines for snazzy things like:

  • File versions
  • Windows services (state/startup mode)
  • Keberos NTAuthenticationProvider in IIS 6.0
  • Applications installed (registry)
  • Web.config modifications

 

image

 

image
image
image
image

Lastly, empirical evidence suggests a fondness for this quirky old language via search results.  

Open-mouthed
http://thumbs.dreamstime.com/thumb_229/1201479864wVkudS.jpg

Unable to assign this e-mail address to the list, because the address is in use – FIXED

I came across this WSS error message today while working on incoming email updates and was stuck.   The browser clearly showed the list has no inbound email enabled and offered no alternatives on how to enable.   My enable failed, the address is taken, and I have no way to remove.

SQL Studio to the rescue!

addr in use

OK.  First of all I know, I know I know.   TSQL against the databases even in read only mode is frowned upon.   What I am doing here is far beyond supported, not safe, and I am a crazy man.  Again, I know this.   I had no other options and needed a solution.

The config database holds a central table the incoming email references to get the site, web, and list GUID for where to place the message.    I found my old email alias in here despite the fact the web GUI showed it was disabled.  

Disappointed

  I wrote a select statement and copied the output to notepad in case I needed to INSERT this row back.   I then changed “SELECT *” to “DELETE” and killed the one row.   Flipping back to IE and clicking OK, it worked perfectly!   Never had any issues since and this was weeks ago.   Like they say on TV … “don’t try this at home”

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲