Worked Examples
Example A: A Clean Software List, Sorted, With a Combined Column
- Click 'Create report' > 'Software Inventory'.
- Click the editor icon.
- Add a 'Custom column': concat([Software Name], " ", [Software Version]), named Name and Version.
- Add a 'Sort' by 'Software Name'.
- Add a 'Row limit' of 50.
- Click 'Visualize', then save it as Software list sorted.
Result: 50 rows, in name order, with a combined name-and-version column on the right.
Example B: Which Vendors Have the Most Installed Software? (Pie Chart)
- Click 'Create report' > 'Software Inventory' > 'Summarize' and group by 'Software Vendor'.
- Click 'Visualization' > 'Pie'.
- Save it as Software count by Vendor (Pie).
Result: a donut chart with each vendor's share and the total in the centre. Small vendors are combined into 'Other'.
Example C: How Many Devices Are in Each Status?
- Click 'Create report' > 'Hardware Inventory'.
- Click 'Summarize' and group by 'Online Status'.
- Check the bar chart, then click 'Save'.
Example D: Show Only Recent Activity
- Open a table, for example 'Hardware Inventory'.
- Click 'Filter' > 'Last Activity' > '...' > 'Last 30 Days' > 'Apply Filters'.
If your data has no activity in the last 30 days, the report shows 'No results!'. This is normal. Try 'Last 12 Months'.
Example E: How Many Different Programs Does Each Vendor Have?
- Click 'Create report' > 'Software Inventory' > 'Summarize'.
- Click '+' next to 'Count' and add 'Number of distinct values of...' > 'Software Name'.
- Group by 'Software Vendor', then click 'Done'.
- Add a 'Filter' if you only want certain devices, then click 'Save'.
Result: one row per vendor with two numbers: total installs and the number of different programs.

