Device42 data imported into Assets

The data collected from Device42 is assembled and imported into Assets and looks like this in Assets:

Object Schema Tree:

Password

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Username	TEXT
Password Label	TEXT
Category	TEXT
Password Storage	TEXT
Devices	Object - Device		"Id" IN (${Device${0}})
Last Password Change	DATE_TIME
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})
View Users	Object - User		"Name" IN (${View Users${0}})
View Groups	Object - Group		"Name" IN (${View Groups${0}})
Use Only Users	Object - User		"Name" IN (${Use Only Users${0}})
Use Only Groups	Object - Group		"Name" IN (${Use Only Groups${0}})
View edit users	Object - User		"Name" IN (${View edit users${0}})
View edit groups	Object - Group		"Name" IN (${View edit groups${0}})

User

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Auth Type	TEXT
Email	TEXT
Superuser status	BOOLEAN
Groups	Object - Group		"Name" IN (${Group${0}})

Group

Attribute	Default Type	Default Identifier	Unique	Description	AQL
Id	TEXT			Identifier of the object.
Name	TEXT			Name of the object.

Service Level

Attribute	Default Type	Default Identifier	Unique	Description	AQL
Id	TEXT			Identifier of the object.
Name	TEXT			Name of the object.

Lifecycle Event

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Date	DATE_TIME
Device	Object - Device		"Name" = ${Device}
Asset	Object - Asset		"Name" = ${Asset}
End User	Object - End User		"Name" = ${End User}
Notes	TEXTAREA

Custom Field

Attribute	Default Type	Description
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Value	TEXTAREA

QR Profile

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Base URL	TEXT
Code Type	TEXT
Print DPI	TEXT
Include Text	BOOLEAN
Include Name in Text	BOOLEAN
Include Asset # in Text	BOOLEAN
Include Location Text	BOOLEAN
Include Device Model in QR Code	BOOLEAN
Include Serial Number in QR Code	BOOLEAN
Include Hostname in QR Code	BOOLEAN
Include Location in QR Code	BOOLEAN
Device custom fields to include in QR Code	Object - Custom Field		"Name" IN (${Device custom fields to include in QR Code${0}})
Asset custom fields to include in QR Code	Object - Custom Field		"Name" IN (${Asset custom fields to include in QR Code${0}})
Custom Text for QR Label Profile	TEXTAREA

Building

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Address	TEXTAREA
Latitude	DOUBLE
Longitude	DOUBLE
Contact Name	TEXT
Contact Phone	TEXT
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Room

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Building	Object - Building	Building where the room belongs to.	"Name" = ${Building}
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Rack

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Size	INTEGER
Orientation	TEXT
Numbering start from bottom	BOOLEAN
First number	INTEGER
Number between U's	BOOLEAN
Row	INTEGER
Column size	DOUBLE
Row size	DOUBLE
Rack middle option	TEXT
Available units	DOUBLE
Building	Object - Building	Building where the rack belongs to.	"Name" = ${Building}
Room	Object - Room	Room where the rack belongs to.	"Name" = ${Room}
Asset number	TEXT
Manufacturer	Object - Vendor	Manufacturer of the rack	"Name" = ${Vendor}
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Power Unit

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Power Unit Model	Object - Power Unit Model		"Id" = ${Power Unit Model}
Category	Object - Object Category		"Name" = ${Category}
Building	Object - Building	Building where the power unit belongs to.	"Id" = ${Building}
Room	Object - Room	Room where the power unit belongs to.	"Id" = ${Room}
Rack	Object - Rack	Rack where the power unit is mounted to.	"Id" = ${Rack}
Device	Object - Device		"Id" = ${Device}
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Power Unit Model

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Type	TEXT
Size	DOUBLE
Depth	TEXT
Width Ratio	INTEGER
Vendor	Object - Vendor	Vendor of the Power Unit Model.	"Name" = ${Vendor}
Description	TEXT
Port count	INTEGER
PDU Ports	Object - PDU Port		"Id" IN (${PDU Port${0}})

PDU Port

Attribute	Default Type	Description
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Port Type	TEXT

Vendor

Attribute	Default Type	Description
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Account Number	TEXT
Home Page	TEXT
Contact Info	TEXT
Escalation 1	TEXT
Escalation 2	TEXT
Aliases	TEXTAREA

