Admin Tools

Find a property in CMS DB

Problem:

System is locked out after restore from backup, as there is only one Enterprise user “Administrator” and it’s get disabled on system startup due to password policies.

Solution:

We need to update password policies in CMS console mode, but where to find them?

Check CMS DB (on small/test system or directly use AdminTools) for any object related to secEnterprise (assume you don’t know anything about the subject and start with something like Enterprise then quickly narrow it down).

Turned out there is only one relatable object, but it has 131 properties. Filter them out with few guesses or with text from configuration screen in working system.

Few attempts and you got your properties.

Change property in CMS screen in working system and confirm that it is reflected in the found property.

All search from idea to confirmation took ~5min, without any prior knowledge in this area.