→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pskup
Engaged Sweeper III
Hello Community,

I have a report that should list computers and monitors. But only if they are in one of two different asset groups. The report should also show the "used by" relation. This is only setup for computers, not for monitors. So the report below only lists computers of which "used by" is defindet. How should I alter the selection so the monitors are also shown?


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetGroups.AssetGroup,
tblAssetUserRelations.Username,
tblAssets.Domain
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Inner Join tblAssetUserRelations On
tblAssets.AssetID = tblAssetUserRelations.AssetID
Where (tblAssetGroups.AssetGroup = 'Group1' And tblAssetCustom.State = 1) Or
(tblAssetGroups.AssetGroup = 'Group2')


Thanks for your help.
0 REPLIES 0