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 have released 130 script samples since we released the 100th sample last month! Our sample repository is growing quickly every month. The team closely monitors the entire TechNet forum platform, and customers’ support calls to Microsoft, and create automation script to ease those frequently asked IT tasks. We wish that the samples will save your time.
In this blog, we introduce 11 new samples, including 4 Windows 8 script samples; 7 Office 365 scripts sample. The scripts are written for solving frequently asked IT tasks that our team observed in the TechNet forums and Microsoft Support Incidents. Many customers are asking about these IT scenarios.
Script to create a custom Refresh Image in Windows 8
Download: SetRefreshImage.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Script-to-create-a-custom-a6e8b4e8
Description: This PowerShell Script shows how to create custom refresh image.
User Scenarios: Windows refresh feature doesn’t allow you to create custom refresh points like Windows System Restore does. Instead, Refresh creates a Windows Installer Image to help it restore settings to default state. This script can do it.
Acknowledgement: Thanks Anders Wang (one of the PowerShell MVPs in All-In-One Script Framework Team) for the script idea and composing the script sample.
Change the Number of Tile Rows on the Start screen in Windows 8 (VBScript)
Download: ChangeNumberOfAppsTileRows (VBScript).zip Details: http://gallery.technet.microsoft.com/scriptcenter/Change-the-Number-of-Tile-cd9bcc1a
Description: This VBScript shows how to change the number of tile rows on the Start screen in Windows 8.
User Scenarios: By default, the number of rows for the tiles is fully dependent on the screen resolution or window size that fits on your Windows Screen. But sometimes the user wants to display a specific number of rows of tiles on the Start Screen that is not dependent on the screen size.
Acknowledgement: Thanks Anders Wang (PowerShell MVP) for the script idea and composing the script sample.
Delete invalid shortcut on the Start screen in Windows 8 (VBScript)
Download: RemoveInvaildShortcutOnStartScreen(VBScript).zip Details: http://gallery.technet.microsoft.com/scriptcenter/Delete-invalid-apps-bfb4b0c3
Description: This VBS Script shows how to remove invalid shortcut on the Start screen.
User Scenarios: Sometimes when you uninstall software on your computer, even though the software is uninstalled successfully, it leaves some shortcuts that were created behind in your computer. These shortcuts do not work as the related softwares are uninstalled. Perhaps you move a file or a folder to a different location, the shortcut to that file or folder becomes invalid as it still points to the earlier location.
Acknowledgement: Thanks Chao Ma for the script idea and composing the script sample.
Change background color of Windows 8 Start screen (VBScript)
Download: ChangeWin8StartScreenBackColor.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Change-background-color-of-f70f4c41
Description: This sample shows how to change background color of a Windows 8 Start screen by using VBScript. User Scenarios: IT administrators can use this script to adjust the background color of a Windows 8 Start screen for a group of computers to keep user experience consistent.
Description: This sample shows how to change background color of a Windows 8 Start screen by using VBScript.
User Scenarios: IT administrators can use this script to adjust the background color of a Windows 8 Start screen for a group of computers to keep user experience consistent.
Acknowledgement: Thanks Huilin Zhu for collecting the script topic from frequently asked questions in TechNet Windows 8 forums. Zhi-Yi Guo wrote the script sample and Alan Olegario (PFE) reviewed it.
Send Emails until a Designated Time in Office 365 Exchange Online
Download: SendOSCEXOMailMessage.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Send-Emails-until-a-9cee20cf
Description: This script can send an email message with Office 365 Exchange Online. Also this script allows you to delay sending an email message. User Scenarios: Microsoft Outlook has a feature that enables you to delay sending email messages. However, this feature is not available in the Outlook Web App (OWA). Therefore, in order to delay sending email messages for some business needs, you must find a workaround.
Description: This script can send an email message with Office 365 Exchange Online. Also this script allows you to delay sending an email message.
User Scenarios: Microsoft Outlook has a feature that enables you to delay sending email messages. However, this feature is not available in the Outlook Web App (OWA). Therefore, in order to delay sending email messages for some business needs, you must find a workaround.
Acknowledgement: Thanks Greg Gu (one of the PowerShell MVPs in All-In-One Script Framework) for the script idea and composing the script sample.
Export Email Messages from OWA in Office 365 Exchange Online
Download: ExportOSCEXOEmailMessage.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Export-Email-Messages-from-1419bbe9
Description: This script can export email messages from Outlook Web App to a specific folder. These email messages will be saved in .eml format. You need to find the email messages by using search folder. User Scenarios: Microsoft Outlook allows you to export email messages very easily. However, this feature is not available in the Outlook Web App (OWA). Therefore, in order to export email messages from OWA, you must find a workaround.
Description: This script can export email messages from Outlook Web App to a specific folder. These email messages will be saved in .eml format. You need to find the email messages by using search folder.
User Scenarios: Microsoft Outlook allows you to export email messages very easily. However, this feature is not available in the Outlook Web App (OWA). Therefore, in order to export email messages from OWA, you must find a workaround.
Set Email Signatures in Office 365 Exchange Online
Download: SetOSCEXOEmailSignature.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Set-Email-Signatures-in-792587f5
Description: This script can set email signatures in Office 365 Exchange Online. You can change text signature and HTML signature. User Scenarios: Microsoft Outlook enables you to change email signatures very easily. However, this feature is difficult to use in Outlook Web App (OWA). For example, it may be difficult to insert images as signatures. Therefore, in order to set email signatures in OWA, you must find a workaround.
Description: This script can set email signatures in Office 365 Exchange Online. You can change text signature and HTML signature.
User Scenarios: Microsoft Outlook enables you to change email signatures very easily. However, this feature is difficult to use in Outlook Web App (OWA). For example, it may be difficult to insert images as signatures. Therefore, in order to set email signatures in OWA, you must find a workaround.
Acknowledgement: Thanks Greg Gu for the script idea and composing the script sample.
Connect to Office 365 Exchange Online with Prerequisites Verification
Download: ConnectOffice365.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Connect-to-Office-365-dd471880
Description: This script establishes a connection to Office 365 Exchange Online. Before establishing a connection, it checks the prerequisites that required by Office 365 Exchange Online. User Scenarios: Nowadays, Office 365 administrators are required to remember a long command to establish a connection to Office 365 Exchange Online. It’s not easy to remember all the parameters clearly. It’s better to save that command in a Windows PowerShell script. Additionally, it’s worth to check all the prerequisites to help Office 365 administrators to troubleshoot the connection issues.
Description: This script establishes a connection to Office 365 Exchange Online. Before establishing a connection, it checks the prerequisites that required by Office 365 Exchange Online.
User Scenarios: Nowadays, Office 365 administrators are required to remember a long command to establish a connection to Office 365 Exchange Online. It’s not easy to remember all the parameters clearly. It’s better to save that command in a Windows PowerShell script. Additionally, it’s worth to check all the prerequisites to help Office 365 administrators to troubleshoot the connection issues.
Set Calendar Permission in Office 365 Exchange Online
Download: SetOSCEXOCalendarFolderPermission.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Set-Calendar-Permission-in-ad7cd4e6
Description: This script can set calendar permission in Office 365 Exchange Online. You can set permission, grant permission and revoke permission on one or multiple calendar folders by using this script. User Scenarios: Currently, Add-MailboxFolderPermission only accepts single ID as the value of Identity parameter. It requires user to provide a full folder path, for example, "userid\Calendar\Calendar 01". It's inconvenient if you want to set permission on two or more calendar folders. Acknowledgement: Thanks Greg Gu for the script idea and composing the script sample.
Description: This script can set calendar permission in Office 365 Exchange Online. You can set permission, grant permission and revoke permission on one or multiple calendar folders by using this script.
User Scenarios: Currently, Add-MailboxFolderPermission only accepts single ID as the value of Identity parameter. It requires user to provide a full folder path, for example, "userid\Calendar\Calendar 01". It's inconvenient if you want to set permission on two or more calendar folders.
Retrieve Mailbox Folder and Subfolder Size in Office 365 Exchange Online
Download: GetOSCEXOMailboxFolderSize.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Retrieve-Mailbox-Folder-227e7566
Description: This script can retrieve mailbox folder and subfolder size in Office 365 Exchange Online. User Scenarios: Most of you manage your mailbox by using folders. These folders are named with year or other name conventions. When the mailbox is almost full, you will try to archive or delete old email messages. But you found that it’s inconvenient to check the size of each folder in Outlook Web App (OWA). So you are trying to find a workaround to mitigate this problem. Although, Office 365 administrators can use Get-MailboxFolderStatistics to help helpdesks to check the folder size. It's better to provide a script to reduce the support calls to these administrators in one company. Acknowledgement: Thanks Greg Gu for the script idea and composing the script sample.
Description: This script can retrieve mailbox folder and subfolder size in Office 365 Exchange Online.
User Scenarios:
Most of you manage your mailbox by using folders. These folders are named with year or other name conventions. When the mailbox is almost full, you will try to archive or delete old email messages. But you found that it’s inconvenient to check the size of each folder in Outlook Web App (OWA). So you are trying to find a workaround to mitigate this problem.
Although, Office 365 administrators can use Get-MailboxFolderStatistics to help helpdesks to check the folder size. It's better to provide a script to reduce the support calls to these administrators in one company.
Bulk import the user information from CSV file
Download: ImportUsersFromCSVFile.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Bulk-import-the-user-568abc5f
Description: This script can be used by an Office365 administrator to batch add user information from a CSV file. User Scenarios: Sometimes an Office365 administrator must add many users to Microsoft Office365. For example, when an organization first uses Office365, they must import all members to the system. Acknowledgement: Thanks Tony Zhang for the script idea and composing the script sample. Thank Mauricio Tamayo Ortega (Senior Consultant at Microsoft) for reviewing the script sample.
Description: This script can be used by an Office365 administrator to batch add user information from a CSV file.
User Scenarios: Sometimes an Office365 administrator must add many users to Microsoft Office365. For example, when an organization first uses Office365, they must import all members to the system.
Acknowledgement: Thanks Tony Zhang for the script idea and composing the script sample. Thank Mauricio Tamayo Ortega (Senior Consultant at Microsoft) for reviewing the script sample.
Happy New Year! Thank you for all your support since All-In-One Script Framework was born five months ago. What a great year of 2012! So many things have happened. We gave birth to this customer-driven script sample library on August 1st – the date when Windows 8 was RTM-ed. Global PowerShell MVPs and the community gave lots of suggestions to change us for the better. With your love and support, we have released 124 automation script samples to the TechNet Script Center, with the focus on Windows 8, Windows Server 2012, Office 365, and Office 2013. There is customer evidence behind every script sample that was published. Luckily, these scripts received 300,000 reads in five months. Two of the Windows 8 script samples seem getting really popular. “Script to Create a Shutdown/Restart/Logoff Windows 8 Tile for the Start menu (PowerShell)” is ranking the 1st among 7000+ scripts in TechNet, and “Remove Windows Store apps in Windows 8” is ranking the 2nd. The team is very thankful to the IT community, so they prepared a New Year gift (actually 2 New Year gifts, but today, we announce the first one)!
As an IT Pro, there is no gift better than useful automation scripts that can save time, ease the work and free the hassle in the New Year! The All-In-One Script Framework team worked over-time during the holiday season, and presents to you 20 NEW Windows 8 script samples, 10 NEW Office 365 script samples and 13 new Office 2013 samples!
We are looking forward to the New Year and the many coming new experiences and growths. In our internal pipeline, we have another 150+ script ideas in triage and 150+ script samples under construction. The pool is growing quickly every month. In 2013, the team will announce many new services and offerings to save IT Pros’ time. Let’s look forward to another exciting year of 2013!
Cheers and Happy New Year
- All-In-One Script Framework Team
Here are two really popular Windows 8 script samples from Microsoft All-In-One Script Framework. One of them is ranking the 1st among all 7000+ script samples on TechNet Script Center based on popularity. The other one is ranking the 4th. The All-In-One Script Framework writes these script samples because their topics are frequently asked in TechNet forums. Many IT Pros are asking about them. Script sample videos are also available to give you a visual demonstration.
Create a Shutdown/Restart/Logoff Windows 8 Tile for the Start menu (PowerShell)
This is currently the No.1 script on TechNet Script Center. This PowerShell script shows how to create a Shutdown, Restart or Logoff Windows 8 tile for the Start menu.
\
Remove Windows Store apps in Windows 8
This script can be used to remove multiple Windows Store apps from a user account in Windows 8. It provides a list of installed Windows Store apps. You can specify the application IDs, and remove them all at once.
Since we launched Windows 8 How-do-I script sample videos last month, the 3 Win8 videos in the first release have been watched for over 30,000 times! We heard your voice that you want more videos to demonstrate how to use script samples to automate IT tasks. The All-In-One Script Framework team is committed to this. Together with DPE, we now provide you with 2 fresh videos. You get a front line seat to all of our latest Windows 8 script samples with demo videos.
How to Create a Shutdown tile on the Start screen in Windows 8
Script download: http://gallery.technet.microsoft.com/scriptcenter/Create-a-ShutdownRestartLog-37c8111d
How to Batch Rename Virtual Machines in Windows Server 2012
Script download: http://gallery.technet.microsoft.com/scriptcenter/How-to-batch-rename-f3980e1d
More and more Windows 8 script samples and demo videos are coming. We are looking forward to hearing your feedback.
We have released 100 script samples! There is customer evidence behind every script sample. The team closely monitors the entire TechNet forum platform, and customers’ support calls to Microsoft, and create automation script to ease those frequently asked IT tasks. We wish that the samples will save your time.
Today, Microsoft All-In-One Script Framework is updated with over 30 new script samples. In this blog, we introduce 14 of them, including 3 Windows 8 script samples; 1 Windows Server 2012 sample, 2 Office 365 ones, 1 Lync sample, 3 Office samples, and 4 SharePoint scripts. The scripts are written for solving frequently asked IT tasks that our team observed in the TechNet forums and Microsoft Support Incidents. Many customers are asking about these IT scenarios.
Download: CreateWindowsTile.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Create-a-ShutdownRestartLog-37c8111d
This script sample has been the most popular script on TechNet Script Repository.
Description: This PowerShell script shows how to create a Shutdown, Restart or Logoff Windows 8 tile for the Start menu.
User Scenarios: In Windows 8, without a Start button, properly shutting down or rebooting Windows can be a bit of a chore. Many users want to shut down or reboot Windows in just one click. This script enables users to click on a tile to shut down, reboot or log off Windows on the Start menu.
Acknowledgement: Thanks Anders Wang for the script idea and composing the script sample. Thanks Nishant Kumar Singh for reviewing the sample to ensure its quality.
Script to create a Windows 8 Switch User Tile for the Start menu (PowerShell)
Download: CreateSwitchUserWindowsTile.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Script-to-create-a-Windows-2b03ac8c
Description: This PowerShell Script shows how to create a Windows 8 Switch User tile for the Start menu.
User Scenarios: Properly switching users in Windows 8 without a Start button can be a bit of a chore. Many users may want to switch users in just one click. This script enables users to click a tile to switch user on the Start menu.
Acknowledgement: Thanks Anders Wang for the script idea and composing the script sample.
Script to create a Windows 8 Hibernation Tile for the Start menu (PowerShell)
Download: CreateHibernationWindowsTile.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Script-to-create-a-ce24bd63
Description: This PowerShell Script shows how to create a Windows 8 Hibernation tile for the Start menu.
User Scenarios: Properly hibernating Windows 8 without a Start button can be a bit of a chore. Many users may want to hibernate Windows in just one click. This script enables users to click a tile to hibernate Windows on the Start menu.
Switch between Server Core to Server GUI in Windows Server 2012
Download: SwitchGUIServerCORE.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Switch-between-Windows-9680265d
Description: This script sample can be used to switch a full installation of a Server Graphic User Interface (GUI) mode to Server Core mode in Windows Server 2012. Additionally, this script enables you to convert Server Core mode to Server GUI mode.
User Scenarios: After you setup Windows Server 2012, IT administrators may have to convert Server 2012 to Server Core mode for some security reasons. Also, it is more convenient for administrators to change some configurations when using GUI mode. To perform this action, use the following script sample.
Acknowledgement: Thanks Edward Qi for collecting the script idea and composing the script sample. Thanks Christopher Norris for ensuring its quality.
Configuring a Windows PowerShell Profile for Office 365 Exchange Online
Download: SetOffice365PowerShellProfile .zip Details: http://gallery.technet.microsoft.com/scriptcenter/Configuring-a-Windows-faecf7cb
Description: This script can configure a Windows PowerShell profile for Office 365 Exchange Online. It appends the Connect-OSCExchangeOnline and Disconnect-OSCExchangeOnline functions to your Windows PowerShell profile. Afterward, you can use these two functions directly without remembering New-PSSession and its parameters.
User Scenarios: Currently, Office 365 Exchange Online administrators use the New-PSSession function to connect Windows PowerShell to Office 365. Some administrators feel that it is difficult to remember all the parameters clearly. It is better to use a Windows PowerShell profile to store the two functions and help administrators use Office 365 more easily.
Acknowledgement: Thanks Dan Rowley for submitting the script idea and ensuring the script quality. Thanks Greg Gu for composing the script sample.
Add Birthday or Anniversary Reminders in Office 365 Exchange Online
Download: AddOSCEXOAppointment.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Add-Birthday-or-Anniversary-e111b73d
Description: This script creates birthday or anniversary reminders for your contacts. This script also enables you to import a comma-separated values (CSV) file for creating the reminders. Additionally, you can use this script to search a contact folder to find contacts that have birthdays and anniversaries, and then create the reminders.
User Scenarios: Microsoft Outlook has a feature that enables you to “Add a birthday or anniversary for a contact.” However, this feature is not available in the Outlook Web App (OWA). Therefore, in order to add birthday or anniversary reminders in OWA, you must find a workaround.
Acknowledgement: Thanks Greg Gu for submitting the script idea, and composing the sample. Thanks David Los (PM from Exchange Online) for ensuring its quality.
Find Users with Specific Features Enabled in Microsoft Lync Server 2010
Download: SearchOSCCSUser.zip Details: http://gallery.technet.microsoft.com/scriptcenter/ScriptFind-Users-with-fa3d97ea
Description: This script finds users with specific features enabled in Microsoft Lync Server 2010. Features of following policies which defined in user scope are supported by this script. Voice Policy Conferencing Policy Pin Policy ExternalAccess Policy Location Policy Client Policy ClientVersion Policy Presence Policy Mobility Policy Archiving Policy
Description: This script finds users with specific features enabled in Microsoft Lync Server 2010. Features of following policies which defined in user scope are supported by this script.
User Scenarios: Microsoft Lync Server 2010 provides a lot of policies to allow IT administrators to control the features which could be used by end users. Currently, if administrators want to know the list of users who are allowed to use some features, they have to find these policies by using Where-Object cmdlet first. After that they need to prepare a filter script manually by using the policy names. It’s a time consuming job if there are a lot of policies in the organization. Also some administrators want to maintain this kind of list for compliance purpose.
Acknowledgement: Thanks Kelly Huang for submitting the script idea. Thanks Greg Gu for writing the script sample. Thanks Christopher Tart for reviewing it and ensuring its quality.
Remove Notes Pages in PowerPoint (PowerShell)
Download: RemoveNotesInPowerPoint.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Remove-Notes-Pages-in-e5d722da
Description: This PowerShell script will remove all the notes pages form specified PowerPoint files. User Scenarios: In PowerPoint, people often use the notes function to record additional information. When these documents are shared, you may want to remove notes before sharing the document. Instead of removing the notes one by one, you can remove all the notes using the script.
Description: This PowerShell script will remove all the notes pages form specified PowerPoint files.
User Scenarios: In PowerPoint, people often use the notes function to record additional information. When these documents are shared, you may want to remove notes before sharing the document. Instead of removing the notes one by one, you can remove all the notes using the script.
Acknowledgement: Thanks Cristin Yan for submitting the script topic. Thanks Anders Wang for composing the sample. Thanks Shiv Khare for sharing his expertise to review it before the sample is published.
Convert PowerPoint Presentation to Word Document (PowerShell)
Download: ConvertPowerPointToWordDocument.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Convert-PowerPoint-d65f3a82
Description: This PowerShell script sample illustrates how to convert PowerPoint presentations to Word documents. Additionally, script will maintain the original format, layout for presentation and reduce the output file size. Supported version is PowerPoint 2010. User Scenarios: Converting PowerPoint presentations to Word documents is a frequently asked question in many public forums.
Description: This PowerShell script sample illustrates how to convert PowerPoint presentations to Word documents. Additionally, script will maintain the original format, layout for presentation and reduce the output file size. Supported version is PowerPoint 2010.
User Scenarios: Converting PowerPoint presentations to Word documents is a frequently asked question in many public forums.
Acknowledgement: Thanks Zhiliang Zhou for collecting the script idea. Thanks Pranav Wagh for sharing his expertise in Office to ensure the sample quality. Thanks Anders Wang for writing the sample.
Modify Picture Compression Resolution Settings in PowerPoint 2007 (PowerShell)
Download: ModifyPictureCompressionResolutionSetting.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Modify-Picture-Compression-e669d72e
Description: This PowerShell script demo illustrates how to modify picture compression resolution settings in PowerPoint 2007. User Scenarios: This question is asked by users in the TechNet forum. They just want to pre-configure picture compression in PowerPoint 2007.
Description: This PowerShell script demo illustrates how to modify picture compression resolution settings in PowerPoint 2007.
User Scenarios: This question is asked by users in the TechNet forum. They just want to pre-configure picture compression in PowerPoint 2007.
Acknowledgement: Thanks Zhiliang Zhou for the script idea. Thanks Anders Wang for writing the sample. Thanks Pranav Wagh for ensuring its quality.
Manage Managed Metadata Terms in Microsoft SharePoint Server 2010
Download: ManageTaxonomy.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Manage-Managed-Metadata-9c42efef
Description: This script can manage managed metadata terms in Microsoft SharePoint Server 2010. You can use this script to get terms, add terms or remove terms. User Scenarios: In a real world, a lot of people ask the possibility of managing managed metadata terms by using Windows PowerShell. Since administrators need to manage lot of terms, they really need to find a script to reduce their workload.
Description: This script can manage managed metadata terms in Microsoft SharePoint Server 2010. You can use this script to get terms, add terms or remove terms.
User Scenarios: In a real world, a lot of people ask the possibility of managing managed metadata terms by using Windows PowerShell. Since administrators need to manage lot of terms, they really need to find a script to reduce their workload.
Acknowledgement: Thanks Simon Huang for the script idea. Thanks Greg Gu for writing the sample. Thanks Stephen Woodard for review it.
Start a SharePoint Designer Workflow on Multiple List Items
Download: StartWorkflow.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Start-a-Workflow-on-120bffe5
Description: This script can start a SharePoint Designer workflow on Multiple List Items in Microsoft SharePoint Server 2010. User Scenarios: In a real world, you may need to start a workflow on multiple list items. It will be a heavy task if you do it manually, so you are looking for a script to complete this task.
Description: This script can start a SharePoint Designer workflow on Multiple List Items in Microsoft SharePoint Server 2010.
User Scenarios: In a real world, you may need to start a workflow on multiple list items. It will be a heavy task if you do it manually, so you are looking for a script to complete this task.
List Unused Content Databases using PowerShell
Download: ListUnusedContentDatabases.zip Details: http://gallery.technet.microsoft.com/scriptcenter/List-Unused-Content-c078e894
Description: This script can be used to list your unused SharePoint content databases. It can also be used to list used content databases or all content databases. User Scenarios: By default, we can use Get-SPContentDatabase to retrieve SharePoint content databases. But this can only list the database that’s status is Ready. The content database cannot be listed if its status is Offline.
Description: This script can be used to list your unused SharePoint content databases. It can also be used to list used content databases or all content databases.
User Scenarios: By default, we can use Get-SPContentDatabase to retrieve SharePoint content databases. But this can only list the database that’s status is Ready. The content database cannot be listed if its status is Offline.
Acknowledgement: Thanks Wenxuan Fan for the script idea. Thanks Bing Zhao for writing the sample. Thanks Sojesh Sreelayam for review it.
Set User Profile Picture in Microsoft SharePoint Server 2010
Download: SetOSCSPUserPicture.zip Details: http://gallery.technet.microsoft.com/scriptcenter/Set-User-Profile-Picture-1cdbe171
Description: This script changes user profile picture in Microsoft SharePoint Server 2010. It finds user profile pictures from specified picture library. After finding the pictures, it uses User Profile Manager to change PictureUrl property for each user who has user profile. User Scenarios: Under some circumstances, administrators may manage user pictures manually without enabling User Profile Synchronization Service. It indicates that the pictures will not be imported from external systems. They need to find a way to help HR specialist to import user profile picture for each user.
Description: This script changes user profile picture in Microsoft SharePoint Server 2010. It finds user profile pictures from specified picture library. After finding the pictures, it uses User Profile Manager to change PictureUrl property for each user who has user profile.
User Scenarios: Under some circumstances, administrators may manage user pictures manually without enabling User Profile Synchronization Service. It indicates that the pictures will not be imported from external systems. They need to find a way to help HR specialist to import user profile picture for each user.
Acknowledgement: Thanks Wenxuan Fan for the script idea. Thanks Greg Gu for writing the sample. Thanks Shaleen Thapa for review it.
Script of the Day
Script Download: The script is available for download from https://gallery.technet.microsoft.com//How-to-retrieve-all-the-cc002c3c. 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 help us get the codes of stored procedures in a specified database.
A lot of people asked for methods to get the codes of stored procedures in a specified database. Some people want to save the codes so that they can run these codes in other databases.
You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery
Script Download: The script is available for download from https://gallery.technet.microsoft.com//How-to-set-default-printer-00dbc561. 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 VBScript shows how to set default printer in Windows.
In real world, we usually have multiple printers in our company environment. IT admins want to user regularly use specified printer, they have to let user to pick one as default printer.
Script Download: The script is available for download from https://gallery.technet.microsoft.com//How-to-set-default-printer-cf89670b. 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 set default printer in Windows.
Script Download: The script is available for download from https://gallery.technet.microsoft.com//How-to-Restrict-mobile-9cf1d440. 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 restrict mobile attachments to view only in Exchange Online.
Script Download: The script is available for download from https://gallery.technet.microsoft.com//How-to-fix-The-file-is-2684aa3b. 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 VBScript shows how to fix the issue "The file is corrupt and cannot be opened" when opening an Excel file.
Some consumers encounter an issue "The file is corrupt and cannot be opened" error on office Excel while opening .xls files. This script will try to fix that.