Integration Result node

An Integration Result node is a record of the result of running SQL queries against a remote database. It does not contain the actual data returned by the queries, this is stored in the related SQL Result Row nodes.

An Integration Result node is related to either the Provider-Access-node for the endpoint at which the database resides, in the case of database integration, or the Discovery-Access-node used for the discovery of that database instance, in the case of database discovery.

Integration Result Lifecycle

The following section describes the scenarios in which an Integration Result is created,updated or destroyed.

Creation

An Integration Result node is created whenever a pattern makes a new request to a SQL database.

Update

Integration Result nodes are never updated.

Removal

Integration Results are removed when the related Provider-Access-node or Discovery-Access-node is destroyed.

Attributes and relationships of the IntegrationResult node

The attributes of the IntegrationResult node are described in the following table:

UI Name Attribute Name and Type	Description
Result Description label : string	A textual summary of the request made
Integration Point Name integration_point_name : string	Name of IntegrationPoint providing credential
Credential credential_id : string	Credential used to perform request
Name of Performed Query query_name : string	Name of request performed
Hash _hash : string	A hash that uniquely identifies this request
Hard Failure hard_failure : boolean	True if the result is classed as a hard failure
Cancelled cancelled : boolean	True if command was cancelled
Provider provider : string	The name of the provider that handled this request to an integration
Session Identifier session_id : string	Identify SessionResults created by single request
Discovery Method discovery_method : string	Discovery method
Discovery Duration discovery_duration : int	Time in seconds spent in discovery
Request Time request_time : date	When this request was made
Reason failure_reason : string	Reason for state or failure, if any
Failure Cause failure_cause : string	Extra details, if any, on reason for failure
Details details : string	Any other details
Not shown in UI command_status_failure : boolean	Flag that this node has command failures linked to it
Not shown in UI method_failure : boolean	Flag that this node has script failures linked to it
Not shown in UI method_success : string	The name of the script that succeeded in getting this data
Access Method access_method : string	The access method used by the script that succeeded in getting this data
Processing Messages processing_messages : list:string	Optional list of processing messages
Skipped skipped : boolean	Flag that this request was skipped
Requesting Pattern requesting_pattern : string	The name of the pattern that requested this data

The relationships of the IntegrationResult node are described in the following table:

UI Name	Relationship	Description
Data Source Access	DiscoveryResult: DiscoveryAccessResult: DiscoveryAccess: DataSourceAccess	Related Data Source Access
Discovery Access	DiscoveryResult: DiscoveryAccessResult: DiscoveryAccess: DiscoveryAccess	Related Discovery Access
Provider Access	DiscoveryResult: DiscoveryAccessResult: DiscoveryAccess: ProviderAccess	Related Provider Access
SQL Result Rows	List: List: Member: SQLResultRow	SQL Result Rows in the list
vSphere data items	List: List: Member: vSphereIntegrationResult	vSphere data items in the list
Requesting Pattern	DiscoveryResult: Request: Pattern: Pattern	Pattern from which the request to retrieve this information originated (deprecated)
Data Source Access	DiscoveryResult: DiscoveryAccessResult: DiscoveryAccess: DataSourceAccess	Related Data Source Access
Discovery Access	DiscoveryResult: DiscoveryAccessResult: DiscoveryAccess: DiscoveryAccess	Related Discovery Access
Provider Access	DiscoveryResult: DiscoveryAccessResult: DiscoveryAccess: ProviderAccess	Related Provider Access
Command Failures	DiscoveryResult: Metadata: Detail: CommandFailure	Command Failures
Script Failures	DiscoveryResult: Metadata: Detail: ScriptFailure	Script Failures
Requested Discovery Access	RequestSource: Request: DiscoveryAccess: DiscoveryAccess	Discovery requested during discovery of another device
Requesting Pattern	DiscoveryResult: Request: Pattern: Pattern	Pattern from which the request to retrieve this information originated (deprecated)
Not shown in UI (Relationship)	DiscoveryResult: Request: PatternExecution: PatternTrigger	Pattern Execution Trigger which requested retrieval of this information
Requesting Discovery Access	DiscoveryResult: Request: RequestSource: DiscoveryAccess	Requesting Discovery Access
Requesting External Event	DiscoveryResult: Request: RequestSource: ExternalEvent	Requesting External Event