Example Query
In the following SQL Template Designer query, it assumes that you have configured a Location attribute for your storage arrays and you want to return the location of the array's data center for your report.
SELECT rtd.getObjectAttributeValue(sa.storage_array_id,'Location','A') AS " Data Center Location", sa.array_name AS "Array Name", sa.allocated_gb AS "Allocated (GB)" FROM aps_v_storage_array sa WHERE rtd.getObjectAttributeValue(sa.storage_array_id,'Location','A') IS NOT NULL
The resultant report will display a table with three columns: Data Center, Array Name, and Allocated (GB).