Re: [rt-users] Some RTIR automation?
Hi, Condition looks good. On a side note I recommend you start developing using RTIR 2.6 and a dev server, then upgrade when code is ready. We deleted prefix _RTIR_ from custom fields and you'll have to change that if you delay upgrade. Start action from getting IP addresses and storing them into an array then dumping into RT's logs. Look for usage of CustomFieldValues method. On Sat, Dec 18, 2010 at 4:00 AM, Landon Stewart lstew...@superb.net wrote: Hello RT-Users, To recap what I wrote about in this thread before was: - An incident report comes in... - If it has at least one IP address in the _RTIR_IP field do EITHER: -- Link to an existing incident by IP address *OR* -- Create a new incident (The goal is to automatically group Incident Reports by IP address instead of doing it manually.) Ruslan wrote back saying: It's totally doable with scrips. RTIR itself has a lot of examples with bits you need. Basicly you need: When IR is created with and IP is set or when IP is changed from no value to a value, link to existing incident or create a new one. First part is a condition and second part is an action. For example lib/RT/Condition/RTIR_ BlockActivation.pm is quite close. Checks whether ticket is created with active state or state is changed to active. Action is not that straightforward, but try it and if you have problems return back to us with detailed questions. OK lets talk about the Condition first... Is this enough to trigger the condition? my $self = shift; my $txn = $self-TransactionObj; my $type = $txn-Type; return 1 if $type eq 'Create' ($self-TicketObj-FirstCustomFieldValue('_RTIR_IP')); The other thing is the action... I really don't know where to start on the action. I know its going to be lengthy though because there's some checks has to do itself to decide what the exact course of action will be. Here's what it should do, I think: - foreach IP address in _RTIR_IP -- Look for an Incident that contains that IP address -- When it finds one, LINK to that Incident -- If it does not find one, create a new Incident There will probably need to be a list of exclusions somewhere. For example if someone does a lookup on a domain we host and sends a complaint about it they might sent the domain name, the IP address it resolves to as well as the IP address of our name server. I wouldn't want every report that contained the IP address our name server linked to a common Incident. Also there's a what if here... What if they report two IP addresses that already each have an Incident created for them. Would I merge them all together into one Incident? Any ideas on where to start writing the action and reviewing the condition above would be appreciated. On or off list is fine with me. Thank you! -- Landon Stewart lstew...@superb.net SuperbHosting.Net by Superb Internet Corp. Toll Free (US/Canada): 888-354-6128 x 4199 Direct: 206-438-5879 Web hosting and more Ahead of the Rest: http://www.superbhosting.net -- Best regards, Ruslan.
Re: [rt-users] Tracking down rogue dashboard subscriptions
I ran the following command (figured out you meant --epoch, not --time :-) # /usr/local/rt/sbin/rt-email-dashboards --debug --epoch 1292849980 Using time Mon Dec 20 06:59:40 2010 Sending email from helpd...@cas.uab.edu [snip other users] Checking fabrizio's subscriptions: hour 06:00, dow Monday, dom 20 Checking against subscription with frequency never, hour 06:00, dow Monday, dom 1 [snip other users] # I could not trick it into sending the subscription. However, it did send it to me at 6am this morning, as it has been every morning. I notice that the debug output seems to think the subscription is only for dom 1. Yet I still get it every morning. -Fran
[rt-users] Can I add user info to ticket metadata?
Hello, Is it possible to include users Identity, Location and Phone numbers info in the ticket metadata? I know I can grant ShowConfigTab and AdminUsers to give access to this info, but I want access to be read only and, ideally, visible when a ticket is opened. Can this be done? Thanks. Lyle Tollefsen Network Administrator Innovation Place 114 - 15 Innovation Blvd Saskatoon, Sk. S7N 2X8 (P) 306-933-7243 (F) 306.933.8200 ltollef...@innovationplace.commailto:ltollef...@innovationplace.com www.innovationplace.com
Re: [rt-users] Can I add user info to ticket metadata?
On Mon, Dec 20, 2010 at 08:31:15AM -0600, Tollefsen, Lyle wrote: Hello, Is it possible to include users Identity, Location and Phone numbers info in the ticket metadata? I know I can grant ShowConfigTab and AdminUsers to give access to this info, but I want access to be read only and, ideally, visible when a ticket is opened. Can this be done? Thanks. Lyle Tollefsen Hi Lyle, We created custom fields to hold this information and then populate them during the initial ticket creation with scrips in order to keep a copy with the ticket. Cheers, Ken
Re: [rt-users] Can I add user info to ticket metadata?
On 20 Dec 2010 09:31, Tollefsen, Lyle wrote: Is it possible to include users Identity, Location and Phone numbers info in the ticket metadata? I know I can grant ShowConfigTab and AdminUsers to give access to this info, but I want access to be read only and, ideally, visible when a ticket is opened. Can this be done? You could easily do this in 3.8.8 by writing a callback for share/html/Ticket/Elements/ShowRequestor. The callback you'd want to hook is probably AboutThisUser. As a side note, RT 4.0 will have a much more configurable requestor display box. Thomas
[rt-users] Setting up RT 3.8.8 on CentOS 5.5
Hi RT Community, I have been having a difficulty in setting up RT on my CentOS [Apache2, mysql, postfix]. Its defaulting on FCGI while I want it to use mod-perl2. In my /tmp/rt-3.8.8. when I test my RT installation, [r...@rt_sys]# make testdeps /usr/bin/perl ./sbin/rt-test-dependencies --verbose --with-mysql --with-fastcgi perl: =5.8.3(5.8.8) ...found users: rt group (rt) ...found bin owner (root) ...found libs owner (root) ...found libs group (bin) ...found web owner (apache) ...found web group (apache) ...found CLI dependencies: ... The RT configure file doesn't give me options for mod_perl, only apachectl [r...@rt_sys]#./configure --with-mysql --with-modperl2 --with-apachectl configure: WARNING: unrecognized options: --with-mysql, --with-modperl2 configure: error: cannot find install-sh, install.sh, or shtool in . ./.. ./../.. Please help me pinpoint where I might be going wrong, or better, a guide to help me complete the installation from start to finish on CentOS. I have been using the root account (the only account on the system) in my installation... -- Regards, Gregory Okoth
Re: [rt-users] Are privileged users able to customize RT at a Glance?
On Fri, Dec 17, 2010 at 04:52:48PM -0500, sharon.belliv...@frb.gov wrote: We are running RT 3.8.7. Are privileged users allowed to customize their home page, RT at a Glance? Some thought they were able to with earlier versions but are unable to know. The Preferences option is missing as well. Have we disable some right(s)? If so, how can we enable folks to customize their home pages and preferences? You appear to have removed ModifySelf for those users -kevin pgp7qZZnsmwcN.pgp Description: PGP signature
[rt-users] advanced search w/ a sql call
Hello, I'd like to search for tickets created w/in the past 7 days which can be done easily enough by creating a query where Created after some day, Created '2010-12-13'. I'd like to make this more dynamic so I go into Advanced and change the Query to Created date_add(current_date, interval - 7 day) and when I apply the changes I'm left on the Advanced query page and the format has been wiped out. Not what I was hoping for. Are you allowed to enter straight SQL through the interface like this to make dynamic queries? Certainly I can see why this would not be allowed since it could lead to sql injection but I'm curious. Also, is there a way to save such a report so I could just point to a URL or something of that nature to fire it off? Basically my manager wants a weekly report of all the tickets entered into RT and I'm trying to automate the creation of the report I give him. Thanks! RT 3.8.8 w/mysql -- Darin Perusich Email: darin.perus...@ctg.com Office: 716-888-3690 Cell: 716-807-4589 The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you are not the intended recipient of this message, please contact the sender and delete this material from this computer.
Re: [rt-users] Tracking down rogue dashboard subscriptions
On 10/12/20 9:05, Francis L Fabrizio wrote: I ran the following command (figured out you meant --epoch, not --time :-) My bad. Internally the code uses time instead of epoch. # /usr/local/rt/sbin/rt-email-dashboards --debug --epoch 1292849980 Using time Mon Dec 20 06:59:40 2010 Sending email from helpd...@cas.uab.edu [snip other users] Checking fabrizio's subscriptions: hour 06:00, dow Monday, dom 20 Checking against subscription with frequency never, hour 06:00, dow Monday, dom 1 [snip other users] # I could not trick it into sending the subscription. However, it did send it to me at 6am this morning, as it has been every morning. I notice that the debug output seems to think the subscription is only for dom 1. Yet I still get it every morning. The dow and dom attributes only apply when the subscription is weekly or monthly. But your subscription is never so they don't apply. I'm especially stumped now that you can't get it to send you mail even though you're running rt-email-dashboards manually. Can you change your subscription in RT -- especially the hour -- to see if that affects the dashboard mail you shouldn't be getting? Are you comfortable with forwarding me personally a copy of the dashboard email (sar...@bestpractical.com) after removing identifying information? Thanks, Shawn
Re: [rt-users] advanced search w/ a sql call
On Mon, Dec 20, 2010 at 11:38:35AM -0500, Darin Perusich wrote: Hello, I'd like to search for tickets created w/in the past 7 days which can be done easily enough by creating a query where Created after some day, Created '2010-12-13'. I'd like to make this more dynamic so I go into Advanced and change the Query to Created date_add(current_date, interval - 7 day) and when I apply the changes I'm left on the Advanced query page and the format has been wiped out. Not what I was hoping for. Are you allowed to enter straight SQL through the interface like this to make dynamic queries? Certainly I can see why this would not be allowed since it could lead to sql injection but I'm curious. Also, is there a way to save such a report so I could just point to a URL or something of that nature to fire it off? Basically my manager wants a weekly report of all the tickets entered into RT and I'm trying to automate the creation of the report I give him. Thanks! RT 3.8.8 w/mysql You should be able to use something like 7 days ago or -7 days in the query. Cheers, Ken
Re: [rt-users] advanced search w/ a sql call
Use a dashboard (suing a saved search with the time limit as Ken says) with a subscription to fire it off to your boss. Steve -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Marshall Sent: 20 December 2010 17:56 To: Darin Perusich Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] advanced search w/ a sql call On Mon, Dec 20, 2010 at 11:38:35AM -0500, Darin Perusich wrote: Hello, I'd like to search for tickets created w/in the past 7 days which can be done easily enough by creating a query where Created after some day, Created '2010-12-13'. I'd like to make this more dynamic so I go into Advanced and change the Query to Created date_add(current_date, interval - 7 day) and when I apply the changes I'm left on the Advanced query page and the format has been wiped out. Not what I was hoping for. Are you allowed to enter straight SQL through the interface like this to make dynamic queries? Certainly I can see why this would not be allowed since it could lead to sql injection but I'm curious. Also, is there a way to save such a report so I could just point to a URL or something of that nature to fire it off? Basically my manager wants a weekly report of all the tickets entered into RT and I'm trying to automate the creation of the report I give him. Thanks! RT 3.8.8 w/mysql You should be able to use something like 7 days ago or -7 days in the query. Cheers, Ken __ This email has been scanned by Netintelligence http://www.netintelligence.com/email BiP Solutions Limited is a company registered in Scotland with Company Number SC086146 and VAT number 383030966 and having its registered office at Medius, 60 Pacific Quay, Glasgow, G51 1DZ. This e-mail (and any attachment) is intended only for the attention of the addressee(s). Its unauthorised use, disclosure, storage or copying is not permitted. If you are not the intended recipient, please destroy all copies and inform the sender by return e-mail. This e-mail (whether you are the sender or the recipient) may be monitored, recorded and retained by BiP Solutions Ltd. E-mail monitoring/ blocking software may be used, and e-mail content may be read at any time.You have a responsibility to ensure laws are not broken when composing or forwarding e-mails and their contents.
Re: [rt-users] Setting up RT 3.8.8 on CentOS 5.5
The args between ./configure and rt-test-dependencies don't have the same syntax. Read this carefully. http://requesttracker.wikia.com/wiki/ManualInstallation On 12/20/10 9:15 AM, Gregory Greafers wrote: Hi RT Community, I have been having a difficulty in setting up RT on my CentOS [Apache2, mysql, postfix]. Its defaulting on FCGI while I want it to use mod-perl2. In my /tmp/rt-3.8.8. when I test my RT installation, [r...@rt_sys]# make testdeps /usr/bin/perl ./sbin/rt-test-dependencies --verbose --with-mysql --with-fastcgi perl: =5.8.3(5.8.8) ...found users: rt group (rt) ...found bin owner (root) ...found libs owner (root) ...found libs group (bin) ...found web owner (apache) ...found web group (apache) ...found CLI dependencies: ... The RT configure file doesn't give me options for mod_perl, only apachectl [r...@rt_sys mailto:r...@rt_sys]#./configure --with-mysql --with-modperl2 --with-apachectl configure: WARNING: unrecognized options: --with-mysql, --with-modperl2 configure: error: cannot find install-sh, install.sh, or shtool in . ./.. ./../.. Please help me pinpoint where I might be going wrong, or better, a guide to help me complete the installation from start to finish on CentOS. I have been using the root account (the only account on the system) in my installation... -- Regards, *Gregory Okot**h* -- John Arends jare...@illinois.edu Network Analyst College of ACES ITCS University of Illinois at Urbana-Champaign
Re: [rt-users] Setting up RT 3.8.8 on CentOS 5.5
On Mon, Dec 20, 2010 at 06:15:47PM +0300, Gregory Greafers wrote: Hi RT Community, I have been having a difficulty in setting up RT on my CentOS [Apache2, mysql, postfix]. Its defaulting on FCGI while I want it to use mod-perl2. In my /tmp/rt-3.8.8. when I test my RT installation, [r...@rt_sys]# make testdeps /usr/bin/perl ./sbin/rt-test-dependencies --verbose --with-mysql --with-fastcgi perl: =5.8.3(5.8.8) ...found users: rt group (rt) ...found bin owner (root) ...found libs owner (root) ...found libs group (bin) ...found web owner (apache) ...found web group (apache) ...found CLI dependencies: ... The RT configure file doesn't give me options for mod_perl, only apachectl [[1]r...@rt_sys]#./configure --with-mysql --with-modperl2 --with-apachectl run ./configure --help to get a sense of the correct options. -kevin configure: WARNING: unrecognized options: --with-mysql, --with-modperl2 configure: error: cannot find install-sh, install.sh, or shtool in . ./.. ./../.. Please help me pinpoint where I might be going wrong, or better, a guide to help me complete the installation from start to finish on CentOS. I have been using the root account (the only account on the system) in my installation... pgpSkGELSILS5.pgp Description: PGP signature