Formerly UAM table NCQRYDEF, Used to store the query definition. query definitions can be created by a user via the query designer.
Use cases: Dynamic groups reports
| Column Name | Column Datatype | Column Null Option | Column Comment |
| query_uuid | byte(16) | not null | PK , uuid of a query entity |
| domain_uuid | byte(16) | not null | UUID of the query where the query belongs to (ca_n-tier reference) |
| label | nvarchar(255) | with null | User defined and readable name |
| query_type | integer | with null | Type of query |
| query_cont | nvarchar(15000) | with null | Query contents (private format) |
| target_table | nvarchar(255) | with null | Name of db table |
| target_type | integer | with null | Type definition of the target |
| creation_user | nvarchar(255) | with null | Database user or component/process that created the record |
| creation_date | integer | with null | Creation data/time |
| last_update_user | nvarchar(255) | with null | Database user or component/process that updated the record |
| last_update_date | integer | with null | Last Change Date/Time |
| version_number | integer | with null | Last version number |
| auto_rep_version | date | with null |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| query_uuid | ca_group_def | query_uuid |
| query_uuid | polidef | query_uuid |
| query_uuid | ca_query_version | query_uuid |
| query_uuid | ca_query_result | query_uuid |