ServiceNow Discovery Report

[rahulyamgar]

Hello Friends,

I would like to prepare ServiceNow Discovery which shows me below:

1. Total attempted IPs for discovery which responded

2. IPs in CMDB , discovered at some point in time.

3. IPs never discovered.

4. IPs discovered incompletely.

I feel that there is a complex data structure behind the scene to get the list of IPs attempted for the discovery.

Any idea would be of great help !

-Rahul

[Maik Skoddow]

Hi @rahulyamgar 

on a CMDB tables which are discoverable you will find the field "Discovery source". Filter the table cmdb_ci_ip_address for the Discovery source value "ServiceNow" to identify those who have been discovered actively with ServiceNow Discovery.

Additionally, you can also consider the "Updated by" user which will be the one which is assigned to the respective MID server that was used for the discovery.

And then all your question can be answered by choosing the right filter conditions in the IP Address table.

Maik

[rahulyamgar]

Hello Maik,

Thanks for your response !

But looks like cmdb_ci_ip_address table shows the IP address associated with the discovered server. Ex. there is a device with 2 NIC cards i,e, 2 Ip address, if scanned using 1 of the IP address, device has 2 IP addresses associated to it. So i dont think that data in cmdb_ip_address is one to one to the discovery attempted IP addresses. Please validate my understanding.

Thanks,
Rahul

[Harsh Vardhan]

Hi @rahulyamgar  : Have you tried to check "discovery_device_history" table ?

this will cover your requirement.  There is a column here " Completed activity ", it will give you either device has discovered or not. You can also retrieve the IPs here as well as device name. 

Adding Doc link : 

Discovery device history 

Hope it will help you.

Thanks,

Harsh