Snow data imported into Assets

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

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

Object Schema Tree:


API Info

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


API Version

TEXT



Version of the API.


APP Version

TEXT





DB Catalog

TEXT





DB Schema Version

TEXT





DB Server

TEXT





DB Server Version

TEXT





DB User

TEXT





Product

TEXT





Warnings

TEXT






Customer

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


City

TEXT



City of the customer.


Address

TEXT



Address of the customer.


Postal Code

TEXT



Postal-Code of the customer.



User

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Status

STATUS



Status of the user.


Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Full Name

TEXT



The complete name of the user.


Last Logon

DATE_TIME



Last time the user had logged in into Snow.


Updated Date

DATE_TIME



The time when the object was updated the last time.


Quarantine Date

DATE_TIME





Quarantine Delete Date

DATE_TIME





Updated by

TEXT



The account that have made the last update.


Location

TEXT



Location of the user.


Room number

TEXT



Room of the user.


Email

TEXT



Email address of the user.


Phone Number

TEXT



Phone number of the user.


Mobile Phone Number

TEXT



Mobile number of the user.


Organization

TEXT



Organization of the user.


Auto editing

BOOLEAN





Quarantine Management

BOOLEAN





last used computer

Object - Computer



The last computer that the user had used.

"Id" = ${last used computer}

Mobile Devices

Object - Mobile Device



The mobile devices that belongs to this user.

"Id" IN (${Mobile Devices${0}})

Computers

Object - Computer



The referenced computers.

"Id" IN (${Computers${0}})

Applications

Object - Application



Applications referenced to the user.

"Id" IN (${Applications${0}})

Snow Objects

Object - Snow Object



The snowObjects that belongs to this user.

"Id" IN (${Snow Objects${0}})

Custom Fields

Object - Custom Field Value



List of all attached Custom Field Values.

"Category" = "User" AND "Reference Id" IN (${Custom Fields${0}})


Custom Field Value

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Value

TEXT



Value of the custom field.


Reference Id

TEXT



The Identifier of the referenced object for the custom field.


Category

TEXT



The assigned category of the CustomFieldValue.


Updated Date

DATE_TIME



The time when the object was updated the last time.


Custom Field Definition

Object - Custom Field Definition



Reference to the custom field definition.

"Id" = ${Custom Field Definition}


Custom Field Definition

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Description

TEXTAREA



Description of the CustomFieldDefinition.


Category

TEXT



The assigned category of the CustomFieldDefinition.


Data Type

TEXT



The assigned category of the CustomFieldDefinition.


Mandatory

BOOLEAN



Indicates that the Customfield is mandatory.


Default Value

TEXT



The assigned default value of the CustomFieldDefinition.


Multiple Choice

TEXT



The assigned multiple choice values of the CustomFieldDefinition.


Created Date

DATE_TIME



The date when the CustomFiledDefinition was created.


Updated Date

DATE_TIME



The time when the object was updated the last time.



Snow Object

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Snow Object Type

Object - Snow Object Type



Reference to the object type.

"Id" = ${Snow Object Type}

Organization

TEXT





Created by

TEXT





Created Date

DATE_TIME





Updated by

TEXT



The account that have made the last update.


Updated Date

DATE_TIME






Snow Object Type

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Description

TEXTAREA



Description of the SnowObjectType.



Data Center Cluster

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Description

TEXTAREA



Description of the DataCenterCluster


Organization

TEXT



Organization where the DataCenterCluster belongs to.


Server count

INTEGER



Amount of servers that belonging to the DataCenterCluster.


Licensed application count

INTEGER



Amount of licensed applications that belonging to the DataCenterCluster.


Computers

Object - Computer



The computers that belongs to this DataCenterCluster.

"Id" IN (${Computers${0}})

Licenses

Object - License



The licenses that belongs to this DataCenterCluster.

"Id" IN (${Licenses${0}})

Virtual Machine count

INTEGER



Amount of virtual machines that belonging to the DataCenterCluster.


Inventoried Virtual Machine count

INTEGER



Amount of inventoried virtual machines that belonging to the DataCenterCluster.


Updated by

TEXT



The account that have made the last update.


Updated Date

DATE_TIME



The time when the object was updated the last time.



Computer

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Status

STATUS



Status of the computer.


Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Manufacturer Name

TEXT





