Posts Tagged ‘VBS’

VBS scripts to query everything

Wednesday, December 24th, 2014

There are a few simple scripts developed by me to automate somehow regular reporting against set of servers. Result is usually presented in csv file to use it quickly in Excel or similar calculation software.

Scripts to query WMI:

Script to report installed roles and features:

getRoles.zip

usage: cscript /nologo getRoles.vbs servers.txt

Example of input file: servers.txt

Example of output file: getRoles_26-09-2014_12-30-14.csv

Script to report info about installed services:

getServices.zip

usage: cscript /nologo getServices.vbs servers.txt

Example of input file: servers.txt

Example of output file: getServices_19-11-2013_07-30-15.csv

Script to report information about capacity of local disks:

getCapacity.zip

usage: cscript /nologo getCapacity.vbs servers.txt

Example of input file: servers.txt

Example of output file: getCapacity_01-10-2013_13-01-51.csv

Script to report activation status:

getActivationStatus.zip

usage: cscript /nologo getActivationStatus.vbs servers.txt

Example of input file: servers.txt

Example of output file: getActivationStatus_17-06-2013_10-12-18.csv

Script to report about sharings:

getSharings.zip

usage: cscript /nologo getSharings.vbs servers.txt

Example of input file: servers.txt

Example of output:

Scripts to query registry:

Script to report installed software:

getSoftware.zip

usage: cscript /nologo getSoftware.vbs servers.txt

Example of input file: servers.txt

Example of output file: getSoftware_12-06-2013_13-51-58.csv

Script to report status of WSUS:

getWSUS.zip

usage: cscript /nologo getWSUS.vbs servers.txt

Example of input file: servers.txt

Example of output:

Scripts to query LDAP:

Script to enumarate groups where user, specified in input file, belongs to directly (nesting level = 0) and indirectly (nesting level > 0):

getMemberOf.zip

usage: cscript /nologo getMemberOf.vbs users.txt

Example of input file: users.txt

Example of output:

Feel free to use them.

 

DFS resources

Saturday, December 20th, 2014

Here is my trial of grouping DFS resources available to study and I’m sure I missed a lot useful web sites.

Microsoft Official Courses (MOC):

6419B: Configuring, Managing and Maintaining Windows Server 2008-based Servers

Module 4: Configuring and Managing Distributed File System:
– Lesson 1: Distributed File System Overview
– Lesson 2: Configuring DFS Namespaces
– Lesson 3: Configuring DFS Replication
Categorized as Level 200 by Microsoft

6421B: Configuring and Troubleshooting a Windows Server 2008 Network Infrastructure

Module 11: Optimizing Data Access for Branch Offices
– DFS Overview
– Overview of DFS Namespaces
– Configuring DFS Replication
Categorized as Level 200 by Microsoft

20411D: Administering Windows Server 2012

Module 9: Optimizing File Services:
– Overview of DFS
– Configuring DFS Namespaces
– Configuring and Troubleshooting DFS Replication
Categorized as Level 200 by Microsoft

20413C: Designing and Implementing a Server Infrastructure

Module 10: Planning and Implementing File Services:
– Planning and Implementing DFS
Categorized as Level 300 by Microsoft

20414B: Implementing an Advanced Server Infrastructure

Module 7: Planning and Implementing High Availability for File Services and Applications:
– Planning and Implementing DFS
Categorized as Level 300 by Microsoft

Internet:

Perfect repository of all significant resources available in Internet:

DFS Replication: Survival Guide

My own development:

Script to check replication status on all servers found in AD as DFS replication partners:

getDFSRStatus.zip

usage: cscript /nologo getDFSRStatus.vbs

Script to check replication status on one server specified as parameter:

getDFSRStatusLite.zip

usage: cscript /nologo getDFSRStatusLite.vbs <myDFSRServer>

Above scripts generate csv report with status of connection state, target folder state, backlog, etc. Here is an example of output file getDFSRStatus_06-11-2014_13-59-06.csv:

 

DFS-R topology

Saturday, May 4th, 2013

Topology of DFS-R can be easily visualized by using GraphViz tool.

