SAM - Number of Oracle required licenses (per Processor)

GianluNow · ‎02-01-2022

Hi guys,

i'm trying to calculate the number of required license for any Oracle Installations with License metric = Per Processor.

I've installed Oracle Publisher Pack plugin and now I can define an entitlement with Metric group = Oracle and License Metric = Per Processor.

This entitlement is associated to an Oracle Software Model (Oracle DB Server Enterprire Edition).

Discovery process found this software installed to a configuration item that has theese parameters:

- Processor XEON (oracle_product_factor = 0.5)

- CPU Count = 2

- CPU Core Count = 4

I've run reconciliation process and i've try to calculate the number of required licenses for Oracle in this way:

My question is : where can i find this information? I can't see this in entitlement definition and in license workbench.

I've attach ServiceNow documentation for more informations!

Thanks for your support.

Seungmin · ‎02-01-2022

Gianluca, yes it belongs to ITOM.

but, you can find out Oracle Infrastructure Report in the SAM Prof. as following navigation in Rome version.

Software Asset > Software Asset Workspace on your ServiceNow instance. After the Software Asset Workspace launches, navigate to License usage > Reports > Oracle infrastructure report.

There would be following information.

the column for "license required" would be helpful to you.

Regards,

Seungmin

Column	Description
Required by (Device)	Configuration item, such as a server, cluster, vCenter, or datacenter, that the Oracle database, database option, or management pack is installed on. Select an entry to view additional information about the licensing requirements for that configuration item. See Licenses Required By form for more details.
Database option	Database option or management pack that is being used with the Oracle database.
Version	Oracle Database version that is installed on your configuration item.
Edition	Oracle Database edition that is installed on your configuration item.
Software model	Software model that is associated with the Oracle database, database option, or management pack.
License metric result	License metric that the Oracle license is counted against when reconciliation runs. The options are Named User Plus and Per Processor.
Licenses required	Number of rights that are required for license compliance.
Model ID	Model ID of the configuration item that the Oracle database, database option, or management pack is installed on.
CPU manufacturer	Manufacturer of the CPU that is used by the configuration item.
CPU type	Type of CPU that is used by the configuration item.
CPU count	Number of CPUs within the configuration item.
CPU core count	Number of cores within each CPU.
CPU core thread	Number of threads that divide each core within a CPU.
Oracle core factor	Oracle processor core factor that is used to determine the number of required rights.
CPU speed (MHz)	Clock speed (in megahertz) of the CPU that is used by the configuration item.
Purchased	Number of rights that you have purchased.
Operating System	Operating system of the configuration item that the Oracle database, database option, or management pack is installed on.

View solution in original post

Seungmin · ‎02-01-2022

Hi, you're calculation was right!

I recommend to find out the menu for downloading Oracle Glas Data.

Usually you can see the important information in the Oracle_Overview and Oracle_Options csv file inthe archive data.

in the Rome version, you can access it through "Oracle Glas Data Collection>Download Glas Data Collection or any sub category" menu.

Regards,

Seungmin

GianluNow · ‎02-01-2022

Hi Seungmin,

thanks for your answer!

The instance is on Orlando version, so i've not this modules.

But, in witch way theese files can help me with the information that i'm looking for?

Thanks.

Seungmin · ‎02-01-2022

Yes, I also recommend to upgrade to Rome version because it must be useful to you.

Oracle Audit(LMS) collect the Oracle_Glas_Data through their audit script but you can see the same result in the Menu I mentioned.

The file I mentioned illustrate exact physical and logical number of core which the database instance are using. In addition, you can see the number of NUP and Options in use, installed and packs agreed.

I hope to help you through this answer.

Regards,

Seungmin

GianluNow · ‎02-01-2022

I need to do a last question: this module is a part of ITOM?

I've find this article: License Management Services

Thanks,

Gianluca