QUERYDS
Because all dynamic information is stored in tables
in the data collector’s physical
RAM, this command-line utility is provided to query
the current information on the
local zone data collector.
Syntax
queryds tables
queryds /table: tablename
queryds /query: querystring
(Query String is optional, but you must specify a
tablename.)
Parameters
tablename
The name of the data collector table to query. Table
names are case-sensitive.
Options
tables
Returns a complete list of all tables available to
query.
/table: tablename
Outputs to the screen the entire contents of the
table specified by tablename.
Remarks
You can use queryds to determine which
servers are currently available in a farm. It
retrieves all information from the tables stored on
the local zone data collector. For example, the
PN_Table contains information about all available servers that are
accepting Program Neighborhood connections. To view the
entire contents of the PN_Table, execute the following
command:
queryds /table:PN_Table
The output when executed on a single-server farm
looks similar to the following:
[PN_Table]: 1 records.
name:588f
host:XPSERVER1
zone:Zone1
Version:1
Tcp:enabled
Ipx:enabled
Netbios:disabled
In a farm with 100 servers, this command outputs 702 lines
of data. Use the findstr
and sort command-line utilities to filter and sort the output for easier
reading.
Tip
The
findstr and sort commands are installed by default on both
the TSE and Windows 2000 server families. For more information about using
the findstr command to filter output, type findstr /? at a command prompt. For more information about the sort command, type sort /? at a command prompt.
The first entry shows
the number of records in the PN_Table. This number also corresponds
directly to the number of server records in the PN_Table. A server record
does not exist in the PN_Table unless the server’s IMA service is started
and the server is accepting Program Neighborhood connections. Thus, you
can use the following command to determine how many servers in the farm
are online:
queryds /table:PN_Table | findstr /r
PN_Table
The command shown below filters output using the word "host"
(which prefaces
each host name in the table) and displays an alphabetized
list of all the servers
currently online:
queryds /table:PN_Table | findstr /r host |
sort
Using queryds in this manner provides a fast, customizable method to query
any
data collector table.
Queryds is not installed by default. It is in the
\W2K\support\debug\i386 folder on the MetaFrame XP, Feature Release 2
CD.
|
