How to get Active Directory user details

[leemillard]

Hi Guys,

So I have played with Context.Security.CurrentUser for get the currently logged in user, and Context.Security.GetEmail() to get the email address.

What function/method can I use to get the users Ext number or telephone ??

Or any other user detail for that matter.

My aim is to create a grid filled with user names with internal Ext/Telephone numbers.

An internal phone list from the AD within effect.

Thanks

Lee

[Selwyn Rabins]

Hi Guys,

So I have played with Context.Security.CurrentUser for get the currently logged in user, and Context.Security.GetEmail() to get the email address.

What function/method can I use to get the users Ext number or telephone ??

Or any other user detail for that matter.

My aim is to create a grid filled with user names with internal Ext/Telephone numbers.

An internal phone list from the AD within effect.

Thanks

Lee

We will be adding a new function to Xbasic to get this information from the AD. Should be in the pre-release build soon.

[Jonathan Freestone]

You could use a view via a linked server using ADSI. https://www.mssqltips.com/sqlservert...om-sql-server/

SELECT *
FROM
OPENQUERY(ADSI,
'
SELECT displayName,homeMDB,mail, sAMAccountName, ADsPath, telephoneNumber
FROM ''LDAP://DC=your,DC=domain''
WHERE
objectClass = ''User''
AND
objectCategory =''person''

')

[Beta Spark]

You could use a view via a linked server using ADSI. https://www.mssqltips.com/sqlservert...om-sql-server/

Or the a5ws_getUserValuesActiveDirectory Function https://www.alphasoftware.com/docume...ory%20function

[leemillard]

This is far far too slow (a5ws_getUserValuesActiveDirectory)