To delete Wiegand cards from the Unassigned Cards list, you need to execute the query in your database management program. For your convenience, we update a query to delete ALL unassigned Wiegand cards from the Unassigned Cards list.
Caution
- Following operation is required to modify your database.
- Back up your database according to the linked articles below before you run the query.
- Back up Maria DB: [BioStar 2] Database Backup and Restore Instructions (Maria DB)
- Back up MS SQL: [BioStar 2] MSSQL Database Backup and Restore Instructions
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)