Megosztás a következőn keresztül:


Data - Retrieve Datawarehouse Details

Lekéri az adattárház adatait a tárolt eljárás neve alapján.

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

Kérelem törzse

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

Name Típus Description
parameters

object

SQL-paraméterek értékekkel

storedProcedureName

string

StoredProcedureName

Válaszok

Name Típus Description
200 OK

object

Oké. A DatawareHouse adatainak lekérése sikerült.

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

Példák

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

Definíciók

DatawarehouseRequest

Name Típus Description
parameters

object

SQL-paraméterek értékekkel

storedProcedureName

string

StoredProcedureName