Using Altiris Helpdesk ExecuteQuery webservice
Updated: 21 May 2010 | 4 comments
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
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
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...
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
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
Would you like to reply?
Login or Register to post your comment.