copy user name to custom field

[esr]

Goal- to have most recent logged on user name, which is in last-first format, appear in the custom 1 field, which has the display name of "Assigned To:", and to have that user name appear in the classic First Last format.

Our database currently spans ~13,726 items in the Scanned Computers list, and tho it is primarily workstations that are a concern, considering database structure we'd be happy to export and then import from beginning to end for simplicity, rather than attempting to filter to workstation only or similar.

Would be tested in a dev VM environment, so happy to test ideas prior to committing to production database.

Management has decided to have pc's assigned to people instead of location/room # before going forward on other projects. Inventory correction won't happen till the end of the year, so this is the alternative till then.

Thanks-
Eric-

[esr]

Never mind 🙂

tblComputers Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Inner Join
tblADusers On tblADusers.Username = tblComputers.Username


OF course, by the time I located the resources I wanted mgmnt decided to agree with the argument that trying to use fixed data points in an automated scanning system was bad logic and would get progressively out of date if not aggressively maintained.

Logged on users will be considered sufficient for our use till inventory folks transition to a user model.

Thank goodness..... 🙂

[Hemoco]

If you do wish to make this change in the future, please contact us at support@lansweeper.com for a script.