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

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: 22118.zip
    http://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.

    image image
    image

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

  • [Script of Nov.4] Set PictureUrl as default unless another picture is present (PowerShell)

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: SetSPUserPicture.zip
    http://gallery.technet.microsoft.com/scriptcenter/Set-PictureUrl-as-default-9e0123ca

    This script shows how to Set PictureUrl as default unless another picture is present.

    This script will set a default picture for the PictureUrl in a list where all user information are stored .If users don't specify a picture, the default picture will be used.

    image image
    image

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

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

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: 22205.zip
    http://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.

    image image
    image

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

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

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: 22231.zip
    http://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 line that would describe the need of these ports.

    image image
    image

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

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

    Posted over 1 year ago
    by Huilin zhu}

    Script Download: 22121.zip
    http://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. 

    image image
    image

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