Failed to enumerate the disks by Windows File System Backup

SnapCenter UI does not show the disks for a given Microsoft Plug-In host and shows the below errors in the SCWDebug.log:

2023-04-21T11:11:52.3126576+02:00 Information SDW PID=[4960] TID=[1000] Get disks, volumes and partitions on my-hostname0010
2023-04-21T11:11:52.3126576+02:00 Verbose SDW PID=[4960] TID=[1000] query: SELECT * FROM MSFT_StorageNode WHERE Name = 'my-hostname0010.Oster.local'
2023-04-21T11:11:52.3126576+02:00 Verbose SDW PID=[4960] TID=[1000] scope: \\my-hostname0010\root\Microsoft\Windows\Storage
2023-04-21T11:11:52.3282250+02:00 Error SDW PID=[4960] TID=[1000] Error: Failed to get disks. 'results' null
2023-04-21T11:11:52.3282250+02:00 Verbose SDW PID=[4960] TID=[1000] GetNodeSpecificHostStorageData: Caught exception: 'Error: Failed to get disks. 'results' null'
2023-04-21T11:11:52.3282250+02:00 Verbose SDW PID=[4960] TID=[1000] GetNodeSpecificHostStorageData: Stack trace: at SnapDrive.Nsf.Core.Host.HostDiscoveryManager.GetNodeSpecificHostStorageData(String host, Boolean isAlm)

The query is run against the name my-hostname0010 however the host is registered in the NSM MySQL Metatada databasewith host id 2 under the name my-hostname001002.domain.local

Same query run manually from PowerShell on the Plug-In host shows empty output:

gwmi -Namespace ROOT/Microsoft/Windows/Storage -Query "select * from MSFT_StorageNode WHERE Name ='my-hostname0010.domain.local'"

but query run against correct hostname returns the output correctly:

gwmi -Namespace ROOT/Microsoft/Windows/Storage -Query "select * from MSFT_StorageNode WHERE Name ='my-hostname001002.domain.local'"