Notification

Icon
Error

PO Box Query - Adding location to a user report

Posted: Tuesday, June 25, 2019 11:16:28 AM(UTC)
kmoc

kmoc

Member Original PosterPosts: 2
0
Like
Hi all, any help appreciated. Currently running the below report to pull info on users and their device. However it would be very useful to pull in the P.O. Box field from AD, as we have over 900 users in the building and we use this field to input their Floor and office number.

Select Top 1000000 tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Username,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblADusers.email
From tblAssets
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Inner Join tblADusers On tblADusers.Username = tblAssets.Username
Where (tblAssetCustom.Model = 'ThinkPad Yoga 370') Or
(tblAssetCustom.Model = 'ThinkCentre M710q') Or
(tblAssetCustom.Model = 'ThinkPad X380 Yoga')
Order By tblADusers.Firstname,
tblAssets.AssetName

Just cant see where i can get this P.O Box info from.

Thanks in advance.
Kevin Think Brick wall

Active Discussions

Lansweeper Asset Value Report
by  RC62N   Go to last post Go to first unread
Last post: 9/20/2019 7:12:29 PM(UTC)
Lansweeper Display Hyper-V Guest User report
by  GlenTB  
Go to last post Go to first unread
Last post: 9/20/2019 2:26:15 PM(UTC)
Report Center Windows Defender Antivirus Broken Scan Audit
by  Esben.D   Go to last post Go to first unread
Last post: 9/20/2019 12:18:02 PM(UTC)
Lansweeper Reports are empty
by  Mendoza  
Go to last post Go to first unread
Last post: 9/20/2019 11:12:18 AM(UTC)
Lansweeper Custom Helpdesk Report
by  StevoCamaro   Go to last post Go to first unread
Last post: 9/19/2019 11:13:05 PM(UTC)
Lansweeper Windows 7 EOL
by  RC62N  
Go to last post Go to first unread
Last post: 9/19/2019 4:42:11 PM(UTC)
Lansweeper Drive Encryption statuses
by  DFox   Go to last post Go to first unread
Last post: 9/19/2019 12:54:06 PM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D  
Go to last post Go to first unread
Last post: 9/19/2019 10:55:07 AM(UTC)