
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-04-2013 12:04 PM
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
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

Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-04-2013 05:55 PM
Unrated software
Denied software
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 = 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
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-29-2019 06:11 PM
THANK YOU

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-04-2013 05:55 PM
Unrated software
Denied software
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 = 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
