Sys Notifications - Adding Fields

2009-06-24 Thread Scott Fluegge
All, I have two hot issues and both are being denied support by my BMC partner because they call them customizations. Can someone please help me out? We are desperate here. I will open them in two mails as they are not directly related. This first issue is with Sys Notifications. We

3rd issue - This time it is the Requester Console - Adding a third tier

2009-06-24 Thread Scott Fluegge
All, I lied when I said I had 2 issues. I forgot one. We are looking to implement the requester console. Problem is, the two tier Q/A that is out of the box won't work. We need 3. My Admin was able to add the three and it looks great. Only issue is now when you select save, no incident

Another Email issue, this time in SLM

2009-06-24 Thread Scott Fluegge
OK, here is my second issue which again BMC will not support. We have some tricky escalation rules for SLM. We know that. We were able to write some logic through the help desk forms and filters to figure out where the next escalation is to go. Now what I need to do is EMAIL those people

Re: AW: Remedy 7.0 issue with Direct SQL in a filter

2009-06-04 Thread Scott Fluegge
$') + 1, Len('$Assigned Group$' + 't...@client.com'), SLM_EMAIL_BCC = 'serviced...@gssamerica.com' where (Incident_Number = '$Incident Number$' and (upper('$Assigned Group$') like upper('%Tier 4%'))) Thanks, Scott Scott Fluegge CIO Sr. VP of Operations GSS America Infotech Ltd., A SEI-CMMI LevelĀ 3

Remedy 7.0 issue with Direct SQL in a filter

2009-06-03 Thread Scott Fluegge
Anyone able to help me on a potentially simple Remedy question that has my team stumped? This is in regards to a Remedy customization we need to do in our environment. It is with respect to custom filters invoking Direct SQL (MS SQL 2005 database). The SQL works PERFECT from the enterprise