Table of Contents

Class DatabaseInfo

Namespace
Geotab.Checkmate.ObjectModel.Web
Assembly
Geotab.Checkmate.ObjectModel.dll

Information about the performance of a hosted database.

public class DatabaseInfo
Inheritance
DatabaseInfo
Inherited Members

Constructors

DatabaseInfo() 

public DatabaseInfo()

Properties

BadFileCount

Gets or sets the bad file count.

public int BadFileCount { get; set; }

Property Value

int

The bad file count.

BadFileSizeKb

Gets or sets the bad file size.

public int BadFileSizeKb { get; set; }

Property Value

int

The bad file size.

BillableDeviceCount

Gets or sets the billable device count.

public int BillableDeviceCount { get; set; }

Property Value

int

The billable device count.

Comment

Gets or sets the comment.

public string? Comment { get; set; }

Property Value

string

The comment.

CompanyGuid

Gets or sets the company unique identifier.

public Guid CompanyGuid { get; set; }

Property Value

Guid

The company unique identifier.

CpuSeconds

Gets or sets the cpu time / total time ratio - based load factor as percent.

public double CpuSeconds { get; set; }

Property Value

double

The cpu seconds.

CustomCode

Gets or sets the custom codes to report.

public string? CustomCode { get; set; }

Property Value

string

The custom code string for a database.

DataSizeKB

Gets or sets the data size KB.

public long DataSizeKB { get; set; }

Property Value

long

The data size KB.

DatabaseLocation

Gets or sets the Country and City of the database.

public string? DatabaseLocation { get; set; }

Property Value

string

The Country/City string.

DemoExpiryDate

Gets or sets the demo database expiry date.

public DateTime? DemoExpiryDate { get; set; }

Property Value

DateTime?

DateTime

FailedDatabaseServices

Gets or sets the FailedDatabaseServices Names.

public IEnumerable<string>? FailedDatabaseServices { get; set; }

Property Value

IEnumerable<string>

The FailedDatabaseServices Names.

FailedDatabaseServicesCount

Gets or sets the Failed DatabaseServices Count.

public int FailedDatabaseServicesCount { get; set; }

Property Value

int

The Failed DatabaseServices Count.

FuelCustomerIds

Gets or sets the fuel customer identifiers.

public IList<string>? FuelCustomerIds { get; set; }

Property Value

IList<string>

The fuel customer identifiers.

GeocoderType

Gets or sets the geocoder type.

public string? GeocoderType { get; set; }

Property Value

string

string

IsBad

Gets or sets a value indicating whether this database instance is bad (unreachable).

public bool IsBad { get; set; }

Property Value

bool

&lt;c&gt;true&lt;/c&gt; if this instance is bad; otherwise, &lt;c&gt;false&lt;/c &gt;.

LagTime

Gets or sets the lag time of the uploader in ms.

public TimeSpan LagTime { get; set; }

Property Value

TimeSpan

TimeSpan

LastActivityDateTime

Gets or sets the last activity date.

public DateTime? LastActivityDateTime { get; set; }

Property Value

DateTime?

The last activity DateTime .

LastGPSDateTime

Gets or sets the last GPS date time.

public DateTime? LastGPSDateTime { get; set; }

Property Value

DateTime?

The last GPS date time.

LoadFactor

Gets or sets the load factor.

public double LoadFactor { get; set; }

Property Value

double

The load factor.

ManualProcessFileCount

Gets or sets the manualProcess file count.

public int ManualProcessFileCount { get; set; }

Property Value

int

The bad file count.

ManualProcessFileSizeKb

Gets or sets the manualProcess file size.

public int ManualProcessFileSizeKb { get; set; }

Property Value

int

The bad file size.

MapProvider

Gets or sets the map provider.

public string? MapProvider { get; set; }

Property Value

string

string

MyGActiveConnectionPool

Gets or sets the Active number of MyGeotab connections in the pool.

public int MyGActiveConnectionPool { get; set; }

Property Value

int

The Active number of MyGeotab connections in the pool.

MyGConnectionPool

Gets or sets the total number of MyGeotab connections in the pool.

public int MyGConnectionPool { get; set; }

Property Value

int

The total number of MyGeotab connections in the pool.

MyGMaxConnectionPool

Gets or sets the max number of MyGeotab connections in the pool.

public int MyGMaxConnectionPool { get; set; }

Property Value

int

The max number of MyGeotab connections in the pool.

Name

Gets or sets the name.

public string? Name { get; set; }

Property Value

string

The name.

ProcessingStatus

Gets or sets the processing status.

public ProcessingStatus ProcessingStatus { get; set; }

Property Value

ProcessingStatus

TimeSpan

ServerName

Gets or sets the server name.

[JsonIgnore]
public string? ServerName { get; set; }

Property Value

string

The server name.

SqlType

Gets or sets the database provider.

public string? SqlType { get; set; }

Property Value

string

The database provider.

StatusDataCacheFileCount

Gets or sets the StatusData cache file count.

public int StatusDataCacheFileCount { get; set; }

Property Value

int

The StatusData cache file count.

StatusDataCacheFileSizeKb

Gets or sets the StatusData cache file size.

public int StatusDataCacheFileSizeKb { get; set; }

Property Value

int

The TXT StatusData cache size.

TxtFileCount

Gets or sets the TXT file count.

public int TxtFileCount { get; set; }

Property Value

int

The TXT file count.

TxtFileSizeKb

Gets or sets the TXT file size.

public int TxtFileSizeKb { get; set; }

Property Value

int

The TXT file size.

Methods

GetComponents()

Get components for the database.

public Dictionary<DatabaseInfoComponent, object>? GetComponents()

Returns

Dictionary<DatabaseInfoComponent, object>

component dictionary

GetTotalTimeInSeconds()

Gets total time in seconds.

public double GetTotalTimeInSeconds()

Returns

double

Total time in seconds.

SetComponent(DatabaseInfoComponent, object)

Set the components.

public void SetComponent(DatabaseInfoComponent key, object value)

Parameters

key DatabaseInfoComponent

The key.

value object

The value.