Inheritance diagram for MSSQL Database
| Display Name | MSSQL Database |
|---|---|
| Name | sqldatabase |
| Description | SQL Data Base from Microsoft |
| Attributes defined for MSSQL Database | |||||||
|---|---|---|---|---|---|---|---|
| Name | Display Name | Type | Default Value | Description | Factory | Key | Hidden |
| BODY_ICON | string | sqldatabase | true | false | true | ||
| db_size | Size | double | Database size in MB | true | false | false | |
| FAMILY_ICON | string | db | true | false | true | ||
| mirror_server_name | Mirror Server Name | string | Name of the partner server whose copy of the database is currently the mirror database. | true | false | false | |
| principal_server_name | Principal Server Name | string | Name of partner server whose copy of the database is currently the principal database. | true | false | false | |
| Attributes defined for Database Schema | |||||||
| Name | Display Name | Type | Default Value | Description | Factory | Key | Hidden |
| created_at | CreatedAt | date | The creation date of the database | true | false | false | |
| string[100] | The creation date of the database | true | false | false | |||
| Attributes defined for Database Resource | |||||||
| Name | Display Name | Type | Default Value | Description | Factory | Key | Hidden |
| BODY_ICON | string | databaseresource | true | false | true | ||
| FAMILY_ICON | string | db | true | false | true | ||
| Attributes defined for Application Resource | |||||||
| Name | Display Name | Type | Default Value | Description | Factory | Key | Hidden |
| applicationresource_type | Application Resource Type | string[100] | Application Resource Type | true | false | false | |
| BODY_ICON | string | general | true | false | true | ||
| FAMILY_ICON | string | hostresource | true | false | true | ||
| layer | layer_enum | software | true | false | false | ||
| resource_path | Resource Path | string[512] | Resource Path | true | false | false | |
| Attributes defined for InfrastructureElement | |||||||
| Name | Display Name | Type | Default Value | Description | Factory | Key | Hidden |
| BODY_ICON | string | system | true | false | true | ||
| codepage | CodePage | string[50] | System suported CodePage | true | false | true | |
| credentials_id | Reference to the credentials dictionary entry | string | Reference to the credentials dictinary entry | true | false | true | |
| language | Language | string[50] | System suported language | true | false | true | |
| zone_list | Zone List | string_list[256] | List of management zones in which the CI is discovered | true | false | false | |
| Attributes defined for ConfigurationItem | |||||||
| Name | Display Name | Type | Default Value | Description | Factory | Key | Hidden |
| ack_cleared_time | long | true | false | true | |||
| ack_id | string[80] | true | false | true | |||
| bit_position | Bit Position | integer | true | false | true | ||
| bitmap_id | Bitmap ID | integer | true | false | true | ||
| BODY_ICON | string | it_world | true | false | true | ||
| string[50] | City location | true | false | true | |||
| classification | classification_enum | true | false | false | |||
| contextmenu | Context Menu | string_list[100] | Context menu | true | false | true | |
| string[50] | Country or province location | true | false | true | |||
| data_tags | Tags | json[4000] | A tag is a label assigned to a resource.Each tag consists of a key and a value. | true | false | false | |
| discovery_state | Discovery State | discovery_state_enum | State of UD discovery | true | false | false | |
| is_save_persistency | Store KPI History For Over Time Reports | boolean | false | Store KPI history for over time reports | true | false | true |
| layer | layer_enum | true | false | false | |||
| metaphase | Meta Phase | string[50] | Meta Phase of a CI in SMAX. The attribute is owned by SMAX exclusively | true | false | false | |
| sd_type | SD Type | string[32] | true | false | false | ||
| string[50] | State location | true | false | true | |||
| track_changes | Track Configuration Changes | boolean | false | Track configuration changes | true | false | true |
| Attributes defined for Managed Object | |||||||
| Name | Display Name | Type | Default Value | Description | Factory | Key | Hidden |
| TenantOwner | Owner Tenant | string[32] | The Tenant Owner ID | true | false | false | |
| TenantsUses | Consumer Tenants | string_list | The IDs of the Tenants who are associated with the CI | true | false | false | |
| Attributes defined for Object | |||||||
| Name | Display Name | Type | Default Value | Description | Factory | Key | Hidden |
| document_list | Documents | string | Documents | true | false | true | |
| MENU | xml | true | false | true | |||
| Attributes defined for Data | |||||||
| Name | Display Name | Type | Default Value | Description | Factory | Key | Hidden |
| adminstates_enum | 0 | Admin State | true | false | true | ||
| data_allow_auto_discovery | Allow CI Update | boolean[250] | true | true | false | false | |
| changestates_enum | 0 | Change State | true | false | true | ||
| boolean | false | Change State | true | false | true | ||
| changestates_enum | 0 | Change State | true | false | true | ||
| data_externalid | External ID | string[50] | external source id: snmp index, data sources index etc. | true | false | true | |
| data_note | Note | string[250] | true | false | false | ||
| operationstates_enum | 0 | Operation State | true | false | true | ||
| boolean | false | Operation State | true | false | true | ||
| operationstates_enum | 0 | Operation State | true | false | true | ||
| data_origin | Origin | string[100] | true | false | false | ||
| data_source | Created By | string[512] | true | false | false | ||
| teststates_enum | 0 | Test State | true | false | true | ||
| boolean | false | Test State | true | false | true | ||
| teststates_enum | 0 | Test State | true | false | true | ||
| data_updated_by | LastModifiedBy | string[512] | true | false | false | ||
| description | Description | string[1000] | Description | true | false | false | |
| digest | Digest | string[40] | true | false | true | ||
| display_label | Display Label | string[900] | Used as calc attribute for display | true | false | false | |
| MENU | xml | true | false | true | |||
| name | Name | string[900] | true | false | false | ||
| user_label | User Label | string[900] | Used as user label | true | false | false | |
| Attributes defined for Root | |||||||
| Name | Display Name | Type | Default Value | Description | Factory | Key | Hidden |
| BODY_ICON | string | general | true | false | true | ||
| calculated_id | Calculated ID | bytes[16] | Calculated ID | true | false | true | |
| create_time | Created Time | date | When was this CI created | true | false | false | |
| FAMILY_ICON | string | true | false | true | |||
| global_id | Global Id | string[32] | A globally unique identifier for the entity represented by the object | true | false | false | |
| global_id_scope | string | Default | true | false | true | ||
| last_discovered_by | LastDiscoveredBy | string[512] | Who discovered this CI | true | false | false | |
| last_discovered_by_probe | LastDiscoveredByProbe | string | Which probe discovered this CI | true | false | false | |
| last_discovered_time | LastDiscoveredTime | date | When was this CI discovered | true | false | false | |
| last_modified_time | LastModifiedTime | date | When was this CI last updated | true | false | false | |
| root_actualdeletetime | Actual Delete Time | date | When will this CI be deleted | true | false | true | |
| root_actualdeletionperiod | Actual Deletion Period | integer | 40 | What is the period after the CI will be deleted | true | false | false |
| root_candidatefordeletetime | Candidate For Deletion Time | date | When will this CI be warned about deleting | true | false | true | |
| root_class | CI Type | string[100] | Class name of the CI | true | false | true | |
| root_container | Container | string[32] | Container CI of this CI | true | false | false | |
| root_deletioncandidateperiod | Deletion Candidate Period | integer | 20 | What is the period after the CI will be candidate for delete | true | false | false |
| root_enableageing | Enable Aging | boolean | false | Is aging enabled | true | false | false |
| root_iconproperties | string[100] | true | false | true | |||
| root_iscandidatefordeletion | Is Candidate For Deletion | boolean | false | Is candidate for deletion | true | false | false |
| root_lastaccesstime | Last Access Time | date | When was this CI last accessed | true | false | false | |
| string[2] | true | false | true | ||||
Valid direct incoming and outgoing relations defined on MSSQL Database
| Relations defined for MSSQL Database | |||
|---|---|---|---|
| From | To | Type | Description |
| MSSQL Database | ConfigurationDocument | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| MSSQL Database | DBA Object | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| MSSQL Database | Process | DB Client | |
| MSSQL Database | SQL Alert | Deployed | |
| MSSQL Database | SQL Backup | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| MSSQL Database | MSSQL Database | Replicated | |
| MSSQL Database | SQL File | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| MSSQL Database | SQL Performance Monitor | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| MSSQL Database | SQL Server Publication | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| MSSQL Database | SQL Server Subscription | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| DB User | MSSQL Database | Ownership | |
| JdbcDataSource | MSSQL Database | Dependency | represents a dependency between 2 objects |
| MSCS Resource Group | MSSQL Database | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| MSCS Resource Group | MSSQL Database | Membership | |
| SQL Server | MSSQL Database | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| Sql Server Distributor | MSSQL Database | Usage | Monitor system Relationships |
| SQL Server Maintenance Plan | MSSQL Database | DB Link | |
| Relations defined for Database Schema | |||
| From | To | Type | Description |
| DB User | Database Schema | Ownership | |
| HanaDatabase | Database Schema | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| JdbcDataSource | Database Schema | Dependency | represents a dependency between 2 objects |
| Relations defined for Database Resource | |||
| From | To | Type | Description |
| Database | Database Resource | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| Oracle Database | Database Resource | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| Relations defined for Application Resource | |||
| From | To | Type | Description |
| RunningSoftware | Application Resource | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| Relations defined for InfrastructureElement | |||
| From | To | Type | Description |
| BusinessActivity | InfrastructureElement | Usage | Monitor system Relationships |
| BusinessApplication | InfrastructureElement | Containment | |
| BusinessApplication | InfrastructureElement | Usage | Monitor system Relationships |
| BusinessElement | InfrastructureElement | Usage | Monitor system Relationships |
| BusinessTransaction | InfrastructureElement | Usage | Monitor system Relationships |
| CiCollection | InfrastructureElement | Usage | Monitor system Relationships |
| ClusterResourceConfig | InfrastructureElement | Dependency | represents a dependency between 2 objects |
| Service | InfrastructureElement | Containment | |
| Service | InfrastructureElement | Usage | Monitor system Relationships |
| Relations defined for ConfigurationItem | |||
| From | To | Type | Description |
| ConfigurationItem | Automation Flow Execution | Includes | This relationship connects two CIs, one of which is included into another. A child CI can be moved to another parent, but when the parent is deleted, the child will be deleted as well, except if a second includes link exist on it already. Moving of a child CI possible by creation of new link to another parent and deletion of the first one. |
| ConfigurationItem | ConfigurationItem | ConsumerProvider | |
| ConfigurationItem | Kpi | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| ConfigurationItem | Outage | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| ConfigurationItem | PolicyResult | Aggregation | |
| ConfigurationItem | ScheduledDowntime | Connection | |
| ConfigurationItem | ServiceConnectionPoint | Composition | Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed |
| ConfigurationItem | ServiceConnectionPoint | Ownership | |
| DefectsFilter | ConfigurationItem | Containment | |
| ApplicationSystem | ConfigurationItem | Aggregation | |
| Asset | ConfigurationItem | Connection | |
| CiCollection | ConfigurationItem | Containment | |
| CiCollection | ConfigurationItem | Membership | |
| ItProcessRecord | ConfigurationItem | Connection | |
| ItProcessRecord | ConfigurationItem | Membership | |
| Location | ConfigurationItem | Membership | |
| Tenant | ConfigurationItem | Connection | |
| Relations defined for Managed Object | |||
| From | To | Type | Description |
| Managed Object | History Change | History Link | |
| Tenant | Managed Object | Connection | |
Combined inheritance and relation diagram for MSSQL Database
| Adapters providing CIs of type MSSQL Database | ||
|---|---|---|
| Adapter Name | Description | Adapter Type |
| MS SQL Server topology by SQL | The job discovers MS SQL Server topology. | Discovery |
| MS SQL Server topology by SQL - Cloud Service | The job discovers cloud MS SQL Server service topology. | Discovery |
| Adapters providing CIs of type Database Schema | ||
| Adapter Name | Description | Adapter Type |
| HanaDb Topology by SQL | Discovers HanaDB instances and topology using SQL Connections | Discovery |
| HanaDb by shell | Discover HanaDb instances | Discovery |
| J2EE Inactive WebSphere Topology Discovery by Shell | This adapter discovers WebSphere J2EE environment and components by shell only when the WebSphere Application Server is inactive. | Discovery |
| MaxDb Topology by SQL | Discovers MaxDB instances and topology using SQL Connections | Discovery |
| MaxDb by Shell | Discovers MaxDB instances and topology | Discovery |
| Weblogic J2EE Topology Discovery by Shell | Discovers WebLogic J2EE environment and components by shell. Supported versions: 8.1, 9.0, 9.1, 9.2, 10 | Discovery |
| Websphere J2EE Topology Discovery by Shell | This adapter discovers WebSphere J2EE environment and components by shell. | Discovery |
| hp_nonstop_topology_by_shell | HPE NonStop topology discovery. | Discovery |
| Adapters providing CIs of type Database Resource | ||
| Adapter Name | Description | Adapter Type |
| IIS Applications by NTCMD or UDA or PowerCmd | This adapter discovers Microsoft Internet Information Services (IIS). | Discovery |
| Adapters providing CIs of type ConfigurationItem | ||
| Adapter Name | Description | Adapter Type |
| Import from CSV | Imports data from a CSV file into CMDB using mapping of the CSV file columns to CIT attributes. Mapping is defined by the following parameters: ciType: to define the CIT name which you want to create, mappingString: to define the mapping of the CIT attributes to the CSV file columns. Mapping file is used for more complex mapping definitions. Mapping file name is specified by 'mappingFile' parameter. | Integration |
| Import from DB | Imports data from an external database into CMDB using mapping of table columns to CIT attributes. Mapping is defined by the following parameters: ciType: to define the CIT name which you want to create, mappingString: to define the mapping of the CIT attributes to the table columns Mapping file is used for more complex mapping definitions. Mapping file name is specified by 'mappingFile' parameter. A SQL 'select' query is generated automatically and selects all columns in specified table, which defined by parameter: tableName In advanced cases you can specify custom SQL query. | Integration |
| Import from properties file | Imports data from a Properties file into CMDB, using mapping of the CSV file columns to CIT attributes This mapping is usually defined by the setting adapter parameters: ciType: to define the CIT name which you want to create, mappingString: to define the mapping of the Properties attributes to the CSV file columns In cases you need more complex mapping abilities, such as conversion of the strings contained in Properties file to the appropriate type of CMDB object's attribute, you should use the mapping XML configuration file specified by the mappingFile parameter. | Integration |
| SCCM Installed Software Integration | This adapter queries the records from SCCM database and recognizes it as install software by UD SAI | Integration |
| Import from Excel Workbook | Imports data from Excel Workbooks. Parses through multiple worksheet XLS files. Uses 'CIImports.xls' (default) file to import data. | Integration |
| Adapters providing CIs of type Object | ||
| Adapter Name | Description | Adapter Type |
| ALMAdapter | Federate defects from ALM | Integration |
| AMGenericAdapter | This adapter pushes/populates data between UCMDB and Asset Manager. Follow the Quick Start guide supplied with the AM Generic Adapter documentation before creating this integration point. | Integration |
| Application Portfolio Management Push Adapter | This adapter pushes data from UCMDB to HP Application Portfolio Management. Follow the APM Push Adapter documentation included in the HP UCMDB Discovery and Integration Content Guide before creating this integration point. | Integration |
| UCMDB API Population | Allows defining Reconciliation Priority for API Data In flows | Integration |
| Data Push into Atrium | Pushes CIs and relationships to BMC Atrium | Integration |
| AutomationFlowAdapter | Provide API to Operation Orchestration | Integration |
| BSMKpiAdapter | Federate KPIs from BSM | Integration |
| CA CMDB | Pushes CIs and relationships to CA CMDB | Integration |
| UCMDB 10.x and later | Used for Populating and Federating data from a remote UCMDB 10.x(or later) and for Pushing to a remote UCMDB 10.x(or later) | Integration |
| UCMDB 9.x | Used for Populating and Federating data from a remote UCMDB 9.x server and for Pushing to a remote UCMDB 9.x | Integration |
| UCMDB History Adapter [local instance only] | Used to federated data from the UCMDB's History | Integration |
| UCMDB to SaaS | Used for Pushing CIs and Relationships from an on-premises UCMDB 2019.02(or later) to Micro Focus SaaS CMS | Integration |
| Push Adapter DB Example | Push data into Oracle \ MSSQL database | Integration |
| GenericDBAdapter | An example Adapter that uses the GDB-Framework | Integration |
| IAM UI Push Adapter | Push IAM Universal Inventory data into MSSQL database on-premises or on cloud-based Azure. | Integration |
| Java_Adapter_Template | Adapter Description | Integration |
| Kafka Push Adapter 2019.05 | Push function for Kafka Push Adapter | Integration |
| Local State Push Adapter | Used for populating data between the states of the same UCMDB Server | Integration |
| Pulsar Push Adapter | Push function for Pulsar Push Adapter | Integration |
| Push Adapter | Push Adapter | Integration |
| Remedyforce Push Integration | Remedyforce Push Integration | Integration |
| System Center Configuration Manager | Uses the GDB-Framework to Populate and Federate data from a System Center Configuration Manager. The adapter is also backward compatible with the SMS DB | Integration |
| Service Manager 9.41 | Discovery Pattern Description | Integration |
| Service Manager 9.xx | Discovery Pattern Description | Integration |
| Service Manager Enhanced Generic Adapter | Push and Populate CI data between UCMDB and Service Manager | Integration |
| ServiceNow Enhanced Generic Adapter | Push, Populate and Federation of CI data between UCMDB and ServiceNow | Integration |
| UCMDB to XML | Export data into XML from UCMDB | Integration |
© Copyright 2018 Micro Focus or one of its affiliates