Sanitize the Snow Commander database before sharing with Flexera Technical Support
Technical Support may request a database backup for troubleshooting or upgrade validation. Because the Commander database contains sensitive information, Snow Software provides sanitization scripts to remove private data before a backup is shared. These scripts replace sensitive values, such as credentials for mail servers and public cloud connections, and anonymize user email addresses to prevent accidental policy notifications.
Important preparation notes
- The sanitization process changes database content. To protect your working environment:
- Back up the database first and restore it to a separate SQL Server before sanitizing.
- For PostgreSQL (default configuration), snapshot the Commander server before running the query so you can revert after the backup.
Steps to sanitize the database
- Download the provided ZIP file containing the sanitization scripts and extract its contents.
- Run the query appropriate for your database type:
- MS-SQL → Use SQL Server Management Studio.
- PostgreSQL → Use pgAdmin or similar tool.
See Flexera instructions on executing queries for SQL Server and PostgreSQL.
- After the script finishes, create a backup of the sanitized database.
- Upload the backup to the location specified by Flexera Technical Support.
Additional notes
- Once the database is sanitized, native logins will no longer function until passwords are reset in the database.
Outcome
Following these steps ensures your database backup excludes sensitive information before sharing with Technical Support, meeting organizational security requirements.
Was this helpful?
