Pre-migration queries related to data discovery and file analysis

Hello pallavirajak,

Hope the below details help. 

1. Identification of file types - The Information Protection Scanner discovery report will have details about the files scanned. To know more about IP Scanner, refer to: Learn about the Microsoft Purview Information Protection scanner | Microsoft Learn
2. Detection of duplicate or redundant files -Currently, there is no direct method within Purview to identify duplicate files. 
3. Identification of embedded UNC paths, macros, and document links - If you mean links or embedded paths mentioned inside documents, this can be approached by creating custom Sensitive Information Types (SITs) to detect UNC paths and hyperlinks. However, identifying macros specifically is not supported by Purview. Attack Surface Reduction rules of Defendercould help with this - Attack surface reduction rules reference - Microsoft Defender for Endpoint | Microsoft Learn 
4. Detection of applications running directly from file shares- This is not possible with Purview. For this requirement, Microsoft Defender for Endpoint offers better capabilities through Advanced Hunting queries.
   Refer to: Overview - Advanced hunting - Microsoft Defender XDR | Microsoft Learn
   Microsoft-365-Defender-Hunting-Queries/Discovery/SMB shares discovery.txt at master · microsoft/Microsoft-365-Defender-Hunting-Queries · GitHub

For macros and detecting apps running from shares, Defender for Endpoint would provide more effective solutions than Purview.

On the 10,000‑row export limit, guess you’re referring to portal exports (e.g., Activity Explorer). For IP Scanner discovery, reports are available locally on the scanner host. Refer to: https://learn.microsoft.com/en-us/purview/deploy-scanner-manage#run-a-discovery-cycle-and-view-reports-for-the-scanner 

If a long discovery run stops mid‑way, address the root cause first, then resume/partition the scan and consolidate the per‑job CSVs.
When an IP Scanner run stops mid‑scan, refer to: https://learn.microsoft.com/en-us/purview/deploy-scanner#stopped-scanner-processes 

Settings that can be Modified to Improve Network Performance - BizTalk Server | Microsoft Learn

Please mark as solution, if you find the answer helpful. This will assist others in the community who encounter a similar issue, enabling them to quickly find the solution and benefit from the guidance provided