cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
joled
Engaged Sweeper
Greetings,
I am a newbie and I don't know the system well enough to do what I am looking to do. I have defined locations (IT, Marketing ...). I have pinned locations to some assets. I created a report to give me all Windows systems with the query below. I now want to add the location that was pinned to each asset so when I look at the report I can see which have not been given a location.

How can I add the pinned location to the code below?

Thanks in advance.
Joe



Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Username,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.OScode
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tsysAssetTypes.AssetTypename = 'Windows'
Order By tblAssets.AssetName