Notification

Icon
Error

Laptop warranty include users from active directory filtered by OU

Posted: Wednesday, June 16, 2021 11:09:27 PM(UTC)
Iyad

Iyad

Member Original PosterPosts: 2
0
Like
Hi,
I need to build a report that shows me, users, from the active directory and their laptops filtered bu AD user OU
please assist
Brandon
#1Brandon Member Posts: 169  
posted: 6/17/2021 5:52:50 PM(UTC)
Try this and see if it give you the information you need.

Quote:
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassets.Lastseen,
tblassets.Lasttried,
tblassets.Username,
tblADusers.OU
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join lansweeperdb.dbo.tblADusers On tblassets.Username =
tblADusers.Username
Inner Join lansweeperdb.dbo.tblPortableBattery On tblassets.AssetID =
tblPortableBattery.AssetID
Where tblassetcustom.State = 1 And tblPortableBattery.Win32_PortableBatteryid Is
Not Null
Order By tblADusers.OU

Active Discussions

Installer Stop Print Spooler Service
by  Esben.D   Go to last post Go to first unread
Last post: 7/16/2021 2:43:23 PM(UTC)
Installer Java Uninstall Deployment
by  Rodrigo Varela   Go to last post Go to first unread
Last post: 7/1/2021 9:49:00 AM(UTC)
Installer Java Uninstall Deploy
by  Rodrigo Varela  
Go to last post Go to first unread
Last post: 7/1/2021 9:47:26 AM(UTC)
Installer Installing Windows 10 on Win 7?
by  user9482840   Go to last post Go to first unread
Last post: 6/24/2021 1:32:05 AM(UTC)
Installer Uninstall KB5000802
by  hirogen  
Go to last post Go to first unread
Last post: 6/8/2021 2:49:19 PM(UTC)
Installer Freezerworks 2021 Client
by  mzipperer   Go to last post Go to first unread
Last post: 6/2/2021 11:59:05 PM(UTC)
Installer Install .Net Framework 4.7.2
by  John B Fairbrother  
Go to last post Go to first unread
Last post: 5/6/2021 4:58:23 PM(UTC)