Sample discovery status queries

Sample: Determining which address the Ping finder is pinging

The following query returns the current address being pinged by the Ping finder:

select m_CurrentAddress from pingFinder.status;
go
.
{
                m_CurrentAddress=192.168.0.1;
}

Sample: Identifying the current phase of the discovery

The following example shows how to identify the current phase of the discovery. The results of the above query show that the discovery process is still in data collection phase 1.

select * from disco.status;
go
.
{
                m_DiscoveryMode=0;
                m_Phase=1;
                m_BlackoutState=0;
                m_CycleCount=0;
                m_ProcessingNeeded=0;
                m_FullDiscovery=0;
}

Sample: Identifying the status of a NAT discovery

This example shows how to identify the status of the NAT discovery.

select m_NATStatus from disco.NATStatus;
go
.
{
                m_NATStatus=3;
}

Sample: Identifying which agents are enabled

This example shows how to identify whether you have enabled the appropriate discovery agents.

select m_AgentName, m_Valid from disco.agents
where m_Valid = 1;
go
...
{
                m_AgentName='Details';
                m_Valid=1;
}
{
                m_AgentName='AssocAddress';
                m_Valid=1;
}
{
                m_AgentName='IpRoutingTable';
                m_Valid=1;
}
{
                m_AgentName='IpForwardingTable';
                m_Valid=1;
}
 

Sample: identifying the status of the discovery stitchers

The following example shows how to identify the status of the stitchers by querying the stitchers.status table.

select * from stitchers.status
where m_State > 0 ;
go
.........
{
                m_Name='AgentRetToInstrumentationSubnet';
                m_State=3;
}
{
                m_Name='DetailsRetProcessing';
                m_State=3;
}
.....
.....
{
                m_Name='DetectionFilter';
                m_State=3;
}
{
                m_Name='FnderProcToDetailsDesp';
                m_State=3;
}
{
                m_Name='FnderRetProcessing';
                m_State=3;
}

The results from the query show the current status of all stitchers that have been called by the discovery process so far. Note that the results shown above have been abbreviated.

Sample: identifying which agents are active

The following example shows how to query the status of the agents in the agents database.

select * from agents.status
where m_State > 0 ;
go
..
{
                m_Name='Details';
                m_State=3;
                m_NumConnects=1;
}
{
                m_Name='IpRoutingTable';
                m_State=3;
                m_NumConnects=1;
}

The results of the above query show that only the Details agent and the IpRoutingTable agent are active (that is, they have a state greater than zero).