October, 2014

Oct.

31

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

The goal of this script is to automatically collect GPO logs for troubleshooting.

Troubleshooting GPO issues always requires collect a series of related logs, including gpresult and GpSvc. Some Customers get trouble in collecting logs especially Gpsvc. If we can use scripts to collect these logs automatically and save log files in some drive location for customers, it would be more convenient and efficient.

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

Oct.

30

Script Download:  
The script is available for download from https://gallery.technet.microsoft.com//Get-the-frequency-that-a-f400603a.  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 PowerShell script will check the frequency of all the reports visited on the report manager during the latest week, latest month and latest year.

You can use this script for reference when you want to know the frequency of reports visited.

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

Oct.

29

Script Download:  
The script is available for download from https://gallery.technet.microsoft.com//How-to-check-if-TF834-and-f61ab782.  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 PowerShell script will demo how to check if trace flag 834 and column store indexes are used concurrently in SQL Server.

If trace flag 834 and column store indexes are used concurrently, you may encounter performance issues with applications. If this kind of problems exist, this script will warn you.

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

Oct.

28

Script Download:  
The script is available for download from https://gallery.technet.microsoft.com//How-to-get-index-usage-3b7e71cf.  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 output three parts, one to get the result of server level logins and related roles, one to get the result of user databases’ users and related roles, one to get the result of object level permission of specific database.

This script can be used to get the following results:

Server level logins and related roles

User databases users and related roles

Object level permission of specific database

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

Oct.

27

Script Download:  
The script is available for download from https://gallery.technet.microsoft.com//How-to-check-IO-information-b1ccc75e.  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 I/O information about all the database files such as read load, write load or overall I/O usage.

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