ImportedTDSSourceComputer Table

The ImportedTDSSourceComputer table holds source/ingest computer properties imported from TDS. At the moment, only Flexera Inventory/NDI data source type is stored in this table.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for ImportedTDSSourceComputer table

Database Column

Details

ExternalID

Type: big integer. Key

The identifier used in the source connection for the computer. This can be used to join with ImportedComputer/ImportedTDSComputer.

SourceResourceID

Type: text (max 512 characters). Key

Identifier of the ingest/source computer (Flexera Inventory/NDI) in TDS.

LastProcessedForDeletion

Type: datetime. Nullable

When FNMS last processed this record for deletion in TDS.

CreationDate

Type: datetime

Date and time (UTC) when the record was created.