De-normalized RT Views

RT Users
1

To all,

We have found that the RT Query tool doesn't allow certain type of

searches we would like to have. SO we created some de-normalized views
that allow us to use SQL Plus or SQL Navigator, etc. as a tool to access
our RT ticket data. We are on Oracle, so I’m not sure if the code to
create these views will be helpful to anyone else, but I’ll share them
with anyone interested. Also, I’d like to put them in the wiki for RT,
but I’ve never been there and would need some instruction on how to do that.
Also, for those who have been looking for ways to convert from one
ticketing system to RT, we have written a program in Perl to do just
that. It uses the API, so that all relevant table records are updated in
RT. Again, we use Oracle, so this may not work for you, but the logic
and process should. All you would have to do is change the syntax and
any environmental setups so the program would work for you and you’ve
got it. Anyone interested in that?

Kenn
LBNL

2

Hi Kenn,
We have Remedy Helpdesk and I would be interested in your
Perl program to test conversion to RT.

Regards,
JasonOn 5 Mar 2009, at 22:50, Kenneth Crocker wrote:

Also, for those who have been looking for ways to convert from one
ticketing system to RT, we have written a program in Perl to do just
that. It uses the API, so that all relevant table records are
updated in
RT. Again, we use Oracle, so this may not work for you, but the logic
and process should. All you would have to do is change the syntax and
any environmental setups so the program would work for you and you’ve
got it. Anyone interested in that?

3

To all,

We have found that the RT Query tool doesn’t allow certain type of
searches we would like to have. SO we created some de-normalized views
that allow us to use SQL Plus or SQL Navigator, etc. as a tool to access
our RT ticket data. We are on Oracle, so I’m not sure if the code to
create these views will be helpful to anyone else, but I’ll share them
with anyone interested. Also, I’d like to put them in the wiki for RT,
but I’ve never been there and would need some instruction on how to do that.
Also, for those who have been looking for ways to convert from one
ticketing system to RT, we have written a program in Perl to do just
that. It uses the API, so that all relevant table records are updated in
RT. Again, we use Oracle, so this may not work for you, but the logic
and process should. All you would have to do is change the syntax and
any environmental setups so the program would work for you and you’ve
got it. Anyone interested in that?

Kenn
LBNL

Yes, please add these to the wiki. We have had similar needs and
having some samples to look at can really speed up implementation
even on different DB platforms.

Cheers,
Ken