• [Script of Nov.1] Batch convert .txt files to Word documents (VBA)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: ConvertTxtToWord(VBA).zip
    http://gallery.technet.microsoft.com/scriptcenter/Batch-convert-txt-files-to-8b945d5e

    This VBA sample shows how to convert ‘.txt’ files (in a folder) to Word documents.

    Batch converting ‘.txt’ files to Word documents is a frequently asked question in many public forums.

    image image
    image

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

  • [Script of Nov.4] Set PictureUrl as default unless another picture is present (PowerShell)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: SetSPUserPicture.zip
    http://gallery.technet.microsoft.com/scriptcenter/Set-PictureUrl-as-default-9e0123ca

    This script shows how to Set PictureUrl as default unless another picture is present.

    This script will set a default picture for the PictureUrl in a list where all user information are stored .If users don't specify a picture, the default picture will be used.

    image image
    image

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

  • [Script of Nov.5] Script to check and delete all users delegated permission (PowerShell)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: RemoveDelegatedPermission.zip
    http://gallery.technet.microsoft.com/scriptcenter/Script-to-check-and-delete-94c6c6e6

    The script helps us to check and delete all delegated permission of the user.

    As we know, there isn't a delete delegated permission wizard in Windows Server. If we want to delete all delegated permission and restore users' permission to default, we have to use ADUC and other tools such as Dsrevoke to check and delete each user's permission manually. Once we have the script, we could reduce a lot of work.

    image image
    image

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

  • [Script of Nov.6] Automatic Email Notification to Administrator about Inactive Accounts in AD

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: AutomaticEmail(PowerShell).zip
    http://gallery.technet.microsoft.com/scriptcenter/Automatic-Email-Notificatio-31e71980

    The goal of this script is to automatic email notification to Administrator about Inactive accounts in Active Directory.

    For management administrators always intend to identify the inactive user/computer accounts that have not logged on the domain for a certain period of time, then they could determine to disable, delete or remove these accounts. Rather than administrator manually finding out inactive accounts when he needed, automatically generating an inactive user/computer accounts report and sending a email notification to administrator would be much better.

    image image
    image

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

  • [Script of Nov.7] Check pre-requisite fixes on a system for SQL Server 2012 AlwaysOn(PowerShell)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: CheckPre-requisiteFixesSQLServer2012AlwaysOn.zip
    http://gallery.technet.microsoft.com/scriptcenter/Check-pre-requisite-fixes-d5843842

    This sample script checks pre-requisite fixes for AlwaysOn in SQL Server 2012. These fixes are publicly documented in http://technet.microsoft.com/en-us/library/ff878487.aspx (Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server)), in section “Windows Hotfixes that Support AlwaysOn Availability Groups (Windows System)”.

    Installing prerequisite fixes is not checked during configuration of SQL Server AlwaysOn, however may result in unexpected issues later.

    image image
    image

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