Just need it for one project?  Click here for Rental Options.

 

Lost Registration Code?  Click here.

Run Query Using Substitutions



For the ultimate in reporting flexibility, Multi-Remote Registry Change now includes the ability to do a free form query using Substitutions.

For example, to list the hard drive types for all of your computers, you can create the following four Substitution Items:

Replace This Text: HardDisk0
Hive: HKEY_LOCAL_MACHINE
Key Path: \HARDWARE\DEVICEMAP\Scsi\Scsi Port 0\Scsi Bus 0\Target Id 0\Logical Unit Id 0
Value Name: Identifier

Replace This Text: HardDisk1
Hive: HKEY_LOCAL_MACHINE
Key Path: \HARDWARE\DEVICEMAP\Scsi\Scsi Port 0\Scsi Bus 0\Target Id 1\Logical Unit Id 0
Value Name: Identifier

Replace This Text: HardDisk2
Hive: HKEY_LOCAL_MACHINE
Key Path: \HARDWARE\DEVICEMAP\Scsi\Scsi Port 1\Scsi Bus 0\Target Id 0\Logical Unit Id 0
Value Name: Identifier

Replace This Text: HardDisk3
Hive: HKEY_LOCAL_MACHINE
Key Path: \HARDWARE\DEVICEMAP\Scsi\Scsi Port 1\Scsi Bus 0\Target Id 1\Logical Unit Id 0
Value Name: Identifier


After these entries are created, select "Run Query Using Substitutions" from the Substitutions menu.

In the text box, enter your free form query (wrapped for readability only):

"On machine: &computername&, the current user is: &username&. The hard drives are: HD0 - &HardDisk0&, HD1 - &HardDisk1& , HD2 - &HardDisk2&, HD3 - &HardDisk3&"

This can easily be used to produce a Comma Delimited File for import into Excel or another program, simply enter the text in the box exactly as you wish it to be saved:

&computername&,&HardDisk1&,&HardDisk2&,&HardDisk3&,&username&

Another example is just to list the current user on each selected machine. Simply enter &username& in the text box!

An example of the output of this is:

COMP1 CharlieH
COMP2 Ysmith
COMP3 HowardH
SERVER1 Administrator

Main Window
Contents
Substitutions

Copyright © 1998-2006 Eytcheson Software
All rights reserved.
Last Updated:  Saturday, April 29, 2000