ZabCon or API help needed

[qix]

Hi all,

First of all, I'm not a programmer, but I can build descent Bash scripts if I need to
I'm trying to figure out how to do the following.

I'd like to be able to type a command on the zabbix server command line that will return a tab,space or semicolon separated list of data that I can parse through sed, grep and al the other cool GNU tools.
I would like this data to be a representation of the active triggers screen, preferably without the acknowledged triggers.

What command would I need to use on Zabcon to get this out of the API?
All the commands I input, give me lists with reference ID's that don't really mean anything to me. I couldn't really find a command that will let me do a SQL join like operation on the ID's either.

Is this possible? Or should I just create a SQL statement that'll return the wanted data and input that in mysql client?

Thanks,

[nelsonab]

I need to add a feature like that for Zabcon, however you can use the data as it is now by usingthe | character as your delimiter. Also there are 3 lines at the top for the header and one at the bottom.

I have added the following ticket. If you want you can add yourself as a follower on the ticket and you will get an email when it is added. I'll try to get it done in the next day or two.

[fmrapid]

nelsonab,

That is fabulous. Viva the API and zabcon.

I look forward to this functionality.

I expect the same principle would apply for other data values to be extracted.

Cheers,

fmrapid

[richlv]

I have added the following ticket.

where ?

[nelsonab]

LOL... ya a link would help... :-)

http://trac.red-tux.net/ticket/78

[qix]

Hi Nelsonlab,

Thanks for your response.
How do I add myself to the ticket? I coudn't find a signup form or the like either.... Must be blind or something.

Thnx!

[nelsonab]

:-) I guess I've done a good job of locking things down due to spam. :-)

If you want you can send me a message privately, and I can add you or just watch this thread as I will update when I'm done.

[nelsonab]

Ok ticket closed, revision 248 has the changes needed. I have not updated the tarball yet.

If you execute Zabcon as part of a script you will not see any of the table or header information as before.

echo "get user" | zabcon -l

userid,alias
3,apitest

If you wish to change the separator character use the -s option. If your separator involves spaces enclose the option with quotes, for instance

echo "get user" | zabcon -l -s ", "

userid, alias
3, apitest

If you do not wish to see the header use the --no-header option

echo "get user" | zabcon -l --no-header

3,apitest

If you have any other needs or questions, just ask. :-)

[richlv]

If you execute Zabcon as part of a script you will not see any of the table or header information as before.

ooooh, very neat. makes scripting much easier