To delete Wiegand cards from Unassigned Cards list, you need to execute query in your database management program. For your convenience, we update a query to delete ALL unassigned Wiegand cards from Unassigned Cards list.


Caution


DELETE FROM T_BLKL WHERE CRDUID IN (SELECT CRDUID FROM T_CRD WHERE CRDTYPUID=1 AND CRDUID NOT IN (SELECT CRDUID FROM T_USRCRD))

DELETE FROM T_CRDISSHIS WHERE CRDUID IN (SELECT CRDUID FROM T_CRD WHERE CRDTYPUID=1 AND CRDUID NOT IN (SELECT CRDUID FROM T_USRCRD))

DELETE FROM T_CRD WHERE CRDTYPUID=1 AND CRDUID NOT IN (SELECT CRDUID FROM T_USRCRD)