• [Script of Apr. 23] Prepopulate a batch of user passwords to RODC (PowerShell)

    Script Download: 

    The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.

    This Windows PowerShell script will prepopulate a batch of user passwords to a specified Read-only Domain Controller. It will leverage the capability of the native command, repadmin. The script will also strictly check the parameters for avoiding any potential human error.

    Currently, IT Professionals can only prepopulate user password for one account each time.  If IT Professionals have to prepopulate 200 or more user passwords within a very short period of time, the job will turn out to be very stressful and tedious.

    image image
     image

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

  • [Script of Apr. 22] How to combine multiple rows into one row by a same column value (SQL)

    Script Download: 

    The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.

     

    This T-SQL script will demo how to combine multiple rows into one row by a same column value in SQL Server.

    As many people asked how to combine multiple rows into one row by a same column value. The script will demo how to combine by creating a table.

    image image
     image

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

  • [Script of Apr. 21] How to get information of SQL Server and databases (SQL)

    Script Download: 

    The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.

    This T-SQL script will demo how to get the version of SQL Server, the installation path, number of CPU, path of all user database and log files of all databases.

    As many people asked how to get general information of SQL Server, this script will demo how to get the version of SQL Server, the installation path, number of CPU, path of all user database and log files of all databases.

    image image
     image

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

  • [Script of Apr. 18] Configuring FBA (SQL or LDAP) for SP 2010 and SP 2013

    Script Download: 22223.zip
    http://gallery.technet.microsoft.com/Configuring-FBA-SQL-or-935f5c0c

    Script allows an IT admin to configure LDAP or SQL based FBA on SharePoint 2010/2013 web applications i.e. it makes all the changes in web.config files of Central Admin, STS and web applications on all the Servers automatically minimizing the possibility of human error and drastically reducing the time and effort. It also puts in place basic checks like SQL/LDAP connectivity checks, duplicates, web application eligibility for FBA. Most important it takes the backup of each file before modifying anything providing a kind of failback mechanism in case of issues

    Normally configuring FBA in SharePoint involves manual entry of various kinds in web.config files of CA, STS and target web application on all the servers in the farm, resulting in higher probability of human induced errors and subsequently increased time and effort.

    image image
     image

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

  • [Script of Apr. 17] How to Export the list of Active Sync Users to CSV in Office 365 (Powershell)

    Script Download: 29331.zip
    http://gallery.technet.microsoft.com/How-to-Export-the-list-of-f81ea5e1

    This script will generate a report about the status of Exchange Active Sync devices.

    This script is to help Exchange Administrators to generate a report about Exchange Active Sync Devices of mailboxes in organization, a group of mailboxes or a single mailbox.

    image image
     image

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