Hi Folks,
I want to have a report with the location ( are they in the office or home)
this report i have
But i want to know what monitor the have attached
i can see something with relations. But how do i get this in the report.
This is what i got:
Select Top 1000000 tblAssets.AssetID As AssetID1,
tblAssets.AssetName As AssetName1,
tblAssets.Domain As Domain1,
tblAssets.Username As Username1,
tblAssets.Userdomain As Userdomain1,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress As IPAddress1,
tsysIPLocations.IPLocation As IPLocation1,
tblAssetCustom.Manufacturer As Manufacturer1,
tblAssetCustom.Model As Model1,
tsysOS.OSname As OS,
tblAssets.SP As SP1,
tblAssets.Lastseen As Lastseen1,
tblAssets.Lasttried As Lasttried1,
tblAssetCustom.Serialnumber As Serialnumber1
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblAssetRelations On
tblAssets.AssetID = tblAssetRelations.ParentAssetID
Where tblComputersystem.SystemType Like 'x64%' And tblState.Statename = 'Active'
Order By Domain1,
AssetName1
