cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
InnovationIT
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
InnovationIT
Engaged Sweeper
Thank you very much
Hemoco
Lansweeper Alumni
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