Hi Venkat,
Follow the below steps, it will help you to pull the raid details of existing aggregates.
In dictionary tab
1. Clone the dictionary ‘Aggregate’ in the storage scheme
2. Add new row to the cloned dictionary with the below details
Name : raidType
Type : string
Sting length : 128
Use the below query in Cache query
SELECT
aggr.aggrId AS id,
obj.objName AS name,
aggr.dfKBytesTotal/1024 AS total_size_mb,
aggr.dfKBytesUsed/1024 AS used_size_mb,
aggr.dfKBytesAvail/1024 AS available_size_mb,
COUNT (vol.volId) AS volume_count,
aggr.aggrStatus AS STATUS,
aggr.hostId AS array_id,
aggr.aggrBlkType as block_type,
aggr.aggrState as state,
(IF (aggr.isFlashPoolEnabled='Yes') THEN 1
ELSE 0 ENDIF) AS is_hybrid,
aggr.raidType as raidType
FROM
dfm.aggrs aggr
LEFT JOIN
(
SELECT
vol.volId,
vol.aggrId
FROM
dfm.volumes vol
JOIN
dfm.objects
ON vol.volId = objects.objId
WHERE
objects.objDeleted IS NULL
) as vol
ON vol.aggrId = aggr.aggrId
JOIN
dfm.objects obj
ON obj.objId = aggr.aggrId
WHERE
aggr.snapshotsourceid = 0
AND obj.objDeleted IS NULL
AND (
(
obj.objFlags & 0x20000000000000
) = 0
)
GROUP BY
aggr.aggrid,
name,
status,
total_size_mb,
used_size_mb,
available_size_mb,
array_id,
block_type,
state,
is_hybrid,
raidType