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
The Script Browser and Script Analyzer apps have received nearly 15,000 downloads since they were released half a month ago. Microsoft PowerShell MVPs provided numerous suggestions to help us improve the apps. Based on what we have learnt in the past two weeks, today we bring to you the 1.2 update of Script Browser and Script Analyzer. The team is committed to making the apps useful. Your feedback is very important to us.
Download Script Browser & Script Analyzer 1.2(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. A standalone desktop version of Script Browser
In this release, we provide a new standalone desktop version of Script Brower so that non-PowerShell scripters, e.g. SQL/VBS scripters, can also benefit from the browser.
You can easily configure the Script Browser desktop app and the Script Browser PowerShell ISE plugin to share the favorite samples and downloaded samples.
2. New Cmdlets to manually load Script Browser / Script Analyzer when you need them
In the past releases, the Script Browser and Script Analyzer plugins are turned on automatically when you start Windows PowerShell ISE. In this release, you can choose to manually load Script Browser and Script Analyzer into ISE when you need them. Here is how to do it.
First, you need to uncheck the following ‘Allow the installer to update Windows PowerShell ISE profile’ option when you install the 1.2 update. In this way, the Script Browser and Script Analyzer will not be loaded automatically when you start ISE.
Next, when you need Script Browser / Script Analyzer in the ISE, you can type the following cmdlets to load them:
When you do not need them, you can type these cmdlets:
We even provided a cmdlet for starting the desktop version of Script Browser:
3. Largely improved Script Analyzer rules
In this release, we figured out a new solution to largely improve the speedof Script Analyzer.
We have also fixed all Script Analyzer issues that users have reported. Please continue sharing your feedback with us.
4. Bug Fixes
a) Improve the startup speed of Script Browser and Script Analyzer
b) Fixed a sample rating display issue
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.
The PowerShell team has recently announced PowerShellGet, a new way to discover, install and update PowerShell modules, in the Windows Management Framework 5.0 Preview. In this blog, you will learn how to install Script Browser & Script Analyzer through the PowerShellGet.
First, you need to download and install Windows Management Framework 5.0 Preview.
Next, launch Windows PowerShell ISE, and type the following command into the PowerShell console. The installation does not require administrator permission because it installs the apps to your current user profile.
Install-Module ScriptBrowser –Scope CurrentUser
After the installation, you can enable Script Browser / Script Analyzer in the PowerShell ISE by entering the following cmdlets:
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.
This PowerShell script sample shows how to clear the Run box history in Windows.
When we run a application through Win + R, there will be a record in Run box. However if there are too many records, it will be a little terrible. This script is to delete some or all of the records in Run box.
You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery
This PowerShell script sample shows how to change AutoSave interval in Outlook.
Although Outlook by default auto saves emails as you type them every 3 minutes to prevent you from losing work, many people don't know the setting is actually adjustable via UI. This script can easily help user to do it.
This VBScript 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 VBA sample shows how to convert Visio page file to .png file.
This script can be used to detect if the database master key is not encrypted by Service Master Key.
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.