• [Script of Nov. 22] Retrieve a list of Active Directory User based on Display Names (PowerShell)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: 22221.zip
    http://gallery.technet.microsoft.com/scriptcenter/Retrieve-a-list-of-Active-90c533a2

    This PowerShell script sample shows how to get a list of active directory Sam Account name based on display name.

    This PowerShell script sample shows how to get a list of active directory Sam Account name based on display name.

    image image
    image

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

  • [Script of Nov.21] How to add credentials to the Windows Vault (PowerShell)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: 22165.zip
    http://gallery.technet.microsoft.com/scriptcenter/How-to-add-credentials-to-c8e9bd5f

    This PowerShell script shows how add credentials for specific users.

    There is no need to manually add credentials using control userpasswords2>Advanced>Manage Passwords>Add a windows credential. A script for administrator to add credentials for specific users is more convenient.

    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

  • [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. 25] Check the state of all instances in a SQL Server (PowerShell)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: 22123.zip
    http://gallery.technet.microsoft.com/scriptcenter/Check-the-state-of-all-1ad2f8d2

    This PowerShell script will check the state of all instances in a SQL Server. It will list the name, start mode, state and status of all the instances in a local machine. If there is no instance installed, it will remind you that there is no instance.

    Some people asked how to list the state of all instances in a machine. They need get all the instances in their machine and check if they are running or stopped.

    image image
    image

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