List of host templates

[BanditBBS]

I promise, this is my last coding question for at least the next 2 weeks

I'm working on a custom component and I need to list all hosttemplates into a select box. I've done it before with hostgroups using get_xml_hostgroup_objects() but there is no backend call for listing host templates. Anyone know of a way for me to grab all the hosttemplate names?

[jomann]

I'm not aware of a function in XI that currently just grabs the host templates available. However, it should be easy enough to pull from the nagiosql DB in mysql - table is table_hosttemplate - you should get more than enough info for what you need with just a basic SELECT * FROM nagiosql.tbl_hosttemplate;

I should point out there's a function to run SQL queries

Code: Select all

$rs = exec_sql_query(DB_NAGIOSQL, $sql);

inside of XI since it's already actually connected to each of the DBs. This returns an ADO object which you can use $rs->RecordCount(); to get the amount of records or something like $rs->GetArray(); to get a full array of the data.

[BanditBBS]

I'm not aware of a function in XI that currently just grabs the host templates available. However, it should be easy enough to pull from the nagiosql DB in mysql - table is table_hosttemplate - you should get more than enough info for what you need with just a basic SELECT * FROM nagiosql.tbl_hosttemplate;

I should point out there's a function to run SQL queries

Code: Select all

$rs = exec_sql_query(DB_NAGIOSQL, $sql);

inside of XI since it's already actually connected to each of the DBs. This returns an ADO object which you can use $rs->RecordCount(); to get the amount of records or something like $rs->GetArray(); to get a full array of the data.

Yeah, thanks again man! I did digging in nagios code and stole some of yours for anyone else in future, this worked great:

Code: Select all

$hosttemplates = exec_sql_query(DB_NAGIOSQL, "SELECT `template_name` FROM nagiosql.tbl_hosttemplate ORDER BY `template_name`;", true);

You can close this up and I'll not ask coding questions again for 10 days, lol

[jomann]

Awesome