cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
RolandB
Engaged Sweeper III

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.

3 REPLIES 3
rader
Champion Sweeper III

@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 SoftwareChart: 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
Engaged Sweeper III

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

Which Computer have the most Unauthorized software.  🙂 

rader
Champion Sweeper III

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?