I am trying to not include systems in a certain collection that has not updated their password in 45 days. We have computer scavenging scripts that will disable and then remove systems in AD based on pwdLastSet. I am showing a lot of stale systems in reports that I need to filter out.
Mike Iacaruso Enterprise Desktop Engineer Office of Technology Services Towson University 410-704-3965 [email protected]<mailto:[email protected]> From: [email protected] [mailto:[email protected]] On Behalf Of Mike Dzikowski Sent: Wednesday, January 14, 2015 11:19 AM To: [email protected] Subject: RE: [mssms] Create SCCM 2012 collection based on a SQL query 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]<mailto:[email protected]> To: [email protected]<mailto:[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]<mailto:[email protected]>
