Share via

Oracle Database inventory

Duchemin, Dominique 2,006 Reputation points
2022-02-08T00:38:17.927+00:00

Hello,

How to run an Inventory of the servers having Oracle Database on them?
I tried already these queries:
Select distinct v_R_System.Name0, v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, v_GS_ADD_REMOVE_PROGRAMS.Version0
from v_R_System
inner join v_GS_ADD_REMOVE_PROGRAMS on v_GS_ADD_REMOVE_PROGRAMS.ResourceId = v_R_System.ResourceId
where v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 like 'Oracle%'

Select distinct v_R_System.Name0, v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0, v_GS_ADD_REMOVE_PROGRAMS_64.Version0
from v_R_System
inner join v_GS_ADD_REMOVE_PROGRAMS_64 on v_GS_ADD_REMOVE_PROGRAMS_64.ResourceId = v_R_System.ResourceId
where v_GS_ADD_REMOVE_PROGRAMS_64.DisplayName0 like 'Oracle%'

But missing a lot of servers ... having Oracle Databases...

Thanks,
Dom

Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
461 questions
Microsoft Configuration Manager
0 comments
Accepted answer
  1. AllenLiu-MSFT 41,136 Reputation points Microsoft Vendor
    2022-02-08T02:07:18.327+00:00

    Hi, @Duchemin, Dominique

    Thank you for posting in Microsoft Q&A forum.

    The data of v_GS_INSTALLED_SOFTWARE is from asset intelligence. We may use v_Add_Remove_Programs to get a more accurate results. 

    Select distinct v_R_System.Name0, v_Add_Remove_Programs.DisplayName0, v_Add_Remove_Programs.Version0  
from v_R_System  
inner join v_Add_Remove_Programs on v_Add_Remove_Programs.ResourceId = v_R_System.ResourceId  
where v_Add_Remove_Programs.DisplayName0 like 'Oracle%'

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Duchemin, Dominique 2,006 Reputation points
    2022-02-08T02:27:26.267+00:00

    Hello,

    From the latest query

    Select distinct v_R_System.Name0, v_ADD_REMOVE_PROGRAMS.DisplayName0, v_ADD_REMOVE_PROGRAMS.Version0

    from v_R_System
    inner join v_ADD_REMOVE_PROGRAMS on v_ADD_REMOVE_PROGRAMS.ResourceId = v_R_System.ResourceId
    where v_ADD_REMOVE_PROGRAMS.DisplayName0 like '%Oracle%'

    I am getting this type of records:

    Name DisplayName

    VIPLAWSONLBI1 connectivity.connectionserver.drivers.oracle.jdbc-4.0-core-nu
    VIPLAWSONLBI1 connectivity.connectionserver.drivers.oracle.jdbc-4.0-en-nu
    VIPLAWSONLBI1 connectivity.connectionserver.drivers.oracle.oci.config-4.0-core-nu
    VIPLAWSONLBI1 connectivity.connectionserver.drivers.oracle.oci.config-4.0-en-nu
    VIPLAWSONLBI1 connectivity.connectionserver.drivers.oracle.oci-4.0-core-32
    VIPLAWSONLBI1 crystalreports.dataaccess.driver.oracle-4.0-core-32
    VIPLAWSONLBI1 crystalreports.dataaccess.driver.oracle-4.0-en-32
    VIPLAWSONLBI1 platform.library.common.authentication.oracle-4.0-core-32
    VIPLAWSONLBI1 platform.sdk.boe.java.oracle-4.0-core-nu

    But there is not a Database information by itself???

    Thanks,
    Dom