Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Altiris Workflow - WebForm - Finding Service Desk Contacts

Updated: 21 May 2010 | 5 comments
Andy Tous's picture
0 0 Votes
Login to vote

Hello All,

I'm building a WebForm using Altiris WorkFlow that Creates a Helpdesk Ticket. I got it to a point that works really well. However, I would like to include a feature that can search my Service Desk Contacts by only entering any of the following:

1- First Name
2- Last Name
3- Last, First Name
4- Partial Last Name
5- Partial First Name

Then displaying the found contacts on another form using a Grid Configuration so the "affected user" can be selected from this list.

Altiris Helpdesk has this feature, I'm trying to use the same for a WorkFlow WebForm.

I was able to create a simple search feature using the "Find Service Desk Contact" followed by an "EqualsRule" and ending on the found contact form with a grid for selecting the found user. It works OK, but end users need to enter the "affected user's" email, full name (last, first) or NtId. In order words, It does not allow partial information to be entered.

Your suggestions or feedback would be greatly appreciated.

Andy

discussion Filed Under:

Comments

ToadMan8's picture
24
Jul
2008
0 Votes 0
Login to vote

SQL to the rescue

The "Find Service Desk Contact" component states in the help dialog "Contacts can be retrieved by exactly matching either the contact Name, NTId, or Email Address."

So, you appear to be out of luck using this helpful widget.

With the disclaimer that I am quite new to the product and have been known to write things by hand that come built-in, I would turn to the SQL features (not loaded by default - use "Import Components" from below the components menu and pick "SQL.dll" to load), specifically the "Select Command Component" and query your dbo.contact table by full name, as you can search by wildcard, e.g.
SELECT id
FROM dbo.contact
WHERE name LIKE '%smith%'

Does this make sense?

Rob Moore's picture
05
Aug
2008
0 Votes 0
Login to vote

Integration Component

Actually, you would build an integration component that would use a user supplied variable to search for the name. Then you would need to populate a drop down list with the results.

Once the user selects a name, you would have to again query the DB to get the Contact ID for that person.

The SQL is pretty straight forwrad. Let me know if you'd like to have the code, I can gin up a quick component for you.

Rob Moore

Shepherd.Wesley's picture
04
Sep
2008
0 Votes 0
Login to vote

Have to tried making an intergration tool?

Have to tried making the custom SQL query? If not; I gave it a shot this morning using this command it worked like a charm for partial name searches.

Select * From contact
Where name LIKE N'%@_SearchedName%'

Let me know if you need any assistance in making this.

Thanks
Wes

stuper2's picture
05
Sep
2008
0 Votes 0
Login to vote

Use Custom Report on the NS

The SQL Query Integration Tool will definitely give you the data that you need, but I'd reccomend using a custom NS report and using the Report generator.

Then the search is available for other projects that you create in the future, and it's also availabile to you on your NS.

Fabrice B M Raud's picture
02
Oct
2008
0 Votes 0
Login to vote

Use reports!

What I found wonderful with WS is how easy it is to integrate reports as libraries.

Use already defined reports or create you own like said stuper using the wizzard or SQL if you feel it good and create your library and it works!

Best regards;
Saludos,

FABEMARA Consulting the new Symantec Altiris Partner in Spain
www.fabemara.es
inventario.fabemara.es

FABEMARA Consulting the main Symantec Altiris Partner in Spain
http://www.fabemara.es

http://assistance.fabemara.com