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.
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.
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.
You would need to check the internal table T_DC_VERSIONS. Something like this:
SELECT
dc.NAME,
dc.COLLECTOR_TYPE,
min(vr.CREATION_DATE) CREATION_DATE,
max(vr.CREATION_DATE) LAST_MODIFIED_DATE
FROM
T_DATA_COLLECTORS dc
JOIN T_DC_VERSIONS vr ON
dc.ID = vr.DC_ID
AND dc.IS_DELETED = 'FALSE'
AND dc.COLLECTOR_TYPE NOT LIKE 'Child%'
GROUP BY
dc.NAME,
dc.COLLECTOR_TYPE ;
Thanks Mostafa, that's exactly what i needed. Much appreciated for always assisting in my queries.
You would need to check the internal table T_DC_VERSIONS. Something like this:
SELECT
dc.NAME,
dc.COLLECTOR_TYPE,
min(vr.CREATION_DATE) CREATION_DATE,
max(vr.CREATION_DATE) LAST_MODIFIED_DATE
FROM
T_DATA_COLLECTORS dc
JOIN T_DC_VERSIONS vr ON
dc.ID = vr.DC_ID
AND dc.IS_DELETED = 'FALSE'
AND dc.COLLECTOR_TYPE NOT LIKE 'Child%'
GROUP BY
dc.NAME,
dc.COLLECTOR_TYPE ;