Partager via

SqlAssessmentExtensions.GetAssessmentResults Method

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Assessment
Assembly:
Microsoft.SqlServer.Management.Assessment.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

Overloads

GetAssessmentResults(SqlSmoObject, String[])

Synchronously runs assessment for given smoObject and gives a IEnumerable<T> describing discovered issues.
GetAssessmentResults(SqlSmoObject, IEnumerable<ICheck>)

Synchronously runs assessment for given smoObject and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResults(Server, String[])

Synchronously runs assessment for given server and gives a IEnumerable<T> describing discovered issues.
GetAssessmentResults(FileGroup, String[])

Synchronously runs assessment for given fileGroup and gives a IEnumerable<T> describing discovered issues.
GetAssessmentResults(Server, IEnumerable<ICheck>)

Synchronously runs assessment for given server and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResults(Database, String[])

Synchronously runs assessment for given database and gives a IEnumerable<T> describing discovered issues.
GetAssessmentResults(Database, IEnumerable<ICheck>)

Synchronously runs assessment for given database and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResults(AvailabilityGroup, String[])

Synchronously runs assessment for given availabilityGroup and gives a IEnumerable<T> describing discovered issues.
GetAssessmentResults(AvailabilityGroup, IEnumerable<ICheck>)

Synchronously runs assessment for given availabilityGroup and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.
GetAssessmentResults(FileGroup, IEnumerable<ICheck>)

Synchronously runs assessment for given fileGroup and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

GetAssessmentResults(SqlSmoObject, String[])

Synchronously runs assessment for given smoObject and gives a IEnumerable<T> describing discovered issues.

public static System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.IAssessmentResult> GetAssessmentResults (this Microsoft.SqlServer.Management.Smo.SqlSmoObject smoObject, params string[] checkIdsOrTags);
static member GetAssessmentResults : Microsoft.SqlServer.Management.Smo.SqlSmoObject * string[] -> seq<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>
<Extension()>
Public Function GetAssessmentResults (smoObject As SqlSmoObject, ParamArray checkIdsOrTags As String()) As IEnumerable(Of IAssessmentResult)

Parameters

smoObject
SqlSmoObject

Target SqlSmoObject.

checkIdsOrTags
String[]

Optional array of String check ids or tags to perform only selected checks.

Returns

IEnumerable<IAssessmentResult>

Returns an IEnumerable<T> for target SqlSmoObject. Returns an empty IEnumerable<T> if no issues detected.

Applies to

GetAssessmentResults(SqlSmoObject, IEnumerable<ICheck>)

Synchronously runs assessment for given smoObject and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

public static System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.IAssessmentResult> GetAssessmentResults (this Microsoft.SqlServer.Management.Smo.SqlSmoObject smoObject, System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> checks);
static member GetAssessmentResults : Microsoft.SqlServer.Management.Smo.SqlSmoObject * seq<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> -> seq<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>
<Extension()>
Public Function GetAssessmentResults (smoObject As SqlSmoObject, checks As IEnumerable(Of ICheck)) As IEnumerable(Of IAssessmentResult)

Parameters

smoObject
SqlSmoObject

Target SqlSmoObject.

checks
IEnumerable<ICheck>

Optional IEnumerable<T> to perform only selected checks.

Returns

IEnumerable<IAssessmentResult>

Returns an IEnumerable<T> for target SqlSmoObject. Returns an empty IEnumerable<T> if no issues detected.

Applies to

GetAssessmentResults(Server, String[])

Synchronously runs assessment for given server and gives a IEnumerable<T> describing discovered issues.

public static System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.IAssessmentResult> GetAssessmentResults (this Microsoft.SqlServer.Management.Smo.Server server, params string[] checkIdsOrTags);
static member GetAssessmentResults : Microsoft.SqlServer.Management.Smo.Server * string[] -> seq<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>
<Extension()>
Public Function GetAssessmentResults (server As Server, ParamArray checkIdsOrTags As String()) As IEnumerable(Of IAssessmentResult)

Parameters

server
Server

Target Server.

checkIdsOrTags
String[]

Optional array of String check ids or tags to perform only selected checks.

Returns

IEnumerable<IAssessmentResult>

Returns an IEnumerable<T> for target SqlSmoObject. Returns an empty IEnumerable<T> if no issues detected.

Applies to

GetAssessmentResults(FileGroup, String[])

Synchronously runs assessment for given fileGroup and gives a IEnumerable<T> describing discovered issues.

public static System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.IAssessmentResult> GetAssessmentResults (this Microsoft.SqlServer.Management.Smo.FileGroup fileGroup, params string[] checkIdsOrTags);
static member GetAssessmentResults : Microsoft.SqlServer.Management.Smo.FileGroup * string[] -> seq<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>
<Extension()>
Public Function GetAssessmentResults (fileGroup As FileGroup, ParamArray checkIdsOrTags As String()) As IEnumerable(Of IAssessmentResult)

Parameters

fileGroup
FileGroup

Target FileGroup.

checkIdsOrTags
String[]

Optional array of String check ids or tags to perform only selected checks.

Returns

IEnumerable<IAssessmentResult>

Returns an IEnumerable<T> for target SqlSmoObject. Returns an empty IEnumerable<T> if no issues detected.

Applies to

GetAssessmentResults(Server, IEnumerable<ICheck>)

Synchronously runs assessment for given server and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