Manufacturer Website

TEXT





Model

TEXT





Serial Number

TEXT



Serialnumber from the assigned hardware bios.


Virtual Machines

Object - Computer



Virtual machines on the computer.

"Id" IN (${Virtual Machines${0}})

Hardware

Object - Hardware



Reference to the hardware.

"Id" = ${Hardware}

Logical Disks

Object - Logical Disk



The logical disks that belongs to this computer.

"Id" IN (${Logical Disks${0}})

Optical Drives

Object - Optical Drive



The optical drives that belongs to this computer.

"Id" IN (${Optical Drives${0}})

Network Adapters

Object - Network Adapter



The network adapters that belongs to this computer.

"Id" IN (${Network Adapters${0}})

Display Adapters

Object - Display Adapter



The display adapters that belongs to this computer.

"Id" IN (${Display Adapters${0}})

Monitors

Object - Monitor



The monitors that belongs to this computer.

"Id" IN (${Monitors${0}})

Applications

Object - Application



Applications referenced to the computer.

"Id" IN (${Applications${0}})

Operating System

TEXT





Operating System Service Pack

TEXT





Organization

TEXT





IP Addresses

TEXTAREA



List of assignet IP-Addresses.


Last Scan Date

DATE_TIME



Last time when the computer was scanned.


Auto editing

BOOLEAN





Datacenter Name

TEXT





Quarantine Management

BOOLEAN





Quarantine Date

DATE_TIME





Quarantine Delete Date

DATE_TIME





is Portable

BOOLEAN





is Server

BOOLEAN





is Virtual

BOOLEAN





is 64Bit

BOOLEAN





is part of Vdi

BOOLEAN





Client Configuration Name

TEXT





Client Install Date

DATE_TIME





Client Site Name

TEXT





Client Version

TEXT





Scanner Version

TEXT





Domain

TEXT





Hypervisor Name

TEXT





Scan Identifier

TEXT





Transfer Date

DATE_TIME





Updated by

TEXT



The account that have made the last update.


Updated Date

DATE_TIME





Notes

TEXT





Security Code

TEXT





Purchase Date

DATE_TIME





Purchase Vendor

TEXT





Purchase price

DOUBLE





Currency

TEXT





User Purchase Value

DOUBLE





Purchase Invoice Reference

TEXT





Snow Objects

Object - Snow Object



The snowObjects that belongs to this computer.

"Id" IN (${Snow Objects${0}})

Custom Fields

Object - Custom Field Value



List of all attached Custom Field Values.

"Category" = "Computer/Mobile device" AND "Reference Id" IN (${Custom Fields${0}})


Hardware

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Bios Serial Number

TEXT





Bios Version

TEXT





Bios Date

DATE_TIME





Processor Type

TEXT





Processor Count

INTEGER



Amount of installed processors.


Cores per Processor

INTEGER



Amount of CPU Cores.


Physical Memory

INTEGER



Amount of RAM in Mb.


Memory Slots

INTEGER



Amount of used memory slots.


Memory Slots available

INTEGER



Amount of available memory slots.


System Disk Space

INTEGER



Amount of system disk space in Mb.


System Disk Space available

INTEGER



Amount of available system disk space in Mb.


Total Disk Space

INTEGER



Amount of disk space in Mb.


Total Disk Space available

INTEGER



Amount of available disk space in Mb.



Logical Disk

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Volume Name

TEXT





Size

INTEGER






Optical Drive

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Type

TEXT






Network Adapter

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

IP Address

TEXT





MAC Address

TEXT






Display Adapter

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Current Resolution

TEXT





Max Resolution

TEXT






Monitor

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Max Resolution

TEXT






Mobile Device

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Status

STATUS



Status of the mobile device.


Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Mobile Device Type

TEXT





Manufacturer Name

TEXT



Manufacturer of the device.


Manufacturer Website

TEXT



Website of the manufacturer.


Model

TEXT



Device model.


Phone Number

TEXT





Roaming

BOOLEAN





Operating System

TEXT



Operating System that the device is running on.


Organization

TEXT





IP Addresses

TEXTAREA



List of assignet IP-Addresses.


Last Scan Date

DATE_TIME



Last time when the device was scanned.


Auto editing

BOOLEAN





Quarantine Management

BOOLEAN





Quarantine Date

DATE_TIME