Hardware Model

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Type	TEXT
Size	DOUBLE
Depth	TEXT
Width Ratio	INTEGER
Part Number	TEXT
Watts	INTEGER
Blade Chassis	BOOLEAN
Network Device	BOOLEAN
Add Ports when creating devices	BOOLEAN
Specification URL	TEXT
Vendor	Object - Vendor	Vendor of the Hardware Model.	"Name" = ${Vendor}
End of support date	DATE
End of life date	DATE
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Part

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Last updated	DATE_TIME
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Part Model	Object - Part Model		"Id" = ${Part Model}
Count	INTEGER
Slot	INTEGER
Firmware Version	TEXT
Serial Number	TEXT
Asset number	TEXT
Assignment	TEXT
Room	Object - Room		"Name" = ${Room}
Device	Object - Device		"Id" = ${Device}
Rack	Object - Rack		"Name" = ${Rack}
Date Changed	DATE_TIME
Description	TEXTAREA
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Part Model

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Type	TEXT
Description	TEXT
Connectivity	TEXT
Media Type	TEXT
Connector Type	TEXT
Length	TEXT
Model Number	TEXT
Part Number	TEXT
Location	TEXT
Manufacturer	Object - Vendor	Manufacturer of the part model	"Name" = ${Vendor}
Port Prefix	TEXT
Port Template	TEXT
Total available	INTEGER
In Storage Rooms	INTEGER
In Storage Racks	INTEGER
Total in use	INTEGER
Checked Out to Devices	INTEGER
In RMA	INTEGER
In Transit	INTEGER
Total count	INTEGER
Cores/CPU	INTEGER
Threads	INTEGER
CPU Speed	DOUBLE
HD Type	TEXT
HD size	DOUBLE
HD RPM	INTEGER
RAM Type	TEXT
RAM Size	INTEGER
RAM Speed	INTEGER
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Customer

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Manager	TEXT
Contact Info	TEXT
Contacts	Object - Contact	List of all contacts that belongs to this customer.	"Id" IN (${Contact${0}})
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Contact

Attribute	Default Type	Description
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Type	TEXT
Email	TEXT
Phone	TEXT
Address	TEXTAREA

End User

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Email	TEXT
Contact Info	TEXT
Location	TEXT
Full qualified username	TEXT
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Purchase

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Vendor	Object - Vendor		"Name" = ${Vendor}
Cost Center	TEXT
Customer	Object - Customer		"Name" = ${Customer}
PO Date	DATE
Building	Object - Building		"Name" = ${Building}
Cost	DOUBLE
Total cot for non-recurring line items	DOUBLE
Order Completed	BOOLEAN
Line Items	Object - Line Item	List of all line items that belongs to this purchase.	"Id" IN (${Line Item${0}})
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Line Item

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Completed	BOOLEAN
Line Number	TEXT
Line Type	TEXT
Item Type	TEXT
Quantity	INTEGER
Unit cost	DOUBLE
Cost Center	TEXT
Customer	Object - Customer		"Name" = ${Customer}
Devices	Object - Device	List of all devices that belongs to this line item.	"Id" IN (${Device${0}})
Racks	Object - Rack	List of all racks that belongs to this line item.	"Id" IN (${Rack${0}})
Assets	Object - Asset	List of all assets that belongs to this line item.	"Id" IN (${Asset${0}})
Operating System In Use	Object - Operating System In Use	List of all device operating systems that belongs to this line item.	"Name" IN (${Operating System In Use${0}})

Cable

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Room	Object - Room		"Name" = ${Room}
Vendor	Object - Vendor		"Name" = ${Vendor}
Origin Type	TEXT
Origin Cable	Object - Cable		"Id" = ${Origin Cable}
Origin Switch Port	Object - Switch Port		"Id" = ${Origin Switch Port}
Origin Patch Panel	Object - Asset		"Name" = ${Origin Patch Panel}
Origin Back of patch panel	BOOLEAN
Origin Cable Type	TEXT
Origin Optic Type	TEXT
Origin Connector Type	TEXT
Origin Cable Color	TEXT
End Point Type	TEXT
End Point Cable	Object - Cable		"Id" = ${End Point Cable}
End Point Switch Port	Object - Switch Port		"Id" = ${End Point Switch Port}
End Point Patch Panel	Object - Asset		"Name" = ${End Point Patch Panel}
End Point Back of patch panel	BOOLEAN
Allow multiple cable endpoints	BOOLEAN
End Cable	TEXT
End Optic Type	TEXT
End Connector Type	TEXT
End Cable Color	TEXT
Cable Length	DOUBLE
Cable Length Units	TEXT
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Telco Circuit

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Type	TEXT
Status	TEXT
Bandwidth	INTEGER
DMARC	Object - Asset		"Id" = ${Asset}
Vendor	Object - Vendor		"Id" = ${Vendor}
Customer	Object - Customer		"Id" = ${Customer}
Origin Type	TEXT
Origin Circuit	Object - Telco Circuit		"Id" = ${Origin Circuit}
Provision Date	DATE
Turn on Date	DATE
Order Date	DATE

Power Circuit

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Power Circuit Label	TEXT
Rated Voltage	INTEGER
Rated Amps	INTEGER
Breaker Panel	Object - Asset		"Id" = ${Asset}

Object Category

Attribute	Default Type	Description
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Description	TEXTAREA

Tag

Attribute	Default Type	Default Identifier	Unique	Description	AQL
Id	TEXT			Identifier of the object.
Name	TEXT			Name of the object.

Device

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Last updated	DATE_TIME
Notes	TEXTAREA
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Type	TEXT
Virtual Hostname	TEXT
Virtual Subtype	TEXT
Category	Object - Object Category		"Name" = ${Category}
Network Device	BOOLEAN
Blade Chassis	BOOLEAN
Modules	Object - Asset	List of all modules that this blade is hosting.	"Id" IN (${Modules${0}})
Virtual Host	BOOLEAN
Virtual Machines	Object - Device	List of all virtual machines that this host is running.	"Id" IN (${Virtual Machines${0}})
Cluster Devices	Object - Device	List of all cluster device that are belongs to this host.	"Id" IN (${Cluster Devices${0}})
In Service	BOOLEAN
Service Level	Object - Service Level		"Name" = ${Service Level}
UCS Manager	TEXT
Hardware Model	Object - Hardware Model	Hardware model of the device.	"Id" = ${Hardware Model}
Customer	Object - Customer	Customer that belongs to this device.	"Id" = ${Customer}
Asset	Object - Asset	Asset that belongs to this device.	"Name" = ${Asset}
Manufacturer	Object - Vendor	Manufacturer of the device.	"Name" = ${Vendor}
Serial Number	TEXT
UUID	TEXT
Asset number	TEXT
Total CPUs	INTEGER
Cores/CPU	INTEGER
CPU Speed	DOUBLE
RAM	DOUBLE
HardDisk Count	INTEGER
HD size	DOUBLE
HW/SW Raid	TEXT
Raid Type	TEXT
Operating System	Object - Operating System	The Operating System that this device is running.	"Name" = ${Operating System}
OS Version	TEXT
OS Version Number	TEXT
Architecture Type	INTEGER
Aliases	TEXTAREA
Non-Authoritative Aliases	TEXTAREA
Building	Object - Building	Building where the device belongs to.	"Name" = ${Building}
Room	Object - Room	Room where the device belongs to.	"Name" = ${Room}
Orientation	TEXT
Rack	Object - Rack	Rack where the device is mounted to.	"Id" = ${Rack}
Hardware Depth	TEXT
Hardware Size	DOUBLE
X Position	INTEGER
Start at	DOUBLE
IP Addresses	Object - IP Address	List of all IP-Addresses that belongs to this device.	"Id" IN (${IP Address${0}})
MAC Addresses	Object - MAC Address	List of all MAC-Addresses that belongs to this device.	"Id" IN (${MAC Address${0}})
Device URLs	TEXTAREA
Mountpoints	Object - Mountpoint	List of all mountpoints.	"Id" IN (${Mountpoint${0}})
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Mountpoint

Attribute	Default Type	Description
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Last updated	DATE_TIME
Mountpoint Label	TEXT
File System	TEXT
File System Type	TEXT
Capacity	DOUBLE
Available	DOUBLE

Asset

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Type	TEXT
Serial Number	TEXT
Asset number	TEXT
Service Level	Object - Service Level		"Name" = ${Service Level}
Vendor	Object - Vendor		"Id" = ${Vendor}
Building	Object - Building		"Name" = ${Building}
Room	Object - Room		"Name" = ${Room}
Customer	Object - Customer		"Id" = ${Customer}
Category	Object - Object Category		"Id" = ${Category}
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Patch Panel Model

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Type	TEXT
Manufacturer	Object - Vendor	Manufacturer of the patch panel model.	"Name" = ${Vendor}
Module Position	TEXT
Port Type	TEXT
Number of ports	INTEGER
Number of ports in row	INTEGER
Numbering Start Location	TEXT
Numbering Direction	TEXT

Patch Panel Module Model

Attribute	Default Type	Description
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Port Type	TEXT
Number of ports	INTEGER
Number of ports in row	INTEGER

