Global Text Search - How to search Asset Number

[Celliven]

Hi There

I have added a search group to look at [alm_asset] and [alm_hardware] and allocated the roles of admin and itil.

I would think that If I have these tables selected ServiceNow should perform a search against all fields on both tables, however when I perform a search against a serial number I do not get a hit?

I'm sure this must be a fairly standard request.....

Any thoughts?

Thanks

Chris

[larstange]

Hi

The Generate text index will only show on the collection, as you will regenerate the text index for the entire table - therefore just open the collection entry in the dictionary and click the link.

I don't thing it will make sense to click it on the asset_tag dictionary entry.

I just changed the value of the "Text index" field directly in the dictionary table so I didnt't have to mess with any ui policies

[Celliven]

Now that makes sense, especially when I test it on another instance and 'hey Presto' works just as you described.

The issue I have is that the instance I am working on doesn't have a Collection entry on any table.

Not sure why and can't see how to create one.

Have you heard of that before?

[larstange]

If you go to Asset -> All Assets and open the table. Then right click the header and go to the dictionary

The you MUST have a collection entry

If not you have a corruption in your dictionary data model

[Celliven]

Oh dear

sounds like a corruption in the data model

I'll have to escalate that and perhaps log it with ServiceNow.

Wonder how that happened, imagine it isn't an easy fix.

Thanks for all your help, I'll go back and mark your answer as correct, especially as I saw it work in another instance.

Thanks again

Chris

[larstange]

Hi

You should be able to export the collection record from another instance as an XML file and import it to restore the record.

Or ServiceNow will probably be able to fix it.