09-15-2022 10:06 AM
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.
09-22-2022 09:05 PM
@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.
09-16-2022 12:25 PM
Yes I need a chart. I want to show how many Unauthorized software have every computer.
Which Computer have the most Unauthorized software. 🙂
09-15-2022 07:06 PM - edited 09-15-2022 07:07 PM
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?
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now