‎03-09-2016 09:57 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tsysAssetTypes.AssetTypeIcon10 As icon,
tsysAssetRelationTypes.Name As Relation,
tblAssets1.AssetName As Monitor,
tblMonitor.ManufacturedDate,
tblMonitor.MonitorModel
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetRelations On tblAssetRelations.ParentAssetID =
tblAssets.AssetID
Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID =
tblAssetRelations.Type
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetRelations.ChildAssetID
Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
tblAssets1.Assettype
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Left Join tblMonitor On tblMonitor.MonitorID = tblAssets1.AssetID
Where tsysAssetRelationTypes.Name = 'connected to' And
tsysAssetTypes1.AssetTypename = 'monitor' And tblADComputers.OU Like '%HQN%'
Order By tblAssets.AssetName
Solved! Go to Solution.
‎03-18-2016 03:39 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tsysAssetTypes.AssetTypeIcon10 As icon,
tsysAssetRelationTypes.Name As Relation,
tblAssets1.AssetName As Monitor,
tblMonitor.ManufacturedDate,
tblMonitor.MonitorModel
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetRelations On tblAssetRelations.ParentAssetID =
tblAssets.AssetID
Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID =
tblAssetRelations.Type
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetRelations.ChildAssetID
Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
tblAssets1.Assettype
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Left Join tblMonitor On 'mon:' + tblMonitor.MonitorManufacturer + ':' +
tblMonitor.SerialNumber = tblAssets1.AssetUnique
Where tsysAssetRelationTypes.Name = 'connected to' And
tsysAssetTypes1.AssetTypename = 'monitor' And tblADComputers.OU Like '%HQN%'
Order By tblAssets.AssetName
‎03-18-2016 03:39 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tsysAssetTypes.AssetTypeIcon10 As icon,
tsysAssetRelationTypes.Name As Relation,
tblAssets1.AssetName As Monitor,
tblMonitor.ManufacturedDate,
tblMonitor.MonitorModel
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetRelations On tblAssetRelations.ParentAssetID =
tblAssets.AssetID
Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID =
tblAssetRelations.Type
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetRelations.ChildAssetID
Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
tblAssets1.Assettype
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Left Join tblMonitor On 'mon:' + tblMonitor.MonitorManufacturer + ':' +
tblMonitor.SerialNumber = tblAssets1.AssetUnique
Where tsysAssetRelationTypes.Name = 'connected to' And
tsysAssetTypes1.AssetTypename = 'monitor' And tblADComputers.OU Like '%HQN%'
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now