
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-22-2015 10:24 PM
Hello - I'm trying to pull a report to grab the extensionAttribute1 field in our AD user table:
I don't see an option to select it in the Report builder in Lansweeper. Here is what I currently have setup:
Select Top 1000000 tblADusers.OU,
tblADusers.Country,
tblADusers.Username,
tblADusers.email,
tblADusers.Lastname,
tblADusers.Firstname,
tblADusers.EmployeeID,
tblADusers.Telephone,
tblADusers.Title,
tblADObjects.sAMAccountName As ManagerName
From tblADObjects
Right Join tblADusers On tblADObjects.ADObjectID =
tblADusers.ManagerADObjectId
Order By tblADusers.Username
In Active Directory, It is labeled under the Attribute Editor tab, then under extensionAttribute1 field. I'd like to get the value of that field.
Thanks!
I don't see an option to select it in the Report builder in Lansweeper. Here is what I currently have setup:
Select Top 1000000 tblADusers.OU,
tblADusers.Country,
tblADusers.Username,
tblADusers.email,
tblADusers.Lastname,
tblADusers.Firstname,
tblADusers.EmployeeID,
tblADusers.Telephone,
tblADusers.Title,
tblADObjects.sAMAccountName As ManagerName
From tblADObjects
Right Join tblADusers On tblADObjects.ADObjectID =
tblADusers.ManagerADObjectId
Order By tblADusers.Username
In Active Directory, It is labeled under the Attribute Editor tab, then under extensionAttribute1 field. I'd like to get the value of that field.
Thanks!
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-26-2015 01:15 PM
We only pull a limited number of properties from AD computer and user accounts. ExtensionAttributes won't get scanned by default. The only way of pulling reports on that is using openQuery and directly querying your Active Directory. That is possible if your database is running on SQL Server Express or higher edition.
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-26-2015 01:15 PM
We only pull a limited number of properties from AD computer and user accounts. ExtensionAttributes won't get scanned by default. The only way of pulling reports on that is using openQuery and directly querying your Active Directory. That is possible if your database is running on SQL Server Express or higher edition.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-24-2015 03:41 AM
I don't know if that attribute is scanned in LS or not.
I don't see it tblADUsers.
I use that attribute field too and here is a basic Powershell script that will give you what you want.
Depending on your OU structure, change the value in [1]
I don't see it tblADUsers.
I use that attribute field too and here is a basic Powershell script that will give you what you want.
Depending on your OU structure, change the value in [1]
$aduserinfo = get-aduser -Identity "grant.harrington" -Properties *
$ou = $aduserinfo.distinguishedname.split(",")[1]
$ou = $ou.substring(3)
$ADUserProps = [ordered]@{
'OU' = $ou
'Country' = $aduserinfo.Country
'UserName' = $aduserinfo.Name
'EmailAddress' = $aduserinfo.EmailAddress
'Surname' = $aduserinfo.Surname
'GivenName' = $aduserinfo.GivenName
'Employee ID' = $aduserinfo.extensionAttribute1
'TelephoneNumber' = $aduserinfo.telephoneNumber
'Title' = $aduserinfo.Title
'sAMAccountName' = $aduserinfo.SamAccountName
}
$ADUserObj = New-Object -TypeName PSObject -Property $ADUserProps
Write-output $ADUserObj
