4 Replies Latest reply on Dec 3, 2018 7:58 AM by Sushant Pradhan

    Credential requirement for Deep Database Discovery

    Sushant Pradhan

      Hi Experts,

       

      Can anybody tell me what are the privileges required for deep discovery of databases. I couldn't locate this in the documentation. Can anybody point me to the documentation section.

        • 2. Re: Credential requirement for Deep Database Discovery
          Sushant Pradhan

          Hi Vikash, Thank you. I have checked this link before but it does not contain information related to privileges required for deep discovery. I need infomation of what type of user we need to create. Do we need to create a DB admin or a normal user can do deep discovery?

          • 3. Re: Credential requirement for Deep Database Discovery
            VIKASH CHAURASIA

            DB User must have permission to execute the respective queries.

             

            Here is the example of MS-SQL. For other databases, you can find from ADDM console credential section.

             

            Microsoft SQL

            1. Sr. No.

            Description

            Query

            1

            Returns related BMC CONTROL-M/Server hostnames

            SELECT CTM_HOST_NAME from COMM

            2

            Returns BMC Remedy AR System Applications

            select application_guid, property_name, property_value from SHARE_Application_Properties

            3

            Returns BMC Remedy AR System Licensing Data

            select Key_x, Expiration_Date, License_Type, Number_of_Licenses from AR_System_Licenses

            4

            Return a list of databases and their sizes in KB through a stored procedure

            sp_helpdb

            5

            Return a list of defined databases through a SELECT statement

            SELECT name AS database_name FROM SYS.SYSDATABASES

            6

            Return a list of defined databases through a SELECT statement on Microsoft SQL Server 2000

            SELECT name AS database_name FROM master..sysdatabases

            7

            Return a list of defined databases through a Stored Producedure

            sp_databases

            8

            Return a list of defined tables within the given database

            SELECT TABLE_NAME, TABLE_SCHEMA FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG = %db_name%

            9

            Returns related Microsoft System Center DPM Agents hostnames

            SELECT ServerName FROM tbl_AM_Server

            10

            Return related Microsoft System Center VMM Agents hostnames

            SELECT ComputerName FROM tbl_ADHC_AgentServer

            11

            Returns the UUID of each VM managed by a specified Microsoft Hyper-V host

            SELECT VMId FROM dbo.tbl_WLC_VMInstance WHERE VMInstanceId IN (SELECT ObjectId FROM dbo.tbl_WLC_VObject WHERE HostId = %hostid%)

            12

            Returns Microsoft Hyper-V hosts managed from the Microsoft System Center VMM

            SELECT HostID,ComputerName FROM dbo.tbl_ADHC_Host

            13

            Query to obtain SAP Components

            select * from CVERS

            14

            Query to obtain SAP Components Description

            select * from CVERS_REF

            15

            Query to obtain SAP Licensing

            select * from MLICHECK

            16

            Query to obtain SAP Release

            select * from SVERS

            17

            Query to obtain SAP Versioning

            select * from CVERS_TXT

            18

            Returns related Deployment Agents hostnames

            SELECT computer_id, ip_hostname, domain_name FROM dbo.computer

            19

            Returns related Deployment Agents IP addresses

            SELECT computer_id, ip_address FROM dbo.computer_display

             

            2 of 2 people found this helpful
            • 4. Re: Credential requirement for Deep Database Discovery
              Sushant Pradhan

              Hi Vikash,

               

              Thank you. I was wondering if this is documented. Now I understood, will extract this from the console.