Idea ID: 2700195

Create list of all triggered CIs for a discovery job

Status : Waiting for Votes
Waiting for Votes
See status update history
over 1 year ago

Is there a way to get a list of all of the triggered CIs for a particular discovery job? The Discovery Status job will report CI's which ended with warning or error. I am looking for a way to get all triggered CIs including those which were successful.

For example, I would like to get a list of all of the triggered CI's for host connection by shell. I would then compare that list against other sources to help verify that everything in the environment is getting discovered.

Thanks

Labels:

Discovery-infra
  • The data are there and should be made available to administrators through the UI

  • Based on a suggestion during one of the practitioners call I came up with the following work-around.  Basically I just created an SQL query to go against the CCM_DISCOVERY_DESTS table.  The case statements get around the fact that certain discovery jobs set the trigger CI to "UDA" which is not very useful.

    I am not an SQL expert so any improvements to the query would be appreciated.

    SELECT
    CASE
    WHEN JOB_ID = 'Apache Tomcat by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'Host Applications by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'Host Resources and Applications by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'J2EE JBoss by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'J2EE Weblogic by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'J2EE WebSphere by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'Microsoft Message Queue Topology by NTCMD' THEN HOST_LABEL
    WHEN JOB_ID = 'MQ by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'Oracle Application Server' THEN HOST_LABEL
    WHEN JOB_ID = 'Oracle Connection by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'Oracle Listeners by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'Oracle VM Server for SPARC Technology by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'Veritas Cluster by Shell' THEN HOST_LABEL
    WHEN JOB_ID = 'VMware VirtualCenter Topology by VIM' THEN HOST_LABEL
    WHEN JOB_ID = 'Webserver by Shell' THEN HOST_LABEL
    ELSE CI_LABEL
    END AS SEARCHKEY
    ,[TRIGGER_CI_TYPE]
    ,[CI_LABEL]
    ,[HOST_LABEL]
    ,[PROBE_NAME],
    CASE
    WHEN STATUS = 0 THEN 'Server Processing Failure'
    WHEN STATUS = 2 THEN 'Reached Probe'
    WHEN STATUS = 6 THEN 'Error'
    WHEN STATUS = 7 THEN 'Success'
    WHEN STATUS = 10 THEN 'Server Processing Failure'
    ELSE CAST(STATUS AS varchar)
    END AS TXTSTATUS,
    CASE
    WHEN SEVERITY = 0 THEN 'OK'
    WHEN SEVERITY = 2 THEN 'Warning'
    WHEN SEVERITY = 6 THEN 'Error'
    WHEN SEVERITY = 7 THEN 'Fatal'
    ELSE CAST(STATUS AS varchar)
    END AS TXTSEVERITY
    ,[EXECUTION_START]
    ,[LAST_SUCCESSFUL_INVOCATION]
    ,[JOB_ID]
    ,[HOST_ID]
    ,[EXECUTION_END]
    FROM [UCMDB].[dbo].[CCM_DISCOVERY_DESTS]
    ORDER BY SEARCHKEY

  • Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team