Active Directory authenticates by the group and only returns the short account name and nothing else. The only solution is to have a table of employees that includes an Active Directory ID to relate to the full names of employees. If price is of no concern, I bet 360Works can find a solution for you, but it will probably be pretty expensive and involve a lot of work. Adding an Active Directory field to your employee table is probably a lot easier and less expensive. By the way, I think moving to AD is great because it moves all of the account maintenance and password resetting over on someone other than the FM developer. And if someone retires, quites or gets fired, it makes it the IT department's job to remove users, etc.
A couple of ideas:
First, use something besides the Get ( AccountName ) function, moving forward. For instance, set a global at startup and always refer to that.
Second, this might help you locate current occurrences of the funciton in your scripts:
Active Directory authenticates by the group and only returns the short account name and nothing else.
That is not correct. Get(Accountname) will return the full account name that was used to authenticate. Users can authenticate with a UPN or UNC syntax and there a different scenarios to cater for with the workstation being part of the domain, not part of the domain or being part of a trusted domain.
For the exact same account get(accountname) may return:
in different scenarios.
Yes, you are correct, wimdecorte. But since he is only getting the "jsmith" version, I think that is all MacUT is concerned about and he is not going to be able to get more info from Active Directory even though an Active Directory database can container all kinds of things about the user such as their full name, phone number, address, picture, etc. None of those are available natively to FileMaker.
I believe the Scodigo SmartPill PHP plugin can read and write to Active Directory withy LDAP functions. You might look into that.
Thanks to the three of you who responded. I was able to incorporate your ideas to solve my problem. Debi, the software at draconventions worked perfectly for what I needed. Thanks so much.