Skip to content
Espresso Data Privacy

Find

Finding personal data – in files, databases and Microsoft 365

Personal data is any information relating to an identified or identifiable person. Finding it means systematically establishing in which storage locations, databases and services such information is held – as the basis for the register, access requests and deletion.

Why does an organisation need to know where personal data is stored?

Almost every obligation under data protection law presupposes this knowledge. The record of processing activities (Art. 12 FADP, Art. 30 GDPR) describes which data is processed where. A response to an access request (Art. 25 FADP, Art. 15 GDPR) must cover all of a person's data. And personal data must be deleted or anonymised as soon as it is no longer needed for its purpose (Art. 6 para. 4 FADP, Art. 5 para. 1 let. e GDPR).

Looking only at the known systems means overlooking copies, exports and old storage locations. That is often exactly where the most sensitive data lies – and the greatest risks in the event of a data breach.

Where is personal data typically stored?

In legacy IT landscapes, personal data is not stored only in business applications:

  • Business applications and their databases, for example for customers, contracts, HR or cases.
  • File storage with exports, lists, spreadsheets and scanned documents.
  • Mailboxes in which documents are passed back and forth as attachments.
  • SharePoint, OneDrive and Teams – often shared more widely than intended.
  • Test and analytics environments with copies of production data.
  • AI services: prompts, chat histories and meeting transcripts.

Which information counts as personal data?

Personal data is not just names. Identifiers that can be used to identify a person are also included. An overview:

Type Examples
Identifiers AHV number (Swiss social security number), IBAN, ID document, insurance, customer and policy number
Person and contact Name, address, date of birth, email address, phone number, employee number
Sensitive personal data (Art. 5 let. c FADP) Health, religious, ideological or political views, trade union, intimate sphere, ethnicity, genetic data, biometric data that uniquely identifies a person, administrative and criminal proceedings and sanctions, social assistance measures

The GDPR has a similar list known as “special categories of personal data” (Art. 9 GDPR).

How do you find personal data reliably?

A search only becomes reliable when several methods are combined. Rules detect identifiers with a fixed structure, such as the AHV number or an IBAN. Free-text detection finds names and addresses. Text recognition makes scanned documents searchable. Custom search patterns add whatever is specific to your organisation, such as customer or contract numbers.

Handling the results is just as important: false positives must be permanently suppressible, and repeated scans should show what has been added and what has disappeared. And because the search reads the content, it belongs in your own environment – the data should not leave your premises for it.

Data Discovery: what a scanner must deliver

There are many tools for data discovery and classification. For data protection, these points matter most:

  • Breadth of sources: file storage, databases and Microsoft 365, not just a single system.
  • Swiss and European identifiers, not just American ones.
  • Read-only: nothing is changed in the sources.
  • Store findings, not content.
  • Confirm findings or suppress them as false positives – and retain the decision in the next run.
  • Reuse findings: for the register, for access requests and for deletion.

How Espresso helps

Data Discovery searches your environment for personal data and passes the findings on to the other modules.

  • Broad range of sources

    File storage, PostgreSQL, MySQL and MariaDB, Microsoft SQL Server, Microsoft 365 with Copilot, and stored data from the use of Claude.

  • Swiss and European identifiers

    AHV number, IBAN, national social security, tax or personal identification numbers from eight European countries, plus names and addresses in free text through local detection.

  • From finding to action

    Confirm findings, suppress false positives, compare runs and track actions with deadlines.

Frequently asked questions

Does personal data mean the same under the Swiss FADP and the GDPR?

Yes. The German-language versions use different terms (“Personendaten” in the Swiss FADP, “personenbezogene Daten” in the GDPR), but both mean information relating to an identified or identifiable natural person (Art. 5 let. a FADP, Art. 4 no. 1 GDPR).

Is a survey of the business units enough?

It shows what the business units know. Often nobody remembers copies, exports and old storage locations. A technical search complements the survey with what is actually stored.

How often should we search?

Regularly, because new data is created all the time. The comparison is especially revealing: what has been added and what has disappeared since the last run.

Does the data have to leave the organisation for the search?

No. Data Discovery runs in your environment and reads the sources there. It stores the location and masked matches in your database, not the content of the sources.

See Espresso in 30 minutes

We will show you the cockpit with sample data – and discuss where you should start.

Request a demo

or write directly to info@espressodataprivacy.com