Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Filter Duplicate Computer Names from Active Directory, in PDQ Inventory

Chad Kramer

January 30, 2013 00:05

I have multiple PC's in my company that have been imaged and reimaged multiple times. These PC's were previously known as XPxxxxxx, and are now known as W7xxxxxx. Since our migration. This has created many duplicate PC's in active directory. I am wondering if there is a way to display PC,s that have both the XP and W7 name, followed by the identical asset number? Such as XP123456 and W7123456. Any help appreciated. Thanks...

Comments

1 comment

Adam Ruth

January 30, 2013 00:24

Interesting problem you've run into. You can get a list of the computers using a SQL Report with this SQL:

select NewComputers.Name as "New Name", OldComputers.Name as "Old Name"
from Computers NewComputers join Computers OldComputers
where NewComputers.Name like 'W7%' 
and OldComputers.Name like 'XP%' 
and substr(NewComputers.Name, 3) = substr(OldComputers.Name, 3)