There are certain classes in ‘wmi’ of a system which has the ‘User’ info stored.
But with respect to SCCM point to consider is as below: The “Last Logon User”, comes from heartbeat.
Is this a known problem with SCCM, or is there something we need to tweak to improve its accuracy?
Better still, is this something we can query via LDAP (for example, using There's no central store of user logins in Active Directory, so you can't just slap together an LDAP query for this information.
The startup script that we have applied across the domain should fix this automatically the next time you reboot the computer, but if it doesn’t for some reason, you need to delete following registry keys from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Mobile Client: Server Push: Server Push installs only work if the departmental admin has added the SCCM Site Server to the local admin group on client machines AND it has firewall access to those client machines.
There are some columns in the 2012 console that are populated with messages generated only by the server push installation method.
This problem may be caused by other group policies that have registry preference settings that fail for some reason and may not be related in any way to SCCM.
Using SCCM to query the Config Mgr database to find which clients a particular user had logged in to.
A customer wanted to know a history of which clients on their estate a particular user had logged into in the last couple of days and cross reference their results from Active Directory against the information held within the SCCM database.
Create a new report and paste the below query into it.
Netbios_Name0 AS "Computer Name", v_GS_SYSTEM_CONSOLE_USER. System Console User0 AS "Console User", v_GS_SYSTEM_CONSOLE_USER.
Last Console Use0 AS "Last Console Use" from v_R_System INNER JOIN (SELECT Resource ID, System Console User0, Number Of Console Logons0, Total User Console Minutes0, Last Console Use0, ROW_NUMBER() OVER(PARTITION BY Resource ID ORDER BY Last Console Use0 DESC) AS Point FROM v_GS_SYSTEM_CONSOLE_USER) v_GS_SYSTEM_CONSOLE_USER ON v_GS_SYSTEM_CONSOLE_USER.