Active Directory Extension Attributes

[Arron]

Hi,

I am looking for what table the data "Active Directory Extension Attributes" against a user are stored in so i can add them to a report?

Thanks,
Arron

[Arron]

Hi Andy,

That is perfect, thank you very much.

Arron

[Andy_Sismey]

Is this what your after - https://www.lansweeper.com/knowledgebase/active-directory-user-and-computer-attributes-scanned-by-lansweeper/

[Arron]

Andy.S wrote:
Is this what your after - https://www.lansweeper.com/knowledgebase/active-directory-user-and-computer-attributes-scanned-by-lansweeper/

Hi Andy,

Thank you, Kind of i can see the attributes and vales when i view a user but i am trying to pull "ExtensionAttribute2" in to a report but cannot find what table it is stored in?

Thanks,
Arron

[Andy_Sismey · Accepted solution]

Hi Arron,

So I think this should work for you, I have ammended one I use for Attrib10 :

Select Top 1000000 tblADusers.Username,
  extension2.Value As ExtensionAttribute2,
  tblADusers.OU,
  tblADusers.whenCreated,
  tblADusers.whenChanged,
  tblADusers.PasswordLastSet,
  tblADusers.Lastchanged,
  tblADusers.LastLogon
From tblADusers
  Left Join (Select tblAdProperty.Value,
        tblAdProperty.AdObjectId
      From tblAdProperty
        Inner Join tsysAdPropertyType On tsysAdPropertyType.TypeId =
          tblAdProperty.TypeId
      Where tsysAdPropertyType.Name = 'ExtensionAttribute2') As extension2 On
    extension2.AdObjectId = tblADusers.ADObjectID
Where extension2.Value Like '%%'
Order By Case
    When tblADusers.Displayname Is Null Or
      tblADusers.Displayname = '' Then tblADusers.Userdomain + '\' +
      tblADusers.Username
    Else tblADusers.Displayname
  End,
  tblADusers.Userdomain,
  tblADusers.Username