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.

Using Altiris Helpdesk ExecuteQuery webservice

Updated: 21 May 2010 | 4 comments
boneill's picture
+1 1 Vote
Login to vote
This issue has been solved. See solution.

Hi,

I'm looking for some help with using the altiris helpdesk webservices. I see that there is an operation called ExecuteQuery when I go to http://[servername]/aexhd/WebService.asmx. However I'm having trouble getting results from the ExecuteQuery operation.

Does anyone have an example xml request using this webservice? I'm trying to do a query of open support incidents.

Thanks!

discussion Filed Under:

Comments

gdavies83's picture
15
Oct
2009
0 Votes 0
Login to vote

I am really interested in

I am really interested in finding out how this function works aswell.

I cannot find any information in the documentation that we have "Integrating with Altiris Helpdesk Specification".

Does anybody have any information on how to cosume this "ExecuteQuery" method.

Thanks

boneill's picture
16
Oct
2009
0 Votes 0
Login to vote

I found something the other

I found something the other day that said that the queryText input should be the name of a query? It seems like no matter what I give it for queryText I get nothing back...

cnimmer's picture
21
Oct
2009
0 Votes 0
Login to vote

URL

Can't you just go to this URL to display all open incidents?

http://server/aexhd/worker/Default.aspx?cmd=runQuery&viewOne=yes&title=All+Open+Incidents&where=workitem_status_lookup_id+%3d+300

boneill's picture
27
Oct
2009
0 Votes 0
Login to vote

Yes, that URL does display

Yes, that URL does display all open incidents and I can also create querys inside of altiris as well. However, maybe I want to display that data on a dashboard with charts without having to create new excel documents everyday or integrate helpdesk with another tool....

So I was able to find the needed info in the "Integrating with Altiris Helpdesk" file. The guide points you more in the direction of using VB.net, but it does include the different field names for workitem_detail_view and workitem_current_view which I found very helpful.

I created a deshboard using Adobe flex to gather data on tickets using the ExecuteQuery operation on the webservice. All I had to do was pass a SQL query and 0 for the max rows. Here is an example of a query that I passed to gather a count of all open tickets owned by a certain worker and more than 30 days old.

SELECT COUNT(*) from workitem_current_view WHERE owned_by_worker_name = 'IS RUN' AND workitem_created_on <= DATEADD(day,-30,CURRENT_TIMESTAMP) AND workitem_status_lookup_id <> 600