Windows Login - get employee Name

Will_SV

Hi,
I´m starting getting our Users in Win Login. Table User contains UserID and Name (e.g. John Smith).
While using T 2…….54 Windows Login the Flow Field column Name ist not working (shows nothing).

Ist there a Chance to retrieve the Name from Active Directory e.g. by changing the calc. of the flow field name?

Thanks a lot!!!

kine

And did you call the CALCFIELDS on the field?

Will_SV

Well, I haven´t changed anything in this Table yet (2000000054, Windows Login),
it says Type: Flow Field,
Calculation: Lookup("Windows Access Control"."Company Name" WHERE (Login ID=FIELD(SID)))

The problem ist, while using Tools-security-windows login you can choose the user from a list, see help:

Windows Users and Groups
In this window you can see a list of all the Windows users and groups that exist in the current forest of domains and domain trees.
This window contains the following information:
ID: The ID of this Windows user or group.
Name: The name of this Windows user or group.
Type: Whether this is a Windows user or a Windows group

Here the Name is shown correct. I just cant get access to the table
Windows Users and Groups ???????

kine

Still, I am not sure, what you want to do.

1) You do not need to change anything in the table
2) How you are reading the data from the table? Through code? Through some form?

Will_SV

I just run the table (2000000054, Windows Login) and its showing the
SID:S-1-5-21-2060521477-837247615-48716514-1684
ID: SIMONHUBER\SheduleNeu
NAME:

but not the name!

kine

Ok, yes, it is not working in this table. But you can use table 2000000050 to get the name...

Will_SV

Hi there,

thanks a lot !!!!!!! thats just what I wanted.

Maybe you know as well, is there a table to add more fields from Active Directory e.g. email. phone.....??

kine

No, in this case you will need to use another way how to read data from the active directory (e.g. some automation).