Highlighted
Active participant

Extracting LMS RAW data from database

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.

 

Labels (1)
0 Kudos
3 Replies
Highlighted
Community Manager Community Manager
Community Manager

Re: Extracting LMS RAW data from database

The documented description of the AuditEvidence field is as follows: "Oracle LMS CVS files in zip archive"

So I expect you will find the varbinary content is a zip file that you could extract and get a set of CSV files.
(Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".)
Highlighted
Flexera
Flexera

Re: Extracting LMS RAW data from database

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.

Highlighted
Active participant

Re: Extracting LMS RAW data from database

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.