Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.

Create list of all triggered CIs for a discovery job

Idea ID 2700195

Create list of all triggered CIs for a discovery job

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

Tags (1)
4 Comments
Micro Focus Expert
Micro Focus Expert
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
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes
 
Respected Contributor.. Paul Meaders Respected Contributor..
Respected Contributor..

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

jxliang101 Trusted Contributor.
Trusted Contributor.

The data are there and should be made available to administrators through the UI

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.