[Script of Nov. 29] Security hardening for SharePoint 2010 farms (PowerShell)

Script Download: 22231.ziphttp://gallery.technet.microsoft.com/Security-hardening-for-c425db1d This PowerShell script shows how to check required ports status in SharePoint 2010. To help the SharePoint admin, we need to come-up with a script that would check all the ports required by SharePoint and provide an output with details as to which all ports are open or block, along with a…

1

[Script of Nov. 28] Find inefficient query plans

Script Download: 21998.ziphttp://gallery.technet.microsoft.com/scriptcenter/Find-inefficient-query-88f4611f This T-SQL script will check the plan cache for the top 25 inefficient query plans. It will list total CPU time, CPU time per execution, total read IOs, average read IOs per execution, total recompiles and average recompiles per execution.his PowerShell script will demo how to back up a SSAS database. The…

1

[Script of Nov. 27] Check the frequency of a report access (T-SQL)

Script Download: 22121.ziphttp://gallery.technet.microsoft.com/scriptcenter/Check-the-frequency-of-a-26609dc9 This T-SQL script will check the frequency of all the reports visited on the report manager during the latest week, latest month and latest year. You can use this script for reference when you want to know the frequency of reports visited.  You can find more All-In-One Script Framework script samples at…

2

[Script of Nov. 26] Backup SQL Server Analysis Service database (PowerShell)

Script Download: 22118.ziphttp://gallery.technet.microsoft.com/scriptcenter/Backup-SQL-Server-Analysis-37016bec This PowerShell script will demo how to back up a SSAS database. Some people asked how to back up a database by PowerShell. And this script will demo how to back up a SSAS database by PowerShell. You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

1

[Script of Nov. 25] Check the state of all instances in a SQL Server (PowerShell)

Script Download: 22123.ziphttp://gallery.technet.microsoft.com/scriptcenter/Check-the-state-of-all-1ad2f8d2 This PowerShell script will check the state of all instances in a SQL Server. It will list the name, start mode, state and status of all the instances in a local machine. If there is no instance installed, it will remind you that there is no instance. Some people asked how to…

1

[Script of Nov. 22] Retrieve a list of Active Directory User based on Display Names (PowerShell)

Script Download: 22221.ziphttp://gallery.technet.microsoft.com/scriptcenter/Retrieve-a-list-of-Active-90c533a2 This PowerShell script sample shows how to get a list of active directory Sam Account name based on display name. This PowerShell script sample shows how to get a list of active directory Sam Account name based on display name. You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

1

[Script of Nov.21] How to add credentials to the Windows Vault (PowerShell)

Script Download: 22165.ziphttp://gallery.technet.microsoft.com/scriptcenter/How-to-add-credentials-to-c8e9bd5f This PowerShell script shows how add credentials for specific users. There is no need to manually add credentials using control userpasswords2>Advanced>Manage Passwords>Add a windows credential. A script for administrator to add credentials for specific users is more convenient. You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

1

[Script of Nov.20] Send a Warning Report of a Mail Storm

Script Download: 22205.ziphttp://gallery.technet.microsoft.com/scriptcenter/Send-a-Warning-Report-of-a-1ad183ae This script will find senders that have sent large numbers of e-mails, then look for consistent use of same subject and recipient, finally send a warning email to a particular User. This script is to help Exchange Administrators to detect mail storm. You can find more All-In-One Script Framework script samples at…

1

[Script of Nov.19] Convert .XLR file to .XLS file

Script Download: 21704.ziphttp://gallery.technet.microsoft.com/scriptcenter/Convert-XLR-file-to-XLS-8748cad9 This script will Convert Microsoft Works Spreadsheet file XLR to Microsoft Excel file XLS. This script is to help users to convert .XLR file to .XLS file via PowerShell. You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

1

[Script of Nov.18] How to set RecyclebinRetentionPeriod settings for SharePoint Web Application

Script Download: 22210.ziphttp://gallery.technet.microsoft.com/scriptcenter/How-to-set-RecyclebinRetent-f2ef042a This script could be used to set RecyclebinRetentionPeriod settings for SharePoint Web Application. Sometimes, SharePoint admin need to set RecyclebinRetentionPeriod settings. You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery

1