• [Script of May 10] Get logins, databases users/roles and object level permission (T-SQL)

    Script Download: LoginUserRolePermission.zip
    http://gallery.technet.microsoft.com/scriptcenter/Get-logins-databases-816f66b2/

    This script contains three code parts, one to get the result of server level logins and related roles, one to get the result of user databases’ users and related roles, one to get the result of object level permission of specific database.

    This script can be used to get the following results:

    • Server level logins and related roles
    • User databases users and related roles
    • Object level permission of specific database

     

    image image
    image

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

  • [Script of May 29] Retrieve all local user accounts information on remote computers (PowerShell)

    Script Download: GetLocalAccount.zip
    http://gallery.technet.microsoft.com/scriptcenter/Script-to-retrieve-all-b70a1dba

    This PowerShell Script shows how to retrieve all local user accounts information on remote computers.

    An enterprise uses Active Directory to manage users and groups, but still need to manage local user accounts. This might be because the computer is not a domain member (if it is in a perimeter network). This script allows admins to retrieve all local user accounts information to management on remote computers, it will be really useful.

    image image
    image

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

  • [Script of May 20] Create a Shutdown/Restart/Logoff Windows 8 Tile for the Start menu (VBScript)

    Script Download: CreateWindowsTile (VBScript).zip
    http://gallery.technet.microsoft.com/scriptcenter/Create-a-ShutdownRestartLog-b4d75991

    This VBScript shows how to create a Shutdown, Restart and Logoff Windows 8 tile to the Start menu.

    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.

    image image
      image

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

  • [Script of May 9] Script to remove Internet Explorer in Windows 7 (VBScript)

    Script Download: RemoveInternetExplorer(VBScript).zip
    http://gallery.technet.microsoft.com/scriptcenter/Script-to-remove-Internet-10785136/

    This VBScript demo shows how to remove Internet Explorer in Windows 7.

    In some situations, customers need to uninstall Internet Explorer 9 to fix crash issue, but they cannot manually uninstall Internet Explorer successfully sometimes. 

    image image
    image

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

  • [Script of May 6] Check SQL Server a specified database index fragmentation percentage (SQL)

    Script Download: IndexFragmentation.zip
    http://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-a-a5758043

    This T-SQL sample script illustrates how to check index fragmentation of a specified database in SQL Server.

    This script can be used for checking index fragmentation percentage of tables in SQL Server user databases. You can specify the database name and fragmentation percent, after you run the script, you will get the result.

     

    image image
    image

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