Zend certified PHP/Magento developer

Find all cloud-based files/folders available in explorer e.g. only on demand locally

Cloud files displayed in Windows Explorer (in my case, locally sync’ed on NTFS drive) can be available at present locally, always locally, or on demand only (or just sync’ing), as indicated by the respective icons.

Is it possible to find and ideally list (display copy-paste / text file) all folders/files with a specific state of availability, throughout a big folder/subfolder structure (i.e. not possible to do manually by looking at the icons)?

I am happy for solutions using Windows Explorer, any usually standard-installed or common open source software, or by cmd or powershell small scripts (or if really necessary VBA).

Thanks in advance!