Queries for Population

For CI/CI Relationship population, the integration does not need queries to save CI/CI Relationship attribute information to Universal CMDB; however in the population configuration file the following query names are mapped to relevant population XSL transformation files (see the following table).

Queries for population
Query name Description
SM Business Service Population This query defines the CI store structure of business service CIs.
SM Computer To Computer With ConnectM Running Software Population This query defines the CI store structure of running software CIs.
SM Computer Population This query defines the CI store structure of computer CIs.
SM Biz To Biz With Containment This query defines the CI store structure of CI relationships in which a bizservice CI contains another.
SM Biz To Biz With Usage This query defines the CI store structure of CI relationships in which a bizservice CI uses another.
SM Biz To Computer With Containment This query defines the CI store structure of CI relationships in which a bizservice CI contains a computer CI.
SM Biz To Computer With Usage This query defines the CI store structure of CI relationships in which a bizservice CI uses a computer CI.
SM Biz To Software With Containment This query defines CI store structure of CI relationships in which a bizservice CI contains a RunningSoftware CI.
SM Biz To Software With Usage This query defines CI store structure of CI relationships in which a bizservice CI uses a RunningSoftware CI.
SM Computer To Computer With Connects This query defines the CI store structure of CI relationships in which a computer CI connects to another.
SM Computer To Software With Composition This query defines the CI store structure of CI relationships in which a RunningSoftware CI is contained within a computer CI and the RunningSoftware CI cannot exist without the container.
CLIP Down Time Population This query defines the CI store structure of ScheduledDowntime CIs.
CI To Down Time CI With Connection This query defines the CI store structure of CI relationships in which a ScheduledDowntime CI connects to an affected CI.