Compartir a través de


SqlAssessmentExtensions.GetAssessmentResultsList Method

Definition

Overloads

GetAssessmentResultsList(SqlSmoObject, IEnumerable<ICheck>)

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

GetAssessmentResultsList(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.

GetAssessmentResultsList(AvailabilityGroup, String[])

Asynchronously runs assessment for given availabilityGroup and gives a List<T> describing discovered issues.

GetAssessmentResultsList(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.

GetAssessmentResultsList(Database, String[])

Asynchronously runs assessment for given database and gives a List<T> describing discovered issues.

GetAssessmentResultsList(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.

GetAssessmentResultsList(FileGroup, String[])

Asynchronously runs assessment for given fileGroup and gives a List<T> describing discovered issues.

GetAssessmentResultsList(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.

GetAssessmentResultsList(Server, String[])

Asynchronously runs assessment for given server and gives a List<T> describing discovered issues.

GetAssessmentResultsList(SqlSmoObject, String[])

Asynchronously runs assessment for given smoObject and gives a List<T> describing discovered issues.

GetAssessmentResultsList(SqlSmoObject, IEnumerable<ICheck>)

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

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

Parameters

smoObject
SqlSmoObject

Target SqlSmoObject.

checks
IEnumerable<ICheck>

Optional IEnumerable<T> to perform only selected checks.

Returns

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

Applies to

GetAssessmentResultsList(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.Threading.Tasks.Task<System.Collections.Generic.List<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>> GetAssessmentResultsList (this Microsoft.SqlServer.Management.Smo.AvailabilityGroup availabilityGroup, System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> checks);
static member GetAssessmentResultsList : Microsoft.SqlServer.Management.Smo.AvailabilityGroup * seq<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> -> System.Threading.Tasks.Task<System.Collections.Generic.List<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>>
<Extension()>
Public Function GetAssessmentResultsList (availabilityGroup As AvailabilityGroup, checks As IEnumerable(Of ICheck)) As Task(Of List(Of IAssessmentResult))

Parameters

availabilityGroup
AvailabilityGroup

Target AvailabilityGroup.

checks
IEnumerable<ICheck>

Optional IEnumerable<T> to perform only selected checks.

Returns

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

Applies to

GetAssessmentResultsList(AvailabilityGroup, String[])

Asynchronously runs assessment for given availabilityGroup and gives a List<T> describing discovered issues.

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

Parameters

availabilityGroup
AvailabilityGroup

Target AvailabilityGroup.

checkIdsOrTags
String[]

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

Returns

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

Applies to

GetAssessmentResultsList(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.Threading.Tasks.Task<System.Collections.Generic.List<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>> GetAssessmentResultsList (this Microsoft.SqlServer.Management.Smo.Database database, System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> checks);
static member GetAssessmentResultsList : Microsoft.SqlServer.Management.Smo.Database * seq<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> -> System.Threading.Tasks.Task<System.Collections.Generic.List<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>>
<Extension()>
Public Function GetAssessmentResultsList (database As Database, checks As IEnumerable(Of ICheck)) As Task(Of List(Of IAssessmentResult))

Parameters

database
Database

Target Database.

checks
IEnumerable<ICheck>

Optional IEnumerable<T> to perform only selected checks.

Returns

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

Applies to

GetAssessmentResultsList(Database, String[])

Asynchronously runs assessment for given database and gives a List<T> describing discovered issues.

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

Parameters

database
Database

Target Database.

checkIdsOrTags
String[]

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

Returns

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

Applies to

GetAssessmentResultsList(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.Threading.Tasks.Task<System.Collections.Generic.List<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>> GetAssessmentResultsList (this Microsoft.SqlServer.Management.Smo.FileGroup fileGroup, System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> checks);
static member GetAssessmentResultsList : Microsoft.SqlServer.Management.Smo.FileGroup * seq<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> -> System.Threading.Tasks.Task<System.Collections.Generic.List<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>>
<Extension()>
Public Function GetAssessmentResultsList (fileGroup As FileGroup, checks As IEnumerable(Of ICheck)) As Task(Of List(Of IAssessmentResult))

Parameters

fileGroup
FileGroup

Target FileGroup.

checks
IEnumerable<ICheck>

Optional IEnumerable<T> to perform only selected checks.

Returns

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

Applies to

GetAssessmentResultsList(FileGroup, String[])

Asynchronously runs assessment for given fileGroup and gives a List<T> describing discovered issues.

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

Parameters

fileGroup
FileGroup

Target FileGroup.

checkIdsOrTags
String[]

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

Returns

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

Applies to

GetAssessmentResultsList(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.Threading.Tasks.Task<System.Collections.Generic.List<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>> GetAssessmentResultsList (this Microsoft.SqlServer.Management.Smo.Server server, System.Collections.Generic.IEnumerable<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> checks);
static member GetAssessmentResultsList : Microsoft.SqlServer.Management.Smo.Server * seq<Microsoft.SqlServer.Management.Assessment.Checks.ICheck> -> System.Threading.Tasks.Task<System.Collections.Generic.List<Microsoft.SqlServer.Management.Assessment.IAssessmentResult>>
<Extension()>
Public Function GetAssessmentResultsList (server As Server, checks As IEnumerable(Of ICheck)) As Task(Of List(Of IAssessmentResult))

Parameters

server
Server

Target Server.

checks
IEnumerable<ICheck>

Optional IEnumerable<T> to perform only selected checks.

Returns

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

Applies to

GetAssessmentResultsList(Server, String[])

Asynchronously runs assessment for given server and gives a List<T> describing discovered issues.

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

Parameters

server
Server

Target Server.

checkIdsOrTags
String[]

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

Returns

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

Applies to

GetAssessmentResultsList(SqlSmoObject, String[])

Asynchronously runs assessment for given smoObject and gives a List<T> describing discovered issues.

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

Parameters

smoObject
SqlSmoObject

Target SqlSmoObject.

checkIdsOrTags
String[]

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

Returns

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

Applies to