CI Class SQL Job Step

Inheritance diagram for SQL Job Step

Summary

Display NameSQL Job Step
Namesqljobstep
DescriptionAn action that the job takes on a database or a server. Every job must have at least one job step.

Attributes

Attributes defined for SQL Job Step
NameDisplay NameTypeDefault ValueDescriptionFactoryKeyHidden
BODY_ICONstringcomponenttruefalsetrue
FAMILY_ICONstringdbtruefalsetrue
sqljobstep_instanceidInstance IDintegerUnique identifier for the row.truefalsefalse
sqljobstep_jobidJob IDstring[100]Job ID.truefalsefalse
sqljobstep_messageMessagestring[1024]Text, if any, of a SQL Server error.truefalsefalse
sqljobstep_rundurationExecution Timestring[100]Elapsed time in the execution of the job or step in HHMMSS format.truefalsefalse
sqljobstep_runstatusStatusintegerStatus of the job execution: 0 = Failed 1 = Succeeded 2 = Retry 3 = Canceled 4 = In progresstruefalsefalse
sqljobstep_runtimeCompletion TimeintegerTime the job or step completed.truefalsefalse
sqljobstep_stepidStep IDintegerID of the step in the job.truetruefalse
Attributes defined for Database Resource
NameDisplay NameTypeDefault ValueDescriptionFactoryKeyHidden
BODY_ICONstringdatabaseresourcetruefalsetrue
FAMILY_ICONstringdbtruefalsetrue
Attributes defined for Application Resource
NameDisplay NameTypeDefault ValueDescriptionFactoryKeyHidden
applicationresource_typeApplication Resource Typestring[100]Application Resource Typetruefalsefalse
BODY_ICONstringgeneraltruefalsetrue
FAMILY_ICONstringhostresourcetruefalsetrue
layerlayer_enumsoftwaretruefalsefalse
resource_pathResource Pathstring[512]Resource Pathtruefalsefalse
Attributes defined for InfrastructureElement
NameDisplay NameTypeDefault ValueDescriptionFactoryKeyHidden
BODY_ICONstringsystemtruefalsetrue
codepageCodePagestring[50]System suported CodePagetruefalsetrue
credentials_idReference to the credentials dictionary entrystringReference to the credentials dictinary entrytruefalsetrue
languageLanguagestring[50]System suported languagetruefalsetrue
zone_listZone Liststring_list[256]List of management zones in which the CI is discoveredtruefalsefalse
Attributes defined for ConfigurationItem
NameDisplay NameTypeDefault ValueDescriptionFactoryKeyHidden
ack_cleared_timelongtruefalsetrue
ack_idstring[80]truefalsetrue
bit_positionBit Positionintegertruefalsetrue
bitmap_idBitmap IDintegertruefalsetrue
BODY_ICONstringit_worldtruefalsetrue
ci_lifecycle_stateCI Lifecycle Statelifecycle_state_enumThe attribute indicates the overall Lifecycle state of a CI when using enhanced lifecycle solutiontruefalsefalse
cityCitystring[50]City locationtruefalsetrue
classificationclassification_enumtruefalsefalse
contextmenuContext Menustring_list[100]Context menutruefalsetrue
countryCountry or Provincestring[50]Country or province locationtruefalsetrue
data_tagsTagsjson[4000]A tag is a label assigned to a resource.Each tag consists of a key and a value.truefalsefalse
discovery_stateDiscovery Statediscovery_state_enumState of UD discoverytruefalsefalse
is_save_persistencyStore KPI History For Over Time ReportsbooleanfalseStore KPI history for over time reportstruefalsetrue
layerlayer_enumtruefalsefalse
metaphaseMeta Phasestring[50]Meta Phase of a CI in SMAX. The attribute is owned by SMAX exclusivelytruefalsefalse
monitor_stateMonitor Statestring[50]Monitor State of a CI in OpsB. The attribute is owned by OpsB exclusively.truefalsefalse
provision_stateProvision Statestring[50]Provision State of a CI in HCMX. The attribute is owned by HCMX exclusively.truefalsefalse
regulatory_detailsRegulatory Detailsstring[1000][Summary]This attribute is used by DCA, it represents the regulatory details. [Collection]The value is pushed by DCA via CMSGatewaytruefalsefalse
regulatory_statusRegulatory Statusregulatory_status_enum[Summary]This attribute is used by DCA, it represents the regulatory status. [Collection]The value is pushed by DCA via CMSGatewaytruefalsefalse
sd_typeSD Typestring[32]truefalsefalse
stateStatestring[50]State locationtruefalsetrue
track_changesTrack Configuration ChangesbooleanfalseTrack configuration changestruefalsetrue
vulnerability_detailsVulnerability Detailsstring[1000][Summary]This attribute is used by DCA, it represents the vulnerability details. [Collection]The value is pushed by DCA via CMSGatewaytruefalsefalse
vulnerability_statusVulnerability Statusvulnerability_status_enum[Summary]This attribute is used by DCA, it represents the vulnerability status. [Collection]The value is pushed by DCA via CMSGatewaytruefalsefalse
Attributes defined for Managed Object
NameDisplay NameTypeDefault ValueDescriptionFactoryKeyHidden
TenantOwnerOwner Tenantstring[32]The Tenant Owner IDtruefalsefalse
TenantsUsesConsumer Tenantsstring_listThe IDs of the Tenants who are associated with the CItruefalsefalse
Attributes defined for Object
NameDisplay NameTypeDefault ValueDescriptionFactoryKeyHidden
document_listDocumentsstringDocumentstruefalsetrue
MENUxmltruefalsetrue
Attributes defined for Data
NameDisplay NameTypeDefault ValueDescriptionFactoryKeyHidden
data_adminstateAdmin Stateadminstates_enum0Admin Statetruefalsetrue
data_allow_auto_discoveryAllow CI Updateboolean[250]truetruefalsefalse
data_changecorrstateChange Corr Statechangestates_enum0Change Statetruefalsetrue
data_changeisnewChange Is NewbooleanfalseChange Statetruefalsetrue
data_changestateChange Statechangestates_enum0Change Statetruefalsetrue
data_externalidExternal IDstring[300]external source id: snmp index, data sources index etc.truefalsetrue
data_noteNotestring[250]truefalsefalse
data_operationcorrstateOperation Corr Stateoperationstates_enum0Operation Statetruefalsetrue
data_operationisnewOperation Is NewbooleanfalseOperation Statetruefalsetrue
data_operationstateOperation Stateoperationstates_enum0Operation Statetruefalsetrue
data_originOriginstring[100]truefalsefalse
data_sourceCreated Bystring[512]truefalsefalse
data_testcorrstateTest Corr Stateteststates_enum0Test Statetruefalsetrue
data_testisnewTest Is NewbooleanfalseTest Statetruefalsetrue
data_teststateTest Stateteststates_enum0Test Statetruefalsetrue
data_updated_byLastModifiedBystring[512]truefalsefalse
descriptionDescriptionstring[1000]Descriptiontruefalsefalse
digestDigeststring[40]truefalsetrue
display_labelDisplay Labelstring[900]Used as calc attribute for displaytruefalsefalse
MENUxmltruefalsetrue
nameNamestring[900]truefalsefalse
user_labelUser Labelstring[900]Used as user labeltruefalsefalse
Attributes defined for Root
NameDisplay NameTypeDefault ValueDescriptionFactoryKeyHidden
BODY_ICONstringgeneraltruefalsetrue
calculated_idCalculated IDbytes[16]Calculated IDtruefalsetrue
create_timeCreated TimedateWhen was this CI createdtruefalsefalse
FAMILY_ICONstringtruefalsetrue
global_idGlobal Idstring[32]A globally unique identifier for the entity represented by the objecttruefalsefalse
global_id_scopestringDefaulttruefalsetrue
last_discovered_byLastDiscoveredBystring[512]Who discovered this CItruefalsefalse
last_discovered_by_probeLastDiscoveredByProbestringWhich probe discovered this CItruefalsefalse
last_discovered_timeLastDiscoveredTimedateWhen was this CI discoveredtruefalsefalse
last_modified_timeLastModifiedTimedateWhen was this CI last updatedtruefalsefalse
root_actualdeletetimeActual Delete TimedateWhen will this CI be deletedtruefalsetrue
root_actualdeletionperiodActual Deletion Periodinteger40What is the period after the CI will be deletedtruefalsefalse
root_candidatefordeletetimeCandidate For Deletion TimedateWhen will this CI be warned about deletingtruefalsetrue
root_classCI Typestring[100]Class name of the CItruefalsetrue
root_containerContainerstring[32]Container CI of this CItruefalsefalse
root_deletioncandidateperiodDeletion Candidate Periodinteger20What is the period after the CI will be candidate for deletetruefalsefalse
root_enableageingEnable AgingbooleanfalseIs aging enabledtruefalsefalse
root_iconpropertiesstring[100]truefalsetrue
root_iscandidatefordeletionIs Candidate For DeletionbooleanfalseIs candidate for deletiontruefalsefalse
root_lastaccesstimeLast Access TimedateWhen was this CI last accessedtruefalsefalse
root_systemSystemstring[2]truefalsetrue

