Device Security
AIMS3 Attribute Reference
Table of Contents
Expand All
|
Collapse All
Device Security Docs
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.