Administrator Command Reference Manual
Command Details : Detailed Descriptions of Commands : QUERY (Querying)
QUERY (Querying)
Function:
Used to output a wide variety of information. In general, querying options are documented with the commands which they relate to. Some options which do not fit into this category are listed here.
Note:
That general AVEVA E3D™ commands for querying elements and attributes are also available.
Examples:
Q COPIES PIPING/AREA-A
List the copies of DB PIPING/AREA-A
Q LINEWIDTHS
List the system defined line widths used in DRAFT
Q SET MDB
Q SET TEAM
Q SET DBSET
Query the set (i.e. current) Team, MDB or DB Set.
Q MOD DESIGN DRAFT 33
Query module entries for MODEL, DRAFT and module 33.
Q DDL
Gives version number of System DDL (Design Data Language).
Q CLAIM SAMPLE/DESI
Outputs information about claimed databases.
Q NEWREF old-ref
Gives the new reference corresponding to the given old reference.
Q SESSION LAST 
Outputs the date, user, and any comments saved with the given session.
Q SESSIONS ON date dbname
Q SESSIONS SINCE n dbname
Q SESSIONS LAST n dbname
Query session information on a specified database.
Q SESSIONS SINCE n
Q SESSIONS LAST n
Q SESSIONS ON date
Query session information on the current database (i.e. System or Global database).
Q ACTIVE
Gives the active session number.
Q NACCNT
At a DB element, gives the non-additive changes count. This value increases when a database is merged, backtracked or reconfigured. This attribute will return the value for the system database if used at STAT /*S, or in a Global project, for the global database if used at GSTAT /*GS.
Q HCCNT
At a DB element, gives the extract list changes count. This value increases when extracts are inserted or removed.
Note:
The superseded ELCCNT pseudo-attribute is retained as a synonym for HCCNT. HCCNT is available at /*S and /*GS elements as well as at DB elements.
Q CLCCNT
At a DB element, gives the claim list changes count. This value increases when elements are claimed or dropped without other changes to the database.
Note:
In a Global project, the above three attributes together with session information can be used to compare the state of the database at different locations. Refer to Running Global Projects for further information.
Querying extracts
Q DBNAME
Gives the name of the database you are actually writing to.
Q CLAIMLIST
Gives a list of user claims in your current database.
Q CLAIMLIST EXTRACT
Tells you what you can flush.
Q CLAIMLIST OTHERS
Tells you what you can't claim, including user claims and extract claims.
The following options are only available in a Global Project:
Q ADMLOC
Returns the currently administered location, which may be different from the true current location.
Q COMMS TO LON
Query state of comms link to location LON. (Equivalent to PING)
Q COMMS LON INPUTPACKETS
Q COMMS LON OUTPUTPACKETS
Query data from comms link to location LON: Input or Output Packets.
Q COMMS LON INPUTRequests
Q COMMS LON OUTPUTRequests
Query data from comms link to named location: Input or Output Requests.
Q COMMS TO LON PATH
Query Comms routing to location LON.
Q CURLOC
Returns the true current location. This command is useful when you are remotely administering another location: it returns the name of the actual location where you are working.
Q ISOLAT AT LON
Returns TRUE if the location LON is isolated.
Q LOCK AT LON
Returns the project lock at location LON.
Q PROJ LOCK AT LON
Returns the project lock at location LON
Q REMOTE LON SAMPLE/DESI FILEDETAILS
Returns details of the latest session number, compaction number and other file details for the database at the specified location. These details are used by the Global daemon when sending a database update, and can be useful when analysing the progress of scheduled updates.
Q REMOTE LON SAMPLE/DESI LASTSESSION
Returns Session information for the last session of the specified database at the specified location. The output is equivalent to that from Q SESSION SAMPLE/DESI at the current location. Note that it is not possible to query sessions other than the latest at a remote location.
Note:
Q COMMS, Q ISOLAT and Q PROJ LOCK are now available in other modules such as MODEL.
The following attributes are also useful:-
At a LOC element,
Q DBALL
lists the allocated dbs;
Q DBPRIM
lists the primary dbs;
At a DB element,
Q DBLC
lists the locations where it is allocated;
At either DB or LOC,
Q PRMLOC
indicates its Primary location
The following options are only available in a Global Project at the Hub
The daemons must be running.
Q READERS HVAC/HVAC AT CAM
Outputs a list of readers of database HVAC/HVAC at Location CAM.
Q READERS HVAC/HVAC AT CAM COUNT
Outputs a count of readers of database HVAC/HVAC at Location CAM.
Q WRITERS HVAC/HVAC AT CAM
Outputs a list of writers to database HVAC/HVAC at Location CAM.
Q WRITERS HVAC/HVAC AT CAM COUNT
Outputs a count of writers to database HVAC/HVAC at Location CAM.
Command Syntax:
>- Q --+- Authuser -------.
       |                  |
       |- Authentication -|
       |                  |
       |--- USer ---------|
       |                  |
       |--- TEam ---------+--- word ------------------.
       |                                              |
       |--- DB -------.                               |
       |              |                               |
       |--- COpies ---+--- dbname --------------------|
       |                                              |
       |--- DBNO dbno --------------------------------|
       |                                              |
       |--- MDB name ---------------------------------|
       |                                              |
       |                .-------<-----.               |
       |               /              |               |
       |--- MOdule ---*--- integer ---|               |
       |              |               |               |
       |              ‘--- word ------+---------------|
       |                                              |
       |--- LOck -------------------------------------|
       |                                              |
       |--- DDL --------------------------------------|
       |                                              |
       |--- SET ---+--- TEam -------------------------|
       |           |                                  |
       |           |--- DBSet ------------------------|
       |           |                                  |
       |           ‘--- MDB --------------------------|
       |                                              |
       |--- PROject ----------------------------------|
       |                                              |
       |--- SESSIONS --+-- SINCE --.                  |
       |               |           |                  |
       |               |-- LAST ---+- n --+-----------|
       |               |                  |           |
       |               ‘—- ON <date> -----+-dbname ---|
       |                                              |
       |--- CLAIM dbname -----------------------------|
       |                                              |
       |--- PASSWORDLOCK -----------------------------|
       |                                              |
       |--- NEWREF oldref ----------------------------|
       |                                              |
       |--- MAXUSers ---------------------------------|
       |                                              |
       |--- ACTIVE -----------------------------------|
       |                                              |
       |--- MACRO n ----------------------------------|
       |                                              |
       ‘--- INFOrmation --+--- dbname ----------------|
                          |                           |
                          ‘--- SYSTEM ----------------+--->
The following options are only available in a Global Project.
>--- Q COMMS ---+--- TO ---.
                |          |
                ‘----------+--- <loc> ---+--- INPUTPackets ----.
                                         |                     |
                                         |--- OUTPUTPackets ---|
                                         |                     |
                                         |--- INPUTRequests ---|
                                         |                     |
                                         |--- OUTPUTRequest ---|
                                         |                     |
                                         |--- PATH ------------|
                                         |                     |
                                         ‘---------------------+-->
>--- Q ADMLOC --->
>--- Q CURLOC --->
>--- Q ISOLAT AT <loc> --->
>--- Q LOCK AT <loc> --->
>--- Q --+-- READERS --. 
>--- Q COMMS ---+--- TO ---.
                |          |
                ‘----------+--- <loc> ---+--- INPUTPackets ----.
                                         |                     |
                                         |--- OUTPUTPackets ---|
                                         |                     |
                                         |--- INPUTRequests ---|
                                         |                     |
                                         |--- OUTPUTRequest ---|
                                         |                     |
                                         |--- PATH ------------|
                                         |                     |
                                         ‘---------------------+-->
>--- Q ADMLOC --->
>--- Q CURLOC --->
>--- Q ISOLAT AT <loc> --->
>--- Q LOCK AT <loc> --->
>--- Q --+-- READERS --. 
         |             |
         ‘-- WRITERS --+- <dbname> --.
                       |             |
                       ‘-------------+--- AT <loc> --.
                                     |               |
                                     ‘---------------+-- COUNT --.
                                                     |           |
                                                     ‘-----------+-->
For details of Q REMOTE, see under REMOTE
Related Commands:
LIST, Q REMOTE
1974 to current year. AVEVA Solutions Limited and its subsidiaries. All rights reserved.
AVEVA Logo