Ok. The other thing it could be that the report definition does not have the all of the columns defined in the hyperlink section.
I found a resolution for this that David Dupre dupda03 provided. It requires having RDP access to the CCR server, editing the MySQL_VMWARE_CORE.sql file and re-running it in MySQL session.
The file MySQL_VMWARE_CORE.sql contains the definitions for this view.
This View of interest starts at line 961 showing the line:
select @controlID := ID from controls where Title = 'VM Usage Summation';
It appears that the line 978 in the file MySQL_VMWARE_CORE.sql file has only enough commas to hold 7 hyperlinks.
There are 8 columns of data on that page. (See lines 966, 970, 971 each has 8 column definitions.)
There needs to be 8 locations for hyperlinks also, there is not. (Line 978)
Note: there are only 2 columns that have URLs filled in.
I show it is currently set to:
(@controlID, 'N', 'Hyperlinks', 'default.aspx?pg=vmdetail&vm={ENTITY_NAME},default.aspx?pg=vhostdetail&vhost={Physical_HOST},,,,,'),
The correction is to add one more comma to this line: (shown below)
(@controlID, 'N', 'Hyperlinks', 'default.aspx?pg=vmdetail&vm={ENTITY_NAME},default.aspx?pg=vhostdetail&vhost={Physical_HOST},,,,,,'),
This should fix the problem and allow export to CSV.
!!! Backup the original file BEFORE editing it!!!
To make this change active after saving the change in the file they must reload the MySQL_VMWARE_CORE.SQL file into CCR.
- Open MS_DOS box on CCR server.
- CD C:\NETQOS\portal\Integration\DataManager
- mysql netqosportal < .\sql\MySQL_VMWARE_CORE.sql
- Test the view again