Little help needed with report builder

[InnovationIT]

I am trying to build a report which will show all software installed on our virtual machines only. So far I've figured out that I can determine which machines are virtual as the computer manufacturer field will show up as something like "VMWare" or "VmWare Virtual platform"

So that's my problem, I would like to find sofwate installed only on a group that I create which contains 2-3 manufacturers only.

Any help would be appreciated.

[InnovationIT]

Thank you very much

[Hemoco · Accepted solution]

A sample report can be seen below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblAssetCustom.Manufacturer Like '%vmware%'
Order By tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion