report generation

[MarioF]

Hi guys,

Let me just say that zabbix really rocks on the monitoring front. Granted I have to tweak the agents a little but overall I'm really happy.

Unfortunately, the powers that be have asked for reports! Now, I have had a look at the SLA functions in "IT services", but what I really want to be able to do it to pick a host and produce a report that will give a monthly summary of a few metrics (such as uptime, disk usage, cpu) as well as SLAs. I suppose I could use the screens function, but I need to produce this information on scheduled basis and don't want people to do it manually.

To this end I've looked at a couple of things mentioned in this forum such as the pdf generator (which I haven't got to work on v1.6.x yet) and I'm now trying to work out the linkages within the database so that I can create some reports using Business Objects. Has anyone already done this? I'm not that hot on SQL.

So, I'm asking for some advice - I'm sure other people have needed to do this in the past.

Thanks in advance!

Mario

[tighep]

I've been creating reports with Business Objects for a few months, and some of the SQL queries can get a bit difficult to make efficient. I've noticed that the default SQL generator is rather poor when it comes to our Zabbix DB. If you provide some specifics, I can try and help, but I'm not an expert at Crystal Reports at all.

[MarioF]

I've been creating reports with Business Objects for a few months, and some of the SQL queries can get a bit difficult to make efficient. I've noticed that the default SQL generator is rather poor when it comes to our Zabbix DB. If you provide some specifics, I can try and help, but I'm not an expert at Crystal Reports at all.

Hi,

Well would like to use Business Objects as well and not Crystal Reports.

I suppose I'd like to be able to produce a report that contained information for a server (cpu, disk space etc) per month, and a report that were for a collection of related servers (such as a 3 tier set up).

What sort of reports have you been able to produce?

What sort of specifics would you like?

[markl]

Hi,

I know the last reply was some time ago, but I'm looking into getting reports out of Zabbix using Business Objects too. I was wondering if you managed to get things up and running? If you did, what sort of reports have you managed to get out of Zabbix using BO? Any advice would be greatly appreciated.

Cheers,

Mark.

[MarioF]

Hi Mark

No, I didn't have any joy with this but to be honest I stopped looking into it shortly after I posted. I'm still running zabbix, but I'm also looking at Splunk and SCOM to see if I can get better reporting out of the box without having to hack things about.

Kind Regards

Mario

[tighep]

Sorry to Mario that I let this drop, I don't check here as often as I should. I have created several reports using BO/Crsytal Reports. I'm currently reporting on disk usage for our application. I'm currently reporting a daily/weekly/monthly list of application errors for each of our systems monitored. I've created a report that returns all of the details on that particular system, such as OS version, cpu speed, paging space and the like.

As I mentioned before, the most difficult part is getting good database queries, here's one that grabs the last date that our client has run a DR set.

select z.description, z.host, z.name, max(u.value), z.profile

from
(
select
i.itemid, i.description, h.host, g.name, p.name as profile
from
items i,
hosts h,
groups g,
hosts_groups hg,
hosts_profiles p
where
i.description='Check last DR set date'
and g.name='Client Systems'
and i.hostid=h.hostid
and p.hostid=h.hostid
and hg.groupid=g.groupid
and hg.hostid=h.hostid
) z,
history_uint u
where
z.itemid = u.itemid
group by z.description, z.host, z.name;

[MarioF]

thats okay tighep, I know we are all busy with our own things