I've been fighting with FS_USERNAME() when inserting into tables with an audit column. It only pulls `pmnsuser`, without the numerical part of the username that actually distinguishes me from any other user in the org.
Is there something I need to do to pull the full RAMP username, or another function that will actually leave a clue as to who was mucking about in the db?
Thanks!
Jennifer
P.S. In case you couldn't tell, we are RAMP clients.
I've been working on my own function, mostly to be able to override with a default name for SQL access, but it occurs to me, with Windows Auth set up we have a built in link between those AD names and the 8 char userids to take advantage of.
For my money, though, it's high time some updates came to user management: T_METUSER based on numerical I'd, so that text usernames can be changed, and the audit columns similarly updated.
Linking to Gawain's other post here, for anyone else fighting with unhelpful FS_USERNAME() truncation: https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_technical-9/22895/user_name-fs_user-and-fs_username-in-v15