I believe I have found the table in the Compliance database with the raw LMS data stored.
Table: Instance_MT
Field: AuditEvidence (varbinary)
Has anyone figured out how to extract the data from this varbinary field? I am guessing the data stored is a csv field or maybe a zipped csv file.
The intent is to automate the dump of option data collected by LMS scripts to validate our reports and some automation to updating option usage settings in Flexera.
Mar 13, 2020 01:11 PM
Mar 15, 2020 11:48 PM
In the upper left of the Oracle Instances view, you will see a link named "Oracle LMS Evidence Archive Download the evidence". Clicking on the link will download the same Oracle LMS Evidence CSV/Spreadsheets that would be generated during an Oracle Audit. You need to be an Administrator to see this link.
Mar 16, 2020 06:32 AM
The manual link is great but its manual.
There is a lot of great information in the LMS audit evidence required to validate the FNMS application results. For example, looking at historical options usage that could potentially cause issues with an official audit.
The plan is to automate the data out of the binary field and into a data set the team can mine.
Mar 17, 2020 04:34 PM