Valid Relations

Valid direct incoming and outgoing relations defined on SQL Job Step

Relations defined for SQL Job Step
FromToTypeDescription
SQL JobSQL Job StepCompositionRepresents 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 Database Resource
FromToTypeDescription
DatabaseDatabase ResourceCompositionRepresents 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 DatabaseDatabase ResourceCompositionRepresents 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
FromToTypeDescription
RunningSoftwareApplication ResourceCompositionRepresents 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
FromToTypeDescription
BusinessActivityInfrastructureElementUsageMonitor system Relationships
BusinessApplicationInfrastructureElementContainment
BusinessApplicationInfrastructureElementUsageMonitor system Relationships
BusinessElementInfrastructureElementUsageMonitor system Relationships
BusinessTransactionInfrastructureElementUsageMonitor system Relationships
CiCollectionInfrastructureElementUsageMonitor system Relationships
ClusterResourceConfigInfrastructureElementDependencyrepresents a dependency between 2 objects
ServiceInfrastructureElementContainment
ServiceInfrastructureElementUsageMonitor system Relationships
Relations defined for ConfigurationItem
FromToTypeDescription
ConfigurationItemConfigurationItemConsumerProvider
ConfigurationItemKpiCompositionRepresents 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
ConfigurationItemOutageCompositionRepresents 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
ConfigurationItemPolicyResultAggregation
ConfigurationItemScheduledDowntimeConnection
ConfigurationItemServiceConnectionPointCompositionRepresents 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
ConfigurationItemServiceConnectionPointOwnership
ApplicationSystemConfigurationItemAggregation
AssetConfigurationItemConnection
CiCollectionConfigurationItemContainment
CiCollectionConfigurationItemMembership
ItProcessRecordConfigurationItemConnection
ItProcessRecordConfigurationItemMembership
LocationConfigurationItemMembership
TenantConfigurationItemConnection
Relations defined for Managed Object
FromToTypeDescription
Managed ObjectHistory ChangeHistory Link
TenantManaged ObjectConnection

