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 fields they map to.
When Device Security integrates with AIMS3, it enriches 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.

Endpoint Attributes

Device Security collects endpoint attributes from AIMS3. The following table lists each AIMS3 attribute, its name as stored in Device Security, and the Device Security field it maps to (if applicable).
AIMS3 Attribute
Device Security Attribute Name
Device Security Common Attribute*
Description
purchaseCost
aims3.purchaseCost
Device Purchase Price
Purchase cost
replacementCost
aims3.replacementCost
Device Replacement Cost
Replacement cost
equipmentIPAddresses.address
aims3.IpAddress.address
IP Address
Address
equipmentMacAddresses.address
aims3.MAC_Address.address
MAC Address; id
Address
modelName
aims3.modelName
Model
Model name
ownershipID
aims3.ownershipID
owner_id
Ownership ID
assetNumber
aims3.assetNumber
—
Asset number
assignedVendorID
aims3.assignedVendorID
—
Assigned vendor ID
buildingID
aims3.buildingID
—
Building ID
conditionDateTime
aims3.conditionDateTime
—
Condition date time
costCenter.assignAllFacility
aims3.Cost_Center.assignAllFacility
—
Assign all facility
costCenter.city
aims3.Cost_Center.city
—
City
costCenter.code
aims3.Cost_Center.code
—
Code
costCenter.contact
aims3.Cost_Center.contact
—
Contact
costCenter.costCenterEquipmentLibrary
aims3.Cost_Center.costCenterEquipmentLibrary
—
Cost center equipment library
costCenter.costCenterFacility
aims3.Cost_Center.costCenterFacility
—
Cost center facility
costCenter.defaultBillableLabor
aims3.Cost_Center.defaultBillableLabor
—
Default billable labor
costCenter.defaultBillableMaterial
aims3.Cost_Center.defaultBillableMaterial
—
Default billable material
costCenter.defaultCostCenterRateID
aims3.Cost_Center.defaultCostCenterRateID
—
Default cost center rate ID
costCenter.easyNetActive
aims3.Cost_Center.easyNetActive
—
Easy net active
costCenter.email
aims3.Cost_Center.email
—
Email
costCenter.id
aims3.Cost_Center.id
—
Unique identifier
costCenter.isCostCenter
aims3.Cost_Center.isCostCenter
—
Is cost center
costCenter.isResponsibleCenter
aims3.Cost_Center.isResponsibleCenter
—
Is responsible center
costCenter.isWard
aims3.Cost_Center.isWard
—
Is ward
costCenter.name
aims3.Cost_Center.name
—
Name of the device
costCenter.noCharge
aims3.Cost_Center.noCharge
—
No charge
costCenter.phone
aims3.Cost_Center.phone
—
Phone
costCenter.phoneExt
aims3.Cost_Center.phoneExt
—
Phone ext
costCenter.pmBaseDate
aims3.Cost_Center.pmBaseDate
—
Pm base date
costCenter.state
aims3.Cost_Center.state
—
State
costCenter.taxRate
aims3.Cost_Center.taxRate
—
Tax rate
costCenter.workdayCompanyID
aims3.Cost_Center.workdayCompanyID
—
Workday company ID
costCenter.workdayReferenceID
aims3.Cost_Center.workdayReferenceID
—
Workday reference ID
costCenter.zip
aims3.Cost_Center.zip
—
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
employees
aims3.employees
—
Employees
equipmentType.code
aims3.Equipment_Type.code
—
Code
equipmentType.name
aims3.Equipment_Type.name
—
Name of the device
equipmentClassificationID
aims3.equipmentClassificationID
—
Equipment classification ID
equipmentConditionID
aims3.equipmentConditionID
—
Equipment condition ID
equipmentInformationServiceID
aims3.equipmentInformationServiceID
—
Equipment information service ID
equipmentLibrary
aims3.equipmentLibrary
—
Equipment library
equipmentStatusID
aims3.equipmentStatusID
—
Equipment status ID
equipmentTypeID
aims3.equipmentTypeID
—
Equipment type ID
estimatedPurchaseCost
aims3.estimatedPurchaseCost
—
Estimated purchase cost
facility.active
aims3.Facility.active
—
Active
facility.address1
aims3.Facility.address1
—
Address1
facility.address2
aims3.Facility.address2
—
Address2
facility.city
aims3.Facility.city
—
City
facility.code
aims3.Facility.code
—
Code
facility.contact
aims3.Facility.contact
—
Contact
facility.country
aims3.Facility.country
—
Country
facility.defaultBillableLabor
aims3.Facility.defaultBillableLabor
—
Default billable labor
facility.defaultBillableMaterials
aims3.Facility.defaultBillableMaterials
—
Default billable materials
facility.defaultWarehouseId
aims3.Facility.defaultWarehouseId
—
Default warehouse ID
facility.extension
aims3.Facility.extension
—
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
—
Unique identifier
facility.name
aims3.Facility.name
—
Name of the device
facility.numberOfBuildings
aims3.Facility.numberOfBuildings
—
Number of buildings
facility.numberOfEmployees
aims3.Facility.numberOfEmployees
—
Number of employees
facility.numberOfLicensedBeds
aims3.Facility.numberOfLicensedBeds
—
Number of licensed beds
facility.phone
aims3.Facility.phone
—
Phone
facility.regionID
aims3.Facility.regionID
—
Region ID
facility.sqFeetOfBuildings
aims3.Facility.sqFeetOfBuildings
—
Sq feet of buildings
facility.state
aims3.Facility.state
—
State
facility.taxRate
aims3.Facility.taxRate
—
Tax rate
facility.timeZone
aims3.Facility.timeZone
—
Time zone
facility.workdayLocationID
aims3.Facility.workdayLocationID
—
Workday location ID
facility.zip
aims3.Facility.zip
—
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
Information_Services
aims3.Information_Services
—
Information services
inServiceDate
aims3.inServiceDate
—
In service date
equipmentIPAddresses.equipmentID
aims3.IpAddress.equipmentID
—
Equipment ID
equipmentIPAddresses.id
aims3.IpAddress.id
—
Unique identifier
equipmentIPAddresses.wireless
aims3.IpAddress.wireless
—
Wireless
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
equipmentMacAddresses.equipmentID
aims3.MAC_Address.equipmentID
—
Equipment ID
equipmentMacAddresses.id
aims3.MAC_Address.id
—
Unique identifier
equipmentMacAddresses.wireless
aims3.MAC_Address.wireless
—
Wireless
manufacturedDate
aims3.manufacturedDate
—
Manufactured date
modelID
aims3.modelID
—
Model ID
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
parentEquipmentID
aims3.parentEquipmentID
—
Parent equipment ID
pmRequirement
aims3.pmRequirement
—
Pm requirement
poNumber
aims3.poNumber
—
Po number
purchaseDate
aims3.purchaseDate
—
Purchase date
purchasingDepartmentID
aims3.purchasingDepartmentID
—
Purchasing department ID
purchasingFacilityID
aims3.purchasingFacilityID
—
Purchasing facility ID
regionID
aims3.regionID
—
Region ID
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 ID
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
thursdayCloseTime
aims3.thursdayCloseTime
—
Thursday close time
thursdayOpenAllDay
aims3.thursdayOpenAllDay
—
Thursday open all day
thursdayOpenTime
aims3.thursdayOpenTime
—
Thursday open time
totalCount
aims3.totalCount
—
Number of totals
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
—
Active
vendor.code
aims3.Vendor.code
—
Code
vendor.defaultVendorContactID
aims3.Vendor.defaultVendorContactID
—
Default vendor contact ID
vendor.defaultVendorRateID
aims3.Vendor.defaultVendorRateID
—
Default vendor rate ID
vendor.equipmentSupplier
aims3.Vendor.equipmentSupplier
—
Equipment supplier
vendor.id
aims3.Vendor.id
—
Unique identifier
vendor.manufacturer
aims3.Vendor.manufacturer
—
Manufacturer of the device
vendor.minorityOwned
aims3.Vendor.minorityOwned
—
Minority owned
vendor.name
aims3.Vendor.name
—
Name of the device
vendor.nameplateManufacturer
aims3.Vendor.nameplateManufacturer
—
Nameplate manufacturer
vendor.notes
aims3.Vendor.notes
—
Notes
vendor.partSupplier
aims3.Vendor.partSupplier
—
Part supplier
vendor.serviceProvider
aims3.Vendor.serviceProvider
—
Service provider
vendor.supplierNumber
aims3.Vendor.supplierNumber
—
Supplier number
vendor.warrantyProvider
aims3.Vendor.warrantyProvider
—
Warranty provider
vendor.workdayActive
aims3.Vendor.workdayActive
—
Workday active
vendor.workdayCode
aims3.Vendor.workdayCode
—
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.