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

Deleted Host attempting to reenroll duplicate MAC

Scheduled Pinned Locked Moved
FOG Problems
1
2
151
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 Sep 1, 2021, 3:05 PM

    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 Sep 1, 2021, 3:19 PM Reply Quote 0
    • A
      astrugatch @astrugatch
      last edited by Sep 1, 2021, 3:19 PM

      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
      1 / 1
      • First post
        1/2
        Last post

      227

      Online

      12.0k

      Users

      17.3k

      Topics

      155.2k

      Posts
      Copyright © 2012-2024 FOG Project