Skip to main content
Use the Asset tab to create reports based on asset data including warranty details, manufacturer, asset type, and more.

​
Create an Asset Report

​
Date Range

Begin by selecting the start date range for which you’d like to report on. Click on the calendar icon to select a preset date range and click Load Data.
  • Today: From 12:00 AM to the current time
  • Yesterday: Previous day from 12:00 AM to 11:59 PM
  • This Week: From Monday through Sunday of the current week
  • Last Week: Previous week
  • Last 7 Days: Previous seven days, including today
  • This Month: From the first of the current month to the current day
  • Last Month: Entire month before the current month
  • Last 30 Days: Previous 30 days, including today
  • Custom: Use the calendar to select start and end dates

​
Columns

Click on Columns Select the columns to include in your report by clicking Columns. The Jobs report includes these columns by default:
  • #ID: Project number
  • Title: Maintenance agreement title
  • Asset Type: Customer or company asset
  • Status: Maintenance agreement status
  • Customer: Customer linked to the agreement
  • Location: Service location for the agreement
  • Maintenance Agreement: Related maintenance agreement
  • Category: Equipment category
  • Tag: Asset tag
  • Created At: Date and time the agreement was created
  • Created By: Author of the agreement
  • Location Description: Asset location description
  • Install Date: Asset install date
  • Manufacturer: Asset manufacturer
  • Model: Asset model
  • Model Number: Model number
  • Serial Number: Serial number
  • Model Year: Model year
  • Model Details: Model details
  • Parts Warranty Expiration: Warranty expiration date
  • Parts Warranty Information: Warranty information
  • Labor Warranty Expiration
  • Labor Warranty Information
  • Condition: Asset condition
  • Issues: Asset issues
  • Notes: Asset record notes
  • Custom Fields: User-created fields related to the asset
  • Asset Last Update
    • Asset Update: Asset update details
    • Asset Update Job: Asset update related job
    • Asset Update Author: Asset update author
    • Asset Update Created Date: Asset update created date

​
Filters

Click on Filters Before running the report, set filters to narrow your results. From the Filters icon, select how you want to filter the report:
  • #ID: filter by contents
  • Title: filter by contents
  • Asset Type: select type
  • Status: select status
  • Customer: filter by contents
  • Location: filter by contents
  • Maintenance Agreement: filter by contents
  • Category: select category
  • Tag: filter by contents
  • Created At: filter by date
  • Created By: filter by contents
  • Location Description: filter by contents
  • Install Date: filter by date
  • Manufacturer: filter by contents
  • Model: filter by contents
  • Model Number: filter by contents
  • Serial Number: filter by contents
  • Model Year: filter by contents
  • Model Details: filter by contents
  • Warranty Expiration: filter by contents
  • Warranty Information: filter by contents
  • Condition: filter by contents
  • Issues: filter by contents
  • Notes: filter by contents
  • Custom Fields: select custom field
  • Asset Last Update
    • Asset Update: select update
    • Asset Update Job: filter by contents
    • Asset Update Author: filter by contents
    • Asset Update Created Date: filter by date
When filtering by contents, you will need to choose an operator and then enter values to filter the data. Use the table below to learn more about each operator.
OperatorRetrieves DataExampleData Retrieved
EqualsEqual to a specified valueCreated By - Equals Tom GauseFor all records created by Tom Gause only
Not EqualDifferent from a specified valueTag - Not Equal to HVACFor all records except those using the HVAC tag
Less ThanLower than a specified value#ID - Less than 1144For all records below #1144
Less Than or Equal ToLower than or equal to a specified valueJob Date/Time - Less than or equal to 12/13/2023For jobs scheduled before or on 12/13/2023
Greater ThanGreater than a specified valueJob Duration - Greater than 60 minutesFor jobs in the In Progress status type for over 60 minutes
Greater Than or Equal ToGreater than or equal to a specified valueJob Date/Time - Greater than or equal to 1/1/2024For jobs scheduled on or after 1/1/2024
In RangeIncluding and between two specified values#ID - Between 1225 and 1236For all estimate records with #IDs between 1225 and 1236
Starts WithBegins with a specified valueTitle - AnnualFor all job records beginning with Annual
Ends WithEnds with a specified valueLocation - TXFor all job locations ending with TX
BlankNo values are in the fieldSubtitleFor all job records with blank subtitles
Not BlankValues in the fieldNotesFor all job records with values in the notes field
Have additional questions? Contact us at support@fieldpulse.com or use the chat feature in the bottom right corner of your screen.