jdogg707
Diamond Member
I am working on a project to help flush old computer names out of Active Directory. The computers are all named according to the following standard, XXXXUserIDX. The first four letters of the computer name are all the same, the user ID id is always 7 characters, and the last letter represents which computer it is for the user (Ex. the first computer a user has is A, the second B, etc....but all users do not have more than one computer). I would like to compare the user ID to the computer name and get a list of which computers belong to which user ID. I have all of the data in an Excel worksheet and in an Access database. Can anyone think of a way that I can do this?
Thanks!
Thanks!