• [Script of Apr. 3] Create a shortcut to Email a Recipient Directly to desktop in Windows 8 (VBS)

    Script Download: 26702.zip
    http://gallery.technet.microsoft.com/Create-a-shortcut-to-Email-bcf779da

    This script sample shows how to create a shortcut to Email a Recipient Directly to desktop in Windows 8.

    Sometimes we often communicate with some people via Email, so we can create a shortcut on desktop for convenience.

    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. 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

  • [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. 30] How to add application installation condition (Query WMI) in SCCM 2012 SP1

    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 scripts shows how to add an application installation condition (Query WMI) in System Center 2012 Configuration Manager SP1.

    Suppose you are a SCCM administrator of a large company, you need to deploy software to devices provided by different vendors. You can add conditions to a task sequence step to make sure applications are deployed to the right devices. But a task sequence may contain multiple steps requiring to add conditions; it’s not easy to find the steps in task sequence editor. So you want to use a script to ease your work.

    image image
     image

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