Available Trillium Parameters for ODBC, by Query
| Queries | Supported Parameters |
|---|---|
| entity | eid |
| entity_name (entity_ID) | |
| nview_name=’view_attribute_null_values_rows’ |
add_key aid eid max_rows |
|
nview_name=’view_br_fail’ |
add_key aid abr ebr eid max_rows |
| nview_name=’view_entity_fail’ |
eid max_per_rule max_rows |
| nview_name=’view_rows‘ |
add_key eid max_rows |
| show_all_br |
eid generations pid show_disabled tsa |
| show_attribute_names |
aid eid |
| show_attribute_trend | pid |
|
show_baseline |
baseline |
| show_br_groups |
ebr eid generations pid tsa |
| show_br_metadata |
eid generations pid tsa |
| show_entity_member_attributes |
eid generations pid tsa |
| show_entity_metadata |
eid generations pid tsa |
| show_entity_names | eid |
| show_entity_trend | pid |
|
show_failing_br |
eid |
| show_project |
pid proj_type |
| show_project_failing_br | N/A |
| show_project_membership |
Project ID Entity ID |
| show_tsq_project_names | eid |
| TS_test |
N/A |
| view_attribute_decimal_values |
add_key aid eid max_rows |
|
view_attribute_distinct_values |
add_key aid eid max_rows |
| view_attribute_integer_values |
add_key aid eid max_rows |
|
view_attribute_string_values |
add_key aid eid max_rows |
|
view_attribute_values |
add_key aid eid max_rows proj_type |
|
view_attribute_values_discovered_dependencies |
add_key aid eid max_rows |
|
view_attribute_values_discovered_joins |
add_key aid eid max_rows |
|
view_attribute_values_discovered_keys |
add_key aid eid max_rows |
|
view_attribute_values_mask |
add_key aid eid max_rows |
|
view_attribute_values_metaphone |
add_key aid eid max_rows |
|
view_attribute_values_pattern |
add_key aid eid max_rows |
|
view_attribute_values_permanent_dependencies |
add_key aid eid max_rows |
|
view_attribute_values_permanent_joins |
add_key aid eid max_rows |
|
view_attribute_values_permanent_keys |
add_key aid eid max_rows |
|
view_attribute_values_soundex |
add_key aid eid max_rows |
|
view_entity_values_discovered_dependencies |
add_key eid generations max_rows pid tsa |
|
view_entity_values_discovered_joins |
add_key eid generations max_rows pid tsa |
|
view_entity_values_discovered_keys |
add_key eid generations max_rows pid tsa |
|
view_entity_values_permanent_dependencies |
add_key eid generations max_rows pid tsa |
|
view_entity_values_permanent_joins |
add_key eid generations max_rows pid tsa |
|
view_entity_values_permanent_keys |
add_key eid generations max_rows pid tsa |
|
view_notes |
SUBJECT METRICS CLASS SUBCLASS PROJECT_IMPACT BUSINESS_IMPACT CREATED_BY CREATED_DATE TEXT |