Client Configuration Name

TEXT





Client Install Date

DATE_TIME





Client Version

TEXT





Scanner Version

TEXT





Domain

TEXT



Domain which the device belongs to.


Scan Identifier

TEXT





Transfer Date

DATE_TIME





Updated by

TEXT



The account that have made the last update.


Updated Date

DATE_TIME





Notes

TEXT





Security Code

TEXT





Purchase Date

DATE_TIME





Purchase Vendor

TEXT





Purchase price

DOUBLE





Currency

TEXT





User Purchase Value

DOUBLE





Purchase Invoice Reference

TEXT





has Exchange Profile

BOOLEAN





IMEI

TEXT





IMSI

TEXT





Network Type

TEXT





Operator

TEXT





Operator Country

TEXT





Bios Serial Number

TEXT





Bios Version

TEXT





Bios Date

DATE_TIME





Processor Count

INTEGER





Processor Speed

INTEGER





Processor Type

TEXT





Physical Memory

INTEGER





Architecture

TEXT





Applications

Object - Application



Applications referenced to the device.

"Id" IN (${Applications${0}})

Snow Objects

Object - Snow Object



The snowObjects that belongs to this mobile device.

"Id" IN (${Snow Objects${0}})


Application

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Description

TEXTAREA



Description of the application.


Manufacturer Id

TEXT



Identifier of the Application Manufacturer.


Manufacturer Name

TEXT



Name of the Application Manufacturer.


Manufacturer Website

TEXT



Website of the Application Manufacturer.


Family Id

TEXT



Identifier of the application family.


Family Name

TEXT



Name of the application family.


Operating System Type

TEXT



Operating System Type of the application.


Metric

TEXT



Metric of the application.


Bundle

BOOLEAN



Indicates if the application comes from a bundle installation.


Updated Date

DATE



The time when the object was updated the last time.


Updated by

TEXT



The account that have made the last update.


Language

TEXT



Shows who had updated the application


Release Date

DATE



Update Date of the application.


Created Date

DATE



Creation Date of the application.


Created Date

DATE



Creation Date of the application.


Created by

TEXT



Shows who had created the application


System Owner Name

TEXT



System owner of the application


System Owner Phone

TEXT



Phone of the system owner.


System Owner Email

TEXT



Mail of the system owner.


Media

TEXT





Is Operating System

BOOLEAN



Indicates if the application is an operating system.


Application Types

TEXTAREA



Assigned types of the application.


Upgrade Options

TEXTAREA





Downgrade Options

TEXTAREA





Total Coverage

INTEGER





License Required

BOOLEAN



Indicates if a license is required.


License Requirement

INTEGER



The amount of required licences for that application.


License Count

INTEGER



The amount of used licences for that application.


Installation Count

INTEGER



The amount of installations of that application.


Bundle Installation Count

INTEGER



The amount of bundle installations of that application.


Unused Installation Count

INTEGER



The amount of unused installations of that application.


Usage Factor

DOUBLE



The usage factor of that application.


User Count

INTEGER



The amount of users for that application.


Risk

DOUBLE





Risk Unused

DOUBLE





Compliance

INTEGER





License Keys

TEXTAREA



Assigned license keys for that application.


Application Cost Total

DOUBLE



Total cost of that application.


Application Cost per License

DOUBLE



Absolute cost per licence for that application.


Average Cost per License

DOUBLE



Average cost per licence for that application.


License Cost Total

DOUBLE



Total licence cost for that application.


Currency

TEXT



Currency for the license costs.


User License Cost

DOUBLE



Total cost per user for that application.


Alert on overlicensing

BOOLEAN



Indicates if an alert event is triggered by overlicensing.


Alert on underlicensing

BOOLEAN



Indicates if an alert event is triggered by underlicensing.


Alert when not used

BOOLEAN



Indicates if an alert event is triggered when the application is not used.


Secondary use allowed

BOOLEAN



Indicates if an secondary use is allowed.


Multiple versions allowed

BOOLEAN



Indicates if multiple versions are allowed.


Multiple editions allowed

BOOLEAN



Indicates if multiple editions are allowed.


Black Listed

BOOLEAN



Indicates if the application is on the black list.


Custom Fields

Object - Custom Field Value



List of all attached Custom Field Values.

"Category" = "Application" AND "Reference Id" IN (${Custom Fields${0}})


