TechNet Gallery - resources for IT professionals
Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.
Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
|
Note: This script is tailored for the project I used it in. It should work out of the box (by only changing the $location variable), but sometimes it doesn't (because of the configuration of Active Directory, missing of the AD Module, etc. etc). Most of the times when it doesn't
|
(49)
Updated 6/12/2013
Released 4/26/2012
25,378
Downloads
|
|
|
Lync DDC is a simple low-level design calculator for a Lync 2013 Standard or Enterprise deployment. Fill in hostnames, IP and other design elements in the Global Data and Resource Data sheets, and it will calculate DNS records, certificate names, firewall rules and HOSTS entries.
|
(17)
Updated 12/13/2013
Released 8/28/2013
1,382
Downloads
|
|
|
Export-XLSX
Export PowerShell Objects to Excel .xlsx file without Excel! These script cmdlet creates a Excel XLSX workbook file and stores the data of the objects that you submit in a worksheet within the workbook. You can use this script like the Export-CSV cmdlet. |
(4)
Updated 11/7/2013
Released 9/7/2013
617
Downloads
|
|
|
Create a full blown Active Directory HTML/PDF/Excel report with powershell which can be produced with any non-privileged domain user account and without any special powershell modules or administrative consoles.
|
(4)
Updated 11/29/2013
Released 10/18/2013
512
Downloads
|
|
|
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.
|
(6)
Updated 7/29/2013
Released 8/22/2012
920
Downloads
|
|
|
I am pleased to present a new, small application. Addition to Excel, whereby in a simple way you can convert your XLS to CSV, given the different standards of recording it. Export applies to the entire worksheet (the maximum area of use) or for a designated area.
|
(2)
Updated 12/4/2013
Released 12/24/2011
1,269
Downloads
|
|
|
This article describes the formula syntax and usage of the SUMIFBYCOLOR function in Microsoft Excel.Descripti
|
(2)
Updated 9/21/2012
Released 9/21/2012
955
Downloads
|
|
|
A PowerShell V1 script to update users (or any class of AD objects) in bulk from the information in a Microsoft Excel spreadsheet. Only single-valued string attributes are supported.
|
(16)
Updated 9/17/2011
Released 9/17/2011
3,839
Downloads
|
|
|
This script allows you to convert one or more CSVs into an Excel file with each CSV being a new worksheet in excel.
|
(12)
Updated 2/21/2012
Released 9/2/2010
2,900
Downloads
|
|
|
This script build to collect Printer details from local, remote or Printer server.Which gives us - Print Server,Printer Name,Port Name,Share Name,Driver Name,Driver Version,Driver,
@===Amol===@ =============== |
(2)
Updated 4/17/2013
Released 4/16/2013
496
Downloads
|
|
|
This script will help to collect System Information from Local, Remote or Multiple remote computers.
Used Get-WMIObjects to get the required details and will save it in excel. You can change/add the properties as per your requirme |
(0)
Updated 3/22/2013
Released 3/22/2013
577
Downloads
|
|
|
Here is my blog post that explains it in more detail. Plus has some ready to go scripts to try it out.Out-ExcelPi
|
(3)
Updated 12/29/2011
Released 12/29/2011
550
Downloads
|
|
|
This script will perform a enumeration of all installed software on a Windows machine using the WMI Class "Product" and will provide you with a dump of all installed apps for review. The script provides "prompt" boxes for destination host and output locations. It was written by
|
(4)
Updated 2/2/2012
Released 2/2/2012
1,206
Downloads
|
|
|
Create a master page to index all worksheets name and add a hyperlink to them.
|
(3)
Updated 3/26/2012
Released 2/23/2012
303
Downloads
|
|
|
List of uniques is useful in many situations, eg
for the selection of elements in the forms, letters or designation of the scale validation set. One of the simplest ways is to create a pivot tabla, which in its mechanism counts the elements of the counter. |
(3)
Updated 10/25/2012
Released 1/8/2012
214
Downloads
|
|
Download Windows Server 2012