How do I create a breakdown report to list total number of assets by Tags?

[Gonzo J]

I have many assets spread through various locations (sites) that are tagged with one of 10 or so different tags based on their current issue. I need to create a report to display those tags with the total number for each tag type, that I can then drill down to see all the specific devices in that tag grouping.

I'm able to get a report using the Asset table (alm_asset) that can display it grouped by site, but I can't figure out how to build a report to group by the tag. Am I missing something simple? I'm fairly new to Service Now reporting, so its possible I'm overlooking the obvious..

[Thomas_Davis]

Hello,

The link below may help you get what you are looking for.

https://community.servicenow.com/community?id=community_question&sys_id=db96eb59db2817c0fc5b7a9e0f96...

It looks like creating a Database View is the way to go to get what you need from Tags.

https://docs.servicenow.com/bundle/newyork-platform-administration/page/use/reporting/concept/c_Data...

I would also recommend that you since you are fairly new to Performance Analytics & Reporting you take a look at this Article:

https://community.servicenow.com/community?id=community_article&sys_id=44c3a3ecdbf43f84d82ffb2439961...

Hope this helps,