September 27, 200421 yr Does anyone know of a way to determine and access the current user's NT user name from within FileMaker? I am glad to see that external authentication is possible but I need to know exactly who is making changes without having to enter every NT user name into the database.
September 28, 200421 yr You could use the usrstat or whoami terminal commands to output the current user info. You could pipe this information into a file and then import the results into your database. To make it easier you could use the free shell plugin from abstrakt.com to return the results of this or any other shell command to a database field.
September 28, 200421 yr If you use External Authentication, the Get(AccountName) function will get you the user's Windows logon name. If you're not using EA, then you'll need a VBscript or batch file to write the logon name to a little text file and import it into FM. I explained how in an Advisor article last year and I believe there's also a demo file on my website (www.connectingdata.com) HTH Wim
September 28, 200421 yr Author Thanks! It is very good news that Get(AccountName) returns the NT Username. As we are plannign on using Server Advanced this is the best solution
Create an account or sign in to comment