Need a Report = Chart: Computer with Unauthorized software

[RolandB]

Hello,  can someone help me I need a Report == Chart: Computer with Unauthorized software

I want to find the computers with the most Unauthorized software.

[rader]

@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

Chart: Unapproved Software

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.

[RolandB]

Yes I need a chart.  I want to show how many Unauthorized software have every computer.

Which Computer have the most Unauthorized software.  🙂 

[rader]

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?