In IBM Control Desk, there is an object COMPUTERSYSTEM which is being used for Computers application (dpldasset.xml). You can find the application in Go To -> Assets -> Deployed Assets -> Computers.
This COMPUTERSYSTEM object is a VIEW consists of deployedasset, dpacomputer and dpammanuvariant objects. This is not a typical auto-select VIEW and you will need to configure 'View Select' in order to use new attribute for this object. Without additional steps, you won't be able to add additional attribute to this COMPUTERSYSTEM VIEW.
In this blog, I will provide steps in order to add new attributes to COMPUTERSYSTEM object. In this scenario, I am adding 1 attribute to each table; CS1 to deployedasset, CS2 to dpacomputer and CS3 to dpammanuvariant. I understand that your attributename could be different therefore you need to change accordingly when you see CS1, CS2 and CS3.
1. In order to begin with, I will add the attribute to each of the object itself; deployedasset, dpacomputer and dpammanuvariant. If you need to add attribute to only 1 of the objects, you can skip steps related to other objects.
(a) Add CS1 attribute to deployedasset object. (You can skip this if you are not adding from deployedasset object)
i. Go To -> System Configuration -> Platform Configuration -> Database Configuration.
ii. Filter for 'DEPLOYEDASSET' and open the record.
iii. Go to 'Attributes' tab.
iv. Click 'New Row'
Attribute: CS1
Title: Computer System 1
Description: Computer System 1
v. If you require specific attribute type and length, please configure accordingly. Once completed, click Save.
(b) Add CS2 attribute to dpacomputer object. (You can skip this if you are not adding from dpacomputer object)
i. Go To -> System Configuration -> Platform Configuration -> Database Configuration.
ii. Filter for 'DPACOMPUTER' and open the record.
iii. Go to 'Attributes' tab.
iv. Click 'New Row'
Attribute: CS2
Title: Computer System 2
Description: Computer System 2
v. If you require specific attribute type and length, please configure accordingly. Once completed, click Save.
(c) Add CS2 attribute to dpammanuvariant object. (You can skip this if you are not adding from dpammanuvariant object)
i. Go To -> System Configuration -> Platform Configuration -> Database Configuration.
ii. Filter for 'DPAMMANUVARIANT' and open the record.
iii. Go to 'Attributes' tab.
iv. Click 'New Row'
Attribute: CS3
Title: Computer System 3
Description: Computer System 3
v. If you require specific attribute type and length, please configure accordingly. Once completed, click Save.
2. Configure 'View Select' for COMPUTERSYSTEM object.
(a) Go To -> System Configuration -> Platform Configuration -> Database Configuration.
(b) Filter for 'COMPUTERSYSTEM' and open the record.
(c) At View section, you can see 'View' Select' as follows :-
select deployedasset.assetclass, deployedasset.assettag, dpacomputer.biosdate, dpacomputer.biosname, dpacomputer.biospnp, dpacomputer.biosversion, dpacomputer.changedate, deployedasset.changedate as changedate1, dpacomputer.createdate, deployedasset.createdate as createdate1, deployedasset.description, deployedasset.domainname, deployedasset.guid, deployedasset.hwdetectiontool, deployedasset.hwlastscandate, dpacomputer.logonname, deployedasset.makemodel, deployedasset.manufacturer, dpacomputer.moboassettag, dpacomputer.mobochipset, dpacomputer.mobodescription, dpacomputer.mobomakemodel, dpacomputer.mobomanufacturer, dpacomputer.moboserialnumber, dpacomputer.nodeid, deployedasset.nodeid as nodeid1, deployedasset.nodename, deployedasset.orgid, dpacomputer.ramdescription, dpacomputer.ramsize, dpacomputer.ramtotalslots, dpacomputer.ramtype, dpacomputer.ramunit, dpacomputer.ramunusedslots, dpacomputer.rowstamp, deployedasset.rowstamp as rowstamp1, deployedasset.serialnumber, deployedasset.siteid, dpacomputer.smbios, deployedasset.sourceid, deployedasset.supportssnmp, dpacomputer.supportswmi, dpacomputer.swdetectiontool, dpacomputer.swlastscandate, deployedasset.systemrole, dpammanuvariant.manufacturername as cmanufacturer, dpammanuvariant.manufacturervar, dpammanuvariant.dpammanuvariantid, dpammanuvariant.rowstamp as rowstamp2, dpacomputer.plantcode1, dpacomputer.msus1, dpacomputer.mips1, dpacomputer.capacitymodel1, dpacomputer.numcpuconfig1, dpacomputer.numcputotal1, deployedasset.tloamnrsguid, deployedasset.tloamnrssignature, deployedasset.tloamnrsvmid, deployedasset.tloamnrsmanufacturer, deployedasset.tloamnrsmodel, deployedasset.tloamnrsserialnumber, deployedasset.tloamnrssystemboarduuid, deployedasset.tloamnrsprimarymacaddress, deployedasset.tloamnrshostsystem, deployedasset.tloamnrsname, deployedasset.tloamispromoted, deployedasset.tloamnrsmanagedsystemname, deployedasset.tloamhwtype, deployedasset.tloamstatus, dpacomputer.tloamparentid, deployedasset.tloamhash, deployedasset.pluspcustomer, dpacomputer.tloamplatformbase, dpacomputer.numcoretotal, deployedasset.tloamnrsuuid, dpacomputer.tloamcarrier, dpacomputer.tloamimei, dpacomputer.tloamdevownership, dpacomputer.tloamdevphonenum, dpacomputer.tloamdevpwdcompl, dpacomputer.tloamdevpwdenbld, dpacomputer.tloamauthuserid
(d) Add deployedasset.CS1 to the 'View Select' at the end of entry e.g. (You can skip this if you are not adding from deployedasset object)
..., dpacomputer.tloamauthuserid, deployedasset.CS1
(e) Add dpacomputer.CS2 to the 'View Select' at the end of entry e.g. (You can skip this if you are not adding from dpacomputer object)
..., dpacomputer.tloamauthuserid, deployedasset.CS1, dpacomputer.CS2
(f) Add dpammanuvariant.CS3 to the 'View Select' at the end of entry e.g. (You can skip this if you are not adding from dpammanuvariant object)
..., dpacomputer.tloamauthuserid, deployedasset.CS1, dpacomputer.CS2, dpammanuvariant.CS3
(g) Once completed, click Save.
3. Add new attributes to COMPUTERSYSTEM object.
(a) Go To -> System Configuration -> Platform Configuration -> Database Configuration.
(b) Filter for 'COMPUTERSYSTEM' and open the record.
(c) Go to 'Attributes' tab.
(d) Click 'New Row' to add deployedasset.CS1 (You can skip this if you are not adding from deployedasset object)
Attribute: CS1
Title: Computer System 1
Description: Computer System 1
Same as Object: DEPLOYEDASSET
Same as Attribute: CS1
(e) Click 'New Row' to add dpacomputer.CS2 (You can skip this if you are not adding from dpacomputer object)
Attribute: CS2
Title: Computer System 2
Description: Computer System 2
Same as Object: DPACOMPUTER
Same as Attribute: CS2
(f) Click 'New Row' to add dpammanuvariant.CS3 (You can skip this if you are not adding from dpammanuvariant object)
Attribute: CS3
Title: Computer System 3
Description: Computer System 3
Same as Object: DPAMMANUVARIANT
Same as Attribute: CS3
(g) Once completed, click Save and go back to 'List' tab of Database Configuration.
4. Additional steps to run in database backend. You need to connect to database backend and run following queries :-
(a) For CS1 attribute (deployedasset object). (You can skip this if you are not adding from deployedasset object)
# update maximo.maxattributecfg set columnname='CS1', entityname='COMPUTERSYSTEM', persistent=1 where objectname='COMPUTERSYSTEM' and attributename='CS1';
# insert into maximo.maxviewcolumncfg (changed, viewname, viewcolumnname, tablename, tablecolumnname, maxviewcolumnid)
values ('N', 'COMPUTERSYSTEM', 'CS1', 'DEPLOYEDASSET', 'CS1', maximo.maxviewcolumncfgseq.nextval);
# insert into maximo.maxviewcolumn (viewname, viewcolumnname, tablename, tablecolumnname, maxviewcolumnid)
values ('COMPUTERSYSTEM', 'CS1', 'DEPLOYEDASSET', 'CS1', maximo.maxviewcolumnseq.nextval);
(b) For CS2 attribute (dpacomputer object). (You can skip this if you are not adding from dpacomputer object)
# update maximo.maxattributecfg set columnname='CS2', entityname='COMPUTERSYSTEM', persistent=1 where objectname='COMPUTERSYSTEM' and attributename='CS2';
# insert into maximo.maxviewcolumncfg (changed, viewname, viewcolumnname, tablename, tablecolumnname, maxviewcolumnid)
values ('N', 'COMPUTERSYSTEM', 'CS2', 'DPACOMPUTER', 'CS2', maximo.maxviewcolumncfgseq.nextval);
# insert into maximo.maxviewcolumn (viewname, viewcolumnname, tablename, tablecolumnname, maxviewcolumnid)
values ('COMPUTERSYSTEM', 'CS2', 'DPACOMPUTER', 'CS2', maximo.maxviewcolumnseq.nextval);
(c) For CS3 attribute (dpammanuvariant object). (You can skip this if you are not adding from dpammanuvariant object)
# update maximo.maxattributecfg set columnname='CS3', entityname='COMPUTERSYSTEM', persistent=1 where objectname='COMPUTERSYSTEM' and attributename='CS3';
# insert into maximo.maxviewcolumncfg (changed, viewname, viewcolumnname, tablename, tablecolumnname, maxviewcolumnid)
values ('N', 'COMPUTERSYSTEM', 'CS3', 'DPAMMANUVARIANT', 'CS3', maximo.maxviewcolumncfgseq.nextval);
# insert into maximo.maxviewcolumn (viewname, viewcolumnname, tablename, tablecolumnname, maxviewcolumnid)
values ('COMPUTERSYSTEM', 'CS3', 'DPAMMANUVARIANT', 'CS3', maximo.maxviewcolumnseq.nextval);
5. Apply database configuration changes.
(a) In Database Configuration application, go to List tab and remove any filter. Click 'Find' to list all objects and you will see objects with status 'To be Changed'.
(b) Turn ON admin mode. More Action -> Manage Admin Mode. Click 'Turn Admin Mode ON' to turn on admin mode.
(c) Once completed, close the dialog.
(d) Apply database configuration changes. More Action -> Apply Configuration Changes. Make sure you have taken database backup and check 'Do you have a current backup'
(e) Click 'Start Configuring the Database' and occasionally 'Refresh Status' to check the status. e.g.
BMXAA6818I - ConfigDB started for schema MAXIMO, connected to database jdbc:db2://hostname:50005/maxdb75
BMXAA0364I - Getting metadata
BMXAA0349I - Configuring tables
BMXAA0345I - Altering table DEPLOYEDASSET.
BMXAA0345I - Altering table DPACOMPUTER.
BMXAA0345I - Altering table DPAMMANUVARIANT.
BMXAA0342I - Views are being configured.
BMXAA0344I - The attribute metadata is being refreshed.
BMXAA0343I - Object metadata is being refreshed.
BMXAA0341I - Native indexes are being rebuilt.
BMXAA0340I - Refreshing index metadata
BMXAA0339I - Updating table storage partitions
BMXAA0381I - There are no backup tables to restore data from.
BMXAA6820I - ConfigDB completed without errors.
BMXAA6820I - RestoreFromBackup completed without errors.
(f) Wait until you receive complete message e.g.
BMXAA0577I - The database configuration is complete. You can view the log file to see the detailed status.
(g) Turn OFF admin mode. More Action -> Manage Admin Mode. Click 'Turn Admin Mode OFF' to turn on admin mode.
(h) Wait for it to complete and close the dialog e.g.
BMXAA4003I - Administration mode is off for this server.
You have completed adding additional attributes to COMPUTERSYSTEM object. You can now add new textbox for the new attribute in Computers application through Application Designer.