ConsolidatedAccessEvidence Template

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`