Would you like to have a clean metadata? By clean meaning that all the "deleted" site properties, timers, entities, bpts, Webservices, etc, were indeed deleted from the Database, would you like that?

As a Factory Manager, I had and still have that need, so I started building an extension to Service Center, no only to check on "inactive" objects and delete them, but also to improve speed in small things, such as adding or removing components from a Solution.

Currently, I present you the ability to:

Solutions

• Search for solutions
  • By filtering by eSpace, you can see in which solutions is that eSpace included
• Remove Solution Versions
• Delete a Solution
• Associate or Dissociate components to solutions

Timers

• Search for timers
  • Filter by Active/Inactive, eSpaces, MultiTenant, Priorities
  • Checking which timers are currently running
• Deleting Inactive Timers (Timers that were deleted from the code but are still in the database)

Site Properties

• Search for site properties
  • Filter by Active/Inactive, eSpaces, MultiTenant
• Deleting Inactive Site Properties (Site Properties that were deleted from the code but are still in the database)

Applications

• Search for applications
  • Filter by Active/Inactive, eSpaces, extensions
• Deleting Inactive Applications (Applications that were deleted from service center but are still in the database)

BPTs

• Search for BPTs
  • Filter by Active/Inactive, eSpaces
• Deleting Inactive BPTs (BPTs that were deleted from the code but are still in the database)

Integrations

• Search for SOAP or REST Services/References
  • Filter by Active/Inactive, eSpaces
• Deleting Inactive Services/References (Integrations that were deleted from the code but are still in the database)

Emails

• Search Emails
  • Filter by Name, Description, Subject, From, To, Active/Inactive eSpace, and if they have content stored
• Deleting Inactive Emails (Emails that were deleted from the code but are still in the database)

Others

• You can have the espace that has the screens installed only in one environment (preferably in development), and have a new API espace with REST apis that will be installed in other environments. This will save you Application Objects and you can manage all environments in one place only. Another thing is that it gets more secured, since there won't be screens in production to protect. It also might be handy in the future to compare values between environments...
• You have a timer that will delete old module versions and solution versions from the environment. Just change the Site Property that saves how long you want to keep the unused module versions and add a schedule in the Timer. Once a week is more than enough :)
• You have a timer that will delete old sent emails from the environment. Just change the Site Property that saves how long you want to keep the sent emails on your database, and add a schedule in the Timer.

Coming up...

• SQL Converter (the good old SQL Map)
• Probably some improvements...

Stay tuned for new stuff soon!