Filter Duplicate Computer Names from Active Directory, in PDQ Inventory

Comments

1 comment

  • Adam Ruth

    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)
    0
    Comment actions Permalink

Please sign in to leave a comment.