Class SqlInstanceHostInformation

Namespace

CENTREL.XIA.Configuration.Types

Assembly

CENTREL.XIA.Configuration.Types.dll

Represents the host information for a SQL instance. This only applies to on-premises installations of SQL Server.

public class SqlInstanceHostInformation : BaseTypeSection, IComparable<SqlInstanceHostInformation>

Inheritance

object

BaseTypeSection

SqlInstanceHostInformation

Implements

IComparable<SqlInstanceHostInformation>

Constructors

SqlInstanceHostInformation()

Initializes a new instance of the CENTREL.XIA.Configuration.Types.SqlInstanceHostInformation class.

public SqlInstanceHostInformation()

Properties

ComputerFqdn

Gets or sets the fully qualified host name of the server.

public string ComputerFqdn { get; set; }

Property Value

string

Identifier

Gets or sets the unique identifier of the host. This is for internal system use only.

public Guid Identifier { get; set; }

Property Value

Guid

InstanceID

Gets or sets the SQL instance ID for the host.

public string InstanceID { get; set; }

Property Value

string

IsDomainController

Gets or sets whether the host is a domain controller.

public BooleanOption IsDomainController { get; set; }

Property Value

BooleanOption

IsServer

Gets or sets whether the host operating system is a server operating system.

public BooleanOption IsServer { get; set; }

Property Value

BooleanOption

IsServerCore

Gets or sets whether the host operating system is a core operating system.

public BooleanOption IsServerCore { get; set; }

Property Value

BooleanOption

Manufacturer

Gets or sets the manufacturer of the server.

public string Manufacturer { get; set; }

Property Value

string

Model

Gets or sets the model of the server.

public string Model { get; set; }

Property Value

string

Name

Gets or sets the NetBIOS name of the server.

public string Name { get; set; }

Property Value

string

Network

Gets or sets the SQL network configuration for the host.

public SqlInstanceHostNetworkConfiguration Network { get; set; }

Property Value

SqlInstanceHostNetworkConfiguration

OperatingSystemName

Gets or sets the operating system name - for example "Microsoft Windows Server 2012 R2 Datacenter".

public string OperatingSystemName { get; set; }

Property Value

string

Processors

Gets or sets the names of the processors installed on the remote machine - for example "Intel(R) Core(TM) i7-3537U CPU @ 2.00GHz".

public SerializableStringCollection Processors { get; set; }

Property Value

SerializableStringCollection

RebootPending

Gets or sets whether a reboot was pending at the time of the scan.

public BooleanOption RebootPending { get; set; }

Property Value

BooleanOption

SerialNumber

Gets or sets the serial number of the server.

public string SerialNumber { get; set; }

Property Value

string

ServerFunctions

Gets or sets the server functions detected for the server. This only applies to Windows Server 2012 and above.

public WindowsServerFunctions ServerFunctions { get; set; }

Property Value

WindowsServerFunctions

ServicePack

Gets or sets the service version of this server - for example "Service Pack 1".

public string ServicePack { get; set; }

Property Value

string

ServicePackString

Gets the service pack version of this server as a human readable string - for example "Service Pack 1", "[None Installed]" or "Unknown".

public string ServicePackString { get; set; }

Property Value

string

SqlServerAgentService

Gets or sets the SQL Server Agent service configuration.

public SqlInstanceHostSqlServerAgentServiceConfiguration SqlServerAgentService { get; set; }

Property Value

SqlInstanceHostSqlServerAgentServiceConfiguration

SqlServerBrowserService

Gets or sets the SQL Server Browser service configuration.

public SqlInstanceHostSqlServerBrowserServiceConfiguration SqlServerBrowserService { get; set; }

Property Value

SqlInstanceHostSqlServerBrowserServiceConfiguration

SqlServerFullTextSearchService

Gets or sets the SQL Server Full-Text Search service configuration.

public SqlInstanceHostSqlServerFullTextSearchServiceConfiguration SqlServerFullTextSearchService { get; set; }

Property Value

SqlInstanceHostSqlServerFullTextSearchServiceConfiguration

SqlServerService

Gets or sets the SQL Server service configuration.

public SqlInstanceHostSqlServerServiceConfiguration SqlServerService { get; set; }

Property Value

SqlInstanceHostSqlServerServiceConfiguration

SqlServerTelemetryService

Gets or sets the SQL Server telemetry (CEIP) service configuration.

public SqlInstanceHostSqlServerTelemetryServiceConfiguration SqlServerTelemetryService { get; set; }

Property Value

SqlInstanceHostSqlServerTelemetryServiceConfiguration

WindowsDirectory

Gets or sets the Windows directory path - for example "C:\Windows".

public string WindowsDirectory { get; set; }

Property Value

string

WindowsVersion

Gets or sets the Windows version of the host.

public WindowsOperatingSystemVersion WindowsVersion { get; set; }

Property Value

WindowsOperatingSystemVersion

Methods

CompareTo(SqlInstanceHostInformation)

Compares two CENTREL.XIA.Configuration.Types.SqlInstanceHostInformation objects to allow sorting alphabetically by name.

public int CompareTo(SqlInstanceHostInformation other)

Parameters

other SqlInstanceHostInformation

The CENTREL.XIA.Configuration.Types.SqlInstanceHostInformation to compare to.

Returns

int

The sort order of the two CENTREL.XIA.Configuration.Types.SqlInstanceHostInformation objects.

ToString()

Returns the host information as a human readable string.

public override string ToString()

Returns

string

The host information as a human readable string.