Combined inheritance and relation diagram for SQL Job Step

Potential Data Providers

Adapters providing CIs of type Database Resource
Adapter NameDescriptionAdapter Type
IIS Applications by NTCMD or UDA or PowerCmdThis adapter discovers Microsoft Internet Information Services (IIS).Discovery
Adapters providing CIs of type ConfigurationItem
Adapter NameDescriptionAdapter 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 IntegrationThis adapter queries the records from SCCM database and recognizes it as install software by UD SAIIntegration
Import from Excel WorkbookImports 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 NameDescriptionAdapter Type
AMGenericAdapterThis 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
APM Push AdapterThis adapter pushes data from UCMDB to HP APM. Follow the APM Push Adapter documentation included in the HP UCMDB Discovery and Integration Content Guide before creating this integration point.Integration
UCMDB API PopulationAllows defining Reconciliation Priority for API Data In flowsIntegration
Data Push into AtriumPushes CIs and relationships to BMC AtriumIntegration
BSM Kpi Adapter (deprecated)Federate KPIs from BSMIntegration
CA CMDBPushes CIs and relationships to CA CMDBIntegration
UCMDB 10.x and laterUsed 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 (deprecated)Used for Populating and Federating data from a remote UCMDB 9.x server and for Pushing to a remote UCMDB 9.xIntegration
UCMDB History Adapter [local instance only]Used to federated data from the UCMDB's HistoryIntegration
UCMDB to SaaSUsed for Pushing CIs and Relationships from an on-premises UCMDB 2019.02(or later) to Micro Focus SaaS CMSIntegration
Push Adapter DB ExamplePush data into Oracle \ MSSQL databaseIntegration
GenericDBAdapterAn example Adapter that uses the GDB-FrameworkIntegration
IAM UI Push Adapter (deprecated)Push IAM Universal Inventory data into MSSQL database on-premises or on cloud-based Azure.Integration
Java_Adapter_TemplateAdapter DescriptionIntegration
Kafka Push Adapter 2019.05 (deprecated)Push function for Kafka Push AdapterIntegration
Pulsar Push AdapterPush function for Pulsar Push AdapterIntegration
Push AdapterPush AdapterIntegration
Remedyforce Push IntegrationRemedyforce Push IntegrationIntegration
System Center Configuration ManagerUses the GDB-Framework to Populate and Federate data from a System Center Configuration Manager. The adapter is also backward compatible with the SMS DBIntegration
Service Manager 9.41Discovery Pattern DescriptionIntegration
Service Manager Enhanced Generic AdapterPush and Populate CI data between UCMDB and Service ManagerIntegration
ServiceNow Enhanced Generic AdapterPush, Populate and Federation of CI data between UCMDB and ServiceNowIntegration
UCMDB to XMLExport data into XML from UCMDBIntegration

© Copyright 2018 Micro Focus or one of its affiliates