HP Altris eXpress Helpdesk Solution 5.6 SP1 guide

Chapter 6: User Interface

Using Queries

The table below lists the field names that can be queried against, their type, and additional information where appropriate.

Field Name	Type	Acceptable values (and
		comments)
workitem_link_parent_number	uint
workitem_number	uint
workitem_is_last	string	1, 0
workitem_has_attachments	string	1, 0
workitem_version	uint
workitem_external_reference	string
workitem_priority_lookup_id	uint
workitem_status_lookup_id	uint
workitem_category_lookup_id	uint
workitem_type_lookup_id	uint
workitem_link_type_lookup_id	uint
workitem_assigned_to_worker_id	uint
workitem_created_on	datetime
workitem_created_by_worker_id	uint
workitem_start_on	datetime	(only date part is in db; e.g. 11/10/
		00)
workitem_due_on	datetime	(only date part is in db; e.g. 11/10/
		00)
workitem_modified_on	datetime
workitem_modified_by_worker_id	uint
workitem_minutes_spent	uint
workitem_action	string	Create, Open, Assign, Attach,
		Link, Edit, Associate contact,
		Associate object, Resolve (values
		that are provided, however this
		field is customizable)
workitem_title	string
workitem_managed_object_id	uint
workitem_contact_id	uint
workitem_tag_collection_id	uint
workitem_is_scheduled	string	1, 0
assigned_to_worker_name	string
assigned_to_worker_status	string	a, i, v (a=active, i=inactive,
		v=virtual; inactive workers can
		be inactive virtual workgroups or
		inactive real workers)
assigned_to_worker_email	string
assigned_to_worker_phone	string
assigned_to_worker_cell_phone	string
assigned_to_worker_pager	string

Altiris Helpdesk Solution User Guide

74

Image 74

HP Altris eXpress Helpdesk Solution 5.6 SP1 manual Field Name Type Acceptable values Comments

Contents

Helpdesk Solution 5.6 SP1 User Guide Altiris Helpdesk Solution User Guide Contents New Contact Delete Notify Rules 116 What you see PrefaceDocument Conventions Before Contacting Support SupportTraining Support Contact Information Preface Altiris Helpdesk Solution User Guide Integrate with Microsoft SMS Introducing Helpdesk SolutionComplete, Integrated System Helpdesk Solution Satellite Architecture Scenario Customize with Ease Features and BenefitsFeatures Benefits Worker Console System RequirementsServer End User Console Software Requirements Installing and Setting Up eXpressInstallation Preview Software Notification Server Computer RequirementsHardware Install Prerequisite Software to Notification Server Installing and Setting Up eXpress Installing and Setting Up eXpress Install Notification Server To Install a Satellite Helpdesk Install Helpdesk SolutionAltiris eXpress .NET Configuration Wizard Satellite Helpdesk Configure Helpdesk Command Helpdesk Overview Architecture Helpdesk Solution Consoles Worker Consoles See Also Workers and Worker QueuesUser Consoles Workers Contacts Work Items Assets Integration with Microsoft Systems Management Server SMS Installation Prerequisites Helpdesk Setup Console to start the Web Administration Console Altiris eXpress.NET Configuration Wizard To configure the Helpdesk Configuration Wizard Enter a domain\user and password Modifying Helpdesk Solution Installation Configuration Uninstalling Upgrading Releases Configure Regional Option Localization End User Console Policies ConfigurationWeb Administration Console Interface Elements Console Security Reports Administrators Workers End Users Setting Permissions Console.configuration Entry Points Credential WorkerMode=workerwinUserguestuser SelfEnrollmentCmd= Licensing User Interface Logoff Altiris eXpress Helpdesk Consoles Server AccessClient Access Helpdesk Worker Console CommandsDefault Page Description Work Items Assets Common tasksToolbar Description Recent Worker Report Item Count, Date and TimeBulletins New Work Item To Open a New Work Item Work Item Page Description Description Add New Work Item View or Edit Work Items To View or Edit Work Items Additional Work Item Information Attachments To Attach a File to a Work Item Link Work Items Attach Page Field Description Link Page Field Description To Link a Work Item Mail Messages To Send E-Mail Messages To View Contact Properties View Contact Properties New Work ItemMail Page Field Description Contact Page Field Description NT ID To Find a Contact Auto-Associating an Item’s Asset Using the ContactFind Contact New Work Item Select Contact New Work Item To Select a Contact View Asset Properties New Work Item To View Asset Properties Find Asset New Work Item Asset Page Field Description To Find an Asset Auto-Associating an Item’s Contact Using the AssetSelect Asset New Work Item To Select an Asset Find Work Items Find Work Items Simple Tab Find Work Item Simple Field Description Find Work Items Advanced Tab Full-text Freetext and Contains Searches Search in Comment or Title FieldFind Work Item Advanced Field Description Wildcard Searches Using QueriesManual Configuration Syntax List Query Page Field Description List QueryNew Query To List Queries To Modify a Query Search Modify New Query SearchTo Create a New Query String Examples Query Data TypesNew Query Page Field Description Datetime Examples Field Name Type Acceptable values Comments Be inactive virtual workgroups or $promptnumberprompt$ Query Parameter Replacement$currentworkerid$ $promptstringprompt$ $promptdatetimeprompt$ $promptdateprompt$ Delete Queries Are you sure you want to delete the following items? Last Query Results Retrieve Queued Item Contacts Contacts Home View Contacts Find Contacts To Add a Contact New ContactFind Contacts Page Field Description New Contact Page Field Description To Use the Assets Home Assets Assets HomeView Assets To View Assets New AssetFind Assets To Add a New Asset New Asset Page Field Description Recents To Use the Recents My Helpdesk toolbar description My Helpdesk ConsoleTo Use My Helpdesk Console To Add a New Work Item My Helpdesk New Work ItemSort Work Item List Edit My Info To Edit My Info To Logoff My Helpdesk Work Item Request NT UserLogoff Work Item Request User Work Item Request Guest To create a custom URL Create Custom URL to Access Helpdesk ConsolesWork Item History Support for Pocket PC PPC Pocket PC Navigation Administration Administration Helpdesk Admin Console Admin Admin Report Admin Report Page Field Description Run Admin Reports Categories List Categories List Categories Page Description Edit Categories Add New Category Modify Category Move Category Copy Category Delete Category Routing Rules List Routing Rules Process Order of Routing Rules Edit Routing Rule New Routing Rule To Create a New Routing Rule Altiris Helpdesk Solution User Guide 110 Delete Routing Rules To Delete a Routing Rule List Notify Rules Default RulesNotify Rules New Notify Rule Altiris Helpdesk Solution User Guide 114 Select the check box for the rule to be Default Edit Notify Rule Delete Notify Rules Mail Templates List Templates New Template Default E-mail Templates Edit E-mail Templates Mail Template Macros Simple Macros Complex Macros Mail Macros Bulletins List Bulletins Add New Bulletin Delete Bulletin List Sources SourcesView Source New NS Source New SMS Source Edit Source Import from Source Configure Helpdesk Option 1 This database was last configured by Alert Manager Delete Work Items Simple Tab Delete Work Item Simple Field Description Advanced Tab Delete Contacts Delete Work item Advanced Field Description Delete Assets List Workers WorkersNew Worker Edit Worker List Queue View Queue New Queue Edit Queue Reports Notification Policies Service Level Agreements Troubleshooting Log Files Index URL