Query on Asset 'Category'
Overall goal: Make a report that totals the number of systems for each operating system group based off Asset Categories.
So I'm having trouble figuring out how to make a query to search for something that defines what Asset Category (operating systems to be specific) an Asset is in. I can make single reports that total the number of Assets in say Windows, Linux, or Cisco... but each sum would come out individually for that operating systems in the report as opposed to all of them totaled in one report for comparison reasons. Same thing if I play around with Drilldown in Query Viewers... still not all in one view.
If anyone has this simplified this or has any suggestions it would be greatly appreciated, thanks!
Re: Query on Asset 'Category'
Figured it out.
- Variable: FormatGroupOfAsset
- Base Field: Device Asset ID
- Base Group: AssetCategory
- -Base Group: *the category you want to define
...then you can make a condition for Assets that fall under defined Categories.