‎06-04-2021 01:00 PM
Solved! Go to Solution.
‎06-04-2021 03:42 PM
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
‎06-04-2021 03:42 PM
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
‎06-07-2021 03:55 PM
Andy.S wrote:
Hi,
Is this what you are after ?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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now