Delen via


Data - Retrieve Datawarehouse Details

Hiermee worden gegevens van het datawarehouse opgehaald op basis van de naam van de opgeslagen procedure.

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

Aanvraagbody

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

Name Type Description
parameters

object

SQL-parameters met waarden

storedProcedureName

string

StoredProcedureName

Antwoorden

Name Type Description
200 OK

object

OK. DatawareHouse-gegevens zijn opgehaald.

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

Voorbeelden

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

Definities

DatawarehouseRequest

Name Type Description
parameters

object

SQL-parameters met waarden

storedProcedureName

string

StoredProcedureName