public static System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.IAssessmentResult> GetAssessmentResults (this Microsoft.SqlServer.Management.Smo.Server server, System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> checks);
static member GetAssessmentResults : Microsoft.SqlServer.Management.Smo.Server * seq<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> -> seq<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>
<Extension()>
Public Function GetAssessmentResults (server As Server, checks As IEnumerable(Of ICheck)) As IEnumerable(Of IAssessmentResult)

Parameters

server
Server

Target Server.

checks
IEnumerable<ICheck>

Optional IEnumerable<T> to perform only selected checks.

Returns

IEnumerable<IAssessmentResult>

Returns an IEnumerable<T> for target SqlSmoObject. Returns an empty IEnumerable<T> if no issues detected.

Applies to

GetAssessmentResults(Database, String[])

Synchronously runs assessment for given database and gives a IEnumerable<T> describing discovered issues.

public static System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.IAssessmentResult> GetAssessmentResults (this Microsoft.SqlServer.Management.Smo.Database database, params string[] checkIdsOrTags);
static member GetAssessmentResults : Microsoft.SqlServer.Management.Smo.Database * string[] -> seq<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>
<Extension()>
Public Function GetAssessmentResults (database As Database, ParamArray checkIdsOrTags As String()) As IEnumerable(Of IAssessmentResult)

Parameters

database
Database

Target Database.

checkIdsOrTags
String[]

Optional array of String check ids or tags to perform only selected checks.

Returns

IEnumerable<IAssessmentResult>

Returns an IEnumerable<T> for target SqlSmoObject. Returns an empty IEnumerable<T> if no issues detected.

Applies to

GetAssessmentResults(Database, IEnumerable<ICheck>)

Synchronously runs assessment for given database and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

public static System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.IAssessmentResult> GetAssessmentResults (this Microsoft.SqlServer.Management.Smo.Database database, System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> checks);
static member GetAssessmentResults : Microsoft.SqlServer.Management.Smo.Database * seq<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> -> seq<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>
<Extension()>
Public Function GetAssessmentResults (database As Database, checks As IEnumerable(Of ICheck)) As IEnumerable(Of IAssessmentResult)

Parameters

database
Database

Target Database.

checks
IEnumerable<ICheck>

Optional IEnumerable<T> to perform only selected checks.

Returns

IEnumerable<IAssessmentResult>

Returns an IEnumerable<T> for target SqlSmoObject. Returns an empty IEnumerable<T> if no issues detected.

Applies to

GetAssessmentResults(AvailabilityGroup, String[])

Synchronously runs assessment for given availabilityGroup and gives a IEnumerable<T> describing discovered issues.

public static System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.IAssessmentResult> GetAssessmentResults (this Microsoft.SqlServer.Management.Smo.AvailabilityGroup availabilityGroup, params string[] checkIdsOrTags);
static member GetAssessmentResults : Microsoft.SqlServer.Management.Smo.AvailabilityGroup * string[] -> seq<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>
<Extension()>
Public Function GetAssessmentResults (availabilityGroup As AvailabilityGroup, ParamArray checkIdsOrTags As String()) As IEnumerable(Of IAssessmentResult)

Parameters

availabilityGroup
AvailabilityGroup

Target AvailabilityGroup.

checkIdsOrTags
String[]

Optional array of String check ids or tags to perform only selected checks.

Returns

IEnumerable<IAssessmentResult>

Returns an IEnumerable<T> for target SqlSmoObject. Returns an empty IEnumerable<T> if no issues detected.

Applies to

GetAssessmentResults(AvailabilityGroup, IEnumerable<ICheck>)

Synchronously runs assessment for given availabilityGroup and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

public static System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.IAssessmentResult> GetAssessmentResults (this Microsoft.SqlServer.Management.Smo.AvailabilityGroup availabilityGroup, System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> checks);
static member GetAssessmentResults : Microsoft.SqlServer.Management.Smo.AvailabilityGroup * seq<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> -> seq<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>
<Extension()>
Public Function GetAssessmentResults (availabilityGroup As AvailabilityGroup, checks As IEnumerable(Of ICheck)) As IEnumerable(Of IAssessmentResult)

Parameters

availabilityGroup
AvailabilityGroup

Target AvailabilityGroup.

checks
IEnumerable<ICheck>

Optional IEnumerable<T> to perform only selected checks.

Returns

IEnumerable<IAssessmentResult>

Returns an IEnumerable<T> for target SqlSmoObject. Returns an empty IEnumerable<T> if no issues detected.

Applies to

GetAssessmentResults(FileGroup, IEnumerable<ICheck>)

Synchronously runs assessment for given fileGroup and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

public static System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.IAssessmentResult> GetAssessmentResults (this Microsoft.SqlServer.Management.Smo.FileGroup fileGroup, System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> checks);
static member GetAssessmentResults : Microsoft.SqlServer.Management.Smo.FileGroup * seq<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> -> seq<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>
<Extension()>
Public Function GetAssessmentResults (fileGroup As FileGroup, checks As IEnumerable(Of ICheck)) As IEnumerable(Of IAssessmentResult)

Parameters

fileGroup
FileGroup

Target FileGroup.

checks
IEnumerable<ICheck>

Optional IEnumerable<T> to perform only selected checks.

Returns

IEnumerable<IAssessmentResult>

Returns an IEnumerable<T> for target SqlSmoObject. Returns an empty IEnumerable<T> if no issues detected.

Applies to