Export SQL Data Classification Recommendations

Question

Post reply

Export SQL Data Classification Recommendations

Jay1234

SSCommitted

Points: 1624
More actions
April 25, 2023 at 3:14 pm

#4179276

Is there a way export Data Classification recommendations as a pdf or text file? Thanks you.
May 10, 2023 at 8:23 am

This was removed by the editor as SPAM

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Emperor100 SSCrazy Points: 2050 More actions · Answer 1

Jay1234 wrote:

Is there a way export Data Classification recommendations as a pdf or text file? Thanks you.

Yes, you can export the data to Excel or PDF.

2023-04-25_17-03-34

---------------------------------------------------------------------------------------------------------------------------------

kajaldigital8700@gmail.com SSC Rookie Points: 43 More actions · Answer 2

Yes, it is possible to export Data Classification recommendations as a PDF or text file. Here are the steps to do so in Microsoft 365 Compliance Center:

Sign in to the Microsoft 365 Compliance Center.
Go to the Data Classification page and select the Data Classification tab.
Click on the recommendation that you want to export.
In the right-hand pane, you will see the details of the recommendation. Click on the Export button at the top.
Select the format in which you want to export the recommendation - PDF or CSV. Choose PDF if you want to export it as a document, or choose CSV if you want to export it as a text file.
Choose the location where you want to save the file and click on Export.
The recommendation will be exported to the chosen location in the chosen format.Note: The above steps are specific to Microsoft 365 Compliance Center. If you are using a different tool for Data Classification, the steps to export recommendations may vary.

This reply was modified 5 months ago by kajaldigital8700@gmail.com.

Jeff Moden SSC Guru Points: 1003301 More actions · Answer 3

To be honest, though, the tool seems to be based only on column names. It doesn't actually look for columns that, for example, look for 9 digit number or strings of 9 numeric characters. Of course, it will help you find the "overt" problems according to column names but that's not a guarantee.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)