Yes this definitely works, you will need to install and configure an SMI-S provider on your agent... This should help Installing and Configuring EMC SMI-S Provider and Solutions Enabler Appliance (VNX/CLARiiON) (just follow the instructions for installing and configuring the provider). Once you have the SMI-S provider installed and you have added your arrays, adding the VNX in solarwinds is very easy; you will be prompted to add the IP where you installed the provider and it will then run a scan for the arrays that you have added to the provider.
You can get the provider here: https://community.emc.com/docs/DOC-19629
Below are some screenshots of my VNX 5300 in solarwinds:
Yes, SolarWinds Storage Resource Monitor can absolutely monitor the EMC VNX family of devices. You can see details of what that support looks like in our live Orion Demo - http://oriondemo.solarwinds.com/Orion/SRM/ArrayDetailsView.aspx?NetObject=SMSA:4
VNX support includes block and file side monitoring of performance, capacity, and configuration data.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.