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.
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.

Aimsv3 Api Get Endpoint Details Attributes

Device Security collects aimsv3 api get endpoint details 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
PurchaseCost
replacementCost
aims3.replacementCost
Device Replacement Cost
ReplacementCost
equipmentIPAddresses.address
aims3.IpAddress.address
IP Address
Address
equipmentMacAddresses.address
aims3.MAC_Address.address
MAC; id
Address
modelName
aims3.modelName
Model
ModelName
ownershipID
aims3.ownershipID
owner_id
OwnershipID
assetNumber
aims3.assetNumber
AssetNumber
assignedVendorID
aims3.assignedVendorID
AssignedVendorID
buildingID
aims3.buildingID
BuildingID
conditionDateTime
aims3.conditionDateTime
ConditionDateTime
costCenter.assignAllFacility
aims3.Cost_Center.assignAllFacility
AssignAllFacility
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
CostCenterEquipmentLibrary
costCenter.costCenterFacility
aims3.Cost_Center.costCenterFacility
CostCenterFacility
costCenter.defaultBillableLabor
aims3.Cost_Center.defaultBillableLabor
DefaultBillableLabor
costCenter.defaultBillableMaterial
aims3.Cost_Center.defaultBillableMaterial
DefaultBillableMaterial
costCenter.defaultCostCenterRateID
aims3.Cost_Center.defaultCostCenterRateID
DefaultCostCenterRateID
costCenter.easyNetActive
aims3.Cost_Center.easyNetActive
EasyNetActive
costCenter.email
aims3.Cost_Center.email
Email
costCenter.id
aims3.Cost_Center.id
Id
costCenter.isCostCenter
aims3.Cost_Center.isCostCenter
IsCostCenter
costCenter.isResponsibleCenter
aims3.Cost_Center.isResponsibleCenter
IsResponsibleCenter
costCenter.isWard
aims3.Cost_Center.isWard
IsWard
costCenter.name
aims3.Cost_Center.name
Name of the device
costCenter.noCharge
aims3.Cost_Center.noCharge
NoCharge
costCenter.phone
aims3.Cost_Center.phone
Phone
costCenter.phoneExt
aims3.Cost_Center.phoneExt
PhoneExt
costCenter.pmBaseDate
aims3.Cost_Center.pmBaseDate
PmBaseDate
costCenter.state
aims3.Cost_Center.state
State
costCenter.taxRate
aims3.Cost_Center.taxRate
TaxRate
costCenter.workdayCompanyID
aims3.Cost_Center.workdayCompanyID
WorkdayCompanyID
costCenter.workdayReferenceID
aims3.Cost_Center.workdayReferenceID
WorkdayReferenceID
costCenter.zip
aims3.Cost_Center.zip
Zip
costCenterID
aims3.costCenterID
CostCenterID
critical
aims3.critical
Critical
defaultAttachmentID
aims3.defaultAttachmentID
DefaultAttachmentID
defaultAttachmentTable
aims3.defaultAttachmentTable
DefaultAttachmentTable
depreciatedLife
aims3.depreciatedLife
DepreciatedLife
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
EquipmentClassificationID
equipmentConditionID
aims3.equipmentConditionID
EquipmentConditionID
equipmentInformationServiceID
aims3.equipmentInformationServiceID
EquipmentInformationServiceID
equipmentLibrary
aims3.equipmentLibrary
EquipmentLibrary
equipmentStatusID
aims3.equipmentStatusID
EquipmentStatusID
equipmentTypeID
aims3.equipmentTypeID
EquipmentTypeID
estimatedPurchaseCost
aims3.estimatedPurchaseCost
EstimatedPurchaseCost
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
DefaultBillableLabor
facility.defaultBillableMaterials
aims3.Facility.defaultBillableMaterials
DefaultBillableMaterials
facility.defaultWarehouseId
aims3.Facility.defaultWarehouseId
DefaultWarehouseId
facility.extension
aims3.Facility.extension
Extension
facility.facilityGeSettingsID
aims3.Facility.facilityGeSettingsID
FacilityGeSettingsID
facility.facilityPartsSourceSettingsID
aims3.Facility.facilityPartsSourceSettingsID
FacilityPartsSourceSettingsID
Facility.facilityReportGroup
aims3.Facility.facilityReportGroup
FacilityReportGroup
facility.facilitySterisSettingsID
aims3.Facility.facilitySterisSettingsID
FacilitySterisSettingsID
facility.id
aims3.Facility.id
Id
facility.name
aims3.Facility.name
Name of the device
facility.numberOfBuildings
aims3.Facility.numberOfBuildings
NumberOfBuildings
facility.numberOfEmployees
aims3.Facility.numberOfEmployees
NumberOfEmployees
facility.numberOfLicensedBeds
aims3.Facility.numberOfLicensedBeds
NumberOfLicensedBeds
facility.phone
aims3.Facility.phone
Phone
facility.regionID
aims3.Facility.regionID
RegionID
facility.sqFeetOfBuildings
aims3.Facility.sqFeetOfBuildings
SqFeetOfBuildings
facility.state
aims3.Facility.state
State
facility.taxRate
aims3.Facility.taxRate
TaxRate
facility.timeZone
aims3.Facility.timeZone
TimeZone
facility.workdayLocationID
aims3.Facility.workdayLocationID
WorkdayLocationID
facility.zip
aims3.Facility.zip
Zip
facilityID
aims3.facilityID
FacilityID
fridayCloseTime
aims3.fridayCloseTime
FridayCloseTime
fridayOpenAllDay
aims3.fridayOpenAllDay
FridayOpenAllDay
fridayOpenTime
aims3.fridayOpenTime
FridayOpenTime
id
aims3.id
Id
Information_Services
aims3.Information_Services
Information Services
inServiceDate
aims3.inServiceDate
InServiceDate
equipmentIPAddresses.equipmentID
aims3.IpAddress.equipmentID
EquipmentID
equipmentIPAddresses.id
aims3.IpAddress.id
Id
equipmentIPAddresses.wireless
aims3.IpAddress.wireless
Wireless
lastMeter
aims3.lastMeter
LastMeter
lineItemNumber
aims3.lineItemNumber
LineItemNumber
location1ID
aims3.location1ID
Location1ID
location2ID
aims3.location2ID
Location2ID
location3ID
aims3.location3ID
Location3ID
location4ID
aims3.location4ID
Location4ID
location5ID
aims3.location5ID
Location5ID
locationDateTime
aims3.locationDateTime
LocationDateTime
locationDetails
aims3.locationDetails
LocationDetails
equipmentMacAddresses.equipmentID
aims3.MAC_Address.equipmentID
EquipmentID
equipmentMacAddresses.id
aims3.MAC_Address.id
Id
equipmentMacAddresses.wireless
aims3.MAC_Address.wireless
Wireless
manufacturedDate
aims3.manufacturedDate
ManufacturedDate
modelID
aims3.modelID
ModelID
mondayCloseTime
aims3.mondayCloseTime
MondayCloseTime
mondayOpenAllDay
aims3.mondayOpenAllDay
MondayOpenAllDay
mondayOpenTime
aims3.mondayOpenTime
MondayOpenTime
nameplateVendorID
aims3.nameplateVendorID
NameplateVendorID
parentEquipmentID
aims3.parentEquipmentID
ParentEquipmentID
pmRequirement
aims3.pmRequirement
PmRequirement
poNumber
aims3.poNumber
PoNumber
purchaseDate
aims3.purchaseDate
PurchaseDate
purchasingDepartmentID
aims3.purchasingDepartmentID
PurchasingDepartmentID
purchasingFacilityID
aims3.purchasingFacilityID
PurchasingFacilityID
regionID
aims3.regionID
RegionID
replacementDate
aims3.replacementDate
ReplacementDate
responsibleCenterID
aims3.responsibleCenterID
ResponsibleCenterID
riskClassificationID
aims3.riskClassificationID
RiskClassificationID
riskTypeID
aims3.riskTypeID
RiskTypeID
salvageDate
aims3.salvageDate
SalvageDate
salvageValue
aims3.salvageValue
SalvageValue
saturdayCloseTime
aims3.saturdayCloseTime
SaturdayCloseTime
saturdayOpenAllDay
aims3.saturdayOpenAllDay
SaturdayOpenAllDay
saturdayOpenTime
aims3.saturdayOpenTime
SaturdayOpenTime
serial
aims3.serial
Serial number of the device
serviceDepartments
aims3.serviceDepartments
ServiceDepartments
siteID
aims3.siteID
SiteID
statusDateTime
aims3.statusDateTime
StatusDateTime
sundayCloseTime
aims3.sundayCloseTime
SundayCloseTime
sundayOpenAllDay
aims3.sundayOpenAllDay
SundayOpenAllDay
sundayOpenTime
aims3.sundayOpenTime
SundayOpenTime
supplierID
aims3.supplierID
SupplierID
tagNumber
aims3.tagNumber
TagNumber
thursdayCloseTime
aims3.thursdayCloseTime
ThursdayCloseTime
thursdayOpenAllDay
aims3.thursdayOpenAllDay
ThursdayOpenAllDay
thursdayOpenTime
aims3.thursdayOpenTime
ThursdayOpenTime
totalCount
aims3.totalCount
TotalCount
totalRisk
aims3.totalRisk
TotalRisk
trades
aims3.trades
Trades
tuesdayCloseTime
aims3.tuesdayCloseTime
TuesdayCloseTime
tuesdayOpenAllDay
aims3.tuesdayOpenAllDay
TuesdayOpenAllDay
tuesdayOpenTime
aims3.tuesdayOpenTime
TuesdayOpenTime
usefulLife
aims3.usefulLife
UsefulLife
Vendor.active
aims3.Vendor.active
Active
vendor.code
aims3.Vendor.code
Code
vendor.defaultVendorContactID
aims3.Vendor.defaultVendorContactID
DefaultVendorContactID
vendor.defaultVendorRateID
aims3.Vendor.defaultVendorRateID
DefaultVendorRateID
vendor.equipmentSupplier
aims3.Vendor.equipmentSupplier
EquipmentSupplier
vendor.id
aims3.Vendor.id
Id
vendor.manufacturer
aims3.Vendor.manufacturer
Manufacturer of the device
vendor.minorityOwned
aims3.Vendor.minorityOwned
MinorityOwned
vendor.name
aims3.Vendor.name
Name of the device
vendor.nameplateManufacturer
aims3.Vendor.nameplateManufacturer
NameplateManufacturer
vendor.notes
aims3.Vendor.notes
Notes
vendor.partSupplier
aims3.Vendor.partSupplier
PartSupplier
vendor.serviceProvider
aims3.Vendor.serviceProvider
ServiceProvider
vendor.supplierNumber
aims3.Vendor.supplierNumber
SupplierNumber
vendor.warrantyProvider
aims3.Vendor.warrantyProvider
WarrantyProvider
vendor.workdayActive
aims3.Vendor.workdayActive
WorkdayActive
vendor.workdayCode
aims3.Vendor.workdayCode
WorkdayCode
vendorID
aims3.vendorID
VendorID
wednesdayCloseTime
aims3.wednesdayCloseTime
WednesdayCloseTime
wednesdayOpenAllDay
aims3.wednesdayOpenAllDay
WednesdayOpenAllDay
wednesdayOpenTime
aims3.wednesdayOpenTime
WednesdayOpenTime
* Only some attributes map to a Device Security Common Attribute.