• Register
    • Login
    • Search
    • Recent
    • Unsolved
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Deleted Host attempting to reenroll duplicate MAC

    FOG Problems
    1
    2
    59
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      astrugatch last edited by

      I have a couple hosts that I deleted via the fog GUI (1.5.9.98) and when I go to reenroll them they are complaining that the MAC is already in use. Any way to completely purge these?

      A 1 Reply Last reply Reply Quote 0
      • A
        astrugatch @astrugatch last edited by

        When I run :

        SELECT * FROM hostMAC WHERE hmMAC LIKE '%aa:bb:cc:dd:ee:ff%';
        SELECT * FROM hosts WHERE hostID IN (SELECT hmHostID FROM hostMAC WHERE hmMAC LIKE '%aa:bb:cc:dd:ee:ff%');
        

        I get output pertaining to the host that I had deleted via the GUI. Is there a way to delete those records from the DB using the MAC?

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post

        78
        Online

        10.4k
        Users

        16.4k
        Topics

        150.5k
        Posts

        Copyright © 2012-2023 FOG Project