This documentation supports the 1.4 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. For example, product categorization related fields such as product name, model, and version or Site/region related fields such as region, site group, and site. This is driven by the typical query patterns used in your organization.

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 on the following fields. You may preferably use BMC Atrium Class Manager for adding indexes on the fields pertaining to BMC.CORE:BMC_BaseElement. The AST:Attributes fields requires BMC Remedy Developer Studio for creating indexes. Creating indexes by using BMC Atrium Class Manager is a handy way, but it is not a mandatory method. You may still create indexes using BMC Remedy 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 nameForm nameField name and ID
AssetIDAST:AttributesAssetID(210000000)
NameBMC.CORE:BMC_BaseElementName(200000020)

Indexes for searching assets by using Scanned code

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


You can create composite indexes on the following fields:

Indexes for searching assets by using Type/Subtype

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

Indexes for searching assets by using Product Category/Name

Field nameForm nameField name and ID
TypeBMC.CORE:BMC_BaseElementType(200000004)
ItemBMC.CORE:BMC_BaseElementItem(200000005)
Model BMC.CORE:BMC_BaseElementModel(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 nameForm nameField name and ID
RegionBMC.CORE:BMC_BaseElementRegion(200000012)
SiteGroupBMC.CORE:BMC_BaseElementSiteGroup(200000007)
SiteBMC.CORE:BMC_BaseElementSite(260000001)
RoomBMC.CORE:BMC_BaseElementRoom(260000005)
FloorAST:AttributesFloor(260000004)
StatusAST:AttributesAssetLifecycleStatus(7)
ManufacturerBMC.CORE:BMC_BaseElementManufacturerName(240001003)

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

  1. Foued Ben hadj ali

    Hi,

    as far as I know, adding indexes on the CMDB should be performed via le class manager and not developer studio (https://docs.bmc.com/docs/display/public/ac91/Specifying+class+indexes+from+the+Class+Manager).

    Could you please check as I think this doc should be updated.

     

    Thanks

    Aug 31, 2016 05:54
    1. Rakhi Rathod

      Hello Foued,

      Thanks for the comment. I'll discuss your comment with Smart IT SMEs, and update the topic. I'll keep you posted.

      Regards,

      Rakhi

      Aug 31, 2016 02:18
    1. Rakhi Rathod

      Hello Foued,

      I updated the topic based on your comment.

      Let me know if you have additional questions.

      Regards,

      Rakhi

      Sep 06, 2016 09:44
  2. Foued Ben hadj ali

    Hi,

    I think this doc is still not accurate.

    For instance it is written:

    Depending on the common search pattern followed at your site, you can create separate or composite indexes using BMC Remedy Developer Studio on the following fields:

    Indexes for searching assets using other available filters

    Field name
    Form name
    Field name and ID
    Field name
    Form name
    Field name and ID
    RegionBMC.CORE:BMC_BaseElementRegion(200000012)
    SiteGroupBMC.CORE:BMC_BaseElementSiteGroup(200000007)

    I think this is wrong as Atrium Class manager should be used as per the document I have previously sent you.

    Therefore, I think it would be better to remove each reference to dev studio when it is said to add indexes to BaseElement.

     

    Thanks

     

    Sep 06, 2016 09:52
    1. Rakhi Rathod

      Hi,

      I update the topic to clarify the point. You can use both Atrium Class Manager or Dev studio to create indexes. It depends on the availability and accessibility to these tools. 

      Thanks,

      Rakhi

      Sep 07, 2016 02:21
  3. Ravi Vakkalar

    Hi,

    On which form we have to add index to managed by field which is used as default search field along with Asset type on Smart IT console? Currently I can see when we add indexes to the fields mentioned above search works much better. But for all the users by default ,search criteria is AssetType+Managed by. on Smart IT Asset console. I am not able to find Managed by field on AST:Base Element or AST:Attributes or on BMC.CORE:BMC_BaseElement form. From which form managed by field is used in query? 

    May 18, 2018 04:01