Based on Active Directory Topology Visualization part 1 solution I’ve developed next script to have clear picture how DFS replication looks like. Design of solution is very the same: vbs script queries AD regarding to DFS replication groups, folders, servers and connections and formats result into dot language file. Then dot file is used as input for GraphViz package to generate picture of DFS-R topology.

Vbs script can be downloaded here without any limitation of using:

getDFSRTopology.zip

usage:

Result:

Generated dot file can look like this:

and based on it here is the picture (command: fdp *.dot -Tjpg -O):

fdp4

Rectangles represent replication groups with replication partners. Opposite to Active Directory Topology Visualization part 1 or Site links topology solutions, where nodes occur only once, here is needed one trick to have the same server in various groups. In line 88 in vbs script I pin to node names additional counter to have group specific servers, however their labels stay the same. It allows to see the same server name in various groups but nodes are definitely different from dot language viewpoint.

 

Site links topology

Saturday, May 4th, 2013

Based on solution developed for Active Directory Topology Visualization part 1 purpose I’ve made very similar script to have nice picture of defined site links in AD.

I think it’s quite good to know if gap in replication is not caused by lack of site link, etc.

Details:

Nothing special was developed by me. I simply query via vbs script this DN:

CN=IP,CN=Inter-Site Transports,CN=Sites,CN=Configuration,DC=my,DC=domain

and result is presented in dot language formatted file.

Vbs code can be downloaded here and feel free to use it:

getSiteLinks.zip

usage:

Gallery:

Result of above vbs script can look like as follow:

and based on it GraphViz can generate:

dot diagram layout (command: dot *.dot -Tjpg -odot.jpg):

dot3

fdp diagram layout (command: fdp *.dot -Tjpg -ofdp.jpg):

fdp3

sfdp diagram layout (command: sfdp *.dot -Tjpg -osfdp.jpg):

sfdp3

Example of site node picture:

site

There is possible to use any other picture to present site in diagram than above one. The most important is to put picture file of site (site.png in this case) in the same location where dot file is stored before compilation.

 

Active Directory Topology Visualization part 1

Saturday, May 4th, 2013

Overview:

Except of Microsoft Active Directory Topology Diagrammer, which requires licensed MS Visio installed, there is no easy way to show how physical topology of Active Directory looks like. As the Chinese proverb goes, “A picture is worth a thousand words”, result of 17 repadmin /replsum <DC> commands even prepared in MS Excel will not tell as much as below screen:

circo

Details:

GraphViz is open-source tool based on dot language dedicated for drawing diagrams. It allows to present any graph or network in simple static form with information like direction of flow between nodes or node specific details. It is perfect tool to show how Active Directory Domain Controllers replicate each other and allows to find bottleneck or critical paths in AD physical topology.

Usage is very simple and requires GraphViz package installed locally and own developed script to prepare input for this tool based on dot language.

1. Below code is dot language script topology.dot used as input for GraphViz package to generate nice diagram:

note:

– AD Sites: EU, US and AS are specified as SUBGRAPH cluster_XX and are presented as rectangles in final diagram

– AD DCs: EUDC014, USDC014 and ASDC015 are simply nodes in diagram

– example of server picture to put into the same folder where topology.dot is located:

server

2. Command to generate picture of dot diagram layout:

 and result:

dot

3. Examples of commands to generate all kind of diagram layouts:

Practice:

Dot file can be prepared manually or a bit smarter. Below vbs is my own developed and many time used script which queries AD regarding to sites, domain controllers and connection objects and generates dot launguage file used later in GraphViz package.

Vbs script is available to download here and feel free to use it:

getReplicationTopologyLite.zip

usage:

Gallery:

Below diagrams are examples of AD replication topology:

dot2

fdp1However more complex environments (>100 DCs) require a few tricks to make pictures more readable. I usually add dotted style for connections for example:

or trying to generate all kind of diagram layouts to choose the most suitable to study. In most cases huge networks need specific approach.

A few useful links:

1. Official GraphViz web site: http://www.graphviz.org

2. Dot guide: http://www.graphviz.org/pdf/dotguide.pdf

3. Wikipedia about GraphViz: http://en.wikipedia.org/wiki/Graphviz

4. Active Directory Topology Visualization part 2

Let the “more readable replication topology” be with you.