Custom Report Needed For Software Changes

[RTI_IT]

Hi! Not sure how to make this work but I need a custom report that shows the following:

Poll only from assets that are in the LS Asset Group "QA Software Tracking"
Computer Name
Last Username (We have only one user per machine here)
Software installed that is on the LS Unauthorized or LS Neutral List.
Install Date

Can anyone help with this?
Ed

[RTI_IT]

Worked out great, thanks!!

[Hemoco · Accepted solution]

Please use the following report:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblSoftwareUni.softwareName,
Case tblSoftwareUni.Approved When 0 Then 'unrated' When 1 Then 'Approved'
When 2 Then 'unapproved' End As approved,
tblSoftware.Installdate
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'QA Software Tracking' And
(tblSoftwareUni.Approved = 0 Or tblSoftwareUni.Approved = 2)