Data Normalization

These tools allow you to normalize data that might be missing or incorrect. (See the linked list below.)

In the off chance you end up with duplicated asset tags (manual twiddling is the most common reason), you can run this query via mySQL:

SELECT id, asset_tag, assigned_to, assigned_type, created_at, updated_at from assets where asset_tag IN (SELECT asset_tag FROM assets WHERE deleted_at IS NULL GROUP BY asset_tag HAVING COUNT(*) > 1);

The resulting records are the ones that are duplicates.