Delphix Products

 View Only
  • 1.  Get db usage recorded in masking engine

    Posted 07-09-2024 11:54:00 AM
    Edited by Vijayender Singidi 07-09-2024 11:54:50 AM

    Hi, 

    We are trying to capture the database usage(db size) for masking  with endpoint  "/database-usage" but when it execute not returning anything.

    Do we need any permissions on system tables on the DB ?. 



    ------------------------------
    Vijayender Singidi
    ------------------------------



  • 2.  RE: Get db usage recorded in masking engine

    Posted 07-09-2024 04:49:00 PM

    Do you mean literally nothing is returned, or are you getting an empty result set or error? 

    The user executing the call needs to have admin access on the masking engine.



    ------------------------------
    Matt Watson
    Staff Engineer
    Delphix
    ------------------------------



  • 3.  RE: Get db usage recorded in masking engine

    Posted 07-12-2024 11:20:00 AM

    yes, the user have Admin rights on the engine,  when running getting below response, 

    "data": [
        {
          "dbType": "Database - Extended",
          "size": 0,
          "databaseProperties": {},
          "executionId": 372,
          "failureReason": "Database size calculation not supported",
          "reportingDate": "2024-04-02 18:49:37.506"
        }

     



    ------------------------------
    Vijayender Singidi
    ------------------------------



  • 4.  RE: Get db usage recorded in masking engine

    Posted 07-14-2024 07:35:00 PM
    Edited by Matt Watson 07-14-2024 07:56:51 PM

    Please see Utilization , This feature only support Oracle 12c and above. I assume you are calling this against some other database type?



  • 5.  RE: Get db usage recorded in masking engine

    Posted 07-22-2024 09:28:00 AM
    Edited by Vijayender Singidi 07-22-2024 12:01:17 PM

    Yes Watson, 

    We need to get the  usage report for DB2,oracle and SQL server. and we would like to know the  db access required for masking to get the usage report.



    ------------------------------
    Vijayender Singidi
    ------------------------------