SPHealthReportCreationData constructor (String, String, Boolean, Boolean, Boolean, Boolean, Boolean, List<String>)

Initializes a new instance of the SPHealthReportCreationData class based on the name of the report, an SQL query that is a stored procedure with specified parameters, and a list of columns.

Namespace:  Microsoft.SharePoint.Administration
Assembly:  Microsoft.SharePoint (in Microsoft.SharePoint.dll)

Syntax

'Declaration
Public Sub New ( _
    name As String, _
    sql As String, _
    isStoreProcedure As Boolean, _
    supportSelectWebApplication As Boolean, _
    supportLogTime As Boolean, _
    supportMachineName As Boolean, _
    supportMaxRows As Boolean, _
    columnNames As List(Of String) _
)
'Usage
Dim name As String
Dim sql As String
Dim isStoreProcedure As Boolean
Dim supportSelectWebApplication As Boolean
Dim supportLogTime As Boolean
Dim supportMachineName As Boolean
Dim supportMaxRows As Boolean
Dim columnNames As List(Of String)

Dim instance As New SPHealthReportCreationData(name, sql, _
    isStoreProcedure, supportSelectWebApplication, _
    supportLogTime, supportMachineName, _
    supportMaxRows, columnNames)

public SPHealthReportCreationData(
    string name,
    string sql,
    bool isStoreProcedure,
    bool supportSelectWebApplication,
    bool supportLogTime,
    bool supportMachineName,
    bool supportMaxRows,
    List<string> columnNames
)

Parameters

• name
  Type: System.String

  The name of the report.

• sql
  Type: System.String

  The SQL query.

• isStoreProcedure
  Type: System.Boolean

  true if the query is a stored procedure; otherwise, false.

• supportSelectWebApplication
  Type: System.Boolean

  true if the query supports the @WebApplicationId parameter, where WebApplicationId is a GUID that identifies the Web application.

• supportLogTime
  Type: System.Boolean

  true if the query supports @StartTime and @EndTime parameters that indicate the time range of the log.

• supportMachineName
  Type: System.Boolean

  true if the query supports the @MachineName parameter that indicates a server in the farm.

• supportMaxRows
  Type: System.Boolean

  true if the query supports the @MaxRows parameter that indicates the maximum number of rows to return.

• columnNames
  Type: System.Collections.Generic.List<String>

  A list of column names.

See also

Reference

SPHealthReportCreationData class

SPHealthReportCreationData members

SPHealthReportCreationData overload

Microsoft.SharePoint.Administration namespace