[INUG-Users] Any good tool instead of reporter?

douglasstvnsn at aol.com douglasstvnsn at aol.com
Fri Jan 25 10:39:40 EST 2008 

 Too funny!!

I do PHP...
and Java...
and Javascript...
and Perl...
and Python...
and TCL/TK...

I guess I'm turning out to be what I didn't really want... A programmer! I guess thats good because there are soo many ENMS Architects now, theres not much room for me any more!

Dougie!!!


 


 

-----Original Message-----
From: Hubbard, Greg L <greg.hubbard at eds.com>
To: users at netcoolusers.org
Sent: Fri, 25 Jan 2008 9:16 am
Subject: Re: [INUG-Users] Any good tool instead of reporter?










WOW!  You and Uncle Doug should get together and swap code!

GLH 

-----Original Message-----
From: users-bounces at netcoolusers.org
[mailto:users-bounces at netcoolusers.org] On Behalf Of
brad.bueche at wachovia.com
Sent: Thursday, January 24, 2008 5:33 PM
To: users at netcoolusers.org
Subject: Re: [INUG-Users] Any good tool instead of reporter?

You can also roll your own in PHP.   If you are going to do canned
reports 
this is very easy.  Creating a front by which to query takes a little
longer.

I have set up a front end that allows users to query any field (or set
of
fields) for any value (or set of values)  using any valid oracle
operator (including regex, and IN, NULL, all case independent --- except
regex) and this then generates a table in html that can be copied and
pasted right into excel with no changes.  It also does counts (with
drilldown), handles class conversions (for english names) , and displays
and allows searching of the journal fields as well.  And I can put in
the frigging partition
(!) so my reports are a heck of a lot faster (I also can queue records
so I'm not sending them to the brower 1 at a time).  Query time to the
db is displayed. Render time is displayed. And you can hit either our
production data or test data by choosing the target db from a drop down.
And you can sort your drill down top level reports by count (if you
want)! (Reporter cant). It also has canned report options with sql that
duplicates all the webtop entity filters.  So customer can get reports
for the webtop buckets that they are working  (all the way back to
1/1/2007) and see who closed what and when, and who ack'd what and when.


Its actually my fist web app/page/anything.   PHP and HTML have to be
the 
most well documented technologies on the net. (doh!) So dont think you
cant do it! (Admittedly, I'm currently on version 61of this app now!)

The total code was up to about 15k lines but I've cut it back to about
3k now as I have learned more. In the begining, I had no concept of
generating anything dynamically.  Eventually, I'm going to have the
entire thing generated dynamically by just pointing to a db then letting
the user create the query interface they want.  It will however be
geared toward netcool archives.  (And of course that means I still have
to create user logins, work with a db for user data, start using
sessions, etc ...........as soon as I have time to learn all that
stuff).

Additionally, I've already started incorporating flex so that I can do
charting as well.  And I'll probably eventually re-do the whole front
end in flex/flash.  Flash is soooooooooo much better than java on the
client 
side.   Nice, small, very fast, and adobe provides the code to check and

see if the user has the correct version of flash and if not downloads it

for them.   (For those of you sick and tired of troubleshooting java 
runtime configuration issues on the client side this is a dream come
true!).  Did I say its fast? Flash actually incorporates a little web
engine so your server is on the client. No need for ajax. Its RIA from
the get go. Responsive! Drag and drop, stateful, lots of security built
in, etc.  I'm setting up the engine to read xml so that, really, it can
chart any data that meets the format. But it will be geared toward doing
event reporting for command centers.  Yes, xml is larger than binary but
this is internal on 100mb connections.  I'm watching the amf3 and
blazeds stuff though. I dont think they will be as open for input
though..........vs. 
just saying make your data look like this xml and the charts will work.

$750 for Crystal reports may get you there faster though!!  ;) 

brad




"Hubbard, Greg L" <greg.hubbard at eds.com> Sent by:
users-bounces at netcoolusers.org
01/24/2008 03:29 PM

Please respond to
users at netcoolusers.org


To
<users at netcoolusers.org>
cc

Subject
Re: [INUG-Users] Any good tool instead of reporter?






You might Google "Oracle reporting" and see what you get.

I have looked at the Oracle Business Intelligence product, which is a
reporting system from Oracle.  You also might look at Crystal Reports
from Business Objects.  There might even be a way to use Windows tools
against a remote Oracle server via ODBC driver.

I've found that Reporter stacks up fairly well against these other
products if you just look at features, and these other products are not
much different in price.

If you have some flexibility, you MIGHT consider switch Reporter from
Oracle to Microsoft SQL Server, and then you can use some of the
Microsoft reporting tools.  But the last time I tried to use the MS SQL
reporter gateway it did not work very well.

GLH 

-----Original Message-----
From: users-bounces at netcoolusers.org
[mailto:users-bounces at netcoolusers.org] On Behalf Of olga NN
Sent: Thursday, January 24, 2008 2:13 PM
To: users at netcoolusers.org
Subject: Re: [INUG-Users] Any good tool instead of reporter?

Good ideaThank you .But I am looking for GUI interface against ORACLE
-alarms are stored in ORACLE database,i need to build graphs

--- Jason Shamroski <jason.shamroski at gulfsoft.com>
wrote:

> I've used InfoVista in the past for device performance reporting. It's

> expensive - typically for larger enterprises, but it's nice. Very 
> customizable reports, provided you know what you want.
> 
> jason
> 
> 
> On 1/24/08, olga NN <al3457 at yahoo.com> wrote:
> >
> > All,
> > I am looking for a good tool to change
> Reporter,can
> > you recommend something?
> > Thank you in advance
> >
> >
> >
> >
> > 
>
________________________________________________________________________
____________
> > Looking for last minute shopping deals?
> > Find them fast with Yahoo! Search.
> >
>
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> >
> > _______________________________________________
> > Sent by the netcoolusers.org "users" mailing list
> > Post: users at netcoolusers.org
> > Unsubscribe: users-unsubscribe at netcoolusers.org
> > Search:
> http://lists.netcoolusers.org/archives/users/
> >
> 
> 
> 
> --
> Jason Shamroski
> Gulf Breeze Software
> www.gulfsoft.com
> 
> Stand by for Tivoli Conference Announcement...
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search:
> http://lists.netcoolusers.org/archives/users/
> 



 
________________________________________________________________________
____________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/

_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/

ForwardSourceID:NT0004798E
_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/

_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/



 


________________________________________________________________________
More new features than ever.  Check out the new AOL Mail ! - http://webmail.aol.com

More information about the Users mailing list