ConfigMgr reporting of AD timestamps
I was helping out a fellow consultant with some less-than-obvious T-SQL for some custom reporting recently. One of the needs was to get the Last Logon time for an Active Directory user. ConfigMgr Active Directory User Discovery was pulling in the correct attributes, but we hit a snag in getting a good report of the…