Find-DbaOrphanedFile does not work with SQL on Linux

[potatoqualitee]

Verified issue does not already exist?

Yes

What error did you receive?

wrong output

Steps to Reproduce

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\master.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\master.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\mastlog.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\mastlog.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\model.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\model.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\modellog.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\modellog.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\msdbdata.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\msdbdata.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\msdblog.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\msdblog.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\northwnd.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\northwnd.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\northwnd.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\northwnd.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\pubs.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\pubs.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\pubs_log.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\pubs_log.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\tempdb.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\tempdb.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\tempdb2.ndf
RemoteFilename : \\mssql1\var\opt\mssql\data\tempdb2.ndf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data\templog.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\templog.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data/pubs.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\pubs.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : /var/opt/mssql/data/pubs_log.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\pubs_log.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\master.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\master.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\mastlog.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\mastlog.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\model.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\model.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\modellog.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\modellog.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\msdbdata.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\msdbdata.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\msdblog.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\msdblog.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\northwnd.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\northwnd.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\northwnd.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\northwnd.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\pubs.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\pubs.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\pubs_log.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\pubs_log.ldf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\tempdb.mdf
RemoteFilename : \\mssql1\var\opt\mssql\data\tempdb.mdf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\tempdb2.ndf
RemoteFilename : \\mssql1\var\opt\mssql\data\tempdb2.ndf

ComputerName : mssql1
InstanceName : MSSQLSERVER
SqlInstance : mssql1
Filename : \var\opt\mssql\data\templog.ldf
RemoteFilename : \\mssql1\var\opt\mssql\data\templog.ldf

Are you running the latest release?

Yes

Other details or mentions

No response

What PowerShell host was used when producing this error

Windows PowerShell (powershell.exe)

PowerShell Host Version

Name Value

---

PSVersion 5.1.22000.282
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.22000.282
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

SQL Server Edition and Build number

linux

.NET Framework Version

.NET Framework 4.8.4420.0