We all know the pressure of being an IT Pro - it is a busy and challenging life!  Late nights, nervous strain, repetitive work, and talking to themselves.  Does this sound familiar to you?

Today Microsoft is announcing All-In-One Script Framework - an IT Pros' Time Saver.   It is a sister project of Microsoft All-In-One Code Framework – Developers' Pain Killer.  We can't guarantee that the late-night work will disappear but we can try our best to save your time!

All-In-One Script Framework is an automation script sample library for IT Professionals.  The key value that All-In-One Script Framework is trying to deliver is Scenario-Focused Script Samples driven by IT Pros' real-world pains and needs.  The team is monitoring all TechNet forums, IT Pros' support calls to Microsoft, and will start to monitor the script requests submitted to TechNet Script Repository soon. We collect frequently asked IT scenarios, and create script samples to automate the tasks and save some time for IT Pros. Samples will illustrate the frequently asked IT scripting scenarios of Microsoft products (Windows Server, Windows Client, SQL Server, Exchange, O365, SharePoint, Lync, Dynamics, IIS, etc) through scripting languages such as PowerShell, VBScript and T-SQL.  The team of All-In-One Script Framework sincerely hope that these customer-driven automation script samples can help our IT community in this script-centric move.  

In three short months,  the team of All-In-One Script Framework has collected over 80 qualified script sample topics from TechNet Forums.  These topics are frequently asked by IT Pros and can be eased with automation scripts.  29 of these script topics have been tuned into actual script samples published on TechNet Script Repository. 

The initial feedback was great! 
"All-In-One Script Framework promises to be an amazing place for IT Pros to get help with their scripting needs for Windows, SharePoint, SQL Server, Exchange, and a growing number of products". – Dan Ruder, Principal Escalation Engineer.

This is just the beginning.  With the next script-centric wave, more and more script samples are coming.  In the following one year, Microsoft will release lots of big products such as Windows 8, Windows Server 2012, the new Office, Exchange Server, SharePoint Server, etc.  The All-In-One Script Framework team has planned 200 script samples, and more surprises, to be shared with our IT Pro community.  

Please spread the word of the new All-In-One Script Framework offering.  Please also keep track of our news and offerings in this portal.  We look forward to hearing from your feedback.

This is the first release of script samples in Microsoft All-In-One Script Framework.  We bring to you two Office 365 automation script samples, three Windows Server / Windows Client scripts, and three Exchange Server 2010 script samples.   All of these scripts are based on frequently asked IT tasks that our team collected in TechNet forums and Microsoft Support Incidents.  Many customers are asking about these scenarios, so we expect that the script samples can save more time for our worldwide IT Pros.

------------------------------------------------------------

New Office 365 Script Samples

