This documentation supports the 1.3 version of Remedy with Smart IT.

To view the latest version, select the version from the Product version menu.

Adding indexes for improving asset search

On the Asset Console, depending on the filters you commonly use, you may need to fine tune the performance of Smart IT. To improve performance you may apply indexes given in this topic, to the corresponding fields on their specific form. Fields that are found underperforming when searching for assets are listed in this topic.

Along with indexes, performance improvement also depends on the query criteria that is used in conjunction with indexes. Therefore, it is recommended that you create composite indexes based on the common search patterns.

Disclaimer

Effectiveness of indexes depends on the distribution of data and usage of query criteria. To ensure better performance, carefully test the indexes before you implement them in your production environment. 

You can create separate indexes using BMC Remedy Developer Studio on the following fields:

Indexes for searching asset using Keyword

Field nameForm nameField name and ID
AssetIDAST:AttributesAssetID(210000000)
NameBMC.CORE:BMC_BaseElementName(200000020)

Indexes for searching assets using Scanned code

Field nameForm nameField name and ID
TagNumberAST:AttributesTagNumber(260100004)
SerialNumberBMC.CORE:BMC_BaseElementSerialNumber(200000001)


You can create composite indexes using BMC Remedy Developer Studio on the following fields:

Indexes for searching assets using Type/Subtype

Field nameForm nameField name and ID
DatasetIdBMC.CORE:BMC_BaseElementDatasetId(400127400)
ClassIdBMC.CORE:BMC_BaseElementClassId(400079600)

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments