You might be able to get some of that using the Analytics, but I typically build a ticket or asset view with the field(s) I need and export it. Then I’ll use Google Sheets/Excel to fine-tune the data.

@BGlover 300f99a penntrafford Thank you for submitting your question to our community!

There are a few threads in the community and @AMeyer Greendale Schools makes a great point about creating a table or graph within excel. Here is an idea to upvote about getting better tracking like this:

This did what I was looking for. I was able to create a ticket view for our chromebook models then export it and sort in an Excel sheet by asset tag, and then highlight duplicate values.

This could be a solution all it’s own, especially if it was possible to list the owner of the asset that the ticket was linked to. Being able to view the asset owner would cut out the step of having to look up the asset in question in IIQ again.

I sometimes will do 2 exports - one with the tickets, including asset tag, and a second with the asset tags & owner information. I do an index match to pull the user data over to the ticket tab in my sheet.

Your ticket export should be able to include some owner data, but that depends on how the ticket was submitted, I think.