Device42 data imported into Assets
The data collected from Device42 is assembled and imported into Assets. The Object Schema Tree looks like this in Assets:
- 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
Password
| Attribute | Default Type | Default Identifier | Unique | 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 | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| Id | TEXT | Identifier of the object. | |||
| Name | TEXT | Name of the object. | |||
| Auth Type | TEXT | ||||
| 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| Id | TEXT | Identifier of the object. | |||
| Name | TEXT | Name of the object. | |||
| Notes | TEXTAREA | ||||
| Value | TEXTAREA | 
QR Profile
| Attribute | Default Type | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| Id | TEXT | Identifier of the object. | |||
| Name | TEXT | Name of the object. | |||
| Port Type | TEXT | 
Vendor
| Attribute | Default Type | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| Id | TEXT | Identifier of the object. | |||
| Name | TEXT | Name of the object. | |||
| Type | TEXT | ||||
| TEXT | |||||
| Phone | TEXT | ||||
| Address | TEXTAREA | 
End User
| Attribute | Default Type | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| Id | TEXT | Identifier of the object. | |||
| Name | TEXT | Name of the object. | |||
| 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| Id | TEXT | Identifier of the object. | |||
| Name | TEXT | Name of the object. | |||
| Description | TEXTAREA | ||||
| Change permanent | BOOLEAN | 
Switch Port
| Attribute | Default Type | Default Identifier | Unique | 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 | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | Description | AQL | 
|---|---|---|---|---|---|
| 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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 | Default Identifier | Unique | 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}}) | 
