@RolandB, it took me some time to get this far, but here's what I came up with. Not perfect by my standards, but should provide a starting point for others as well.
First I went thru the Software Authorization list and either Approved, Unapproved or left Unrated all the software I had.
Second was to add this chart to the dashboard for reporting. I labeled mine "Chart: Unapproved Software" and choose Bar as the display. Also I left on the data table for additional information.
Select Top (1000000) tblSoftwareUni.softwareName As Software, Count(tblSoftwareUni.SoftID) As [Unapproved Software] From tblSoftware Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID Where tblSoftwareUni.Approved = 2 Group By tblSoftwareUni.softwareName, tblSoftwareUni.Approved
I'd like to have the software linkable to show the assets their on.
If anyone has any ideas I'm open to trying them.
Hope this helps.
If you bring up the built-in report "Software authorization" you can approve/deny./unrate your software list that Lansweeper detected.
Then you have three other reports that you can select from to find what you're looking for:
1 - Software: Approved software
2 - Software: Unauthorized software
3 - Software: Unrated software
From any of these reports you can filter the data as needed.
Does this statement "Report == Chart:" mean that you're looking to have a chart of the results?