• [Script of Oct 16th] Script to Enable Users and Enterprise Voice in Microsoft Lync Server 2010

    Script Download: EnableLyncUsersForEnterpriseVoice.zip
    http://gallery.technet.microsoft.com/scriptcenter/Script-to-Enable-Users-and-f56306ed

    This script could be used to enable users and enterprise voice feature in Microsoft Lync Server 2010. It will help you to generate LineUri and provide a confliction detection mechanism. Also you can assign dial plans and voice policies at the same time. It is recommended to use this script right after deploying a new Lync environment. You need to find another solution or extend this script to support user provisioning.

    With Enterprise Voice, Microsoft Lync Server 2010 delivers a stand-alone Voice over Internet Protocol (VoIP) offering to enhance or replace traditional PBX systems. Enterprise Voice users can call colleagues on your organization’s VoIP network or PBX, and they can call traditional phone numbers outside your organization.

    Currently, administrators feel difficulties when they try to enable users and enterprise voice right after deploying a new Lync environment. It requires a lot of work to assign phone numbers (LineUri) to each user. So administrators do need a script to mitigate this problem.

    image image
    image image

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

  • [Script of Oct 18th] Import Multiple Tables from Access to Excel

    Script Download: mdlTransferAccessToExcel.zip
    http://gallery.technet.microsoft.com/scriptcenter/Import-Multiple-Tables-ad78b80f

    This VBA sample illustrates how to import multiple Access tables to Excel worksheets at once, meanwhile each worksheet‘s name will correspond to each table's name. It can be run on Excel 2003, 2007 and 2010.

    Users would like to import Access tables to Excel worksheets, meanwhile each worksheet's name will correspond to each table's name.

     

    image image
    image image

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

  • [Script of Oct 15th] Get Checkout Files List in Microsoft SharePoint Server 2010

    Script Download: GetCheckOutFileList.zip
    http://gallery.technet.microsoft.com/scriptcenter/Get-Checkout-Files-List-in-040002fd 

    This PowerShell could be used to get a list of checkout files from a site collection in Microsoft SharePoint Server 2010. You can also get a list of files which checkout by specific user.

    In a real world, IT administrators often need to get a checkout files list in Microsoft SharePoint Server 2010, especially after the resignation of an employee. It will be a heavy task if they do it manually. It’s better to use a script to generate a checkout files list automatically.

    image image
    image image

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

  • [Script of Oct 26th] Publish report to Reporting Services in SharePoint Integrated Mode

    Script Download: PublishReportInIntegratedMode.zip
    http://gallery.technet.microsoft.com/scriptcenter/Publish-report-to-0ca69662 

    This VB.NET sample script illustrates how to publish a report from a computer path to Reporting Services in SharePoint integrated mode. This script applies to SQL Server Reporting Services 2008 R2 integrated with SharePoint 2010.

    Starting from SQL Server 2008 R2, the rs utility is supported against report servers that are configured for SharePoint integrated mode as well as servers configured in native mode. Today, most of the available script samples correspond to the native mode.  This sample script will ease the problems in below two scenarios:

    1. The report server configured to SharePoint integrated mode.
    2. The published report use embedded data source or shared data source.

     

    image image
    image image

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

  • [Script of Oct 10th] Prepopulate a batch of user passwords to RODC (PowerShell)

    Script Download: PrepopulatePasswordCacheForRODC.zip
    http://gallery.technet.microsoft.com/scriptcenter/Prepopulate-a-batch-of-34e6d0dc 

    This Windows PowerShell script will prepopulate a batch of user passwords to a specified Read-only Domain Controller. It will leverage the capability of the native command, repadmin. The script will also strictly check the parameters for avoiding any potential human error.

    Currently, IT Professionals can only prepopulate user password for one account each time.  If IT Professionals have to prepopulate 200 or more user passwords within a very short period of time, the job will turn out to be very stressful and tedious.

     

    image image
    image image

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