SPSiteDataQuery is used to Query multiple lists or to read data from all the lists in a site collection.
Get Combined result
Below is the example to query multiple list data sources and get combined information in data table:
Related Article:
- How to update SharePoint’s Group Owner using PowerShell
- Get extract of files modified after particular date from SharePoint library or folder within library (PowerShell script)
- Bulk delete SharePoint List items using CSOM
- Delete all sharepoint list item using powershell
- Window scroll event is not firing in SharePoint
