Data - Retrieve Datawarehouse Details

Reference

Service:: Operations Manager

API Version:: v1

Retrieves data warehouse details based on stored procedure name.

POST http://<Servername>/OperationsManager/data/DataWarehouse

Request Body

Media Types: "application/json", "text/json", "application/xml", "text/xml", "application/x-www-form-urlencoded"

Name	Type	Description
parameters	object	SQL Parameters with values
storedProcedureName	string	StoredProcedureName

Responses

Name	Type	Description
200 OK	object	OK.Successfully retrieved DatawareHouse details. Media Types: "application/json", "text/json", "application/xml", "text/xml"

Name

Type

Description

200 OK

object

OK.Successfully retrieved DatawareHouse details.

Media Types: "application/json", "text/json", "application/xml", "text/xml"

Examples

GetDataFromDW

Sample Request

HTTP

POST http://<Servername>/OperationsManager/data/DataWarehouse

Sample Response

Status code:: 200

{
  "resultList": [],
  "columnDefinitions": [
    {
      "columnName": "ServiceLevelAgreementRowId",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelAgreementGuid",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelAgreementDisplayName",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ManagementGroupGuid",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelAgreementManagedEntityRowId",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelAgreementManagedEntityTypeGuid",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelAgreementManagedEntityTypeDisplayName",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelAgreementManagedEntityGuid",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelAgreementManagedEntityDisplayName",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelAgreementManagedEntityPath",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelObjectiveRowId",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelObjectiveGuid",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelObjectiveDisplayName",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelObjectiveTargetManagedEntityTypeGuid",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    },
    {
      "columnName": "ServiceLevelObjectiveTargetManagedEntityTypeDisplayName",
      "sourceColumnName": null,
      "aliased": false,
      "isExpression": false,
      "columnSource": null,
      "columnType": "System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089",
      "columnDatabaseTypeAsInt": 0,
      "columnMaxLength": 0,
      "isNullable": false
    }
  ]
}

Definitions

DatawarehouseRequest

Name	Type	Description
parameters	object	SQL Parameters with values
storedProcedureName	string	StoredProcedureName