Command Line queries for Asset Tracker

Hey guys,

We use numerous scripts that make queries of RT tickets from the
command-line (using the ./rt CLI), I am now wondering how one queries
the Asset Tracker database plug-in from the command-line? Can anyone
provide an example, using the ./rt CLI, of querying the asset tracker
db?

Thanks heaps.
BenR

Ben Robson wrote:

Hey guys,

We use numerous scripts that make queries of RT tickets from the
command-line (using the ./rt CLI), I am now wondering how one queries
the Asset Tracker database plug-in from the command-line? Can anyone
provide an example, using the ./rt CLI, of querying the asset tracker db?

Thanks heaps.

BenR

There is a patch that adds AT to the rt CLI. I think it is available at
the AT homepage on Google.
Search the mailinglist for further info.

Joop

Joop,

Thanks for the reply. I spent a decent amount of time hunting around
and the best I could find was a mention of “RTx::Atom” which I couldn’t
actually locate as a project, and also something done by Philip Kime to
the REST interface, but I couldn’t find that anywhere either.

Does anyone have any other ideas about Asset Tracker queries from the
commandline?

Thanks,
BenRFrom: Joop [mailto:JoopvandeWege@mococo.nl]
Sent: Wednesday, 25 June 2008 6:14 PM
To: Ben Robson
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Command Line queries for Asset Tracker

Ben Robson wrote:

Hey guys,

We use numerous scripts that make queries of RT tickets from the
command-line (using the ./rt CLI), I am now wondering how one queries
the Asset Tracker database plug-in from the command-line? Can anyone
provide an example, using the ./rt CLI, of querying the asset tracker
db?

Thanks heaps.

BenR

There is a patch that adds AT to the rt CLI. I think it is available at
the AT homepage on Google.
Search the mailinglist for further info.

Joop

Ben Robson wrote:

Joop,

Thanks for the reply. I spent a decent amount of time hunting around
and the best I could find was a mention of “RTx::Atom” which I couldn’t
actually locate as a project, and also something done by Philip Kime to
the REST interface, but I couldn’t find that anywhere either.

Does anyone have any other ideas about Asset Tracker queries from the
commandline?

Thanks,
BenR

There is a patch that adds AT to the rt CLI. I think it is available at
the AT homepage on Google.
Search the mailinglist for further info.

Found it in my rt-users archive:

http://code.google.com/p/asset-tracker-4rt/

What you’re looking for is in CVS and called AT-REST

Joop

Thanks for locating the patch for me. I have implemented it using the
normal %patch method and run in to troubles. So I backed out to a clear
version of %rt and re-applied it by hand making sure everything went in
to the right location.

If I do a query, such as %rt ls -t asset “Type = ‘Servers’”, I get an
error message "rt: Unsupported object type. Unsupported object type."
This error message seems to be getting thrown by
~/share/html/REST/1.0/search/dhandler (it being the only place with a
message “Unsupported object type.”, but I can’t for the life of me work
out why its complaining.

Has anyone used this AT CLI patch and seen this issue?

Thanks heaps for the help.

BenRFrom: Joop [mailto:JoopvandeWege@mococo.nl]
Sent: Wednesday, 25 June 2008 9:38 PM
To: Ben Robson
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Command Line queries for Asset Tracker

Ben Robson wrote:

Joop,

Thanks for the reply. I spent a decent amount of time hunting around
and the best I could find was a mention of “RTx::Atom” which I
couldn’t
actually locate as a project, and also something done by Philip Kime
to
the REST interface, but I couldn’t find that anywhere either.

Does anyone have any other ideas about Asset Tracker queries from the
commandline?

Thanks,
BenR

There is a patch that adds AT to the rt CLI. I think it is available
at
the AT homepage on Google.
Search the mailinglist for further info.

Found it in my rt-users archive:

http://code.google.com/p/asset-tracker-4rt/

What you’re looking for is in CVS and called AT-REST

Joop