ConsolidatedAccessEvidence Template

FlexNet Manager Suite (Cloud)

ConsolidatedAccessEvidence provides a simpler interface to specify client access happening on application installed on server computers. It combines the server computer, and its access evidence details into a single row.

Table 1. Columns included with ConsolidatedAccessEvidence templates

Column

Details

ComputerID

Type: big integer. Key

The identifier used in the source connection for the computer. It must match the ComputerID from the Computer spreadsheet or the row will be ignored.

Destination:

ImportedClientAccessedAccessEvidence.ImportedClient AccessedAccessEvidenceID

ImportedClientAccessedAccessEvidence.ExternalServer ComputerID

ImportedClientAccessedAccessOccurrence.ImportedClient AccessedAccessEvidenceID

ProductName

Type: text (max 256 characters). Key

The product name of the software as reported by the access evidence.

Destination:

ImportedClientAccessEvidence.ExternalAccessEvidenceID

ImportedClientAccessEvidence.ProductName

ImportedClientAccessedAccessEvidence.ImportedClient AccessedAccessEvidenceID

ImportedClientAccessedAccessEvidence.ExternalAccess EvidenceID

ImportedClientAccessedAccessOccurrence.ImportedClient AccessedAccessEvidenceID

Version

Type: text (max 72 characters). Key. Nullable

The version of the software as reported by the access evidence.

Destination:

ImportedClientAccessEvidence.ExternalAccessEvidenceID

ImportedClientAccessEvidence.Version

ImportedClientAccessedAccessEvidence.ImportedClient AccessedAccessEvidenceID

ImportedClientAccessedAccessEvidence.ExternalAccess EvidenceID

ImportedClientAccessedAccessOccurrence.ImportedClient AccessedAccessEvidenceID

Edition

Type: text (max 50 characters). Key. Nullable

The edition of the software as reported by the access evidence.

Destination:

ImportedClientAccessEvidence.ExternalAccessEvidenceID

ImportedClientAccessEvidence.Edition

ImportedClientAccessedAccessEvidence.ImportedClient AccessedAccessEvidenceID

ImportedClientAccessedAccessEvidence.ExternalAccess EvidenceID

ImportedClientAccessedAccessOccurrence.ImportedClient AccessedAccessEvidenceID

AccessingDeviceIPAddress

Type: text (max 256 characters). Key. Nullable

IP Address of the accessing device.

Destination:

ImportedAccessingDevice.ExternalAccessingDeviceID

ImportedAccessingDevice.IPAddress

ImportedClientAccessedAccessEvidence.ImportedClient AccessedAccessEvidenceID

ImportedClientAccessedAccessEvidence.ExternalAccessing DeviceID

ImportedClientAccessedAccessOccurrence.ImportedClient AccessedAccessEvidenceID

AccessingDevice ComputerName

Type: text (max 256 characters). Key. Nullable

IP Address of the device accessing the product.

Destination:

ImportedAccessingDevice.ExternalAccessingDeviceID

ImportedAccessingDevice.ComputerName

ImportedClientAccessedAccessEvidence.ImportedClient AccessedAccessEvidenceID

ImportedClientAccessedAccessEvidence.ExternalAccessing DeviceID

ImportedClientAccessedAccessOccurrence.ImportedClient AccessedAccessEvidenceID

AccessingDeviceSerialNo

Type: text (max 100 characters). Nullable

Serial number of the device accessing the product.

Destination:

ImportedAccessingDevice.SerialNo

AccessingDeviceDomain

Type: text (max 100 characters). Key. Nullable

Domain name of the device accessing the product.

Destination:

ImportedAccessingDevice.ExternalAccessingDeviceID

ImportedAccessingDevice.Domain

ImportedClientAccessedAccessEvidence.ImportedClient AccessedAccessEvidenceID

ImportedClientAccessedAccessEvidence.ExternalAccessing DeviceID

ImportedClientAccessedAccessOccurrence.ImportedClient AccessedAccessEvidenceID

AccessingUser

Type: text (max 128 characters). Key. Nullable

The DOMAIN/SAMAccountName of the user accessing the product.

Destination:

ImportedAccessingUser.ExternalAccessingUserID

ImportedAccessingUser.UserName (Element 2 after splitting on '\')

ImportedAccessingUser.DomainName (Element 1 after splitting on '\')

ImportedClientAccessedAccessEvidence.ImportedClient AccessedAccessEvidenceID

ImportedClientAccessedAccessEvidence.ExternalAccessingUserID

ImportedClientAccessedAccessOccurrence.ImportedClient AccessedAccessEvidenceID

AccessDate

Type: datetime. Key. Nullable

The date that the product was accessed. The date must be specified in the following format: ‘yyyyMMdd’.

Possible values:

  • yyyy/MM/dd
  • yyyy/MM/dd HH:mm:Ss
  • yyyy/MM/dd HH:mm
  • yyyy-MM-dd
  • yyyy-MM-dd HH:mm:Ss
  • yyyy-MM-dd HH:mm
  • yyyyMMdd
  • yyyyMMdd HH:mm:Ss
  • yyyyMMdd HH:mm

Destination:

ImportedClientAccessedAccessOccurrence.AccessDate

ImportedClientAccessedAccessOccurrence.LicenseDate

AccessCount

Type: integer. Nullable

Number of times the product was accessed on the given access date.

Destination:

ImportedClientAccessedAccessOccurrence.AccessCount

InventoryDate

Type: datetime. Nullable

The date (and optionally time) the access evidence record was inventoried.

Possible values:

  • yyyy/MM/dd
  • yyyy/MM/dd HH:mm:Ss
  • yyyy/MM/dd HH:mm
  • yyyy-MM-dd
  • yyyy-MM-dd HH:mm:Ss
  • yyyy-MM-dd HH:mm
  • yyyyMMdd
  • yyyyMMdd HH:mm:Ss
  • yyyyMMdd HH:mm

Destination:

ImportedClientAccessedAccessOccurrence.InventoryDate

ClientAccessSource

Type: text (max 100 characters). Nullable

The source type of the access evidence.

Destination:

ImportedClientAccessedAccessEvidence.ClientAccessSource

FlexNet Manager Suite (Cloud)

Current