Hi all
I am not sure if the following is possible, but I thought I would ask just in case.
We managed to create (with the kind help of someone here), a report of all the software, number of installations and whether its approved or not. Basically the Software Authorization page in a report format, so its easy to export and send around etc. Which is below:
Select Top 1000000 Count(tblAssets.AssetID) As Count,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
Case
When tblSoftwareUni.Approved = 2 Then 'Unauthorised'
When tblSoftwareUni.Approved = 1 Then 'Approved'
When tblSoftwareUni.Approved = 0 Then 'No Status'
End As Status
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
Case
When tblSoftwareUni.Approved = 2 Then 'Unauthorised'
When tblSoftwareUni.Approved = 1 Then 'Approved'
When tblSoftwareUni.Approved = 0 Then 'No Status'
End
Order By Software
I wanted to know if its possible to group software, for example, instead of listing 20 different versions of 7-zip, group that into one entry based on perhaps the publisher, for example. I understand this might be hard if some versions are approved and others not, but would there be a way to group that also depending on its approved status?
Hope I've explained well.
Many thanks in advance!
