Last logged user property in database

Usage and Config Platform
1

(imported topic written by bflearner91)

Hello,

Quick question: in the BES console, you can see the last logged user for every computer in the Computers list (field ‘User Name’). Where is this user name data stored in the database? I can’t seem to find it in any table.

2

(imported comment written by BenKus)

select * from USERINFO

Ben

3

(imported comment written by bflearner91)

Unfortunately that table only contains console operators. I’m looking for the data that shows the last logged-in domain/local user for every computer.

4

(imported comment written by mcalvi91)

there is a property somewhere that pulls the currently logged on user, when the box is powered up but at Ctrl-Alt-Del screen it is empty. What we did was create a fixlet which compares a reg entry to the currently logged on user property. if different and not one of the exceptions, it updated the reg key. then we made a property which read the reg key for the last logged on user.

5

(imported comment written by bflearner91)

So the last logged user data is not stored in the database? Can I get a clear confirmation for this?

6

(imported comment written by BenKus)

See here for a “primary user” property:

http://forum.bigfix.com/viewtopic.php?id=1424

Ben