Performing an entity smart search across a custom NCIM database table
Use the entity smart search feature to search for an entity across a custom NCIM database table in an extended NCIM database.
Before you begin
About this task
To perform an entity smart search across a custom NCIM database table specify the following URL to the Dashboard Application Services Hub:
http(s)://DASH_HOST:DASH_PORT/ibm/console/ncp_structureview/Search.do?
selectEntityName=entityName&namespace=CUSTOM_TABLE.CUSTOM_FIELDwhere
- DASH_HOST -- Specifies the name of the host computer on which the Dashboard Application Services Hub server was installed.
- DASH_PORT -- Specifies the port number associated with the host computer on which theDashboard Application Services Hub server was installed.
- entityName -- Specifies the name of the entity
to search across a custom NCIM database table. The entityName is
case sensitive as it must match an existing value in the specified
NCIM custom database table. The entityName is linked
to the entityId in the custom NCIM database table.
You can also specify spaces in the entityName by using the
+(plus sign) or%20(percent sign followed by the number 20). For example, the space in the entity name;SM 0001can be specified as;SM+0001or;SM%200001.Note: The URL path is case sensitive (that is, all items in the path are lower case except for the upper caseSinSearch). The parameter nameselectEntityNamein the URL specification is also case sensitive. - CUSTOM_TABLE -- Specifies the name of the NCIM
custom database table in the extended NCIM database in which to perform
the search of the entity specified in entityName.
This NCIM custom database table contains the two fields: entityId
and CUSTOM_FIELD. The entityId is a foreign key
to the entityNameCache table and must be unique for each entity across
all domains. The entityId is automatically incremented.Note: You do not specify the entityId in the URL specification.
- CUSTOM_FIELD -- Specifies the name of the field
to search within the NCIM custom database table. The entityId field
in the NCIM custom database table in the extended NCIM database will
reference the entityId field in the entityData table.Note: When using the extended namespace functionality, ensure that the NCIM custom database table forms a natural join to the NCIM.entityData table by entityId. After that, the user can put whatever data they want into the NCIM custom database table.
The performance of the extended namespace search is dependent on the NCIM custom database having relevant up-to-date indexing.
The following notes describe use of the
namespaceparameter and associated values:- The
namespaceparameter is not case sensitive - The parameter values, CUSTOM_TABLE and CUSTOM_FIELD, must be separated by a dot (.).
- The parameter values, CUSTOM_TABLE and CUSTOM_FIELD, are not case sensitive and can include only alphabetic characters and the underscore (_) character. These parameter values must also begin with an alphabetic character.
- The
Procedure
Example
https://dash01.ibm.com:16311/ibm/console/ncp_structureview/Search.do?
selectEntityName=Tokyo&namespace=customns.locationwhere
dash01.ibm.com-- Specifies the host name of the computer on which the Dashboard Application Services Hub server was installed.16311-- Specifies the port number associated with the host computer on which the Dashboard Application Services Hub server was installed.customns-- Specifies the name of the custom table in the extended NCIM database in which to perform the search of the entity specified in entityName.location-- Specifies name of the field to search within thecustomnscustom table.Tokyo-- Specifies the name of the entity to search for in thecustomnscustom table. (This entity is linked to the entityId in thecustomnscustom database table.)