Saltear al contenido principal

Sensitive Data Classification Report in SQL Server

ES: Reporte de Información confidencial en SQL Server

First it is important you have all your confidential information in your databases identified. Surely you have done this work after you took a look at Finding Sensitive Data in SQL Server. Now is the turn to obtain a sensitive data classification report with all of your findings.

Let’s begin with the easieast.

Generate report from Tasks

Have you already seen the first paragraph’s link? It’s just the same way but now you go through “Generate Report” option.


You don’t have to do anything else and the report is done. You got an easy to see graphical report with all of the configurations you did before with Data Classification.


Do you prefer plain text reports?

Almost in every place you have the option to generate the information you need through some code lines. I’ve got some from Microsoft docs.

Basically I select data from Extended Properties.

  • sys_information_type_name
  • sys_sensitivity_label_name

You get a simple report in plain text as you can see in the image.

And if you got SQL Server 2019

Of course, as some other improvements in this version, some of them will help you to report additional information.

You can query a new catalog system view.

  • sys.sensitivity_classifications

And we can use it this way. (Also taken from the previous official link)


Finally you need to maintain the sensitive data classification report

You’ve got your report. Now use it and if necessary share it with your coworkers.

It is important that the DBAs team, developers and everybody who interacts with databases, know this data classification.

We cannot spread confidential information without control.

You need to update this report periodically and take a look if everything is correct. Also you must work with different areas in your organization, all the people involve in risks, security and others that can influence in data classification.

Pablo Javier Fernández
I love working on SQL Server Performance Tuning and finding the origin of the problems. Music and SQL Server passionate.

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Close search


Volver arriba