Get Chargeback Report
Get charge back report
Query Parameters
- parameter.spName boolean
RptMonthlyStorageUsage (Stored Procedure Name)
- parameter.param8 string
Type (1 for monthly, 2 Weekly, 4 Daily)
- parameter.param9 string
- offset int32
- dateFormat string
- priority string
- syscol boolean
- limit int64
number_of_rows
- parameter.param2 int32
Aggregate level 0 for Subclient, 1 for Client, 2 for CommCell, 3 for Client Group, 4 for Tag, 5 for Subclient per Copy
- parameter.param3 int32
CommCell UniqId
- parameter.param1 int64
CommCell Group Id -1 for all
- parameter.param6 string
Size (GB, TB, PB)
- operation string
- parameter.param7 string
Client Group Name (Null or Name of Client Group)
- parameter.param4 string
Include Cost (1 to include defined cost, 0 to Exclude)
- parameter.param5 string
Start Date
- orderby string
Same as SQL Order by clause
- where string
Same as SQL where clause
- having string
Same as SQL having clause
- groupby string
Same as SQL group by clause
- cache=true boolean
Enables caching of the ResultSet and returns the cacheID
- cacheId string
Reads the ResultSet from the cache instead of the revising the original data sources
- fields string
Column name to include in the output.
Responses
- 200
OK
- application/json
- Schema
- Example (from schema)
- Chargeback Report - Via Web Console
- Chargeback Report
Schema
- cacheId string
- offset integer
- limit integer
- totalRecordCount integer
columns object[]
name stringdataField stringtype stringprecision integerscale integer- recordsCount integer
records object[]
failures object
warnings object
{
"cacheId": "string",
"offset": 0,
"limit": 0,
"totalRecordCount": 0,
"columns": [
{
"name": "string",
"dataField": "string",
"type": "string",
"precision": 0,
"scale": 0
}
],
"recordsCount": 0,
"records": [
{}
],
"failures": {},
"warnings": {}
}
{
"cacheId": "8202e47e7d4a420395a021f05da627ff",
"offset": 0,
"limit": 50,
"totalRecordCount": 0,
"columns": [
{
"name": "Data Source",
"dataField": "Data Source",
"type": "String",
"precision": 2147483647,
"scale": 0
},
{
"name": "CommServ UniqueId<DONOTSHOW>",
"dataField": "CommServ UniqueId<DONOTSHOW>",
"type": "Integer",
"precision": 10,
"scale": 0
},
{
"name": "CommCell Name",
"dataField": "CommCell Name",
"type": "String",
"precision": 2147483647,
"scale": 0
},
{
"name": "Client Groups",
"dataField": "Client Groups",
"type": "String",
"precision": 2147483647,
"scale": 0
},
{
"name": "Client",
"dataField": "Client",
"type": "String",
"precision": 2147483647,
"scale": 0
},
{
"name": "Agent",
"dataField": "Agent",
"type": "String",
"precision": 2147483647,
"scale": 0
},
{
"name": "Instance",
"dataField": "Instance",
"type": "String",
"precision": 2147483647,
"scale": 0
},
{
"name": "Backupset",
"dataField": "Backupset",
"type": "String",
"precision": 2147483647,
"scale": 0
},
{
"name": "Subclient",
"dataField": "Subclient",
"type": "String",
"precision": 2147483647,
"scale": 0
},
{
"name": "Front End Backup Size",
"dataField": "Front End Backup Size",
"type": "Decimal",
"precision": 32,
"scale": 3
},
{
"name": "Front End Backup Cost<FORMATNUMBERNA>",
"dataField": "Front End Backup Cost<FORMATNUMBERNA>",
"type": "Decimal",
"precision": 32,
"scale": 3
},
{
"name": "Front End Archive Size",
"dataField": "Front End Archive Size",
"type": "Decimal",
"precision": 32,
"scale": 3
},
{
"name": "Front End Archive Cost<FORMATNUMBERNA>",
"dataField": "Front End Archive Cost<FORMATNUMBERNA>",
"type": "Decimal",
"precision": 32,
"scale": 3
},
{
"name": "Primary App Size",
"dataField": "Primary App Size",
"type": "Decimal",
"precision": 32,
"scale": 3
},
{
"name": "Primary App Cost<FORMATNUMBERNA>",
"dataField": "Primary App Cost<FORMATNUMBERNA>",
"type": "Decimal",
"precision": 32,
"scale": 3
},
{
"name": "Total Cost<FORMATNUMBERNA>",
"dataField": "Total Cost<FORMATNUMBERNA>",
"type": "Decimal",
"precision": 32,
"scale": 3
}
],
"recordsCount": 0,
"records": [],
"failures": {},
"warnings": {}
}
{
"cacheId": "string",
"offset": 0,
"limit": 0,
"totalRecordCount": 0,
"columns": [
{
"name": "string",
"dataField": "string",
"type": "string",
"precision": 0,
"scale": 0
}
],
"recordsCount": 0,
"records": [
{}
],
"failures": {},
"warnings": {}
}
Loading...