Any way to get/calc Windows current user with Attribute Rules?

Question

Hello! We currently have Attribute Assistant calculating last_editor with the CURRENT_USER value of 'U' (windows login) and I'm trying to figure out how to do the same in Attribute Rules in Pro.

I know I could enable Editor Tracking, but that won't help us as our enterprise geodatabase is connected to with database authentication using one connection file, so everyone ends up showing up as 'company_editor'. We need to be able to know the editor was 'user1' 'user2' etc.

Any leads, tips, tricks, etc?

LeonS · Answer

I found this to work if you are connecting to the database through windows authentication.  I use this track changes in just geometry.  If everyone is connecting using DB authentication with the same credentials, then this probably less useful.  I don't see anything in Arcade that will get the Windows OS credentials.

// Using Pro 2.7
var pFS = FeatureSetByName($datastore, "dbname.owner.dataset")
var pUser = GetUser(pFS).username

It looks like at Pro 2.8 you will be able to simplify this to :

var pUser = GetUser($featureSet).username

Alex_Reid · Answer

Hi XanderBakker, thanks for the reply. I saw that but I guess I wasn't clear enough in my question - we need the computer user/Windows login, not the ESRI user. The Arcade still doesn't appear to be able to get the computer user, unless I'm not understanding how to ask it to do so.

XanderBakker · Answer

Hi @Alex_Reid  and @JohnBrodnicki ,

Please have a look at the post by @HusseinNasser2 explaining new functionality released in Arcade version 1.12 (available in ArcGIS Pro 2.7)

https://community.esri.com/t5/attribute-rules-videos/use-the-getuser-arcade-function-to-return-the-current-user-name/m-p/1016599#M17