Sccm query last login date. May 9, 2022 · and they want us to pull out this data from SCCM. SCCM report for computers with last logged on user from collection SCCM report of computers with serial, user and last login time Feb 11, 2025 · Consider the following scenario in System Center 2012 Configuration Manager: Active Directory User Discovery is enabled in Configuration Manager. Apr 28, 2016 · I created a custom SCCM report that has the following inforation: Computername Serial number Last logged in user Last logged in time Here is the SQL query needed for the dataset in Report Builder. You can query computer information into SCCM database without depend on AD system discovery and then do compare with client information with AD & SCCM . As far as I know, SCCM maintains a record of the Last logged User and Last logged on time. ToLocalTime() method. I have run an ad report to get all user/device with last logon date but some of them are using more than 1 year or no date. What report should I look into? 1. By this way I will get the details of the machines which are Dec 1, 2022 · I had a workstation that I wanted to know if anyone had interactively logged onto it recently, so I wrote a PowerShell script to check the Security Event Log to find the last time someone logged on. By this way I will get the details of the machines which are Jan 20, 2023 · The LastLogon property is retrieved and converted to a readable date format using the . aqtz ocuu oxmyo keenrpg unplmsx nwvpkjt fpsa uecix lersy ssrdxwh