Adding indexes for improving asset search
This topic provides additional suggestions for improving performance based on internal benchmarks and field engagement.
On the Asset Console, depending on the filters you commonly use, you might need to fine tune the performance of Smart IT. To improve performance, you can apply indexes to the fields listed in this topic, which are found to under perform during asset searches.
You can create separate indexes on the fields listed in this topic. You may preferably use Class Manager for adding indexes on the fields pertaining to BMC.CORE:BMC_BaseElement. The AST:Attributes fields requires Developer Studio for creating indexes. Creating indexes by using Class Manager is a handy way, but it is not a mandatory method. You may still create indexes using Developer Studio, if it is available. Your preference depends on the availability and accessibility to these tools.
Indexes for searching asset by using Keyword
Field name | Form name | Field name and ID |
|---|---|---|
AssetID | AST:Attributes | AssetID(210000000) |
Name | BMC.CORE:BMC_BaseElement | Name(200000020) |
Indexes for searching assets by using Scanned code
Field name | Form name | Field name and ID |
|---|---|---|
TagNumber | AST:Attributes | TagNumber(260100004) |
SerialNumber | BMC.CORE:BMC_BaseElement | SerialNumber(200000001) |
You can create composite indexes on the following fields:
Indexes for searching assets by using Type/Subtype
Field name | Form name | Field name and ID |
|---|---|---|
DatasetId | BMC.CORE:BMC_BaseElement | DatasetId(400127400) |
ClassId | BMC.CORE:BMC_BaseElement | ClassId(400079600) |
Indexes for searching assets by using Product Category/Name
Field name | Form name | Field name and ID |
|---|---|---|
Type | BMC.CORE:BMC_BaseElement | Type(200000004) |
Item | BMC.CORE:BMC_BaseElement | Item(200000005) |
Model | BMC.CORE:BMC_BaseElement | Model(240001002) |
Depending on the common search pattern followed at your site, you can create separate or composite indexes on the following fields:
Indexes for searching assets by using other available filters
Field name | Form name | Field name and ID |
|---|---|---|
Region | BMC.CORE:BMC_BaseElement | Region(200000012) |
SiteGroup | BMC.CORE:BMC_BaseElement | SiteGroup(200000007) |
Site | BMC.CORE:BMC_BaseElement | Site(260000001) |
Room | BMC.CORE:BMC_BaseElement | Room(260000005) |
Floor | AST:Attributes | Floor(260000004) |
Status | AST:Attributes | AssetLifecycleStatus(7) |
Manufacturer | BMC.CORE:BMC_BaseElement | ManufacturerName(240001003) |
(Change request tickets only) You can create separate indexes for searching assets by using keywords in the default text field:
Indexes for searching assets by using keywords
Field name | Form name | Field name and ID |
|---|---|---|
Name | BMC.CORE:BMC_BaseElement | Name(200000020) |
ManufacturerName | BMC.CORE:BMC_BaseElement | ManufacturerName(240001003) |
Model | BMC.CORE:BMC_BaseElement | Model(240001002) |