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?
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.
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.