• [Script of Oct 17th] Remove E-Mail address with Specific Domain Name in Microsoft Exchange 2010

    Script Download: RemoveEmailAddress.zip
    http://gallery.technet.microsoft.com/scriptcenter/Remove-E-Mail-address-with-d716e055

    This script could be used to remove E-Mail address with specific domain Name in Microsoft Exchange 2010. This script can remove E-Mail address from mailbox, distribution group and dynamic distribution group.

    In a real world, IT Administrators may want to remove new e-mail addresses due to variety of reasons. If an organization has thousands of recipients, it’s impossible to remove e-mail addresses for these recipients one by one. IT administrators do need a script to complete this task.

     

    image image
    image image

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script Of July 10] How to check if SQL Server database files are marked as sparse files

    image image
    July
    10
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-check-if-SQL-Server-af01ebb9 (SQL) and http://gallery.technet.microsoft.com/How-to-check-if-SQL-Server-23bace0c (powershell).  You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment. 

    Only files associated with a database snapshot should be marked as sparse files. If a regular database is marked as a sparse file, you might encounter unexpected performance degradation and errors during normal activities. This script will find all the database files marked as sparse files in an instance.

    Some people asked how to check if SQL Server database files marked as sparse files. This script will help demo how to find out all the database files marked as sparse files.

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script of Feb. 7] Lists all the shared folder permissions or NTFS permissions (PowerShell)

    Script Download: ListAllSharedFolderPermission.zip  
    http://gallery.technet.microsoft.com/scriptcenter/Lists-all-the-shared-5ebb395a 

    This PowerShell script illustrates how to list all the shared folder permissions and NTFS permissions.

    In many cases, users want to check many share folders permission one by one. If we can use the script to list these share folders permission, it will really useful.  

    image image
     image

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script Of July 31] How to rebuild or reorganize indexes in a specified SQL server database

    image image
    July
    31
    image

    Script Download:  
    The script is available for download from http://gallery.technet.microsoft.com/How-to-rebuild-or-12b01775.  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 sample shows how to rebuild or reorganize indexes in a specified database.

    This script will list all the indexes in a database. We can choose to rebuild or reorganize the indexes according to their defragmentation. If avg_fragmentation_in_percent_value is higher than 30 and page_cout is more than 1000, we can rebuild the indexes. If avg_fragmentation_in_percent_value is between 5 and 30 and page_count is more than 1000, we can reorganize the indexes.

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery

  • [Script of Feb. 12] How to create home folder and grant the appropriate permission to users

    Script Download: CreateHomeFolder.zip 
    http://gallery.technet.microsoft.com/scriptcenter/How-to-create-home-folder-d968f1d4 

    This script could be used to create folder for a one to one correspondence user. Also assign the appropriate permissions to each folder, that only the exact user and specified file admins get full control. Nobody can read or write in that folder except these users. Finally, it will generate a report to tell you which folder created successfully, and which did not.

    IT Administrators may need to generate several folders to new comers as their home folder. For security reason, the home folder could only be accessed by the exact user and some admins. If you want to do so, you can use this script sample.

    image image
     image

    You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery