There is a mode on the VNX to create self-tier Reporting on Mon distribution.I need to create a summary table shows the percentage allocation of LUNs on different types of disk without the use of 'analyzer
You can use the CLI to export the list of LUNs and Tier Distribution. Only have access to a Clarion Array, but guessing its the same for VNX.
naviseccli -h <SP IP> lun -list -tiers
I would redirect to a text file.
naviseccli -h <SP IP> lun -list -tiers >>LUNList.txt
Then import in to Excel.