Dela via

Data - Retrieve Datawarehouse Details

  • Referens
Tjänst:
Operations Manager
API-version:
v1

Hämtar information om informationslagret baserat på namnet på den lagrade proceduren.

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

Begärandetext

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

Name Typ Description
parameters

object

SQL-parametrar med värden
storedProcedureName

string

StoredProcedureName

Svar

Name Typ Description
200 OK

object

OKEJ. DatawareHouse-information har hämtats.

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

Exempel

GetDataFromDW

Exempelbegäran

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

Exempelsvar

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

Definitioner

DatawarehouseRequest

Objekt
Name Typ Description
parameters

object

SQL-parametrar med värden
storedProcedureName

string

StoredProcedureName