When I look at the Oracle Instance Properties for a certain Instance, a number of Options is being displayed. For some of these options "used" is set to "yes". For these cases usage is being deifined based on "From inventory".
When I select the "yes" as described above, a detailed pane becomes visible. In 1 case only 1 line appears with a yes, which confirms the option is being used or has been used.
However, other sources confirm this specific option has been in use but it is over a year ago (last use date). Ever since the option was disabled. Also, in de detailed usage pane a date is visible on top of the screen. This date is almost a year in the past.
So, how do i interpret this information? And most important: Are historic values being represented and constitute a yes for usage? In this case, how can I prevent so and until what point in time in the past these values are taken into account?
btw: for the specific application, usage values have been set to 3 months but since this is an Oracle Option I presume this value is being ignored.
Thanks in advance!
‎Mar 30, 2021 05:15 AM
Hi Matthias,
From what I can see, the date comes from the OracleFeature table. The value of ScanDate seems to be what you're decribing from the WebUi.
SELECT *
FROM Instance i
LEFT JOIN OracleFeature ofe
ON i.InstanceID = ofe.InstanceID
LEFT JOIN OracleFeatureEvidence ofee
ON ofe.OracleFeatureID = ofee.OracleFeatureID
However, I am not sure how ScanDate relates to AuditEvidenceDate.
Best regards,
Markward
‎Apr 01, 2021 07:36 AM