The ETL Database does not always update correctly. It is, therefore, not reliable for our reports. Examples:
1) When the DC folder structure was changed, the ci_location string in dbo.configuration_item did not update accordingly; we had to drop the table in the ETL DB and export it again
2) For a 2nd month the rack used/free space numbers in dbo.swo_kpi are the same – which is not possible, as there have been changes in ISX
We have gone through the available ETL settings in the webmin interface, but there appears to be no option whatsoever to tweak how exactly the export of the data is done.
What we do need is the ability to overwrite the existing data if it exists already in the reporting database, so that it updates properly. Or, for it to update fully if there are significant differences (which does not seem to always happen now). With the MS SQL export/import options, the option I refer to is:
Is this a known issue, is there a fix, or are they working on one?
(CID:132655462)
