Cacti Log File Questions

[Marador]

Hey Everyone,

Below is a snipet of my log, i am trying to find out if there is a way to identifiy which host[x] associates with which hosts.

Any help would be much appreciated.


10/26/2004 08:36:38 AM - SYSTEM STATS: Time: 97.0234 s, Method: cmd.php, Processes: 1, Threads: N/A, Hosts: 18, Hosts/Process: 18
10/26/2004 08:36:19 AM - CMDPHP: Poller[0] Host[15] WARNING: Result from SNMP not valid. Partial Result:
10/26/2004 08:35:18 AM - CMDPHP: Poller[0] Host[3] WARNING: Result from SNMP not valid. Partial Result:
10/26/2004 08:35:14 AM - CMDPHP: Poller[0] Host[3] WARNING: Result from SNMP not valid. Partial Result:

[Hip]

Hello Marador,

The host number between the brackets is in fact the host id that is stored in the database.

Using an SQL query, you can fetch the hostname / description of these hosts with the following query:

Code: Select all

SELECT hostname, description FROM host WHERE id='x'

Note: obviously, you should replace the x with the number in brackets (keeping the apostrophes).

Alternatively, you may go on the "Console -> Devices" page and look at the links of all the devices. This host id is in the link.

Hope that helps.

[Marador]

Thanks mate,

I had to use the Mysql query because i couldnt find it listed under Device, but now i have something to work with.

Thanks