Adding tables to Global Search is not working?

[harshald]

Hi All,

I have created "CMDB" in Text Search Groups and added "cmdb_ci" in Text search tables in order to search CI's or other fields from Global search.

Please find attachments.

I have checked all the steps mentioned in is not working at all :
1. https://community.servicenow.com/community?id=community_question&sys_id=dadecf61dbdcdbc01dcaf3231f961936

2. https://community.servicenow.com/community?id=community_question&sys_id=71dc4729db9cdbc01dcaf3231f961950

I have referred  OOB "Tasks" Text Search Groups for refrence there it is configured like all the tables under task are added in "Text search tables" , so do I need to add all the child tables of cmdb_ci ??

(I have tried this for one of the table i.e. alm_hardware still it didn't worked.)

Please let me know if someone have any solution to this or any point I am doing incorrectly.

[Ricardo Velez]

Hello Harshald,

Have you generated a text index for the CMDB table? If not I would suggest you do this in order to be able to generate the indexes and allow you to search through the hierarchy of tables in CMDB. 

1) Go to System Definition > Text Indexes

2) Create a text index record like so:

3) Click on the 'Regenerate Text index' related link at the bottom of this new text index record.

It will take a while for the indexing to finish depending on the size of your cmdb table (Could be a couple of hours), but as long as you refresh your record and see indexed rows column increasing, then it should be doing its job. 

If doing this does not work, then I suggest you open a ticket in Hi for our User Experience group who specializes in text searching.

Best regards,
Ricardo Velez | Senior Technical Support Engineer
ServiceNow | The Enterprise Cloud Company

[Aishwarya Tengs]

Hi Ricardo,

Is text indexing must in order to add table in global search if it is not existing?

If yes then It is not allowing me to create it, as in I am not getting "New"option, also text indexing for  cmdb_ci is not existing.

Please Guide me to the correct way.

Best Regards,

Aishwarya Tengse

ServiceNow Developer | Accenture

[Ricardo Velez]

Hi Aishwarya,

If you do not generate the text index for the cmdb table, then we do not generate the corresponding ts_document records that allow the system to search for terms inside this table and will return 0 results.

The instructions mentioned in my previous comment only function for maint users. The correct steps to follow are listed in the following doc:

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/search-administra...

1) Go to the dictionary table (sys_dictionary)

2) Look for the table you want to enable text indexing for by searching for the cmdb_ci table on the Table column.

3) Open the 'Collection' Type record on this list in the dictionary.

4) Click on Generate Text Index.  (See highlighted UI Action on screenshot)

Hope this helps!

Best regards,
Ricardo Velez | Senior Technical Support Engineer
ServiceNow | The Enterprise Cloud Company

[Aishwarya Tengs]

Hi Ricardo,

I tried this and it worked for me , thanks a lot 🙂 !!

Best Regards,

Aishwarya Tengse

ServiceNow Developer | Accenture