Re: How can an external program query to see if a ticket # exists?
Thanks John. Your post gives a new idea. I could have a perl cgi accessed by
the external entity through http. Since this cgi can be in unix, it's easy for
me to do here.
---
I got runmacro.exe to work, but it's awfully slow. Takes 10+ seconds to query
for one record. The trick is to use the -o flag. It cause runmacro to do
something other than run a macro...do a straight query instead.
---
C:\> runmacro.exe -o "c:\temp\test3.txt" -f HPD:HelpDesk -t csv -x server.com
-U "" -P ""
-Q "4\1\1\1\2\4\15\HD00070\"
Action Request System Runmacro.exe Version 6.3
Copyright (c) BMC Software, Inc. 1991-2005. All rights reserved.
Accessing server - server.com ...
Processing form - HPD:HelpDesk ...
Processing complete with total matches of 1 record(s).
Server - server.com access complete with total matches of 1 record(s).
Record detail got dumped into the file test3.txt
I used -Q with internal qualification format, because I couldn't get -q
('Entry Id' = "HD00070") to work. Something
with double quotes in windows command line. I tried a zillion things, always
getting error on qualification.
The -Q parameter means:
'1' = "HD00070"
meaning
'Entry Id' = "HD00070"
If you change -o "" to
-o ""
no file is created with the record's field values; instead, the record is
dumped on the screen. May be useful.
This is an awesome (effortless) way for any external entity to query Remedy,
except for the 10+ second performance. I wonder if there's any local issue in
my setup that's causing the delay.
--- On Tue, 4/20/10, John Sundberg wrote:
> From: John Sundberg
> Subject: Re: How can an external program query to see if a ticket # exists?
> To: arslist@ARSLIST.ORG
> Date: Tuesday, April 20, 2010, 12:57 PM
> setup klink (Kinetic Link)
> http://www.kineticdata.com/Products/KineticLink.html
> (Free/opensource)
>
> then
>
> http://matrix.kineticdata.com:8081/klink/entries/127.0.0.1/User
> (will give you all record numbers)
> http://skitch.com/johnsundberg/n92y6/mozilla-firefox
>
> http://matrix.kineticdata.com:8081/klink/entry/127.0.0.1/User/001
> (will give you User record - 1 -- as XML)
> http://skitch.com/johnsundberg/n92bn/mozilla-firefox
>
>
> http://matrix.kineticdata.com:8081/klink/entries/127.0.0.1/User?qualification='7'=0
> (will give you User records where field '7' = 0)
> http://skitch.com/johnsundberg/n92b3/mozilla-firefox
>
>
>
>
>
> -John
>
>
>
>
>
>
>
>
>
>
> On Apr 20, 2010, at 11:32 AM, Rabi Tripathi wrote:
>
> Hi all,
> I need to provide a way a program can ask Remedy if a
> ticket number exists.
>
> Web services is out (mismatch of Mid-tier and ARS
> versions). I am looking for any other simple solution.
>
> I tried a query with runmacro.exe, hoping i can somehow
> trick it into letting me know if the query matched any
> record or not, but it turns out its not designed to output
> anything to standard output, other than "macro xx processing
> completed".
> I am trying the -o (output to file) option, which may work
> (working on getting the query criteria right), but appears
> to be very slow.
>
> I am considering a Perl script that will take a ticket
> number and simply respond with something like yes or no. I
> will likely turn it into an .exe using perl2exe. We use a
> lot of Perl, but all of it is on the server side and on
> Solaris. This will be the first time doing it on Windows, so
> I wish I could avoid having to open this can of worms to
> build and maintain.
>
> Before I go that route, I want to pick your brain and see
> if I have overlooked any other simple solution.
>
> Thanks in advance.
>
>
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers
> Are"
>
> --
> John Sundberg
>
> Kinetic Data, Inc.
> "Building a Better Service Experience"
> Recipient of the WWRUG09 Innovator of the Year Award
>
> john.sundb...@kineticdata.com
> 651.556.0930
> begin_of_the_skype_highlighting 651.556.0930 end_of_the_skype_highlighting
>
> begin_of_the_skype_highlighting 651.556.0930 end_of_the_skype_highlighting
>
> begin_of_the_skype_highlighting 651.556.0930 end_of_the_skype_highlighting
>
> begin_of_the_skype_highlighting 651.556.0930 end_of_the_skype_highlighting
>
> begin_of_the_skype_highlighting
Re: How can an external program query to see if a ticket # exists?
setup klink (Kinetic Link) http://www.kineticdata.com/Products/KineticLink.html (Free/opensource) then http://matrix.kineticdata.com:8081/klink/entries/127.0.0.1/User (will give you all record numbers) http://skitch.com/johnsundberg/n92y6/mozilla-firefox http://matrix.kineticdata.com:8081/klink/entry/127.0.0.1/User/001 (will give you User record - 1 -- as XML) http://skitch.com/johnsundberg/n92bn/mozilla-firefox http://matrix.kineticdata.com:8081/klink/entries/127.0.0.1/User?qualification='7'=0 (will give you User records where field '7' = 0) http://skitch.com/johnsundberg/n92b3/mozilla-firefox -John On Apr 20, 2010, at 11:32 AM, Rabi Tripathi wrote: Hi all, I need to provide a way a program can ask Remedy if a ticket number exists. Web services is out (mismatch of Mid-tier and ARS versions). I am looking for any other simple solution. I tried a query with runmacro.exe, hoping i can somehow trick it into letting me know if the query matched any record or not, but it turns out its not designed to output anything to standard output, other than "macro xx processing completed". I am trying the -o (output to file) option, which may work (working on getting the query criteria right), but appears to be very slow. I am considering a Perl script that will take a ticket number and simply respond with something like yes or no. I will likely turn it into an .exe using perl2exe. We use a lot of Perl, but all of it is on the server side and on Solaris. This will be the first time doing it on Windows, so I wish I could avoid having to open this can of worms to build and maintain. Before I go that route, I want to pick your brain and see if I have overlooked any other simple solution. Thanks in advance. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" -- John Sundberg Kinetic Data, Inc. "Building a Better Service Experience" Recipient of the WWRUG09 Innovator of the Year Award john.sundb...@kineticdata.com 651.556.0930 I www.kineticdata.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: How can an external program query to see if a ticket # exists?
-- ARS 6.3, Midtier 7.1. The query is to be run from a Windows server. --- On Tue, 4/20/10, Rabi Tripathi wrote: > From: Rabi Tripathi > Subject: How can an external program query to see if a ticket # exists? > To: arslist@arslist.org > Date: Tuesday, April 20, 2010, 12:32 PM > Hi all, > I need to provide a way a program can ask Remedy if a > ticket number exists. > > Web services is out (mismatch of Mid-tier and ARS > versions). I am looking for any other simple solution. > > I tried a query with runmacro.exe, hoping i can somehow > trick it into letting me know if the query matched any > record or not, but it turns out its not designed to output > anything to standard output, other than "macro xx processing > completed". > I am trying the -o (output to file) option, which may work > (working on getting the query criteria right), but appears > to be very slow. > > I am considering a Perl script that will take a ticket > number and simply respond with something like yes or no. I > will likely turn it into an .exe using perl2exe. We use a > lot of Perl, but all of it is on the server side and on > Solaris. This will be the first time doing it on Windows, so > I wish I could avoid having to open this can of worms to > build and maintain. > > Before I go that route, I want to pick your brain and see > if I have overlooked any other simple solution. > > Thanks in advance. > > > > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
How can an external program query to see if a ticket # exists?
Hi all, I need to provide a way a program can ask Remedy if a ticket number exists. Web services is out (mismatch of Mid-tier and ARS versions). I am looking for any other simple solution. I tried a query with runmacro.exe, hoping i can somehow trick it into letting me know if the query matched any record or not, but it turns out its not designed to output anything to standard output, other than "macro xx processing completed". I am trying the -o (output to file) option, which may work (working on getting the query criteria right), but appears to be very slow. I am considering a Perl script that will take a ticket number and simply respond with something like yes or no. I will likely turn it into an .exe using perl2exe. We use a lot of Perl, but all of it is on the server side and on Solaris. This will be the first time doing it on Windows, so I wish I could avoid having to open this can of worms to build and maintain. Before I go that route, I want to pick your brain and see if I have overlooked any other simple solution. Thanks in advance. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
