Chapter 6: User Interface
Using Queries
Altiris Helpdesk Solution User Guide
75
assigned_to_worker_location
string
created_by_worker_name
string
created_by_worker_status
string
a, i, v (a=active, i=inactive,
v=virtual; inactive workers can
be inactive virtual workgroups or
inactive real workers)
created_by_worker_email
string
created_by_worker_phone
string
created_by_worker_cell_phone
string
created_by_worker_pager
string
created_by_worker_location
string
modified_by_worker_name
string
modified_by_worker_status
string
a, i, v (a=active, i=inactive,
v=virtual; inactive workers can
be inactive virtual workgroups or
inactive real workers)
modified_by_worker_email
string
modified_by_worker_phone
string
modified_by_worker_cell_phone
string
modified_by_worker_pager
string
modified_by_worker_location
string
workitem_priority_lookup_value
string
workitem_priority_lookup_ordinal
uint
workitem_status_lookup_value
string
workitem_status_lookup_ordinal
uint
workitem_category_lookup_value
string
workitem_category_lookup_ordinal
uint
workitem_type_lookup_value
string
workitem_type_lookup_ordinal
uint
workitem_link_type_lookup_value
string
workitem_link_type_lookup_ordinal
uint
contact_name
string
contact_email
string
contact_phone
string
contact_organization_name
string
managed_object_name
string
managed_object_type_lookup_id
uint
managed_object_type_lookup_value
string
managed_object_type_lookup_ordinal uint
workitem_comment
string
Field Name
Type
Acceptable values (and
comments)