SCCD ITIC:Verify settings for Asset Initialization adapter

Technote (troubleshooting)


Problem(Abstract)

Customer wants to know the steps to verify configuration for AssetInit Adapter

Resolving the problem

. Run on SCCD database:

select distinct systemrole from maximo.deployedasset

2. Decide if for every system role you want separate classification.
You may group several system roles under the same classification.
You may use existing classifications or create new in Classifications app.

3. For every classification you decide to use create an Item in Item Master app and assign the classification to the item.[using Specification Tab]

4. Create a list:

SystemRole Item

Desktop <desktop item>
Server <server item>
Laptop <laptop item>

where SystemRole column values come from step 1 and Item column values come from step 3.
Remember, you may use the same Item for multiple system roles.
You must have the line in the list above for every system role returned in step 1

5. For every line in the list in step 4 create a line in assetinit.properties file
(you may already have some of them defined):

assetinit_systemrole_item_<systemrole from column 1>=<item from column 2>

6. To verify that all the data exists in SCCD run this query:

with maximo.temp(itemnum) as (values
('<item 1 from column 2>'),
('<item 2 from column 2>'),
('<item N from column 2>'))
select t.itemnum,classstructureid from maximo.ITEM as i RIGHT OUTER JOIN maximo.temp t on i.itemnum=t.itemnum

You must list all the items from the list above.

All records must have values in the classstructureid column of the result.

If any classstructureid is empty, you missed the Item and you have to create it before proceeding

7. Open the mapping in ITIC and modify expressions for Computer.classstructureid and Computer.itemnum as follows:

- Computer.classstructureid

Replace:

if (itemnum.equalsIgnoreCase("COMPUTER")){
itemnum = getProperty("assetinit.properties", "assetinit_systemrole_item_laptop");
} else if(itemnum.equalsIgnoreCase("Server") || itemnum.equalsIgnoreCase("Windows 2003 Server") || itemnum.equalsIgnoreCase("PowerEdge 500C Server") || itemnum.equalsIgnoreCase("Remote Server")) {
itemnum = getProperty("assetinit.properties", "assetinit_systemrole_item_server");
}

with

if (itemnum.equalsIgnoreCase("Desktop"))
{
itemnum = getProperty("assetinit.properties", "assetinit_systemrole_item_desktop");
}
else if(itemnum.equalsIgnoreCase("Server"))
{
itemnum = getProperty("assetinit.properties", "assetinit_systemrole_item_server");
}
else if(itemnum.equalsIgnoreCase("Laptop"))
{
itemnum = getProperty("assetinit.properties", "assetinit_systemrole_item_laptop");
}

Make sure you have "else if" for every systemrole in the list

- Computer.itemnum

Replace

if (itemnum.equalsIgnoreCase("COMPUTER")){
itemnum = getProperty("assetinit.properties", "assetinit_systemrole_item_laptop");
} else if(itemnum.equalsIgnoreCase("Server") || itemnum.equalsIgnoreCase("Windows 2003 Server") || itemnum.equalsIgnoreCase("PowerEdge 500C Server") || itemnum.equalsIgnoreCase("Remote Server")){
itemnum = getProperty("assetinit.properties", "assetinit_systemrole_item_server");
}

with the block above (from Computer.classstructureid), exactly the same block of code.

8. Save the mapping and execute it.

Product Alias/Synonym

SCCD
ITIC
SCCDITIC

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Integration Composer

Software version:

7.2, 7.2.1, 7.5, All Versions

Operating system(s):

AIX, Linux, Windows

Reference #:

1640028

Modified date:

2013-09-16

Translate my page

Machine Translation

Content navigation