Skip to main content
Solved

How to set an Asset filter that will compare two specific fields.

  • January 24, 2025
  • 1 reply
  • 70 views

Is there a way in Asset Explorer to search for discrepencies between two different fields that should match in our inventory? For example we are wanting to locate a list of all our Chromebooks in inventory that do not have a matching value for Serial number and Asset tag? Is there a way to design a Custom Field in Admin for that purpose, etc? Thanks - ACSD1 Technology

Best answer by JustinRaynor_iiQ

Hey ​@ADavis 6209d1b acsd1!

So we do have some discrepancy filters, but they would be for duplicate assets or mismatch of owners. Once thing that you would be able to create as a custom view would be filtering based on Chromebook Model Category and then adding the ‘Serial Number’ column to the view along with Asset Tag. You could then export this data and identify mismatches through the CSV file or going through the list within the browser.

 

 

Hopefully, this information helps with your workflow!

1 reply

JustinRaynor_iiQ
Forum|alt.badge.img+12

Hey ​@ADavis 6209d1b acsd1!

So we do have some discrepancy filters, but they would be for duplicate assets or mismatch of owners. Once thing that you would be able to create as a custom view would be filtering based on Chromebook Model Category and then adding the ‘Serial Number’ column to the view along with Asset Tag. You could then export this data and identify mismatches through the CSV file or going through the list within the browser.

 

 

Hopefully, this information helps with your workflow!