Script Download: The script is available for download from https://gallery.technet.microsoft.com//How-to-check-SQL-Server-985be4f8. You can also use Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.
This PowerShell script will demo how to detect database(s) files residing in resilient file system (ReFS) in Windows Server 2012.
Hosting databases on Windows Server 2012 ReFS is not supported for production use. If there is any database on ReFS file system, the script will give a warning.
You can find more All-In-One Script Framework script samples at http://aka.ms/onescriptingallery