#Remove last user logon windows 7 how to

FROM SMS_R_SystemДЇROM statement indicates which table the information is stored in, in this case SMS_R_SYSTEM WHERE SMS_R_System.LastLogonUserName = #PRM:SMS_R_System.LastLogonUserName# You can use the query builder to add/remove fields to your preference. The SELECT statement is used to decide what information you would like retrieved by the Query in this case the following: SMS_R_System.LastLogonUserName Query Statement Explained SELECT SMS_R_System.LastLogonUserName, SMS_R_System.Name, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonTimestamp You will be presented with the results of where a particular user logged in.> Enter the username for the user you would like to query > Click All Systems (for dev environments, a smaller target collection would be preferable for testing) > Click Device Collections from the drop down menu on the top left However in production environments this is generally a bad idea as the wider the scope of your limiting collection the more tables will be queries in your SCCM database. In a development environment it is not a major issue not setting a limiting collection as there are not many objects in the SCCM database. WHERE SMS_R_System.LastLogonUserName = #PRM:SMS_R_System.LastLogonUserName#

> Paste the following query into the Query Statement SELECT SMS_R_System.LastLogonUserName, SMS_R_System.Name, SMS_R_System.LastLogonUserDomain, SMS_R_System.LastLogonTimestamp > Comments: Brief description of what the query is for

> Name: All Systems вЂ“ Where user last logged on Note: The date range you can query to depends on your data retention policy (how long you keep records in your CM database)

#Remove last user logon windows 7 how to

There are many ways to skin this particular cat but this seemed like a viable scenario to demo a how to query the ConfigMgr database to scan for instances of where this particular user had logged onto a client. Issue:ДЄ 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. Using SCCM to query the ConfigMgr database to find which clients a particular user had logged in to.