We offer two things:
1. Hundreds of automation script samples based on IT Pros' frequently asked IT tasks
2. Script Browser & Script Analyzer tools to ease and improve the script writing
We are very grateful to the Windows PowerShell MVPs Kirk Munro and Laurent Dardenne for providing lots of great ideas to enhance the Script Browser & Script Analyzer in the past 3 weeks. Today, we are releasing the 1.3 update thanks to their suggestions. The team is committed to making the apps useful. Your feedback is very important to us.
Download Script Browser & Script Analyzer 1.3 (If you have already installed an earlier version of Script Browser & Script Analyzer, you will get an update notification when you launch Windows PowerShell ISE.)
1. Support Sub-Categories in Search Filters
You can select sub categories in the Filters now! In the following example, I selected Windows Azure / Automation sub category to look for all Azure automation script samples.
2. Save the Search Filters.
If you have some filter combination that you would like to use very often, you can save the search.
After saving the search, you can easily revisit the search in Saved Filters.
3. Add the support of ‘PowerShell Workflow’ scripts in the Script Browser.
4. In Script Analyzer, switching the code tab will no longer trigger the script analysis automatically
This change is based on the following user feedback and the discussion with MVPs.
https://scriptanalyzer.codeplex.com/workitem/1130
5. Other UI enhancements:
a) Reduce the height of search result in the search result list, so that user can see more search results on the screen.
b) Make it more obvious how to close the Filter option with the ‘Apply Filters’ button.
We sincerely suggest you give the new Script Browser & Script Analyzer a try (click here to download). If you love what you see in Script Browser & Script Analyzer, please recommend it to your friends and colleagues. If you encounter any problems or have any suggestions for us, please contact us at onescript@microsoft.com. Your precious opinions and comments are more than welcome.
Thanks to Satoru Kitabata, we get the chance to introduce the Script Browser and Script Analyzer application to the Japan IT community.
Here is a newly released MSDN article introducing how to use the Script Browser for Windows PowerShell ISE in Japanese.
http://msdn.microsoft.com/ja-jp/dn770154
The following article introduces the Script Analyzer usage.
http://msdn.microsoft.com/ja-jp/dn770155
Script of the Day
Script Download: The script is available for download in Microsoft Script Browser for Windows PowerShell ISE. You need to install the Script Browser application first, and search for the script sample title.
We can use Get-OSCNotEncryptedMasterKey to identify the database master key which is not encrypted by service master key. By default, this script uses Windows Authentication to connect to your SQL Server. If you want to use SQL Server Authentication, just uncomment some code in this script.
SQL Server uses a hierarchy of keys and certificates when a database is enabled for Transparent Database Encryption [TDE]. At the upper levels of the hierarchy, the Service Master Key [SMK] encrypts the Database Master Key [DMK] for the master database. The Database Master Key [DMK] encrypts and protects the Certificate and Database Encryption Key [DEK] involved in the encryption of the user database. After enabling a user database for TDE, you will be able to remove the SMK encryption of the DMK for the master database. If you restart the SQL Server at this point, the database startup will encounter error 15581 and prevent the database from starting up. In some situations, the LogWriter will hang with a wait_type of WRITE_LOG and prevent any transactions from committing in this database. Even though it is possible to remove the SMK encryption for the master database DMK, it is not recommended to do this.
You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery
This PowerShell script sample shows how to convert Visio page file to .png file.
Many companies generate technical visuals in Microsoft Visio and would like to be able to share this information on their corporate sites. The problem, however, is that most users would not be able to view the visuals in this format. One of the ways of solving this problem is converting Visio diagrams to a more universal format like PNG. But doing it manually would be time consuming, this sample can help us to batch convert Visio files, it would be very convenient.
This T-SQL 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.
This VBScript shows how to remove all network printers on a computer.
Remove all network printers is a frequently asked question in many public forums.
This VBscript sample shows how to configure the size limit for both (.pst) and (.ost) files in Outlook 2013.
In Outlook, as the recommended PST file size is less than 2GB, some users want to increase thier Outlook achive files size, but according to the MSKB 832925, the steps seems significantly complicated. The script can help user configure the size limit for .pst and ost files in Outlook, it could save the tedious process.