‎03-27-2015 03:48 PM
Solved! Go to Solution.
‎03-27-2015 04:39 PM
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
Where
tblAssets.AssetID In (Select tblAssetGroupLink.AssetID
From tblAssetGroupLink Inner Join tblAssetGroups
On tblAssetGroupLink.AssetGroupID = tblAssetGroups.AssetGroupID
Where tblAssetGroups.AssetGroup Like 'GROUP1')
And
tblAssets.AssetID Not In (Select tblAssetGroupLink.AssetID
From tblAssetGroupLink Inner Join tblAssetGroups
On tblAssetGroupLink.AssetGroupID = tblAssetGroups.AssetGroupID
Where tblAssetGroups.AssetGroup Like 'GROUP2')
And tblAssetCustom.State = 1
‎03-27-2015 05:14 PM
‎03-27-2015 04:39 PM
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
Where
tblAssets.AssetID In (Select tblAssetGroupLink.AssetID
From tblAssetGroupLink Inner Join tblAssetGroups
On tblAssetGroupLink.AssetGroupID = tblAssetGroups.AssetGroupID
Where tblAssetGroups.AssetGroup Like 'GROUP1')
And
tblAssets.AssetID Not In (Select tblAssetGroupLink.AssetID
From tblAssetGroupLink Inner Join tblAssetGroups
On tblAssetGroupLink.AssetGroupID = tblAssetGroups.AssetGroupID
Where tblAssetGroups.AssetGroup Like 'GROUP2')
And tblAssetCustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now