SOLUTIONS ARE PROVIDED ON AN "AS IS" BASIS. NEITHER FLEXERA NOR ITS SUPPLIERS MAKE ANY WARRANTIES, EXPRESS OR IMPLIED, STATUTORY OR OTHERWISE, INCLUDING BUT NOT LIMITED TO WARRANTIES OF MERCHANTABILITY, TITLE, FITNESS FOR A PARTICULAR PURPOSE OR NONINFRINGEMENT. LICENSEE MAY HAVE OTHER STATUTORY RIGHTS. HOWEVER, TO THE FULL EXTENT PERMITTED BY LAW, THE DURATION OF STATUTORILY REQUIRED WARRANTIES, IF ANY, WILL BE LIMITED TO THE SHORTER OF (I) THE STATUTORILY REQUIRED PERIOD OR (II) THIRTY (30) DAYS FROM LICENSEE’S ACCEPTANCE OF THE AGREEMENT.
Create custom views to understand more details on Oracle instances. Particularly, the document embedded gives the code for implementing an automated generation of the Options.csv file every day and import into a reporting tables that will give all the details on DBA_FEATURE_USAGE_STATISTICS or OEM LMS evidences
Oracle instances details are collected by the FlexNet Inventory agent. The agent runs an LMS verified script that collects a large quantity of information that is made available by FlexNet Manager in multiple places… but that is not available a flat way (across servers, across instances):
This document gives the steps to create in an on premise FNMS instance 6 views and implement the ORCL_OPTIONS.csv generation and re-import. These views augment the transparency you can get on Oracle data.
The six views are the following
The approach of the views is the following:
The changes can be simply reverted by deleting the stored procedures and the view from FNMP Web.
This view is for customers in FNMS 2020R1 and later versions
on
Dec 19, 2018
08:43 AM
- edited on
Aug 05, 2022
04:10 AM
by
nrousseau1
The embedded document above seems to be for Adobe and Office reports. Can you please embed the document relevant to Oracle options reporting?
True, the document look like it's for Adobe and office optimization, also is possible to implement report like in multitenant environment?
My bad, sorry I uploaded the wrong document... I upload the current version!
Hi Nrousseau
If you could possible to clarify me the Powersheel script, where the query you stated below in LMS file extraction.
I would like to know and I was confused - what Document Name and File from dbo also you mentioned Document. where document name
# Select-Statement for filename & BLOB
$SQL = "SELECT [DocumentName], [DocumentFile] FROM [dbo].[Document] WHERE [DocumentName] = 'OracleLMSAuditEvidence.zip'"