• [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 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 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 18] How to convert .xlr file to .xls file

    image image
    July
    18
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-convert-xlr-file-to-45c07dbe.  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 Convert Microsoft Works Spreadsheet file XLR to Microsoft Excel file XLS.

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

  • [Script Of July 21] How to send a warning report of a mail storm

    image image
    July
    21
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-Send-a-Warning-9d8e503f.  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 find senders that have sent large numbers of e-mails, then look for consistent use of same subject and recipient, finally send a warning email to a particular User.

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