Example Query
Note:
In the SQL Template Designer query, the function name must be prefaced with:
SELECT *
FROM table (srm_rtd.listChargebackByLUNDetail(100000,
numberListType(),
numberListType(),
numberListType(),
numberListType(${hostGroups}),
1,
numberListType()
))Specify the following arguments:
Argument Name | Description |
|---|---|
userID | Number |
listOfHosts | numberListType Example: numberListType(1,2,3) |
listOfDomains | numberListType Example: numberListType(1,2,3) |
listOfArrays | numberListType Example: numberListType(1,2,3) |
listOfHostGroups | numberListType Example: numberListType(1,2,3) |
cascade | Specify 1 to designate that you want to cascade through the host group hierarchy; Otherwise, set to 0. |
listOfPolicy | numberListType Example: numberListType(1,2,3) |
This function returns rows that contain: host ID, host name, policy ID, chargeback policy name, storage array ID, storage array name, LUN ID, LUN name, unit cost, total GB, total cost.