Partilhar via


Data - Retrieve Datawarehouse Details

Recupera dados do armazém de dados com base no nome do procedimento armazenado.

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

Corpo do Pedido

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

Name Tipo Description
parameters

object

Parâmetros SQL com valores

storedProcedureName

string

Nome de Reserva DeProcedure Armazenado

Respostas

Name Tipo Description
200 OK

object

Ok. Recuperou com sucesso os detalhes do DatawareHouse.

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

Exemplos

GetDataFromDW

Sample Request

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

Sample Response

{
  "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
    }
  ]
}

Definições

DatawarehouseRequest

Name Tipo Description
parameters

object

Parâmetros SQL com valores

storedProcedureName

string

Nome de Reserva DeProcedure Armazenado