PowerShell

Having fun around the office with PowerShell Pranks – PowerPoint

Last week I presented to the Indianapolis PowerShell User Group about PowerShell Pranks. I will be doing a much more in depth blog post about it in the near future. I wanted to first provide the PowerPoint slide that I used, please note that there is a serious line you shouldn’t cross; where you draw that line is at your discretion and it may be a lot closer than my line is.

The road to become an MCT

I have had a goal over the last two years to become a Microsoft Certified Trainer (MCT). I was already half way there by holding an MCITP certificate in Windows 7 and Server 2008; however I still had to finalize the last requirement of either obtaining my CompTIA CTT+ or attending a Train The Trainer course. Earlier this summer I had started the path to obtain my CTT+ by purchasing and began reading the book to prep me for the exam. About a month later the details for the MCT Summit along with the Train The Trainer course was posted. I spoke with my manager about the positives and negatives of the Train the Trainer path and we decided that was best.

1239026_583642745026355_1992737302_n
2013 MCT Summit Baby MCT’s with their trainers

Last month the on September 16th and 17th I spent my entire day in a room with 25 other people wanting to become MCT’s. A few weeks prior to this I had received a few emails with pre-course work that needed to be completed. Nothing too major just an evaluation asking what I was hoping to learn, a assessment quiz to gauge where I was with the CTT+, and a document I had to fill out, outlining what my presentation would be on.

Get Most Used Document Libraries and Lists in SharePoint

Lately I have been putting a lot of my time into developing useful PowerShell scripts for managing Windows environments. While working on these scripts I’ve developed some really cool 1-liner scripts that are extremely easy to run. In the below 1-liner PowerShell scripts you will get the top 10 most used Document Libraries and Lists by item count. The nice thing about SharePoint and PowerShell is the majority of the scripts written for SharePoint 2010 will work in SharePoint 2013; in this case it does!

Top 10 Document Libraries:

Get-SPSite -Limit All | Get-SPWeb -Limit All | % { $_.Lists} | ? { $_ -is [Microsoft.SharePoint.SPDocumentLibrary] } | Sort-Object { $_.ItemCount } -Descending | Select-Object Title, Description, ItemCount, ParentWebUrl -First 10

 Top 10 Lists:

Get-SPSite -Limit All | Get-SPWeb -Limit All | % { $_.Lists} | ? { $_ -isnot [Microsoft.SharePoint.SPDocumentLibrary] } | Sort-Object { $_.ItemCount } -Descending | Select-Object Title, Description, ItemCount, ParentWebUrl -First 10

PowerShell One Liner for Count of all Documents in SharePoint 2010 Farm

Last week I had a client reach out to me, asking for a count of all documents in their SharePoint 2010 internal farm. They were planning on implementing Metalogix StoragePoint and were working on estimates for the deployment.
After a bit of work with PowerShell, I was able to throw a single line of PowerShell that sum’s the entire environment for me.

Get-SPSite -Limit All | Get-SPWeb -Limit All | % { $_.Lists} | ? { $_ -is [Microsoft.SharePoint.SPDocumentLibrary] } | % { $total+= $_.ItemCount} ; $total