Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kwinter

  1. kwinter

    Performance of SQL database visualization in SC

    Hi! First of all, thanks for all your help!!! So, I did the SQL debug, but I guess, I can't really interprete all this stuff very well. So I give you one statement which ist very fast: 980 12/06/2002 09:58:04 PREPARE SELECT * FROM IP_SERVICECENTER_VIEW WHERE TME_OBJECT_LABEL=:nameh0 980...
  2. kwinter

    Performance of SQL database visualization in SC

    The view is very fast if stated from an SQL plus window, so I think the query is okay...? We run SC 4.0.1 and an oracle8i enterprise edition release 8.1.7.0.0
  3. kwinter

    Performance of SQL database visualization in SC

    Hi folks, I need an online visualization of inventory data stored in an oracle database of TIVOLI Inventory within SC. To do that, I created several forms (and corresponding files) fitting to certain views within the TIVOLI database and display these forms as virtual joins. Everything works...
  4. kwinter

    DB View Visualization in Service Center

    Hi thanks, that's it! I need the LEFT OUTER!!! Thanks a lot for your help! And have a nice weekend! Kai
  5. kwinter

    DB View Visualization in Service Center

    Your're right, the jointype is an EQUAL indeed!
  6. kwinter

    DB View Visualization in Service Center

    Yes, that's exactly my point! I don't know how to join these tables togesther!!! I hoped, direkting all tables (devicem1, devicea1...)to one certain view in the database (e.g. within the SQL mapping I changed all these tablenames devicem1, devicea1 etc to my single view name HDISK_VIEW) would...
  7. kwinter

    DB View Visualization in Service Center

    The hard disk data is actually a bunch of seperate records. I tried all options concerning array mapping. Unfortunately in oracle there are only tables allowed with one long text field only, so SC is creating a number of tables when pushing to SQL...
  8. kwinter

    DB View Visualization in Service Center

    Hi all, I try to configure a visualization of an Oracle Database View within Service Center. The View contains information about harddisks (and certainly one host has several harddisks) The structure is pretty easy: 1.hostname/diskinfo1A/diskinfo1B/diskinfo1C...
See more

Part and Inventory Search

Back
Top