1.Stop CCA Services, both CCA Server and Grids
2.Open SQL Management Studio
3.Select CCA DB instance and click on New Query button
4.Paste the SQL content provided in acmbo_server_ci.sql
5.Now Go to Views section and delete the view acmbo_server_ci
6.Execute the view content of Step 4
7.The view will be recreated again.
8.Go to the CCA Server Install path (\CA\CCA Server\tomcat\conf). Now place the updated ci_sql_mapping.xml (backup existing ci_sql_mapping.xml)
9.Start the CCA Services
10.Login into CCA, go to the Blueprints section.
11.Import the HardwareDetails(Windows)_updated.jar by selecting Overwrite Existing Blueprints
12.Now come to Administration -> SDM Integration -> Attribute Mappings
13.Import ServerAndVirtual.jar and Lpar.jar
14.Now on the SDM side please create custom attributes z_str_proclgcnt, z_int_proclgcore, z_int_vcpu
Before exporting data to SDM, you must to perform the following steps:
1. Clean up the Hardware Details component discovered data. For doing so the best option is to come to Software tab -> Components section, filter the data on Component Name Matches Hardware Details (Windows)
2. Delete this component data for the required Windows Servers that to be exported to SDM. Rediscover this required servers for this Hardware Details (Windows) so that the custom attributes are populated with the required details.
3. Now export the data to SDM and you can notice the custom attributes cpucorecount, cpulogicalcount and vcpuscount are part of Server CI, Virtual CI of Windows platform.
Note: Blueprint created by making Copy of Hardware Details Blueprint will not contribute Server or Virtual or LPAR CI’s data to SDM export. Only the OOTB Hardware Details Blueprint will contribute for the SDM Export of Server and Virtual CIs.
This procedure will results the following contents in CCA and Service Desk Manager respectively: