• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Help Sorting Data

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!
 
Back
Top