→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ryancarter
Engaged Sweeper II
I am trying to build a report that will work with a chart to show me Approved / Denied / Unclassified software.
1 ACCEPTED SOLUTION
ryancarter
Engaged Sweeper II
I did it like this:

Select Top 1000000 Case tblSoftwareUni.Approved When 1 Then 'Approved'
When 2 Then 'Denied' Else 'Unclassified' End As Status,
COUNT(*) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Group By Case tblSoftwareUni.Approved When 1 Then 'Approved'
When 2 Then 'Denied' Else 'Unclassified' End

View solution in original post

1 REPLY 1
ryancarter
Engaged Sweeper II
I did it like this:

Select Top 1000000 Case tblSoftwareUni.Approved When 1 Then 'Approved'
When 2 Then 'Denied' Else 'Unclassified' End As Status,
COUNT(*) As Total
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Group By Case tblSoftwareUni.Approved When 1 Then 'Approved'
When 2 Then 'Denied' Else 'Unclassified' End