Forum Discussion

M_10's avatar
M_10
Level 3
7 years ago

OPS Center SQL Query for policy chnage information

Hi All,

I need a help to get the query or create the Ops center SQL query to see which id(NBAC is enabled already) have changed the policy and what have been changed(e.g policy Type, storage Unit, schedule)in the policy. Please help me someone.

 

 

Thanks

Mainak Das

6 Replies

  • I'm not sure but if remember correctly, the standard Audit report provide these details?

    • M_10's avatar
      M_10
      Level 3

      I need it through SQL query through Ops Center. The one which you are pointing, is time taking jobs.

       

       

      Thanks

      Mainak Das

      • Mouse's avatar
        Mouse
        Moderator

        You can filter actions in the audit_Record table using the schema below:

        Column Name Data Type Nulls Primary Key Description
        masterServerId integer N Y Unique identifier for master server
        tieInId bigint N Y Tie in identifier
        recordId bigint N Y Unique identifier for audit record
        auditTime bigint Y N Audit Time
        categoryId integer Y N Identifier for the record category
        hasChildren bit Y N Indicates if record has any children
        messageId integer Y N Unique identifier for the message
        operationId integer Y N Unique identifier for the operation
        parentRecordId bigint Y N Record identifier of the parent
        reason long varchar Y N Reason
        subCategoryId integer Y N Identifier for the record sub-categor
        userIdentityId integer Y N Identifier for user identity

         

        The you can pull userIdentityId from audit_UserIdentity and audit message details from the respective lookups.