Summary report for software

[d_i_saunders]

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?

thanks

[nhouse24]

THANK YOU

[Hemoco · Accepted solution]

Unrated software

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

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

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