Appendix A- Template Details for CAL Usage Inventory Upload

FlexNet Manager Suite 2023 R1 (On-Premises)

You can import CAL usage inventory through spreadsheet imports when you cannot collect access evidence for the accessed server applications. You can schedule regular inventory imports through the FlexNet Beacon, or you can use the Inventory Data One-Off Uploads feature (see Data Inputs in the online help) to upload CAL usage inventory spreadsheet. For more information on inventory uploads, see the Importing Inventory Spreadsheets and CSV Files chapter of this guide.

To upload CAL usage inventory, the spreadsheet template should be populated with at least all mandatory (Required) columns, and uploaded to FlexNet Manager Suite. The following table describes the columns of the CAL Usage Inventory spreadsheet template, accessible through the Inventory Data One-Off Upload page:

Column	Description	Mandatory
AccessCount	The number of times that the server application was accessed.	No
AccessDate	The date on which the server application was accessed.	No
AccessingDeviceComputerName	The ComputerName of the accessing device (through which the server application was accessed).	No, if AccessingUser is specified.
AccessingDeviceDomain	The domain name of the accessing device.	No
AccessingDeviceIPAddress	The IP address of the accessing device.	No, if AccessingUser is specified.
AccessingDeviceSerialNo	The serial number of the accessing device.	No
AccessingUser	The DOMAIN/SAMAccountName for the accessing user.	No, if AccessingDeviceIPAddress or AccessingDeviceComputerName is specified.
ComputerID	The ComputerID of the accessed device (where the server application has been installed). It must match the ComputerID specified for this device in the Computer spreadsheet, or the row will be ignored. Uploading the Computer spreadsheet is mandatory with the CAL inventory upload.	Yes
Edition	The edition of the accessed server application as reported by the access evidence. This data is not used for access recognition.	No
InventoryDate	Inventory date of the evidence. If not provided, defaults to the current Coordinated Universal Time (UTC).	No
ProductName	The product name of the accessed application as reported by the access evidence. For all supported server applications except Microsoft Endpoint Configuration Manager (previously Microsoft SCCM), the Version and Edition (if present) is included in the ProductName. For example, Microsoft SharePoint Server 2013 Enterprise Preview	Yes
Version	The version of the accessed server application as reported by the access evidence. Note: This column should be populated only for Microsoft Endpoint Configuration Manager (previously Microsoft SCCM).	No