Here is a concise guide on how to clean up entries associated with a specific user across multiple Slurm related XDMod databases.

1. Set the Active Database and Remove Entries: Start by setting the active database to mod_hpcdb and removing job entries for the user:

USE mod_hpcdb;
DELETE FROM hpcdb_jobs WHERE username='<username>';

2. Switch to Shredder Modules: Next, address the mod_shredder database to remove all traces of user data from various job tables:

USE mod_shredder;
DELETE FROM shredded_job WHERE user_name='<username>';
DELETE FROM shredded_job_slurm WHERE user_name='<username>';
DELETE FROM staging_job WHERE user_name='<username>';

3. Clean Up Supremm Data: Finally, switch to the modw_supremm database to clean up additional job data:

USE modw_supremm;
DELETE FROM job WHERE username='<username>';