Any reason to do this inside of ConfigMgr and not with an AD query? Are you trying to not discover machines that have not updated their password in 45 days?
From: [email protected] To: [email protected] Subject: [mssms] Create SCCM 2012 collection based on a SQL query Date: Wed, 14 Jan 2015 16:10:05 +0000 I need to use the AD attribute pwdLastSet in SCCM to filter out stale systems. I added the attribute to the AD system discovery, but I need to convert pwdlastset to a date readable format. I need to find systems that are older than 45 days. I have found that I cannot convert this using WQL and have used SQL to convert this but I need to create a collection with these results. I need this collection as part of a report for management. Is there a way to create a collection using this SQL query? Is there a better way to accomplish this? Thanks Mike Iacaruso Enterprise Desktop Engineer Office of Technology Services Towson University 410-704-3965 [email protected]
