queryDB_util

Description queryDB_util enables searching the object database according to search parameters.

Syntax

# queryDB_util [-t <table_name>] [-o <object_name>] [-a]
[-mu <modified_by>] [-mh <modified_from>]
[-ma <modified_after>] [-mb <modified_before>] [-p{m|u|h|t|f}]
[-f <filename>] [-h] [-q]

Parameter	Description
`-t <table_name>`	The name of the table.
`-o <object_name>`	The name of the object.
`[-a]`	All objects.
`-mu <modified_by>`	The name of the administrator who last modified the object.
`-mh <modified_from>`	The host from which the object was last modified.
`-ma <modified_after>`	The date after which the object was modified `<[hh:mm:ss][ddmmmyyyy]>`. Either or both options may be used. Omitting `hh:mm:ss` defaults to today at midnight, omitting `ddmmmyyyyy` defaults to today's date on the client.
`-mb <modified_before>`	The date before which the object was modified `<[hh:mm:ss][ddmmmyyyy]>`. Either or both options may be used. Omitting `hh:mm:ss` defaults to today at midnight, omitting `ddmmmyyyyy` defaults to today's date on the client.
`-p{m\|u\|h\|t\|f}`	Short print options: `c` - creation details. `m` - last_modification details. `u` - administrator name (create/modify). `h` - host name (create/modify). `t` - time (create/modify). `f` - field details.
`-f <filename>`	The name of the output file
`-h`	Display command help
`-q`	Quit.

Example Print modification details of all objects modified by administrator "aa":

query> -a -mu Bob -pm

Object Name:my_object

Last Modified by:Bob

Last Modified from:london

Last Modification time:Mon Jun 19 11:44:27 2000

Object Name:internal_ca

Last Modified by:Bob

Last Modified from:london

Last Modification time:Tue Jun 20 11:32:58 2000

A total of 2 objects match the query.