AIMS3 Attribute Reference
Focus
Focus
Device Security

AIMS3 Attribute Reference

Table of Contents

AIMS3 Attribute Reference

This reference lists the attributes that Device Security collects from AIMS3, their names as stored in Device Security, and the Device Security device fields they map to.
Device Security integrates with AIMS3 to enrich the device inventory with attributes from AIMS3-managed assets. The attributes in this reference cover device identification, network details, and hardware information collected from AIMS3 device records.
The third-party attribute name in Device Security refers to the attribute name as it appears in the Assets Inventory table and in Query Engine. This follows the format of third-party-name.attribute-name. When viewing the attribute name in the Assets Inventory table column selector or on a Device Details page, where the third-party name can be found as a header for the attributes section, then the third-party name is removed from the attribute name.
For example, micrsoft_defender_xdr.macAddress would appear in the Query Builder and in the Assets Inventory table, but under Device DetailsAttributesIntegration Specific AttributesMicrosoft Defender, the attribute would appear as macAddress.

Device Attributes

Device Security collects device attributes from the AIMS3 endpoint details API. The following table lists each AIMS3 attribute, its name as stored in Device Security, the Device Security device field it maps to (if applicable), and a description.
AIMS3 Attribute
Device Security Attribute Name
Device Security Common Attribute*
Description
assetNumber
aims3.assetNumber
Asset number of the device in AIMS3
assignedVendorID
aims3.assignedVendorID
Assigned vendor ID
buildingID
aims3.buildingID
Building ID
conditionDateTime
aims3.conditionDateTime
Condition date time
costCenter.assignAllFacility
aims3.Cost_Center.assignAllFacility
Cost center assign all facility
costCenter.city
aims3.Cost_Center.city
Cost center city
costCenter.code
aims3.Cost_Center.code
Cost center code
costCenter.contact
aims3.Cost_Center.contact
Cost center contact
costCenter.costCenterEquipmentLibrary
aims3.Cost_Center.costCenterEquipmentLibrary
Cost center equipment library
costCenter.costCenterFacility
aims3.Cost_Center.costCenterFacility
Cost center cost center facility
costCenter.defaultBillableLabor
aims3.Cost_Center.defaultBillableLabor
Cost center default billable labor
costCenter.defaultBillableMaterial
aims3.Cost_Center.defaultBillableMaterial
Cost center default billable material
costCenter.defaultCostCenterRateID
aims3.Cost_Center.defaultCostCenterRateID
Cost center default cost center rate ID
costCenter.easyNetActive
aims3.Cost_Center.easyNetActive
Cost center easy net active
costCenter.email
aims3.Cost_Center.email
Cost center email
costCenter.id
aims3.Cost_Center.id
Cost center ID
costCenter.isCostCenter
aims3.Cost_Center.isCostCenter
Cost center is cost center
costCenter.isResponsibleCenter
aims3.Cost_Center.isResponsibleCenter
Cost center is responsible center
costCenter.isWard
aims3.Cost_Center.isWard
Cost center is ward
costCenter.name
aims3.Cost_Center.name
Cost center name
costCenter.noCharge
aims3.Cost_Center.noCharge
Cost center no charge
costCenter.phone
aims3.Cost_Center.phone
Cost center phone
costCenter.phoneExt
aims3.Cost_Center.phoneExt
Cost center phone ext
costCenter.pmBaseDate
aims3.Cost_Center.pmBaseDate
Cost center pm base date
costCenter.state
aims3.Cost_Center.state
Cost center state
costCenter.taxRate
aims3.Cost_Center.taxRate
Cost center tax rate
costCenter.workdayCompanyID
aims3.Cost_Center.workdayCompanyID
Cost center workday company ID
costCenter.workdayReferenceID
aims3.Cost_Center.workdayReferenceID
Cost center workday reference ID
costCenter.zip
aims3.Cost_Center.zip
Cost center zip
costCenterID
aims3.costCenterID
Cost center ID
critical
aims3.critical
Critical
defaultAttachmentID
aims3.defaultAttachmentID
Default attachment ID
defaultAttachmentTable
aims3.defaultAttachmentTable
Default attachment table
depreciatedLife
aims3.depreciatedLife
Depreciated life
description
aims3.description
Description associated with the device in AIMS3
employees
aims3.employees
Employees
equipmentClassificationID
aims3.equipmentClassificationID
Equipment classification ID
equipmentConditionID
aims3.equipmentConditionID
Equipment condition ID
equipmentInformationServiceID
aims3.equipmentInformationServiceID
Equipment information service ID
equipmentIPAddresses.address
aims3.IpAddress.address
ipv4_address
Equipment IP addresses address
equipmentIPAddresses.equipmentID
aims3.IpAddress.equipmentID
Equipment IP addresses equipment ID
equipmentIPAddresses.id
aims3.IpAddress.id
Equipment IP addresses id
equipmentIPAddresses.wireless
aims3.IpAddress.wireless
Equipment IP addresses wireless
equipmentLibrary
aims3.equipmentLibrary
Equipment library
equipmentMacAddresses.address
aims3.MAC_Address.address
MAC; id
Equipment MAC addresses address
equipmentMacAddresses.equipmentID
aims3.MAC_Address.equipmentID
Equipment MAC addresses equipment ID
equipmentMacAddresses.id
aims3.MAC_Address.id
Equipment MAC addresses ID
equipmentMacAddresses.wireless
aims3.MAC_Address.wireless
Equipment MAC addresses wireless
equipmentStatusID
aims3.equipmentStatusID
Equipment status ID
equipmentType.code
aims3.Equipment_Type.code
Equipment type code
equipmentType.name
aims3.Equipment_Type.name
Equipment type name
equipmentTypeID
aims3.equipmentTypeID
Equipment type ID
estimatedPurchaseCost
aims3.estimatedPurchaseCost
Estimated purchase cost
facility.active
aims3.Facility.active
Facility active
facility.address1
aims3.Facility.address1
Facility address line 1
facility.address2
aims3.Facility.address2
Facility address line 2
facility.city
aims3.Facility.city
Facility city
facility.code
aims3.Facility.code
Facility code
facility.contact
aims3.Facility.contact
Facility contact
facility.country
aims3.Facility.country
Facility country
facility.defaultBillableLabor
aims3.Facility.defaultBillableLabor
Facility default billable labor
facility.defaultBillableMaterials
aims3.Facility.defaultBillableMaterials
Facility default billable materials
facility.defaultWarehouseId
aims3.Facility.defaultWarehouseId
Facility default warehouse ID
facility.extension
aims3.Facility.extension
Facility extension
facility.facilityGeSettingsID
aims3.Facility.facilityGeSettingsID
Facility GE settings ID
facility.facilityPartsSourceSettingsID
aims3.Facility.facilityPartsSourceSettingsID
Facility parts source settings ID
Facility.facilityReportGroup
aims3.Facility.facilityReportGroup
Facility report group
facility.facilitySterisSettingsID
aims3.Facility.facilitySterisSettingsID
Facility Steris settings ID
facility.id
aims3.Facility.id
Facility ID
facility.name
aims3.Facility.name
Facility name
facility.numberOfBuildings
aims3.Facility.numberOfBuildings
Facility number of buildings
facility.numberOfEmployees
aims3.Facility.numberOfEmployees
Facility number of employees
facility.numberOfLicensedBeds
aims3.Facility.numberOfLicensedBeds
Facility number of licensed beds
facility.phone
aims3.Facility.phone
Facility phone
facility.regionID
aims3.Facility.regionID
Facility region ID
facility.sqFeetOfBuildings
aims3.Facility.sqFeetOfBuildings
Facility sq feet of buildings
facility.state
aims3.Facility.state
Facility state
facility.taxRate
aims3.Facility.taxRate
Facility tax rate
facility.timeZone
aims3.Facility.timeZone
Facility time zone
facility.workdayLocationID
aims3.Facility.workdayLocationID
Facility workday location ID
facility.zip
aims3.Facility.zip
Facility zip
facilityID
aims3.facilityID
Facility ID
fridayCloseTime
aims3.fridayCloseTime
Friday close time
fridayOpenAllDay
aims3.fridayOpenAllDay
Friday open all day
fridayOpenTime
aims3.fridayOpenTime
Friday open time
id
aims3.id
Unique identifier for the device in AIMS3
Information_Services
aims3.Information_Services
Information services
inServiceDate
aims3.inServiceDate
In-service date
lastMeter
aims3.lastMeter
Last meter
lineItemNumber
aims3.lineItemNumber
Line item number
location1ID
aims3.location1ID
Location1 ID
location2ID
aims3.location2ID
Location2 ID
location3ID
aims3.location3ID
Location3 ID
location4ID
aims3.location4ID
Location4 ID
location5ID
aims3.location5ID
Location5 ID
locationDateTime
aims3.locationDateTime
Location date time
locationDetails
aims3.locationDetails
Location details
manufacturedDate
aims3.manufacturedDate
Manufactured date
modelID
aims3.modelID
Model ID
modelName
aims3.modelName
Model
Model name of the device
mondayCloseTime
aims3.mondayCloseTime
Monday close time
mondayOpenAllDay
aims3.mondayOpenAllDay
Monday open all day
mondayOpenTime
aims3.mondayOpenTime
Monday open time
nameplateVendorID
aims3.nameplateVendorID
Nameplate vendor ID
ownershipID
aims3.ownershipID
owner_id
Ownership identifier for the device in AIMS3
parentEquipmentID
aims3.parentEquipmentID
Parent Equipment ID
pmRequirement
aims3.pmRequirement
PM requirement
poNumber
aims3.poNumber
PO number
purchaseCost
aims3.purchaseCost
device_purchase_price
Purchase cost of the device
purchaseDate
aims3.purchaseDate
Purchase date
purchasingDepartmentID
aims3.purchasingDepartmentID
Purchasing department ID
purchasingFacilityID
aims3.purchasingFacilityID
Purchasing facility ID
regionID
aims3.regionID
Region ID
replacementCost
aims3.replacementCost
device_replacement_cost
Replacement cost of the device
replacementDate
aims3.replacementDate
Replacement date
responsibleCenterID
aims3.responsibleCenterID
Responsible center ID
riskClassificationID
aims3.riskClassificationID
Risk classification ID
riskTypeID
aims3.riskTypeID
Risk type ID
salvageDate
aims3.salvageDate
Salvage date
salvageValue
aims3.salvageValue
Salvage value
saturdayCloseTime
aims3.saturdayCloseTime
Saturday close time
saturdayOpenAllDay
aims3.saturdayOpenAllDay
Saturday open all day
saturdayOpenTime
aims3.saturdayOpenTime
Saturday open time
serial
aims3.serial
Serial number of the device
serviceDepartments
aims3.serviceDepartments
Service departments
siteID
aims3.siteID
Site identifier
statusDateTime
aims3.statusDateTime
Status date time
sundayCloseTime
aims3.sundayCloseTime
Sunday close time
sundayOpenAllDay
aims3.sundayOpenAllDay
Sunday open all day
sundayOpenTime
aims3.sundayOpenTime
Sunday open time
supplierID
aims3.supplierID
Supplier ID
tagNumber
aims3.tagNumber
Tag number assigned to the device
thursdayCloseTime
aims3.thursdayCloseTime
Thursday close time
thursdayOpenAllDay
aims3.thursdayOpenAllDay
Thursday open all day
thursdayOpenTime
aims3.thursdayOpenTime
Thursday open time
totalCount
aims3.totalCount
Total count
totalRisk
aims3.totalRisk
Total risk
trades
aims3.trades
Trades
tuesdayCloseTime
aims3.tuesdayCloseTime
Tuesday close time
tuesdayOpenAllDay
aims3.tuesdayOpenAllDay
Tuesday open all day
tuesdayOpenTime
aims3.tuesdayOpenTime
Tuesday open time
usefulLife
aims3.usefulLife
Useful life
Vendor.active
aims3.Vendor.active
Vendor active
vendor.code
aims3.Vendor.code
Vendor code
vendor.defaultVendorContactID
aims3.Vendor.defaultVendorContactID
Vendor default vendor contact ID
vendor.defaultVendorRateID
aims3.Vendor.defaultVendorRateID
Vendor default vendor rate ID
vendor.equipmentSupplier
aims3.Vendor.equipmentSupplier
Vendor equipment supplier
vendor.id
aims3.Vendor.id
Vendor ID
vendor.manufacturer
aims3.Vendor.manufacturer
Vendor manufacturer
vendor.minorityOwned
aims3.Vendor.minorityOwned
Vendor minority owned
vendor.name
aims3.Vendor.name
Vendor name
vendor.nameplateManufacturer
aims3.Vendor.nameplateManufacturer
Vendor nameplate manufacturer
vendor.notes
aims3.Vendor.notes
Vendor notes
vendor.partSupplier
aims3.Vendor.partSupplier
Vendor part supplier
vendor.serviceProvider
aims3.Vendor.serviceProvider
Vendor service provider
vendor.supplierNumber
aims3.Vendor.supplierNumber
Vendor supplier number
vendor.warrantyProvider
aims3.Vendor.warrantyProvider
Vendor warranty provider
vendor.workdayActive
aims3.Vendor.workdayActive
Vendor Workday active
vendor.workdayCode
aims3.Vendor.workdayCode
Vendor workday code
vendorID
aims3.vendorID
Vendor ID
wednesdayCloseTime
aims3.wednesdayCloseTime
Wednesday close time
wednesdayOpenAllDay
aims3.wednesdayOpenAllDay
Wednesday open all day
wednesdayOpenTime
aims3.wednesdayOpenTime
Wednesday open time
* Only some attributes map to a Device Security Common Attribute.