I need to build a report showing the date on which collectors where created. Can anyone help me?
The database and tables/views available don't have that level of information.
You would need to check the internal table T_DC_VERSIONS. Something like this:
JOIN T_DC_VERSIONS vr ON
dc.ID = vr.DC_ID
AND dc.IS_DELETED = 'FALSE'
AND dc.COLLECTOR_TYPE NOT LIKE 'Child%'
check the CREATION_DATE column in the V_DATA_COLLECTORS view.
I already tested that column and it is wrong. The date provided in the "CREATION_DATE" is the last date on when the collector was updated, not created.
Thanks Mostafa, that's exactly what i needed. Much appreciated for always assisting in my queries.
Retrieving data ...