Skip to main content

developerWorks >  Tivoli  >  Forums  >  Tivoli Common Reporting - General Discussion  >  developerWorks

change report    Point your RSS reader here for a feed of the latest messages in this thread


     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
Permlink Replies: 2 - Pages: 1 - Last Post: Nov 5, 2009 7:42 AM Last Post By: tsekman
zpacci

Posts: 2
Registered: Oct 30, 2009 10:50:57 AM
change report
Posted: Oct 30, 2009 12:49:13 PM
Click to report abuse...   Click to reply to this thread Reply
Hello,

I need to BIRT report for TADDM. I have tried to develop change_history.rptdesign which is uploded. But; it works correctly if comptype is one of the these: filesystems, softwarecomponet, windows service,SCSIvolume and Logical contents. These are using views. DB contains view over of 1400. I can't find anything about CMDB's db structure .

For example, I want to get report for Apache Servers. There is no defined view for Apache, so some information comes blank. I don't know which views are related with apache.

Besides, if I knew DB structure, do I really define all views for all types?

Thanks,

Regards

Zeynep
DK_

Posts: 112
Registered: Jan 09, 2008 04:08:04 PM
Re: change report
Posted: Nov 03, 2009 07:36:16 PM   in response to: zpacci in response to: zpacci's post
Click to report abuse...   Click to reply to this thread Reply
Hi,
I'm not sure about your main question: the DB structure. However, if I look at the TADDM Apache report from OPAL, and search it in a text editor for "from ", I see the SQL statements pulling data from DP_APACHE_SVR_GENERAL_V

Dan
tsekman

Posts: 66
Registered: Jul 14, 2008 04:42:56 PM
Re: change report
Posted: Nov 05, 2009 07:42:37 AM   in response to: zpacci in response to: zpacci's post
Click to report abuse...   Click to reply to this thread Reply
Hi,

DP_% are the views which are used by details panels in TADDM client application.
BB_% are the views recommended for reports development.

It is all described here:
http://www.ibm.com/developerworks/wikis/display/tivoliaddm/Report+development+walk-through
http://www.ibm.com/developerworks/wikis/display/tivoliaddm/TADDM+Database+and+Schema+Views

Kind regards,
Tomasz Sekman

Point your RSS reader here for a feed of the latest messages in all forums