Queries for Push

For the push feature, the integration uses a collection of queries to gather CI attribute information from Universal CMDB and send it to the Service Manager system.

To access the out-of-the-box data push queries, navigate to Modeling > Modeling Studio, select Queries for Resource Type, and then navigate to the Root > Integration > Service Manager > Push folder.

If you want to change what CI types, Relationship types or attributes are part of the integration, you must also edit the integration queries to support your updated CI types, CI Relationship types and attributes.

Note The Service Manager Enhanced Generic Adapter has been introduced since UCMDB version 10.20. This adapter can coexist with an old XSLT adapter. In order to distinguish its queries from those of an XSLT adapter, all queries of the enhanced adapter are suffixed with 2.0.

Query name

Description

SM Local Printer Push 2.0 This query gathers CI attributes from printer CIs. It also gathers related CI attributes from the Node CI type.

SM Net Printer Push 2.0

This query gathers CI attributes from Node CI types whose NodeRole contains “printer.”

It also gathers related CI attributes from the following CI types through containers and links: IPAddress, Interface, CPU, FileSystem, DiskDevice, and Location.

SM Mainframe Push 2.0

This query gathers CI attributes from the following Node CI types: Mainframe Logical Partition, and Mainframe CPC.

It also gathers related CI attributes from the following CI types through containers and links: IPAddress, Interface, CPU, FileSystem, DiskDevice, and Location.

SM Mobile Device Push 2.0

This query gathers CI attributes from Node CI types whose NodeRole contains “pda_handheld.”

It also gathers related CI attributes from the following CI types through containers and links: IPAddress, Interface, CPU, FileSystem, DiskDevice, and Location.

SM Network Component Push 2.0

This query gathers CI attributes from Node CI types whose NodeRole contains router, adsl_modem, appletalk_gateway, bandwith_manager, cable_model, csu_dsu, ethernet, fddi, firewall, hub, kvm_switch, load_balancer, multicast_enabled_router, nat_router, token_ring, undefined_network_ component, voice_gateway, voice_switch, or vpn_gateway.

It also gathers related CI attributes from the following CI types through containers and links: IPAddress, Interface, CPU, FileSystem, DiskDevice, and Location.

SM Cluster Push 2.0

This query gathers CI attributes from the following Node CI type: ClusterResourceGroup.

It also gathers related CI attributes from the following CI types through containers and links: IPAddress, Interface, CPU, FileSystem, DiskDevice, Location, and Cluster.

SM Computer Push 2.0 This query gathers CI attributes from the node CI type with NodeRole containing “desktop”, “server”, “virtualized_system” or not set. It also gathers related CI attributes from the following CI types through containers and links: IPAddress, Interface, CPU, FileSystem, DiskDevice, and Location.

SM Storage Push 2.0

This query gathers CI attributes from the Node CI type whose NodeRole contains san_switch, san_gateway, san_router, or whose Display Name is Storage Array.

It also gathers related CI attributes from the following CI types through containers and links: IPAddress, Interface, CPU, FileSystem, DiskDevice, and Location.

SM Running Software Push 2.0 This query gathers CI attributes from Running Software CIs.

SM Switch Push 2.0

This query gathers CI attributes from the Node CI type whose NodeRole contains atm_switch, frame_relay_switch, or lan_switch.

It also gathers related CI attributes from the following CI types through containers and links: IPAddress, Interface, CPU, FileSystem, DiskDevice, and Location.

SM Service Element Push 2.0 This query gathers CI attributes from the Business Element CI type.
SM Business Service Push 2.0 This query gathers CI attributes from the Business Service CI type.
SM Layer2 Topology Relations Push 2.0 This query gathers relationships between the following components: Two or more nodes. The query includes compound relationships because the relationships can extend through a group.
SM Business Service Relations Push 2.0

This query gathers relationships between the following components:

  • Business Service and Running Software CIs
  • Business Service and Node CIs
  • Two or more Business Services

The query includes compound relationships because the relationships can extend through a group.

SM CRG Relations Push 2.0

This query gathers relationships between the following components: Node and Cluster Resource Group CIs.

The query includes compound relationships because the relationships can extend through a group.

SM Node Relations Push 2.0

This query gathers relationships between the following components:

  • Node and Printer CIs
  • Node and RunningSoftware CIs

The root class of the relationship is composition.

SM ASM Relations Push 2.0

This query gathers ASM discovered consumer-provider relationships that point from a Business Element CI to a Running Software CI.

Note This query does not support consumer-provider relationships between a Business Element CI and a Cluster CI.

Note To work correctly, this query requires the ASM Enhanced package to be deployed in UCMDB. This package is already included in UCMDB Content Pack (CP) 17.