Asset "State" field choices, repeat in dropdown

[WB]

I noticed the OOB Hardware Asset form's "State" field is showing repeating choices for In Use and In Stock, only differing in capitalization (screenshot below).  Haven't noticed it prior. Possibly started a few months ago with an upgrade to UTAH.   Has anyone experienced this same issue and know the solution?   Thank you in advance.

[AshishKM · Accepted solution]

Hi @WB ,

Check the details in sys_choice table , my instance on tokyo but "In Use" and "In Stock" showing only once.

You can set "Inactive=true" if not used by any asset else update the asset first and inactivate it.

-Thanks

Ashish

AshishKMishra

[Danish Bhairag2]

Hi @WB ,

Is you Asset data getting populated/updated via Transform Map(Bulk Upload)/SCCM/Discovery.

Then there is a high chance those extra ones would have come from those.

As Ashish suggested, you can navigate to the sys_choice table, find those entries by applying proper filter & deactivate those if not required.

Also you need to check these part  how data comes in Asset table (Transform Map(Bulk Upload)/SCCM/Discovery).

Deactivating will not help as whenever the above mentioned things runs again it will again create one.

Thanks,

Danish

[AshishKM]

adding , if data is coming from external source which is using transform map then update the "Choice action" for state field mapping as ignore.

-Thanks

Ashish

[Dr Atul G- LNG]

Hi @WB 

I am on Vancouver now and all good here.

Possible reason, someone created manually or coming from discovery or other external sources.