ILMT / SUA – SUADB Database Integration – Is it supported?

Hello vipin,

You can check existing hardware inventory panel on UI if there are attributes you want.
Additional attributes can be imported to BFI after adding them as computer property.

Here is the information how to deal with it:

http://www-01.ibm.com/support/knowledgecenter/SSKLLW_9.2.1/com.ibm.bigfix.inventory.doc/Inventory/com.ibm.bigfix.inventory.doc/planinconf/t_setting_up_computer_properties.html

After running import process all available new attributes can be found on computers report.

About API, please start with this API:
http://www-01.ibm.com/support/knowledgecenter/SSKLLW_9.2.1/com.ibm.bigfix.inventory.doc/Inventory/com.ibm.bigfix.inventory.doc/integration/r_get_computer_systems.html

Also here is short guide how to combine results of computer system API from above with computer properties.

1.) You have configured new computer property and imported it to BFI.

2.) Use api/schemas/computer.json API to find name mapping for your property. Part of example output:
“computer_property_1”: {
“type”: [
“string”,
“array”,
“null”
],
“items”: “string”,
“title”: “RAM”,
“mappings”: {
“type”: “array”,
“association”: true,
“description”: “Mappings into datasource properties”,
“item”: [
{
“datasource_site_remote_id”: -1995306482,
“datasource_analysis_remote_id”: 28,
“datasource_property_remote_id”: 1,
“datasource_id”: 1
}
]
}
}

3.) Use “computer_property_1” for RAM attribute as a name of column in API. Example:
/api/sam/computer_systems?columns[]=id&columns[]=computer_property_1