Oracle Database Applicative Credentials

[tim_sewell]

The documentation for Oracle database applicative credentials for discovery states that the user must have access to the dba_hist_active_sess_history table.  Our DBA team would like to know why this table is needed before granting us this access.  Can anyone explain why this specific table is required?

https://docs.servicenow.com/bundle/london-it-operations-management/page/product/discovery/concept/c_OracleDatabaseDiscovery.html

[doug_schulze]

They way it reads its due to the software asset management requirements.  Must be something with the tracking of licensing.

[Vini · Accepted solution]

Hi Tim sewell,

Refer Oracle patterns " Oracle Unix for SAM customers" & "Oracle Windows for SAM customers" on these patterns you can notice the code to retrieve records from "dba_hist_active_sess_history" table.

Attached screenshot for your reference.

Business Case# from Jakarta version onwards ServiceNow Introduces new feature called "oracle options" discovery. it helps to calculate license on number of oracle Installations. if you need more Info please refer following links#

https://docs.servicenow.com/bundle/london-it-operations-management/page/product/discovery/concept/c_...

https://docs.oracle.com/en/

Hope this Helps…If so, please mark this as correct answer.

Thanks & Regards,

Vinil.

[tim_sewell]

Thanks!