search

microsoft / Microsoft-Purview-Advanced-Rich-Reports-MPARR-Collector

Repository with all the MPARR components solution
MIT License
102 stars 23 forks source link

Sensitivity labels missing names #60

Open jamwhit opened 5 months ago

jamwhit commented 5 months ago

Hi

I'm having an error occur on the MPARR2 template as my Labels_CL table has empty/duplicate entries under the name field. I've checked on using PowerShell and each label does have a name value, mostly set to the same as the guid.

Here is the error I am receiving on the Sensitivity Labels query: Column 'Name_s' in Table 'Sensitivity Labels' contains a duplicate value '' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

A screenshot of my log table showing empty values:

image

Screenshot of the labels showing the name is set as the guid on the tenant. This is consistent for all but one label: image

Many thanks

jamwhit commented 5 months ago

I updated the the rule to use name_g instead of name_s and this has resolved the issue as there are no missing values.

Having the same buffer issue other have been facing though. Are there any workarounds i can try to produce limited reports? Removing 'Enable load' from the DLPAll Data Details table makes the report very limited as we have no policy match data.

Thanks