Notification

Icon
Error

Summary report for software

Posted: Friday, October 4, 2013 11:04:10 AM(UTC)
d.i.saunders

d.i.saunders

Member Original PosterPosts: 99
2
Like
This issue has been solved! Click here to view the solution
Hi,

I'm looking for a report to show the summary of software.

The data i'm looking for is identical to the data displayed on the Software Authorization view in lansweeper... Just need these as 3 different reports

Eg:

Report 1
Allowed software:
(Applications name) (Publisher) (number of installs)

Report 2
Denied software:
(Applications name) (Publisher) (number of installs)

Report 3
Denied software:
(Applications name) (Publisher) (number of installs)

any one got the code for this?

thanksDancing
Lansweeper
#1Lansweeper Member Posts: 13,442  
posted: 10/4/2013 4:55:04 PM(UTC)
Unrated software
Quote:
Select Top 1000000 tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
Count(tblSoftware.AssetID) As Installs
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.Approved = 0
Group By tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher
Order By tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher

Denied software
Quote:
Select Top 1000000 tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
Count(tblSoftware.AssetID) As Installs
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.Approved = 2
Group By tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher
Order By tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher

Approved software
Quote:
Select Top 1000000 tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
Count(tblSoftware.AssetID) As Installs
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.Approved = 1
Group By tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher
Order By tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher
nhouse24
#2nhouse24 Member Posts: 4  
posted: 10/29/2019 6:11:11 PM(UTC)
THANK YOU

Active Discussions

Lansweeper HP Warranty scan - broken for some products
by  M Redfern   Go to last post Go to first unread
Last post: Today at 12:30:44 PM(UTC)
Lansweeper Worked time
by  Imrane DESSAI  
Go to last post Go to first unread
Last post: Today at 7:14:40 AM(UTC)
Lansweeper Adding Owner/User information to Assets:All column report
by  ssmarr5   Go to last post Go to first unread
Last post: Today at 12:15:01 AM(UTC)
Lansweeper Send users email about low disk space
by  DontByteMe  
Go to last post Go to first unread
Last post: Yesterday at 10:02:43 PM(UTC)
Lansweeper Can reports be directed to a file server
by  RKCar   Go to last post Go to first unread
Last post: Yesterday at 9:40:18 PM(UTC)
Lansweeper Monitor Model- Generic PnP Monitor
by  Roger D.  
Go to last post Go to first unread
Last post: Yesterday at 7:22:01 PM(UTC)
Lansweeper Are Deleted Dashboard Tabs Retrievable?
by  Rob-CD   Go to last post Go to first unread
Last post: Yesterday at 4:04:45 PM(UTC)
Lansweeper Assets Not Seen in 90 Days not Automatically becoming Inactive
by  Rob-CD  
Go to last post Go to first unread
Last post: Yesterday at 4:00:00 PM(UTC)