Report that shows everything except servers, phones, or VM

[SebastianR7]

Forgive my lack of SQL knowledge.

I need a report that will show ALL desktops and laptops running Windows, Linux, and Mac.

Is there such a thing?

[Hemoco]

Yes, please check the filters below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where tblAssetCustom.Model Not Like '%virtual%' And
tblComputersystem.Domainrole < 2 And tsysAssetTypes.AssetType In ( -1, 11, 13)
And tblAssetCustom.State = 1
Order By tblAssets.AssetName

[SebastianR7]

Thank you very much. Is there a way to only show workstations...no servers or virtual machines?

[Hemoco · Accepted solution]

All in one reports are never a good idea but this report gives you the list you require:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Where (tblComputersystem.Domainrole < 2 Or tblComputersystem.Domainrole Is Null)
And tsysAssetTypes.AssetType In ( -1, 11, 13) And tblAssetCustom.State = 1
Order By tblAssets.AssetName