Report for Software but only in PCs

[KahaMakate]

Greetings to the community,

I have created the following report to get PCs with Firefox Installed, but i keep getting VMs as well.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.OSname As OS,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID In (Select Top 1000000 tblAssets.AssetID
From tblAssets Inner Join tblAssetCustom On tblAssets.AssetID =
tblAssetCustom.AssetID Inner Join tsysAssetTypes On
tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblSoftware
On tblAssets.AssetID = tblSoftware.AssetID Inner Join tblSoftwareUni On
tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Firefox%' And (tsysOS.OSname =
'Win 10' Or tsysOS.OSname = 'Win 11'))

How can i exclude VMs and anything that is not a Windows Computer?

Thanks!
 

[FrankSc]

Hello KahaMkate,
You could add a WHERE clause in the query for tblAssetCustom.Manufacturer and exclude the ones that have "VMware, Inc." for this value.

[KahaMakate]

Great, can you provide the exact code line and where to put it?

[KevinA-REJIS · Accepted solution]

Try it in the last line of code:

Where tblSoftwareUni.softwareName Like '%Firefox%' And (tsysOS.OSname =
'Win 10' Or tsysOS.OSname = 'Win 11') And tblAssetCustom.Manufacturer Not Like "%VMware%")