What are all the tables discovery uses from running discover schedule to storing extracted information in CMDB?

lvakare
Kilo Contributor

Can any one please tell when we click on Discover now it will create discovery status in discovery status we find device,ECC queue,Discover logs and so on.Internally How it maintain the relation between tables.For example when i click on Discover Now in discovery schedule it generates Discovery status record this record contains ECC queue,device,discovery logs details,Is this all happening with Business Script or do we fire any query internally to get all this results?

2 REPLIES 2

doug_schulze
ServiceNow Employee
ServiceNow Employee

Lokesh,



There has to be hundreds of direct and indirect tables that discovery uses on the platform, well to many to document here. So I have to ask, what is the reason behind your question, what are you looking for in this information?


Alex Mittell
ServiceNow Employee
ServiceNow Employee

In basic - the discovery_status table is linked to the discovery_log(X) tables by sys_id of the row in the discovery_status, the entries from the ecc_queue table are filtered by the agent_correlator field which is also the sys_id of the related row from the discovery_status table. The Discovery Status form is configured to show data from those related lists, you can view them by right clicking on the header and selecting Configure > Related Lists.