OPS Center SQL Query for policy chnage information

[M_10]

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

[Mouse]

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

[M_10]

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

Thanks

Mainak Das

[Marianne]

I do not have much experience with OpsCenter and even less with custom scripts.

No sure if this will help to get started - I found this in the online manual:

https://www.veritas.com/content/support/en_US/doc/67898349-127431275-0/v47930697-127431275

In the meantime, you may want to use 'nbauditreport' from cmd.

My experience with auditing is that all changes will show as being executed by root if user access control has not been configured.

[Mouse]

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.

[M_10]

Hi,

While checking the nbaudit report command, i am getting below information. I need to know what chnaged in the policy rather than showing attributes of the policy was modified..Please help if someone can know any SQL script. I know this can be acheived but i am unable to create the script.

12/18/2017 13:05:47 ******** Attributes of Policy '******************User' were modified
12/18/2017 13:05:32 ******** Attributes of Policy '******************User' were modified
12/18/2017 13:03:59 ******** Attributes of Policy '******************1M' were modified
12/18/2017 13:03:59 ******** Attributes of Policy '******************200' were modified
12/18/2017 13:03:58 ******** Attributes of Policy '******************400' were modified
12/18/2017 13:03:58 ******** Attributes of Policy '**********************' were modified
12/18/2017 13:03:58 ******** Attributes of Policy '******************200' were modified
12/18/2017 13:03:58 ******** Attributes of Policy '******************' were modified
12/18/2017 13:03:57 ******** Attributes of Policy '******************-CTX' were modified
12/18/2017 13:03:57 ******** Attributes of Policy '******************T_Vcenter' were modified
12/18/2017 13:03:57 ******** Attributes of Policy '******************' were modified
12/18/2017 13:03:56 ******** Attributes of Policy '******************MT' were modified
12/18/2017 13:03:56 ******** Attributes of Policy '******************200' were modified
12/18/2017 13:03:56 ******** Attributes of Policy '******************800' were modified
12/18/2017 13:03:56 ******** Attributes of Policy '******************100' were modified
12/18/2017 13:03:55 ******** Attributes of Policy '******************500' were modified
12/18/2017 13:03:55 ******** Attributes of Policy '******************hr' were modified
12/18/2017 13:03:30 ******** Attributes of Policy '*********************' were modified
12/18/2017 13:03:29 ******** Attributes of Policy '*********************' were modified
12/18/2017 13:03:29 ******** Attributes of Policy '******************300' were modified
12/18/2017 13:03:29 ******** Attributes of Policy '**********************' were modified
12/18/2017 13:03:29 ******** Attributes of Policy '******************100' were modified
12/18/2017 13:03:29 ******** Attributes of Policy '**********************' were modified
12/18/2017 13:03:28 ******** Attributes of Policy '******************000' were modified
12/18/2017 13:03:28 ******** Attributes of Policy '******************hrs_WIN' were modified
12/18/2017 13:03:28 ******** Attributes of Policy '******************hrs' were modified
12/18/2017 13:03:27 ******** Attributes of Policy '******************hrs' were modified

Thanks

MainakDas

[M_10]

you are probably right, i know this, but if you see my last post, i have some different requerment. I want to schedule it.

Thanks in advance

Mainak Das