• [Script Of July 17] How to send account lockout email notification

    image image
    July
    17
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-send-account-cdae5b39.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    This script shows how to automatically send an email notification to Administrator when there is a user locked out.

    When there is a user locked out, and then sends an email to domain admin. There are many users ask this issue, and this could be done by schedule task, we could also create a script to do the job.​

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

  • [Script Of July 16] How to modify send connector's address space

    image image
    July
    16
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-modify-send-75ac2030.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    This script updates address space for specific send connectors in Microsoft Exchange Server 2010.

    Send connectors create a logical connection to remote e-mail systems and are responsible for outbound transmission of e-mail messages. If your organization requires a Send connector with specific configuration options, or if you don't use the EdgeSync process, you have to manually configure Send connectors. Sometimes, you need to add or remove dozens of domains in the address spaces. So you want a script to complete this task more efficiently.

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

  • [Script Of July 15] How to find inneficient query plans

    image image
    July
    15
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-find-inneficient-7242d286.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    This T-SQL script will check the plan cache for the top 25 inefficient query plans. It will list total CPU time, CPU time per execution, total read IOs, average read IOs per execution, total recompiles and average recompiles per execution.

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

  • [Script Of July 14] How to assign License to unlicensed users automatically

    image image
    July
    14
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-assign-License-to-a920873d.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    This script will auto assign License to unlicensed users if there's only one type of SKU in an organization. If an organization has multi-type SKUs, an excel sheet will be popped out for edition after you run the script. Then the script will assign license based on the excel file.

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

  • [Script Of July 11] How to list tables with index issues in a SQL database

    image image
    July
    11
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/scriptcenter/How-to-easily-run-an-0c0eb47a/.  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    This script will demonstrate how to list tables with the following index issues in a database:

    • Tables with no index
    • Tables with no clustered index but with non-clustered index
    • Tables with more indexes than columns

    We provide this script for people to reference. If you want to know tables with no index or clustered index, or tables with more indexes than columns, this script will provide some help.

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