Create a way to query the database of item

[ghislain]

Hi,

It will be very valuable to me to be able to search into the item database. For exemple if i want to know:

- list me the host that have more than 2GB of ram
- list me the host with less than 10% of disk in root


All this is in the database but i cannot query it. I would have to create a trigger specialy for this but it would be very usefull to have a way to creta a custom query to see the actual state of an item on every host.

I can see plenty of use for this.


regards,
Ghislain.

[richlv]

this might be something api could help with, maybe... or a zabcon command to the api. not sure on which layer would it belong more

[Axilla]

$lastvalue = mysql_query("SELECT lastvalue,description FROM items INNER JOIN hosts on items.hostid = hosts.hostid INNER JOIN hosts_profiles_ext ON hosts.hostid = hosts_profiles_ext.hostid WHERE device_alias = '$elementid'");