July 24

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-get-detailed-ac767add.  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 demo how to get detailed information of a SQL server, including SQL server version and the installation path, number of CPU, path of all user database and log files of all databases.

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

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

July 23

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-extract-reports-to-5cb7c47a.  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 is to help Exchange Administrators to generate a utilization report of organization's DG. And this script can generate a report with message details sent or received from a DG.

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

July 22

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-extract-metadata-bdd38e62.  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 extract metadata about reports.You can use this script for reference when you want to find information about dataset, data source of a report.

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

July 21

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

July 18

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