Agreement

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Description

TEXTAREA



Description of the agreement.


Sub-Agreements

Object - Agreement



The Sub-Agreements that belongs to this agreement.

"Id" IN (${Sub-Agreements${0}})

Agreement Type

TEXT



Type of the agreement.


Agreement Number

TEXT





Active Period From

DATE_TIME





Active Period To

DATE_TIME





Agreement Periods

Object - Agreement Period



The agreement periods for this agreement.

"Id" IN (${Agreement Periods${0}})

Organization

TEXT





Subscription

BOOLEAN





Automatic License Upgrades

BOOLEAN





Renewal days before expiration

INTEGER





Selectable after expiration

BOOLEAN





Restricted Organization access

BOOLEAN





Alert on expiration

BOOLEAN





Alert warning days before expiration

INTEGER





Alert critical days before expiration

INTEGER





Restricted Role access

BOOLEAN





Restricted to roles

Object - Role



The restricted roles for this agreement.

"Id" IN (${Restricted to roles${0}})

Auto attach computers

BOOLEAN





Created by

TEXT





Created Date

DATE_TIME





Updated by

TEXT



The account that have made the last update.


Updated Date

DATE_TIME





Licenses

Object - License



The licenses that belongs to this agreement.

"Id" IN (${Licenses${0}})

Mobile Devices

Object - Mobile Device



The mobile devices that belongs to this agreement.

"Id" IN (${Mobile Devices${0}})

Computers

Object - Computer



The computers that belongs to this agreement.

"Id" IN (${Computers${0}})

Snow Objects

Object - Snow Object



The snowObjects that belongs to this agreement.

"Id" IN (${Snow Objects${0}})

Contractor

TEXT



The time when the object was updated the last time.


Contractor Website

TEXT





Contractor Phone

TEXT





Contractor Contact

TEXT





Contractor Contact Phone

TEXT





Contractor Contact Email

TEXT





Local Contact

TEXT





Local Contact Department

TEXT





Local Contact Phone

TEXT





Local Contact Email

TEXT





Custom Fields

Object - Custom Field Value



List of all attached Custom Field Values.

"Category" = "Agreement" AND "Reference Id" IN (${Custom Fields${0}})


Agreement Period

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

valid from

DATE_TIME





valid to

DATE_TIME






Role

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}


License

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Self Link

TEXT

(tick)


Server-defined URL for this resource.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Application

Object - Application



Reference to the application.

"Name" = ${Application}

Manufacturer Name

TEXT





Metric

TEXT





Assignment Type

TEXT





Automatic Downgrade

BOOLEAN





Upgrade Rights

BOOLEAN





Invoice Reference

TEXT





Purchase Date

DATE_TIME



The time when the license was purchased.


Purchase price

DOUBLE





Currency

TEXT





Quantity

INTEGER





Vendor

TEXT





External Id

TEXT





Installation Media

TEXT





License Proof Location

TEXT





License Keys

TEXT





Notes

TEXT





Incomplete

BOOLEAN





License Allocations

Object - License Allocation



The license allocations fro thid license.

"Id" IN (${License Allocations${0}})

Upgrading Licenses

Object - License



The referenced upgrading licenses.

"Id" IN (${Upgrading Licenses${0}})

Base Licenses

Object - License



The referenced base licenses.

"Id" IN (${Base Licenses${0}})

Computers

Object - Computer



The referenced computers.

"Id" IN (${Computers${0}})

Virtual Machines

Object - Computer



The referenced virtual machines.

"Id" IN (${Virtual Machines${0}})

Granted Users

Object - User



The referenced granted users.

"Id" IN (${Granted Users${0}})

Updated by

TEXT



The account that have made the last update.


Updated Date

DATE_TIME



The time when the object was updated the last time.


Custom Fields

Object - Custom Field Value



List of all attached Custom Field Values.

"Category" = "License" AND "Reference Id" IN (${Custom Fields${0}})


License Allocation

Attribute

Default Type

Default Identifier

Unique

Description

AQL

Id

TEXT

(tick)


Identifier of the object.


Name

TEXT



Name of the object.


Customer

Object - Customer



Reference to the customer.

"Id" = ${Customer}

Organization

TEXT





Quantity

INTEGER





Last modified on Oct 27, 2022

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.