I'm running the Version 1.1 of the VCenter 6.0 Datasource script to collect VCenter information into a WFA database for some of our workflows. Today I noticed that some of the rows in the nas_share table are missing the data in the array column. I am using the information in this column to automatically determine the cluster mode interface a particular datastore is connected via in order to use that same interface to mount a restored flexclone of that datastore. My test environment did not have any rows where the array column was blank, however, my production environment is much larger than my test environment.
When I run the following query:
SELECT DISTINCT data_store_id,array,share_path FROM vc.nas_share where array = '';
It returns, you can see a number of the datastores have a blank array:
It will create file ./Nas_Share.csv and C:\temp\vmware.log
kindly send those 2.
You may do some debugging yourself. Look into the wmware.log file and see which datastores have empty NFS_HOST_ARRAY
The VC6.0 script just get the attribute RemoteHost for every NFS datastore. If its '' for some datastores, this is how its been returned by Vcenter. I've never see this being empty for any of my NFS datastores. But strange things happen in software.
In this case I need to see how else can I obtain the RemoteHost property for those datastores who have this property as ''.
I suspect those can be NFS datastores created on from local NAS shares. Is it?
If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.
The NFS exports are all done the same way via cluster mode NFS exports that are mounted by our ESX clusters. It's very strange, I cannot really see a pattern as to why these are not collecting the array information whereas the datasource script did correctly log the array information on the majority of our datastores.
One thing I did notice is that the datastores missing array information tend to be mostly from our smaller ESX clusters with only 2 hosts. There are 3 sets of 2 host ESX clusters where the array information is missing on all of their NFS datastores. However, there are also a handful of datastores on the list (roughly 1/3) that are in our largest production cluster with 20 hosts.
The other difference to note between test and prod is that in test we only have 1 vcenter server, however, in prod we have 2 vcenter servers. Our prod WFA server collects from all 3 VCenter servers whereas our test WFA only collects from test.
I'll run through the debug steps you listed and post the results.