Friday, November 7, 2008

Splitting multi-valued variables in TDI

In many cases, we have an entry with multiple values (separated by comma, for example), and we need to split those values and process one at a time.

Assuming there is an entry with the following values:

10.4.128.24, 10.4.128.160, 10.4.128.161, 10.4.128.220, 10.4.128.227, 10.4.128.229, 10.4.128.231, 10.4.128.232, 10.4.128.209, 10.4.129.24

Here are the steps to process each value at a time:

  • In your AL, add a script component with the following code
    multiValued = work.getString ("MultiValued");

    task.logmsg ("multi valued: " + multiValued);

    tokenizer = new java.util.StringTokenizer (multiValued, ",");
    work.setAttribute ("values", null);

    while (tokenizer.hasMoreTokens ()) {
    token = tokenizer.nextToken ();
    task.logmsg ("value: " + token);
    work.addAttributeValue ("values", token);

    }
  • Add a Loop to your AL
  • In the Loop, select Attribute Value Loop
  • In the Work Attribute Name, type values (which matches the Work Entry defined in the code above)
  • In the Loop Attribute Name, type value
  • Inside the loop, you'll have the value Work Entry with a single value to process.
That's it!

Thursday, November 6, 2008

Script to launch ABBA with TADDM 7.1.2

TADDM 7.1.2 is coming soon, and the JAR files for the TADDM API have been consolidated into just one JAR (no comments on backward compatibility...). The tool works with TADDM 7.1.2; we just need to change the required JAR files, so here is a script to launch it with the new version:

export TADDM_SDK=/home/eduardo/Tivoli/TADDM/712/sdk/clientlib
java -cp bin/abba.jar:$TADDM_SDK/taddm-api-client.jar com.ibm.cmdb.tool.abba.ABBAGUI $*

By the way, this incredible tool can be downloaded from: http://www-01.ibm.com/software/brandcatalog/portal/opal/details?catalog.label=1TW10TA0X

Saturday, October 4, 2008

Launching TADDM in context without a GUID

TADDM certainly provides a cool way to be launched in a context, as documented at:

http://publib.boulder.ibm.com/infocenter/tivihelp/v10r1/index.jsp?topic=/com.ibm.taddm.doc_7.1/AdminGuide/r_cmdb_launchincontext.html

For example,

http://taddm_server:9430/cdm/servlet/LICServlet?guid=B435980E80FA39509EBFE294D70BA5C8

will launch TADDM Produce Console in the context of a GUID.

The problem arises when the launching application doesn't know the GUID.
I created a Java Server Page to bridge between such application and TADDM. It's available at:

http://docs.google.com/Doc?id=ddnnhc4w_307dffpq3gs
  • Download the file as taddm_launcher.jsp
  • Edit the line defining the TADDM_SERVER to your TADDM installation
  • Copy the file to the TADDM Server to the directory /deploy-tomcat/cdm
  • Point your browser to
    http://taddm_server:9430/cdm/taddm_launcher.jsp?name=computer_system_name
    replacing taddm_server and the computer_system_name accordingly
This work can certainly be expanded to launch other sections of TADDM and other kinds of resources (it works only with ComputerSystem objects).

The syntax of the Launch in Context URL can be found at:

Wednesday, September 24, 2008

Extending TAMIT ASSETNUM attribute field length

Here is the procedure to extend the size of the attribute ASSETNUM in the ASSET MBO in TAMIT:

  • Do a database backup
  • Go To-> System Configuration -> Platform Configuration -> Database Configuration
  • Object: ASSET
  • Select ASSET
  • Go to Attributes tab
  • Select ASSETNUM
  • Change the length to 32
  • The attribute will be in Change mode
  • Save it
  • Go to List tab
  • Select Action -> Managed Admin Mode
  • Click Turn Admin Mode On
  • Click Refresh Status until Admin Mode is ON
  • Connect to TPAP DB
  • db2 drop trigger multiassetloccip_u
  • db2 drop trigger multiassetloccip_t
  • Select Action -> Apply Configuration Changes
  • Check Do you have a current backup?
  • Click Start Configuring the Databsase
  • Click Turn Admin Mode OFF

Thursday, September 18, 2008

TDI class material

These are the links for the material used in the TDI class in Charlotte on Sep 18 - 20, 2008

Source CSV file: http://spreadsheets.google.com/pub?key=p4p_qEbMe9m6VL-TWV1NyQQ
Lab instructions: http://docs.google.com/Doc?id=ddnnhc4w_2793ph5zxcg
Presentation: http://docs.google.com/Presentation?id=ddnnhc4w_54f9tnwmd2

Wednesday, September 10, 2008

How to configure TADDM 7.1.1 to run BIRT reports

1. replace the reports.xml in dist/etc/cdm/xml
2. replace the dist/deploy-tomcat/cdm/WEB-INF/view/dm_newsummary_sidebar.jsp with the one here
3. untar birt-viewer.tar to dist/deploy-tomcat/
4. restart the server
5. Login to domain manager and you shd see the BIRT reports icon with a list of reports under the Analytics section

These files are available at: http://www.megaupload.com/?d=N1VTT5LT

Friday, September 5, 2008

Exporting data from TADDM

It's very simple to extract data from Tivoli Application Dependency Discovery Manager (TADDM), using Tivoli Directory Integrator (TDI) and the TADDM Connector, available at:

TADDM Connector at Tivoli OPAL

Using the TADDM Connector, you just specify the TADDM configuration information (host name, user, password, CI type), then drag and drop the fields into the desired Connector (for example, a CSV file, using the FileSystem Connector).