Asset Management - List View Search does not work on certain fields

[Frank Reay]

In the List View when I enter some text to search by this does not pick up anything in Device Name (in Asset Class of Mobile Device) or State (Substate is fine). These searches return no records.

Most other fields seem to be OK (although I haven't checked every one of them!).

[Deen]

@Frank Reay I'll run a few tests in house and see if I can replicate this.

[Frank Reay]

Hi @Deen

Any update on this. 

Thanks,

Frank

 

[Frank Reay]

@Deen Are you able to replicate this as this is becoming a pain for us. We can't use the simple search to find anything in the Device Name field.

Searching for something via the Simple Search (as below) which we know exists in the Device Name field returns no assets.

Instead we have to use the Advanced Search (as below) which does work but is a real pain for Agents to do everytime.

[Frank Reay]

What I have just noticed is that it appears nothing in the 'Mobile Device Information' Section is searchable by the Simple Search. However fields in the other Additional Properties Sections are picked up. That doesn't feel right to me as I can't see why that would be the case.

[Deen]

Hi @Frank Reay, Apologies for the delay in getting back to you.  I've been trying to replicate this but not having much luck, if you could PM me a support passcode I can take a closer look at your setup.

[Frank Reay]

@Deen Thank you and I have just PM'd you.

[Deen]

@Frank Reay, thanks for this.  I'm currently taking a look and will have an update for you tomorrow.

[Deen]

@Frank Reay, From discussing this with my colleagues and looking at your setup via the passcode provided, I believe you can only search on values in the h_cmdb_assets table, h_devicename which as the name suggests stores the Device Name is taken from the h_cmdb_assets_mobile_device table which would not be searchable.  It would probably require an enhancement to enable this.

[Frank Reay]

@Deen I am sorry but that is NOT the case. For example from the table h_cmdb_assets_mobile_device:

These are fields are searchable:

h_tariff_code

h_secondary_service_provider_id

h_serial_number

h_os_version

Whereas these fields are not:

h_device_name

h_device_registration_state

h_os_description

I cannot see why some fields within the same table are searchable and some are not (even for related info such as os_description and os_version). It is highly confusing for my users and I cannot explain it.