Disabling SQL Dynamic Data Masking for the CommServe

Question

Hi Community,

I’m currently forwarding logs from Commvault with a external monitoring tool, and then use a DB Connect tool for this.

After a recent upgrade, I can see that my queries for the view [CommServ].[dbo].[CommCellBackupInfo] is now being masked for the variable clientname. It now shows, for example: “eexxxxom”. instead of “example.com”. I found this KB: SQL Dynamic Data Masking about this.

Questions I have relating to this are:

What privilege does the user need to have for this to not mask? Currently, I have “read-only” rights, which only have rights to read and connect to the database. What else would I need for this to work?
Or, are there any way to disable this in Commvault/the SQL database in the CommServe?

Kind regards,

Daniel

ddwyer · Answer

Hi Daniel,Dynamic Data Masking is enabled from 11.36 onwards by default.You can GRANT UNMASK TOthe user which the external log monitoring tool uses to access the Commvault data.This change needs to be made in SQL Server and will require a privileged user account to make the change.Regards,David