This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to
Article Number 000385088 for more information about troubleshooting BMC products in containers.
Legacy ID:KA402577
Please note, the base table name of a Remedy form varies from one installation to the other and it is in the format of T1234, where 1234 is the Remedy form’s schemaID. In this document, we use ???? to represent the Remedy form’s SchemaID.
Use Developer Studio to modify/create indexes.
HPD:Help Desk
a) Modify the existing index I????_1000000427_1 on HPD:Help Desk form so that it becomes a composite index with Status as the second field.
FIELDNAME
|
FIELDID
|
COLUMN POSITION
|
Owner Group ID
|
1000000427
|
1
|
Status
|
7
|
3
|
Assigned Group ID
|
1000000079
|
2
|
LookupKeyword
|
230000009
|
4
|
Company
|
1000000001
|
5
|
.
b) Modify the existing index I????_4_1 on HPD:Help Desk so that it becomes a composite index.
FIELDNAME
|
FIELDID
|
COLUMN POSITION
|
Assignee Login ID
|
4
|
1
|
Status
|
7
|
2
|
Owner Login ID
|
1000000716
|
3
|
LookUpKeyword
|
230000009
|
4
|
Out of box, this index was built on field C4 only.
c) Modify the existing index I????_1000000079_1 on HPD:Help Desk so that it becomes a composite index.
FIELDNAME
|
FIELDID
|
COLUMN POSITION
|
Assigned Group ID
|
1000000079
|
1
|
Status
|
7
|
2
|
Out of box, this index was built on field 1000000079 only.
d) Modify the existing index I????_ 1000000716_1 on HPD:Help Desk so that it becomes a composite index.
FIELDNAME
|
FIELDID
|
COLUMN POSITION
|
Owner Login ID
|
1000000716
|
1
|
Status
|
7
|
2
|
Out of box, this index was built on field 1000000716 only.
CHG:Infrastructure Change
a) Modify the existing index I????_1000000408_1 on CHG:Infrastructure Change form so that it becomes a composite index
FIELDNAME
|
FIELDID
|
COLUMN POSITION
|
CAB Manager Login
|
1000000408
|
1
|
Status
|
7
|
2
|
Out of box, this index was built on field C1000000408 only.
b) Modify the existing index I????_3234_1 on CHG:Infrastructure Change so that it becomes a composite index.
FIELDNAME
|
FIELDID
|
COLUMN POSITION
|
Assigned Group ID
|
1000003234
|
1
|
Status
|
7
|
2
|
Out of box, this index was built on field C1000003234 only.
c) Modify the existing index I????_1000000079_1 on CHG:Infrastructure Change so that it becomes a composite index.
FIELDNAME
|
FIELDID
|
COLUMN POSITION
|
Support Group ID
|
1000000079
|
1
|
Status
|
7
|
2
|
Out of box, this index was built on field 1000000079 only.
d) Add index I????_ 1000003231_1 on CHG:Infrastructure Change.
FIELDNAME
|
FIELDID
|
COLUMN POSITION
|
Assigned Login ID
|
1000003231
|
1
|
Status
|
7
|
2
|
e) Add index I????_ 1000003259_1 on CHG:Infrastructure Change.
FIELDNAME
|
FIELDID
|
COLUMN POSITION
|
ChgImpGrpID
|
1000003259
|
1
|
Status
|
7
|
2
|
|
There are other forms used by the Overview Console that may also need the same type of changes, such as WOI:WorkOrder, TMS:Task, AAS:Activity, AST:CI Unavailability, AST:PurchaseRequisition, RMS:Release, PBM:Known Error, PBM:Problem Investigation, and PBM:Solution Database
Related Products:
- BMC Remedy IT Service Management Suite