Tap Module Model

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Tap Module Ports	Object - Tap Module Port	List of all Tap Ports that are assigned to this Tap Module.	"Id" IN (${Tap Module Port${0}})

IP Address

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Last updated	DATE_TIME
Notes	TEXTAREA
IP Address	TEXT
MAC Address	TEXT
Type	TEXT
Available	BOOLEAN
Subnet	Object - Subnet	The subnet where this ip belongs to.	"Id" = ${Subnet}
Switch Port	Object - Switch Port		"Id" = ${Switch Port}
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

MAC Address

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Switch Port	Object - Switch Port		"HWAddress" = ${Switch Port}
VLAN	Object - VLAN		"Id" = ${VLAN}

VLAN

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Number	TEXT
Description	TEXT
Switches	Object - Device		"Id" IN (${Device${0}})
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

VRF Group

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Description	TEXTAREA
Buildings	Object - Building		"Name" IN (${Building${0}})
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Subnet

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Network	TEXTAREA
Mask Bits	INTEGER
VRF Group	Object - VRF Group		"Id" = ${VRF Group}
Service Level	Object - Service Level		"Name" = ${Service Level}
Subnet Category	Object - Subnet Category		"Id" = ${Subnet Category}
Parent VLAN	Object - VLAN		"Id" = ${VLAN}
Allow network address as usable	BOOLEAN
Allow broadcast address as usable	BOOLEAN
Customer	Object - Customer		"Id" = ${Customer}
Description	TEXTAREA
Gateway	TEXTAREA
Range Begin	TEXTAREA
Range End	TEXTAREA
Allocated	BOOLEAN
Assigned	BOOLEAN
Can edit	BOOLEAN
Parent Subnet	Object - Subnet		"Id" = ${Subnet}
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Subnet Category

Attribute	Default Type	Description
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Description	TEXTAREA
Change permanent	BOOLEAN

Switch Port

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Last updated	DATE_TIME
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Connected	BOOLEAN
Port	TEXTAREA
HWAddress	TEXTAREA
Type	TEXTAREA
Description	TEXTAREA
Primary Device	Object - Device		"Id" = ${Switches}
VLANs	Object - VLAN		"Id" IN (${VLAN${0}})
Module	Object - Device		"Id" = ${Module}
Devices	Object - Device		"Id" IN (${Device${0}})
Remote Port	Object - Switch Port		"Id" = ${Switch Port}
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Tap Module Port

Attribute	Default Type	Description
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Port Type	TEXT
Single Strand	BOOLEAN
Port capability	TEXT
Port to from	TEXT
Monitor direction	TEXT

DNS Record

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Type	TEXT
Content	TEXTAREA
TTL	INTEGER
Prio	INTEGER
Change Date	INTEGER
DNS Zone	TEXT
Nameserver	TEXT
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

IP NAT

Attribute	Default Type	Description
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Two way relation	BOOLEAN
Protocol	TEXT
Source IP Address Start	TEXT
Source IP Address End	TEXT
Source Port Start	INTEGER
Source Port End	INTEGER
Target IP Address Start	TEXT
Target IP Address End	TEXT
Target Port Start	INTEGER
Target Port End	INTEGER

Software Component

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Software Type	TEXT
Category	TEXT
Discovered Count	DOUBLE
Licensing Model	TEXT
Vendor	Object - Vendor		"Name" = ${Vendor}
License Count	INTEGER
Track Licensed Count by Keys	BOOLEAN
Aliases	TEXTAREA
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Software In Use

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Last updated	DATE_TIME
Software	Object - Software Component		"Id" = ${Software Component}
Application Component	Object - Application Component		"Id" = ${Application Component}
Software Key	TEXT
Version	TEXT
File Version	TEXT
Install Date	DATE
Count In Licensing	BOOLEAN
Device	Object - Device		"Id" = ${Device}
End User	Object - End User		"Id" = ${End User}
First Detected	DATE_TIME
Vendor	Object - Vendor		"Id" = ${Vendor}
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Software License Key

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Count	INTEGER
Software	Object - Software Component	Software that is using this key.	"Name" = ${Software Component}

Service

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Tags	Object - Tag	List of all attached tags.	"Name" IN (${Tag${0}})
Display Name	TEXTAREA
Service Type	TEXT
Vendor	Object - Vendor		"Name" = ${Vendor}
Category	TEXT
Description	TEXTAREA