Script to Modify Office 365 Mailbox Permissions (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/Script-to-Modify-Office-55e2147e 

Description: This script could be used to modify Office 365 mailbox permissions. You can use this script to add or remove mailbox permissions. This script will try to connect Windows PowerShell to Office 365 automatically if the connection is not established.

User Scenarios: In a real world, IT Administrators may want to modify mailbox permissions due to variety of reasons. If an organization has thousands of mailboxes, it’s impossible to modify permissions for these mailboxes one by one. IT administrators do need a script to complete this task.

Acknowledgement:  Thanks Greg Gu for composing the script.  Thanks Dan Rowley (Microsoft Senior Support Escalation Engineer) for submitting the script topic and reviewing the script sample.

Script to Get Office 365 Mailbox Folder Permissions (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/Script-to-Get-Office-365-60e262dc

Description: This script could be used to get Office 365 mailbox folder permissions. It will try to connect Windows PowerShell to Office 365 automatically if the connection is not established.

User Scenarios: In a real world, IT Administrators may want to get mailbox folder permissions due to variety of reasons. If an organization has thousands of mailboxes, it’s impossible to get permissions from these mailboxes one by one. IT administrators need a script to complete this task.

Acknowledgement:  Thanks Greg Gu for composing the script.  Thanks Dan Rowley (Microsoft Senior Support Escalation Engineer) for submitting the script topic and reviewing the script sample.

------------------------------------------------------------

New Windows Server / Windows Client Script Samples

Find user logon duration (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/Find-user-logon-duration-667b8c48

Description: This script could be used to collect user logon duration from multiple computers. You can also use the data to generate a report. The user logon duration calculation is based on the general algorithm, Logon duration = Logoff date time - Logon date time. This script considers event 4647 as a logoff event and use it for calculating the logon duration.

User Scenarios: In a real world, IT Administrators may need to collect user logon duration from multiple computers. User logon duration data can be useful when IT Administrators are troubleshooting some issues.

Acknowledgement:  Thanks Shuhao Liu for submitting the script idea.  Thanks Greg Gu for composing the script.  Thanks David Everett (Microsoft Senior Support Escalation Engineer) for reviewing the script sample.

Script to fix issues described in KB947222 (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/Script-to-fix-issues-ab9a639d

Description: This Windows PowerShell script will modify the file permission, and fix fix issues described in KB947222.

User Scenarios: When user redirect the Documents folders to network share, the folders name changes back to My Documents as shown in the following figure. This issue can be fixed by denying Read permission to the administrator for the Desktop.ini files on the server. But the customers need to perform steps one by one. It would be great if we have a script to automate this task.

Acknowledgement:  Thanks Shaon Shan for submitting the script idea.  Thanks Anders Wang for composing the script.  Thanks Gary Mudgett (Microsoft Support Escalation Engineer) for reviewing the script sample.

Prepopulate a batch of user passwords to RODC (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/Prepopulate-a-batch-of-34e6d0dc

Description: This Windows PowerShell script will prepopulate a batch of user passwords to a specified Read-only Domain Controller. It will leverage the capability of the native command, repadmin. The script will also strictly check the parameters for avoiding any potential human error.

User Scenarios: Currently, IT Professionals can only prepopulate user password for one account each time.  If IT Professionals have to prepopulate 200 or more user passwords within a very short period of time, the job will turn out to be very stressful and tedious.

Acknowledgement:  Thanks Arthur Li for submitting the script idea.  Thanks Greg Gu for composing the script.  Thanks Justin Turner (Microsoft Senior Support Escalation Engineer) for reviewing the script sample.

------------------------------------------------------------

New Exchange Server Script Samples

Get Mailbox and Mailbox Database Statistics in Microsoft Exchange 2010 (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/Get-Mailbox-and-Mailbox-96915f45

Description: This script could be used to get mailbox and mailbox database statistics in Microsoft Exchange 2010. You can use this script to get different properties based on your needs.

User Scenarios:  In a real world, IT administrators may want to get mailbox and mailbox database statistics for their production environment. In this way, they can closely monitor mailbox size growth and the database growth. They can also use this script for change verification after modifying some properties of mailboxes and mailbox databases.

Acknowledgement:  Thanks Zifeng Wang for submitting the script idea.  Thanks Greg Gu for composing the script.  Thanks Mike Hendrickson (Microsoft Senior Escalation Engineer) for reviewing the script sample.

Send Welcome Mail to Each Newly Created Mailbox in Microsoft Exchange 2010 (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/Send-Welcome-Mail-to-Each-4fff4a93

Description: This script could be used to send welcome mail for each newly created mailbox in Microsoft Exchange 2010. This script allows you to use an .html file as a template. You can use placeholders in this template file. This script allows you to replace these placeholders when the script is being executed.

User Scenarios:  In a real world, IT administrators are always required by human resource department to send welcome mail to each new employee. A welcome mail to a new employee who has accepted your job offer confirms the employee's decision to accept the position. It will save the new employee some feelings of insecurity and avoids misunderstandings.

Acknowledgement:  Thanks Tiger Li for submitting the script idea.  Thanks Greg Gu for composing the script.  Thanks Mike Hendrickson (Microsoft Senior Escalation Engineer) for reviewing the script sample.

Collect Event Logs from Microsoft Exchange 2010 Servers (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/Collect-Event-Logs-from-99633908

Description: This script could be used to collect warning and error events which generated by Microsoft Exchange Server 2010. You can collect these events by Exchange server role.

User Scenarios:  In a real world, IT Administrators need to collect warning and error events for troubleshooting and monitoring the health of Microsoft Exchange 2010. It will be a time-consuming task in a large scale deployment.

Acknowledgement:  Thanks Tiger Li for submitting the script idea.  Thanks Greg Gu for composing the script.  Thanks Mike Hendrickson (Microsoft Senior Escalation Engineer) for reviewing the script sample.

We look forward to learning your feedback and serving you better.  If you have any suggestions, please email All-In-One Script Framework: onescript@microsoft.com.

Microsoft All-In-One Script Framework is updated today with 10 new script samples.   These new script samples cover Office and SharePoint. All of these scripts are written for solving frequently asked IT tasks that our team observed in TechNet forums and Microsoft Support Incidents.  Many customers are asking about these IT scenarios, so we expect that the script samples can save some time for IT Pros.

------------------------------------------------------------

New Office Script Samples

Save attachments from multiple selected items in Outlook (VBA)

http://gallery.technet.microsoft.com/scriptcenter/Save-attachments-from-5b6bf54b

Description: This VBA sample illustrates how to save attachments from multiple selected items in Outlook.

User Scenarios: When multiple items are selected, the Save Attachments option in the File menu will be grayed out, and it's inconvenient to save attachments one by one. This script is useful and can be used to save attachments from multiple selected items all at once.

Acknowledgement: Thanks Zhiliang Zhou for collecting the script topic.  Thanks Cristin Yan for composing the script sample.   Thanks  Pranav Wagh (Microsoft Support Escalation Engineer) for reviewing it and ensuring the quality.

Convert PowerPoint Presentation to Word Document (VBA)

http://gallery.technet.microsoft.com/scriptcenter/Convert-PowerPoint-c3a26165

Description: This VBA sample illustrates how to convert PowerPoint presentations to Word documents, in the meantime, it will try to keep the original format and layout and reduce the output file size. It can be only run on PowerPoint 2010.

User Scenarios: Converting PowerPoint presentations to Word documents is a frequently asked question by end-users in many public forums. Although there are similar methods available from built-in feature or 3rd-party applications, but most of them have evident disadvantage, some of them make large file size, some of them break or lose the format or layout.

Acknowledgement: Thanks Zhiliang Zhou for collecting the script topic.  Thanks Cristin Yan for composing the script sample.   Thanks  Shiv Khare (Microsoft Tech Lead) for reviewing it.

Remove or Change Password for Multiple PowerPoint Presentations (VBA)

http://gallery.technet.microsoft.com/scriptcenter/Remove-or-Change-Password-0efd9823

Description: This VBA sample illustrates how to convert PowerPoint presentations to Word documents, in the meantime, it will try to keep the original format and layout and reduce the output file size. It can be only run on PowerPoint 2010.

User Scenarios: Converting PowerPoint presentations to Word documents is a frequently asked question by end-users in many public forums. Although there are similar methods available from built-in feature or 3rd-party applications, but most of them have evident disadvantage, some of them make large file size, some of them break or lose the format or layout.

Acknowledgement: Thanks Zhiliang Zhou for collecting the script topic.  Thanks Cristin Yan for composing the script sample.   Thanks  Shiv Khare (Microsoft Tech Lead) for reviewing it.

Import Multiple Tables from Access to Excel (VBA)

http://gallery.technet.microsoft.com/scriptcenter/Import-Multiple-Tables-ad78b80f

Description: This VBA sample illustrates how to import multiple Access tables to Excel worksheets at once, meanwhile each worksheet‘s name will correspond to each table's name. It can be run on Excel 2003, 2007 and 2010.

User Scenarios: Users would like to import Access tables to Excel worksheets, meanwhile each worksheet's name will correspond to each table's name.

Acknowledgement: Thanks Cristin Yan for collecting the script topic and composing the script sample.  Thanks Shiv Khare (Microsoft Tech Lead) for reviewing it.

Remove Notes Pages in PowerPoint (VBA)

http://gallery.technet.microsoft.com/scriptcenter/Remove-Notes-Pages-in-9cd979c7

Description: This VBA demo illustrates how to remove notes pages in PowerPoint 2007 and the later version.

User Scenarios: Removing notes pages in PowerPoint is a frequently asked question by users in the Answers forums. For example, 1) remove slide numbers from PowerPoint notes pages using VBA  2) VBA shut off for PowerPoint 2007 Notes Page Header.  

Acknowledgement: Thanks Cristin Yan for collecting the script topic and composing the script sample.  Thanks Shiv Khare (Microsoft Tech Lead) for reviewing it.

------------------------------------------------------------

New SharePoint Script Samples

Retrieve SharePoint list data (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/Retrieve-SharePoint-list-8e7fb421

Description: This script demonstrates how to retrieve Microsoft SharePoint list data by Windows PowerShell and Microsoft SharePoint PowerShell snapin.

User Scenarios: Retrieve list data is a regular but important task for SharePoint content management. From the related cases, we could see that there are requirements from the IT administrators. There are some scripts in Internet, but all of them just focus on one section (e.g. retrieve all the list items), and also hard to read due to lack of explanations.

Acknowledgement: Thanks Simon Huang for collecting the script topic.  Thanks Greg Gu for composing the script.  Thanks Sojesh Sreelayam (Microsoft Support Escalation Engineer) for reviewing the script sample.

SharePoint List Enumerator (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/SPListEnumerator-PowerShell-b0ce0b9f

Description: This script enumerates through a "large" list or document library and provides information about items in it.

User Scenarios: In SharePoint (2007 and 2010) we have a threshold on the number of list items in a container. In SharePoint 2007, the threshold value is 2,000 and in SharePoint 2010, it is 5,000. We often come across customers who have a large number of items in their lists/document libraries and complain of overall site performance. It is possible for customers to create nested folders and have a large number of documents/list items reside in them. But exceeding the threshold value can cause slowness and have a performance impact on the backend SQL content database.  This script traverses through each folder in a given list/document library and will enumerate items at each container level. It writes the output to a .CSV file to make it easier for viewing in Excel and perform further filtering.

Acknowledgement: Thanks J Vijay William (Microsoft Support Escalation Engineer) for collecting the script topic and composing the script sample.

Reset the User Profile Synchronization Service in SharePoint (PowerShell)

http://gallery.technet.microsoft.com/scriptcenter/Reset-the-User-Profile-cebcdee1

Description: This script will help IT administrator to reset the User Profile Synchronization Service in Microsoft SharePoint Server 2010.

User Scenarios: The User Profile Synchronization service interacts with Microsoft Forefront Identity Manager (FIM) to synchronize profile information with external systems such as directory services and business systems. The two FIM services, Forefront Identity Manager Service and Forefront Identity Manager Synchronization Service, are provisioned when you start the User Profile Synchronization service. Being unable to start the User Profile Synchronization service is the most common profile synchronization (profile sync) issue that administrators encounter. The farm account is used to start the User Profile Synchronization service. If you have configured a wrong service account, User Profile Synchronization Service won’t be started. This script could be used to reset the User Profile Synchronization service and its service account.

Acknowledgement: Thanks Anders Wang for collecting the script topic.  Thanks Greg Gu for composing the script sample.   Thanks Sojesh Sreelayam (Microsoft Support Escalation Engineer) for reviewing it before publishing.

Add attachments for a specific list item in Microsoft SharePoint Server 2010

http://gallery.technet.microsoft.com/scriptcenter/Add-attachments-for-a-1e931663

Description:  This script could be used to add attachments for a specific list item in Microsoft SharePoint Server 2010.

User Scenarios: In a real world, IT Administrators may need to add attachments for a specific list item. It will be a heavy task if we do it manually, so the IT Administrators need a script to complete this task.

Acknowledgement: Thanks Wenxuan Fan for collecting the script topic.  Thanks Greg Gu for composing the script sample.   Thanks Nishand Vasudevan (Microsoft Escalation Engineer) for reviewing it.

Add Allowed Inline Downloaded MIME Types for one Web Application in SharePoint

http://gallery.technet.microsoft.com/scriptcenter/Add-Allowed-Inline-1ae367ae

Description:  This script could be used to add allowed inline downloaded MIME types for one Web Application in Microsoft SharePoint Server 2010.

User Scenarios: By default PDF files cannot open in browser. It is not listed as a safe MIME type. But for most companies, PDF files are widely used in their daily work, so it is necessary to add PDF to the allowed inline downloaded MIME types list.

Acknowledgement: Thanks Wenxuan Fan for collecting the script topic.  Thanks Greg Gu for composing the script sample.   Thanks Sojesh Sreelayam (Microsoft Support Escalation Engineer) for reviewing it.

We look forward to learning your feedback and serving you better.  If you have any suggestions, please email All-In-One Script Framework: onescript@microsoft.com.

We observed some confusion about the relationship between TechNet Script Repository and All-In-One Script Framework.   TechNet Script Repository is a great platform for sharing, finding, and downloading script samples.   All-In-One Script Framework (AIOSF) is focused on creating script samples.  The script samples created by All-In-One Script Framework are eventually published on TechNet Script Repository. 

The key value that All-In-One Script Framework is trying to deliver is Scenario-Focused Script Samples driven by IT Pros' real-world pains and needs.   The team of AIOSF is monitoring all TechNet forums, and collecting frequently asked IT scenarios.  For example, if more than three forum threads are asking about the same IT task, we will regard it as an IT Pros’ pain point, and consider creating a script sample to automate the task and save IT Pros' time.   We are also monitoring all IT Pros' support calls to Microsoft, and will start to monitor the script requests submitted to TechNet Script Repository.  Therefore, the source of script topics in All-In-One Script Framework is different from the tradition.   There is customer evidence behind every script published in AIOSF.   All our effort is to deliver script samples that can better align with and meet IT Pros' real-world needs.

All-In-One Script Framework is actually a new sister project of All-In-One Code Framework (AIOCF) in the developer area.  In 2009, we started AIOCF for the developer community.  Today, AIOCF has over 1000 customer-driven code samples, 6 million downloads and lots of customer kudos.  We see that customers love the customer-driven content that can address their real-world needs.  The team started to expand the audience from developers to IT Pros, and thus All-In-One Script Framework was born.

All-In-One Script Framework is a joint effort across many Microsoft teams.  We work together to triage script ideas, compose script samples, test and review samples based on a streamlined process.  We also hope to have deeper engagements with communities and MVPs to collect script topics, vote for existing script topics, and raise the quality of scripts to a new level.

Dear community, we hope to learn from you how you think about the value of this project effort.  The team of All-In-One Script Framework sincerely hope that these customer-driven automation script samples can help our IT community.

Thank you and have a nice day!

You can stay up to date on the latest news, service offering, and script samples via our Facebook and Twitter pages.   You can also post your needs and questions to the product team of All-In-One Script Framework and interact with other followers.

http://www.facebook.com/groups/maiosf

http://twitter.com/AIOSF