Generating Missing Assets Reports

Missing assets reports show which assets have not been seen within a specified number of days, and optionally, at the specified location. You can also use the missing assets reports to report the current location of specified assets (see Set Missing Time Threshold).

Generating Missing Assets Reports

Setting Missing Assets Report Options

To prepare a missing assets report, specify values for the desired selection criteria, as follows.

You must specify a number of days under Set Missing Time Threshold. Other than that, there are no specific dependencies among the other criteria. You can set criteria for none, one, several, or all of the remaining categories.

In some sections on this page, you can enter items (EPCs, GTINs, location URNs, etc.) directly in the field provided for that type of item. You can list multiple items by separating each one with a space or a carriage return.

Set Asset Selection Criteria

Set options in this section to limit the report to assets of the specified types.If you set no options, the default criterion Select All Assets is used.

To specify a type of asset on which to report, select the type from the drop-down list. The choices are:

Select All Assets. Select this option to report on assets of all types.
Specify EPCs. After selecting this type, enter the Electronic Product Codes (EPCs) of the assets to report. You do not have to include the urn:epc:id/urn:epc:idpat portion of the EPC. For example:

sgtin:1234567.000001.600

sgtin:1234567.000001.780

sgtin:1234567.*.*

Specify GTINs. After selecting this type, enter one or more 14-digit Global Trade Item Numbers (GTINs) of assets to report. For example:

10054000217255 10037000308048

Specify Company Prefixes. After selecting this type, enter the GS1 Company Prefixes of assets to report. For example:

1234567 0037000

Specify EPC Classes. When you select this type, a second drop-down list appears. Do one of the following:

Choose List EPC Classes to enter EPC class patterns directly, as URIs. You do not have to include the urn:epc:idpat portion of the EPC class pattern. For example:

    sgtin:1234567.000001

    sgtin:1234567

The report will be limited to assets of the specified EPC classes, where the EPC class pattern exactly matches or includes the string entered here.

Choose Search EPC Classes to search for assets based on master data attributes defined for the EPC class to which the assets belong. (This option is available only when master data has been defined for EPC classes.)

When you choose this option, a table is displayed for specifying the search criteria. Enter criteria as follows:

Select an attribute from the Attribute column.
Enter a value for the selected attribute in the Value field. This field is case-sensitive, so enter the value using the correct upper- and lowercase letters. Only exact matches to this value will be returned.

To delete an attribute from the search criteria, click Delete in that row.

To add a row for entering a new attribute on which to search, click Add.

If master data exists for the EPC class of a reported asset, the master data value for the EPC class attribute is displayed in the report, whether you used the List EPC Classes option or the Search EPC Classes option. If master data does not exist, the URI that identifies the EPC class is displayed.

Set Events Start Time Range

Specify a start time to limit the report to assets associated with events that occurred since the specified time. If you do not set a start time, start time is ignored when generating this report.

You can use this parameter to reduce the number of events that will be considered for generating the report. Only events with time greater than or equal to the start time will be used to generate the report.

If you want to set a start time, you must at least enter a year. The other values are optional:

If you do not set a month, the default is January.
If you do not set a day, the default is 1 (the first of the month).
If you do not set a time, the default is as it appears in the Console, for example, 12:00 A.M.

Set Location Selection Criteria

Set options in this section to limit the report to assets associated with events that occurred in the specified business locations. If you set no options in this section, business locations are ignored when generating the report.

If a specified business location includes "child" business locations (for example, a warehouse might contain several portals), all the locations in the hierarchy are evaluated when generating the report.

List Locations. After selecting this option, enter the business location identifiers on which to report. Specify a business location identifier as a URN, for example:

urn:epc:sgln:1234567.123

Separate each business location identifier in a list with a space or a carriage return.

Search Locations. This option is available when master data has been defined for business locations. Choose this option to search for assets associated with events occurring at a specified business location. When you select this option, a table is displayed for specifying search criteria. Enter criteria as follows:

Select an attribute from the Attribute column. The attributes listed are from master data associated with business location identifiers.
Enter a value for the attribute in the Value field. This field is case-sensitive, so enter the value using the correct upper- and lowercase letters. Only exact matches to this value will be returned.

To delete an attribute from the search criteria, click Delete in that row.

To add a row for entering a new attribute on which to search, click Add.

If master data exists for the business location included in a record, the master data entry value is displayed in the report, whether you used the List Locations option or the Search Locations option. If master data does not exist, a URI is displayed.

Set Missing Time Threshold

Specify a missing time threshold to indicate how may days an asset can be missing before it is listed on this report.

To specify the threshold, enter a number of days. Any item missing longer than this period (and fulfilling the other criteria for this report) will be included in the report.

The missing time threshold can be 0 (zero) or greater number of days. Fractional days are not allowed.

Set Report Display Options

From the Rows per page drop-down list, select a number to set the number of results to be listed per page.
From the Sort By drop-down list, select the column on which you want to sort the results when the report is first displayed.

Note:

You can resort the report by clicking any column header label that is displayed as a hyperlink.

Contents of a Missing Assets Report

The columns in a missing assets report are described in Table 4-1, below. Each row in the table shows an asset (identified by an EPC) plus information to describe when it was last seen and its state when it was last seen, according to the options specified for this run of the report.

If master data has been defined for assets in the report, the master data values are shown in the appropriate fields in the report, in place of more technical (and less readable) identifiers. The fields where that can happen are identified by a Yes in the Display Master Data column.

Table 4-1 Missing Assets Report Contents
Column Name	Description	Display Master Data?
EPC	The Electronic Product Code (EPC) that uniquely identifies the asset.	No
Asset Description	A description of the asset, specified as master data.	Yes If no master data exists for this asset, this field is blank.
Days Since Last Sight	Number of days since an event was reported to be associated with this asset.	No
Last Seen Time	Time when the most recent event associated with this report occurred.	No
Event Type	The type of event that occurred. Event types include AggregationEvent, TransactionEvent, and ObjectEvent. If the asset is a child in an AggregationEvent, this field identifies its parent. If the asset is the parent in an AggregationEvent, it is identified as a parent. AggregationEvents are displayed as hyperlinks. Click the link to display information about the aggregation, including a list of the assets associated with this aggregation event.	No
Business Location	The business location where the event occurred.	Yes If no master data exists for this business location, the location is displayed as a URI.
Disposition	The disposition, or business state, associated with this asset following the most recent event. (For example, an item can be "available for sale" or "sold.")	Yes If no master data exists for the disposition, the disposition is displayed as a URI.
Business Step	The business step associated with this asset and the most recent event.	Yes If no master data exists for this business step, the step is displayed as a URI.
Read Point	The read point where this asset was most recently read.	Yes If no master data exists for this read point, the read point is displayed as a URI.

Generating WebLogic RFID Enterprise Server Reports

Generating Missing Assets Reports