• [Script of May 15] Update Owner of a Group with another Group in a Web in Microsoft SharePoint 2010

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: ScriptPack.zip
    http://gallery.technet.microsoft.com/scriptcenter/Update-Owner-of-a-Group-1a205289

    The script can be used to update Group owner of a web with another group in the same web.

    The action can be performed from UI but is often time taking if needed to be done in bulk.

     

    image image
    image

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

  • [Script of May 16] Fix Publishing Pages which reference bad page layout within a site collection

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: FixPublishingPages.zip
    http://gallery.technet.microsoft.com/scriptcenter/Fix-Publishing-Pages-which-1e0deb22

    This script will scan all publishing pages in a given site collection and check if the pages in the pages library have a valid url for the page layout. The script runs in a “detect” mode by default and also accepts parameters which allow fixing the page layout url for pages. If the page is checked out to someone else, you can force undo of the checkout (results in changes on that page being lost). When fixing the page layout url, it will also checkout and approve the pages post fixing if moderation is enabled. It does not publish the pages.
    Having a correct page layout is important when rendering pages in publishing site or when using features such as Variations or Content Deployment because these will fail if the referenced page layout is invalid or pointing to a location which is not valid in the context of the site.
     
    In a real world, this script will help fix issues wherein
                a. Variations create hierarchies fail because the page layout is invalid.
                b. Page rendering fails because the page layout is invalid.

     

    image image
    image

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

  • [Script of May 17] Guest user permission check for multiple databases per security best practices

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: GuestUserCheck.zip
    http://gallery.technet.microsoft.com/scriptcenter/Guest-user-permission-ac9eecdb

    This T-SQL sample script checks permissions for guest user in all databases. This script applies to system and to user databases.

    Knowing about guest user in Sql server is a frequent security requirement. This can also be a source of confusion since many a times guest user is disabled in Sql Server msdb's Sql server and results in issues indicated in below mentioned KB. 

    Some forums for such requirements are below:
    http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/04940880-85c4-419a-a859-8a6bd58a18f0 

    Such a script should also help in below mentioned KB (KB has script for single database):
    http://support.microsoft.com/kb/2539091

    You should not disable the guest user in the msdb database in SQL Server 

    Script does below:

    • Script checks that all databases (except msdb) do not have any permission per security best practice.
    • Script checks that msdb database has Connect permission for guest user.
    • Script runs in Sql 2005/2008/2008R2/2012.

     

    image image
    image

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

  • [Script of May 20] Create a Shutdown/Restart/Logoff Windows 8 Tile for the Start menu (VBScript)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: CreateWindowsTile (VBScript).zip
    http://gallery.technet.microsoft.com/scriptcenter/Create-a-ShutdownRestartLog-b4d75991

    This VBScript shows how to create a Shutdown, Restart and Logoff Windows 8 tile to the Start menu.

    In Windows 8, without a Start button, properly shutting down or rebooting Windows can be a bit of a chore. Many users want to shut down or reboot Windows in just one click. This script enables users to click on a tile to shut down, reboot or log off Windows on the Start menu.

    image image
      image

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

  • [Script of May 21] Create a Windows 8 Switch User Tile for the Start menu (VBScript)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: CreateSwitchUserWindowsTile(VBScript).zip
    http://gallery.technet.microsoft.com/scriptcenter/Create-a-Windows-8-Switch-2c09bee4

    This VBScript shows how to create a Windows 8 Switch User tile for the Start menu.

    Properly switching users in Windows 8 without a Start button can be a bit of a chore. Many users may want to switch users in just one click. This script enables users to click a tile to switch user on the Start menu.

     

    image image
    image

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