Data Source 'Is used' indicator

Under 'System Admin > Data Sources' AND 'Common>Configuration > Data source Registry'  there needs to be a flag saying "is used."   Ideally, it would also tell you where its used, but just a count would be handy.

We currently have around 600 data sources, a significant number of which are now out of use.  We need to remove the DB files from the SQL instances as we are out of space, but ADM stops functioning if we remove a DB that is registered, giving errors, even if the db not actually used!

We need to identify if a db is actually used, (e.g. in Collect).Those that are not used should also be excluded from the validation code as it makes no sense stopping ADM from running for a db that is not actually used.    

We can write code to do this check ourselves,  but others must surly have the same requirements? 

  • Phil Towe
  • Apr 30 2019
  • Unlikely to Implement
  • Nov 4, 2019

    Admin response

    As Eric has stated the Active flag can be used to avoid stopping the DSP from running in this scenario, and therefore we are unlikely to prioritize this request.

  • Attach files
  • Eric Weldon commented
    16 May, 2019 06:17pm

    Hi Phil, 

    There is an "Active" flag on the Cransoft.dbo.DataSource table. If you set it to 0 for a data source, then validate the "Cransoft" datasource, it will rebuild the webSQLSys views exlcuding those sources that are not active. That will allow you to test/remove a datasource without breaking DSP.