Skip to main content
Solved

Creating a report or view with asset tag to display serial numbers

  • February 28, 2024
  • 3 replies
  • 159 views

Forum|alt.badge.img+1

Is there a way to create a report where I enter 150 asset tags and it will print the serial numbers for these asset tags in a spreadsheet?  

Best answer by jclark

Technically, yes and no.

The “yes”:
You can create an asset view of all devices, and add the columns you want to see (such as serial number) to the view. Then filter by Asset Tag and paste your list of asset tags in the search box.

 

The “no”:
You can only paste 100 line items at a time - it drives me crazy. Vote on the idea below so iiQ devs will fix it lol.

 

 

3 replies

Forum|alt.badge.img+16
  • Specialist
  • Answer
  • February 28, 2024

Technically, yes and no.

The “yes”:
You can create an asset view of all devices, and add the columns you want to see (such as serial number) to the view. Then filter by Asset Tag and paste your list of asset tags in the search box.

 

The “no”:
You can only paste 100 line items at a time - it drives me crazy. Vote on the idea below so iiQ devs will fix it lol.

 

 


Erica
Contributor
Forum|alt.badge.img+9
  • Contributor
  • February 28, 2024

@LSmith 3476410 mymec - you will also want to be sure that you have the proper Barcode Value set in your Site Options as well.

 


Kathryn Carter
Forum|alt.badge.img+18

@LSmith 3476410 mymec Thank you for submitting your question to our community! 😄

I agree with @jclark on this! That is what I would have suggested, too. Did this work for you?