September, 2013

Script Download: AlwaysOnDataCollection.zip
http://gallery.technet.microsoft.com/T-SQL-script-to-capture-add13e98

This T-SQL sample script quickly captures topology of an AlwaysOn configuration in SQL Server.

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

Script Download: ListUnusedContentDatabases.zip
http://gallery.technet.microsoft.com/List-Unused-Content-c078e894

This script can be used to list your unused SharePoint content databases. It can also be used to list used content databases or all content databases.

By default, we can use Get-SPContentDatabase to retrieve SharePoint content databases. But this can only list the database that’s status is Ready. The content database cannot be listed if its status is Offline.

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

Script Download: DeleteEvilPrintQueueRegKey.zip
http://gallery.technet.microsoft.com/Script-to-fix-issues-1763321b

This sample can help you resolve the issue “The new printer status is Offline after you delete a print queue and then restart a Windows-based computer” described in KB2027593. It demonstrates how to list printers, print queues and how to delete evil registry key for print queue by using PowerShell script. This script completes the tasks by using registry and WMI Win32_Printer class.

Consider the following scenario:

In this scenario, the status of the new print queue is displayed as Offline. To solve this issue, you can use this script to get and remove evil registry key which cause the problem after you delete a print queue but before you add a new print queue of the same name.

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

Script Download: NewOSCSPSiteGroup.zip
http://gallery.technet.microsoft.com/Create-SharePoint-Groups-29637f98

This script can create SharePoint groups with group members in Microsoft SharePoint Server 2010.

In a real world, you may need to create a lot of SharePoint groups and add many users to this group for some reasons. If there are lots of users, it will be a lot of work for IT Administrators, so they need a script to help them complete this task.

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

Script Download: UPASync-2010.zip
http://gallery.technet.microsoft.com/Start-User-Profile-4a6a82a9

This script can be used to automate the user profile synchronization for the default User Profile Service Application. 

It can be used to schedule the user profile sync operation or start it after a farm restore operation.

You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery