i need computer name, model, serial, and connected monitor, model and serial number
i have so far the easy part computer name, model, serial i missing how to get in the report the attached monitor to each computer
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssets.AssetID Not In (Select tblSoftware.AssetID
From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblSoftware.softID Where (tblSoftwareUni.softwareName Like '%Sophos%') Or
(tblSoftwareUni.softwareName Like '%Guardian Edge%') Or
(tblSoftwareUni.softwareName Like '%Symantec Endpoint Encryption%')) And
tblAssets.Lastseen <> '' And tblAssets.Assettype = -1
