Report help, new boss & nightmare, desperate - please help! Or get an add-on product for reporting?

Question

Hi,

I need to write a report with the following items, and I am stuck.

I need a single line format for the time frame, right now it would start with daily, then go to weekly.

Something like:
Nodename, system uptime, system availability average, avg cpu, max cpu, min cpu, avg physical memory, max physical memory, min physical memory, avg virtual memory, min/max, avg disk i/o, min/max, user processor time avg compared to physical system time average, and so forth.  Basically key server metrics on one line per node, and then I have to write others such as network uptime reports and such.

I am not a sql person and would rather grab a sql add-on easy report tool if report writer won't do this.

THANK YOU!!

diykev · Answer

Thx, I found them, the problem is I can't find one that let's you combine things.  IE:

I need a report that will show me the following on one line per device, 2 lines could be OK.

nodename, availability within time range, avg/max/min cpu, memory - each in a separate column.  then disk i/o, page file avg/min/max, user processor time, system processor time, etc...

I tried doing some of this and you can't combine APM items and NPM items as the items to add aren't there depending on which report you pick.

How can you have all the items available to choose from, that would probably solve this problem.  If I could select nodename, then applicationname, statistics items, etc then that would be a huge improvement.

mark_wiggans · Answer

There are several custom reports here that you can tweak-

http://thwack.com/media/g/orion_custom_reports/default.aspx