Service Instance

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Last updated	DATE_TIME
Service	Object - Service		"Id" = ${Service}
Start Mode	TEXT
State	TEXT
Device	Object - Device		"Id" = ${Device}
End User	Object - End User		"Id" = ${End User}
Vendor	Object - Vendor		"Id" = ${Vendor}
Application Component	Object - Application Component		"Id" = ${Application Component}

Service Schedule

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Service	Object - Service		"Id" = ${Service}
Service Instance	Object - Service Instance		"Id" = ${Service Instance}
Device	Object - Device		"Id" = ${Device}
End User	Object - End User		"Id" = ${End User}
Arguments	TEXT
Status	TEXT
Runs at logon	BOOLEAN
Runs at startup	BOOLEAN
Runs based on Event	BOOLEAN
Runs during idle time	BOOLEAN
Other Trigger	BOOLEAN
Other Trigger Typer	TEXT
Weeks	INTEGER
Days	INTEGER
Hours	INTEGER
Minutes	INTEGER
Month(s) of Year	INTEGER
Day(s) of Month	INTEGER
Day(s) of Week	INTEGER
Install Date	DATE_TIME
Description	TEXTAREA

Service Port

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Port	TEXT
Protocol	TEXT
Listening IP	TEXT
Remote IP	TEXT
Device	Object - Device		"Name" = ${Device}
Description	TEXT
Service	Object - Service		"Name" = ${Service}
Application Components	Object - Application Component		"Id" IN (${Application Component${0}})

Network Share

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Last updated	DATE_TIME
Path	TEXT
Device	Object - Device		"Name" = ${Device}
Install Date	DATE_TIME
First Detected	DATE_TIME
Caption	TEXT
Status	TEXT
Type	TEXT
Description	TEXTAREA

Application Component

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Device	Object - Device		"Name" = ${Device}
Responsible Customer or Department	Object - Customer		"Name" = ${Customer}
Affected Customers or Departments	Object - Customer		"Name" IN (${Customer${0}})
Components it depends on directly	Object - Application Component		"Name" IN (${Application Component${0}})

Operating System

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Notes	TEXTAREA
Vendor	Object - Vendor	Vendor of the operating system.	"Name" = ${Vendor}
Category	TEXT
Discovered License Count	INTEGER
Discovered Non-Licensed Count	INTEGER
Total count	INTEGER
Aliases	TEXTAREA

Operating System In Use

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Operating System	Object - Operating System		"Id" = ${Operating System}
Device	Object - Device		"Id" = ${Device}
OS Version	TEXT
OS Version Number	TEXT
Count In Licensing	BOOLEAN
License Key	TEXT
Discovered OS License Key	TEXT

Certificate

Attribute	Default Type	Description	AQL
Id	TEXT	Identifier of the object.
Name	TEXT	Name of the object.
Days to expiry	INTEGER
Parent Certificate	Object - Certificate	Parent certificate.	"Name" = ${Certificate}
Vendor	Object - Vendor	Vendor of the certificate.	"Name" = ${Vendor}
Valid From	DATE
Valid To	DATE
Version	INTEGER
Serial Number	TEXT
Signature Algorithm	TEXT
Signature Hash	TEXT
Is Digital Signature	BOOLEAN
Is Content Commitment	BOOLEAN
Is Key Encipherment	BOOLEAN
Is Data Encipherment	BOOLEAN
Is Key Agreement	BOOLEAN
Is Key CERT Sign	BOOLEAN
Is CRL Sign	BOOLEAN
Is Encipher Only	BOOLEAN
Is Decipher Only	BOOLEAN
Extended Key Usage	TEXTAREA
Custom Fields	Object - Custom Field	List of all custom fields.	"Id" IN (${Custom Field${0}})

Page

Viewport

Confluence

Device42 data imported into Assets

Assets - Device42 Integration

On this page

Related content

Still need help?

Password

User

Group

Service Level

Lifecycle Event

Custom Field

QR Profile

Building

Room

Rack

Power Unit

Power Unit Model

PDU Port

Vendor

Hardware Model

Part

Part Model

Customer

Contact

End User

Purchase

Line Item

Cable

Telco Circuit

Power Circuit

Object Category

Tag

Device

Mountpoint

Asset

Patch Panel Model

Patch Panel Module Model

Tap Module Model

IP Address

MAC Address

VLAN

VRF Group

Subnet

Subnet Category

Switch Port

Tap Module Port

DNS Record

IP NAT

Software Component

Software In Use

Software License Key

Service

Service Instance

Service Schedule

Service Port

Network Share

Application Component

Operating System

Operating System In Use

Certificate

Related content