July, 2014

July 30

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-find-logins-without-5dd0311f.  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 find all the logins without user mapping in a specified SQL Server database. Besides, it will list all the users and logins, except for server roles and server principals with names enclosed by double hash marks ?#?which are for internal system use only.

Some people may encounter an error "The login already has an account under a different user name" when creating a user account for a specified database. So they need to create a user with another login. If there are many logins, it is not easy for them to try one by one. It will be better if there is a script to find all the available logins.

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

July 25

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-retrieve-the-IP-5781fc88.  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 shows how to get the IP address from virtual machines.

IT admins usually maintain multiple virtual machines. Getting the IP addresses of multiple virtual machines is not convenient.Using this script can easily to maintain and check virtual machines' info.

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

July 28

Script Download:  
The script is available for download from http://gallery.technet.microsoft.com/How-to-retrieve-a-list-of-da0fa284.  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 sample shows how to get a list of active directory Sam Account names based on display names.

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