View AssetTrack Reports

AssetTrack provides two views to collected and published data that can be used to create reports. These views reside within AssetTrack’s SQL Server database and there is no built-in user interface for viewing the data. You can access this data from any application, reporting tool, or query tool that supports connections to SQL Server such as SQL Management Studio.

Queue summary view

The queue summary view displays data that is currently awaiting review in the queue. The name of the queue summary view is QueueSummary and is a view available in the AssetTrack database.

All data currently sitting the Queue is made accessible via a SQL Server view called QueueSummary.  Querying the queue data is helpful in cases of auditing, where you want to compare data collected by end users to what's currently in the asset database.  An example audit workflow is:

  1. Create a form for collecting sample audit data.
  2. Set that form to enqueue all collected data.
  3. Collect sample data
  4. Query the QueueSummary view for all data in that queue, and compare that data to data in your repository.

This method works for comparing location or other sample audit data against your database for reporting data accuracy.

 

The queue summary view contains the following columns.

Column name

Description

FormName

The name of the form that was used to collect this item.

DateCollected

The date and time that this record was collected. This value is in Coordinated Universal Time (UTC).

CollectedUser

The name of the User that collected this record.

AssetTag

SerialNumber

MacAddress

Cost

PONumber

Status

Description

ServiceStatus

 

 

 

The collected value for the field if that field was included on the form.

LeaseEndDate

WarrantyEndDate

AcquistionDate

 

The collected value for the field if that field was included on the form. These values are in Coordinated Universal Time (UTC).

Model

AssetType

Manufacturer

 

The model, asset type, or manufacturer of the product, if the product was included on the form.

FirstName

LastName

The first name or last name of the assignee, if assignee was included on form.

LocationX

The location collected separated into each level as configured in the Management Console. X is the level number of the location. For example, if you have two levels of locations, you will have a Location1 column and a Location2 column.

OrganizationX

The organization collected separated into each level as configured in the Management Console. X is the level number of the organization. For example, if you have two level of organizations, you will have a Organization1 column and a Organization2 coumn.

(Custom Field Name)

Each column field also has a column in this view. This column contains the collected value for the custom field if the custom field was included on the form.

Queue Summary Example

select * from QueueSummary where formname = 'IMAC' and CollectedUser = 'JohnDoe'

Published data view

The published data view displays data that has been successfully published. The name of the published data view is PublishedDataSummary and is a view available in the AssetTrack database.

All data collected by end user via mobile devices, web-forms, spreadsheets or upload API submissions are recorded in AssetTrack's database. This is helpful in monitoring user's compliance with process, as well as for using enqueue data as a comparison source for audit functions. AssetTrack provides access to this historical data via SQL Server views which can be accessed by any SQL-capable tool, including Excel. See Reporting on User Activity for more information.

 

Column name

Description

FormName

The name of the form that was used to collect this item.

DataCollected

The date and time that this record was collected. This value is in Coordinated Universal Time (UTC).

CollectedUser

The name of the User that collected this record.

DatePublished

The date and time the record was published. This value is in Coordinated Universal Time (UTC).

AssetTag

SerialNumber

MacAddress

Cost

PONumber

Status

Description

ServiceStatus

 

 

 

The collected value for the field if that field was included on the form.

LeaseEndDate

WarrantyEndDate

AcquistionDate

 

The collected value for the field if that field was included on the form. These values are in Coordinated Universal Time (UTC).

Model

AssetType

Manufacturer

 

The model, asset type, or manufacturer of the product, if the product was included on the form.

FirstName

LastName

The first name or last name of the assignee, if assignee was included on form.

LocationX

The location collected separated into each level as configured in the Management Console. X is the level number of the location. For example, if you have two levels of locations, you will have a Location1 column and a Location2 column.

OrganizationX

The organization collected separated into each level as configured in the Management Console. X is the level number of the organization. For example, if you have two level of organizations, you will have a Organization1 column and a Organization2 coumn.

(Custom Field Name)

Each column field also has a column in this view. This column contains the collected value for the custom field if the custom field was included on the form.

Published Data Example

select * from PublishedDataSummary where formname = 'IMAC' and datepublished > '2014-01-01' and CollectedUser = 'JohnDoe'

Have more questions? Submit a request

Comments

  • Avatar
    John E Mcconnell
    how can I pull data for the dataitems blob

Please sign in to leave a comment.