JOB: Remedy Contract - London
Job: Cubicegg requires 3 contract remedy developers (v5.x+) with mid-tier and architecture experience for 6 month contract in London. Please call me direct on 0044 (0) 7952 145 127 to discuss or send me a mail ([EMAIL PROTECTED]). Happy New Year! James . . . . . . . . James Tobin Cubicegg +44 (0) 870 720 1074 - office To learn more about Cubicegg please visit our website at http://www.cubicegg.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Need help constructing a URL
Hi, I wrote this simple url builder utility, to create mid tier and flashboard urls thanks, Samir On 12/27/06, Lucero, Michelle - IST contractor [EMAIL PROTECTED] wrote: ** Hi, Candace and Jenni: Not sure if this has been answered for you. http://midtier host/arsys/forms/ar server/HPD%3AHelpDesk/Support/?eid=H123456 Hope that helps, Michelle -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Candace DeCou *Sent:* Tuesday, December 26, 2006 6:09 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Need help constructing a URL ** WOW! It looks like I'm not the only one needing this help and thanks to so many of you for ALL your help…now I think I know several ways to attempt this. I must have been working too hard to pay attention to all the great responses. Thanks again to each and every one of you – all you crazies out there working day after Christmas…yikes! Happy Holidays! J Candace -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Wacholz, Jeanette (Jenni) *Sent:* Tuesday, December 19, 2006 9:42 AM *To:* arslist@ARSLIST.ORG *Subject:* Need help constructing a URL Happy Holidays, Listers! The following URL will take me directly (after stopping for login, which is fine) to a HelpDesk search window. http://servername/mid-tier/forms/server/HPD%3AHelpDesk/Support/http://%3cservername%3e/mid-tier/forms/%3cserver%3e/HPD%3AHelpDesk/Support/ What do I need to add to it to take me directly to a specific ticket #, for example HD123456? Or is it not that simple? Jenni Wacholz 480-445-2517 Remedy Administrator Coventry Health Care Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. __20060125___This posting was submitted with HTML in it___ -- * This message contains information from Silicon Valley Bank, or from one of its affiliates, that may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify the sender immediately by telephone or by replying to this transmission. This message may include indicative rate information relating to one or more products offered through Silicon Valley Bank, or affiliated broker-dealer, SVB Securities. Rates and yields shown are provided for informational purposes only, are not guaranteed, and are subject to market conditions and availability. Nothing in this communication shall constitute a solicitation or recommendation to buy or sell a particular security. Columbia Cash Reserves, Columbia Treasury Reserves, Columbia Institutional Cash Reserves, SVB Securities Liquid Reserves, SVB Securities Institutional Liquid Reserves and SVB Securities Horizon Shares are offered through SVB Securities, a registered broker- dealer and non-bank affiliate of Silicon Valley Bank. Investments in these products require the involvement of a licensed representative of SVB Securities. Investment products offered through SVB Securities are not insured by the FDIC or any other Federal Government Agency, are not deposits of or guaranteed by Silicon Valley Bank or its affiliates, and may lose value. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are Mid Tier URL Flashboard URL Mid Tier name (e.g) localhost Port Server Web Context (e.g) arsys Application Form Name (e.g) User View Entry id Mid Tier Version 6.3 7.x
Re: Need help constructing a URL
Thank you for sharing that! It is very much appreciated. Jenni Wacholz 480-445-2517 Remedy Administrator Coventry Health Care From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sam Rx Sent: Wednesday, January 03, 2007 5:13 AM To: arslist@ARSLIST.ORG Subject: Re: Need help constructing a URL ** Hi, I wrote this simple url builder utility, to create mid tier and flashboard urls thanks, Samir On 12/27/06, Lucero, Michelle - IST contractor [EMAIL PROTECTED] wrote: ** Hi, Candace and Jenni: Not sure if this has been answered for you. http://midtier host/arsys/forms/ar server/HPD%3AHelpDesk/Support/?eid=H123456 Hope that helps, Michelle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Candace DeCou Sent: Tuesday, December 26, 2006 6:09 PM To: arslist@ARSLIST.ORG Subject: Re: Need help constructing a URL ** WOW! It looks like I'm not the only one needing this help and thanks to so many of you for ALL your help...now I think I know several ways to attempt this. I must have been working too hard to pay attention to all the great responses. Thanks again to each and every one of you - all you crazies out there working day after Christmas...yikes! Happy Holidays! :-) Candace From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Wacholz, Jeanette (Jenni) Sent: Tuesday, December 19, 2006 9:42 AM To: arslist@ARSLIST.ORG Subject: Need help constructing a URL Happy Holidays, Listers! The following URL will take me directly (after stopping for login, which is fine) to a HelpDesk search window. http://servername/mid-tier/forms/server/HPD%3AHelpDesk/Support/ http://%3cservername%3e/mid-tier/forms/%3cserver%3e/HPD%3AHelpDesk/Supp ort/ What do I need to add to it to take me directly to a specific ticket #, for example HD123456? Or is it not that simple? Jenni Wacholz 480-445-2517 Remedy Administrator Coventry Health Care Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. __20060125___This posting was submitted with HTML in it___ * This message contains information from Silicon Valley Bank, or from one of its affiliates, that may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify the sender immediately by telephone or by replying to this transmission. This message may include indicative rate information relating to one or more products offered through Silicon Valley Bank, or affiliated broker-dealer, SVB Securities. Rates and yields shown are provided for informational purposes only, are not guaranteed, and are subject to market conditions and availability. Nothing in this communication shall constitute a solicitation or recommendation to buy or sell a particular security. Columbia Cash Reserves, Columbia Treasury Reserves, Columbia Institutional Cash Reserves, SVB Securities Liquid Reserves, SVB Securities Institutional Liquid Reserves and SVB Securities Horizon Shares are offered through SVB Securities, a registered broker- dealer and non-bank affiliate of Silicon Valley Bank. Investments in these products require the involvement of a licensed representative of SVB Securities. Investment products offered through SVB Securities are not insured by the FDIC or any other Federal Government Agency, are not deposits of or guaranteed by Silicon Valley Bank or its affiliates, and may lose value.
Re: Need help constructing a URL
Very nice :-) I'll have to try it later. Thanks, Dan From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sam Rx Sent: Wednesday, January 03, 2007 7:13 AM To: arslist@ARSLIST.ORG Subject: Re: Need help constructing a URL ** Hi, I wrote this simple url builder utility, to create mid tier and flashboard urls thanks, Samir On 12/27/06, Lucero, Michelle - IST contractor [EMAIL PROTECTED] wrote: ** Hi, Candace and Jenni: Not sure if this has been answered for you. http://midtier host/arsys/forms/ar server/HPD%3AHelpDesk/Support/?eid=H123456 Hope that helps, Michelle From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG ] On Behalf Of Candace DeCou Sent: Tuesday, December 26, 2006 6:09 PM To: arslist@ARSLIST.ORG Subject: Re: Need help constructing a URL ** WOW! It looks like I'm not the only one needing this help and thanks to so many of you for ALL your help...now I think I know several ways to attempt this. I must have been working too hard to pay attention to all the great responses. Thanks again to each and every one of you - all you crazies out there working day after Christmas...yikes! Happy Holidays! :-) Candace From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Wacholz, Jeanette (Jenni) Sent: Tuesday, December 19, 2006 9:42 AM To: arslist@ARSLIST.ORG Subject: Need help constructing a URL Happy Holidays, Listers! The following URL will take me directly (after stopping for login, which is fine) to a HelpDesk search window. http://servername/mid-tier/forms/server/HPD%3AHelpDesk/Support/ http://%3cservername%3e/mid-tier/forms/%3cserver%3e/HPD%3AHelpDesk/Supp ort/ What do I need to add to it to take me directly to a specific ticket #, for example HD123456? Or is it not that simple? Jenni Wacholz 480-445-2517 Remedy Administrator Coventry Health Care Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA). The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer. __20060125___This posting was submitted with HTML in it___ * This message contains information from Silicon Valley Bank, or from one of its affiliates, that may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify the sender immediately by telephone or by replying to this transmission. This message may include indicative rate information relating to one or more products offered through Silicon Valley Bank, or affiliated broker-dealer, SVB Securities. Rates and yields shown are provided for informational purposes only, are not guaranteed, and are subject to market conditions and availability. Nothing in this communication shall constitute a solicitation or recommendation to buy or sell a particular security. Columbia Cash Reserves, Columbia Treasury Reserves, Columbia Institutional Cash Reserves, SVB Securities Liquid Reserves, SVB Securities Institutional Liquid Reserves and SVB Securities Horizon Shares are offered through SVB Securities, a registered broker- dealer and non-bank affiliate of Silicon Valley Bank. Investments in these products require the involvement of a licensed representative of SVB Securities. Investment products offered through SVB Securities are not insured by the FDIC or any other Federal Government Agency, are not deposits of or guaranteed by Silicon Valley Bank or its affiliates, and may lose value. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
ITSM 7 Patch 9001
Just noticed these on the patch page for PM/IM, AM CM. They're listed as ITSM 7 upgrade utilities, though I'll dig deeper when I can actually download them tonight. Anyone actually use them yet? -- Rick Cook Cook Enterprises 253-278-4112 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Push fields failing
Thanks guys. Seems it's actually a problem with an escaltion using Application-Delete-Entry which is deleting records it shouldn't be, I'll investigate this seperately. As for the 0=1 qualification, I understood that this only performs a full table scan on Oracle for certain versions of Oracle. I'll go through ours and get rid anyway. Cheers ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
ITSM7 patch 9002 - Task template add-on!
Found this poking around on the patch site this morning... Not listed in the smbu patch form, you need to browse the ftp site. BMC® Remedy® Incident Management 7.0 Task Template Add-on Installation Guide BMC Remedy Incident Management 7.0 Task Template Add-on Installation Guide describes how to install the new task template add-on for BMC Remedy Incident Management 7.0. -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2
Thanks you Axton, Patrick, Lars!!! We really appreciate the input so far and I've taken these suggestions to the powers that be for discussion!! I look forward to any other ideas that may be out there! Thank you all again!! Shawn Stonequist EMNS, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ITSM 7 Patch 9001
Rick - It's just a set of pdfs explaining the possibilties for migration. No actual tool is included. It's mostly marketing material pushing professional services. The release of 7.0 has created significant interest amongst the customer base and many customers have been awaiting this tool to begin the migration process. As an initial step to assist in the migration process and ensure a good migration success rate, BMC offers customers the opportunity to consult BMC Professional Services or a qualified BMC partner. What do you need to know prior to beginning the migration of your current production system?... One benefit of contacting BMC Professional Services and/or a qualified BMC Partner is that BMC Professional Services has developed a Sure Start package offering a proven implementation methodology. Similarly, our approved partners have their own methodologies. Both will have tools to assist in the migration process. BMC Professional Services offers the SureStart for ITSM 7.x Migrations. This service package was built to help customers eliminate some of that risk and start your initiative off the right way. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Rick Cook [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/03/2007 08:35 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject ITSM 7 Patch 9001 ** Just noticed these on the patch page for PM/IM, AM CM. They're listed as ITSM 7 upgrade utilities, though I'll dig deeper when I can actually download them tonight. Anyone actually use them yet? -- Rick Cook Cook Enterprises 253-278-4112 __20060125___This posting was submitted with HTML in it___ CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Suppressing Web Service errors.
We call our external web services in escalations and have those external web services setup to return an error code which we store in a field on the Remedy form. We can then use filters on this field to trigger a notification or open a ticket if certain known unrecoverable errors occur that would need manual intervention. If it's a recoverable error we simply let the escalation retry it during the next cycle. It works pretty well and prevents users from ever getting errors that would stop them from saving a ticket. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michael Worts Sent: Friday, December 22, 2006 9:24 AM To: arslist@ARSLIST.ORG Subject: Fw: Suppressing Web Service errors. ** Hi again, I am really struggling to find a solution for this one. I have tried executing the Web Service form an Escalation and it did suppress the error message but only because the escalation failed, which meant I never got my failure message. Any ideas? Half ideas? Mike. Michael Worts Remedy Specialist IGS, Business Consulting Services ITIL Service Manager Certified Tel: +44 (0)1962 822273 Mob: +44 (0)7801 755346 Internet: [EMAIL PROTECTED] - Forwarded by Michael Worts/UK/Contr/IBM on 22/12/2006 15:08 - Michael Worts/UK/Contr/IBM 21/12/2006 23:28 To arslist@arslist.org cc Subject Suppressing Web Service errors. Hello everyone, I would like the ability to suppress any error messages that are returned from my Web Services call. Say for example, if the web service I call is unavailable for whatever reason, I do not want the error to appear on the screen. I would prefer to do the error handling through workflow, it is much neater. Any ideas? Many thanks, Michael. AR 6.3 Patch 11, Oracle 9i, AIX 5.2 __20060125___This posting was submitted with HTML in it___ * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ITSM 7 Patch 9001
Hmmm...figures. Well, it's nice to know that marketing is still going strong, since most of my customers couldn't even tell me who their BMC sales reps are, much less the last time they actually saw them Rick On 1/3/07, Tony Worthington [EMAIL PROTECTED] wrote: Rick - It's just a set of pdfs explaining the possibilties for migration. No actual tool is included. It's mostly marketing material pushing professional services. The release of 7.0 has created significant interest amongst the customer base and many customers have been awaiting this tool to begin the migration process. As an initial step to assist in the migration process and ensure a good migration success rate, BMC offers customers the opportunity to consult BMC Professional Services or a qualified BMC partner. What do you need to know prior to beginning the migration of your current production system?... One benefit of contacting BMC Professional Services and/or a qualified BMC Partner is that BMC Professional Services has developed a Sure Start package offering a proven implementation methodology. Similarly, our approved partners have their own methodologies. Both will have tools to assist in the migration process. BMC Professional Services offers the SureStart for ITSM 7.x Migrations. This service package was built to help customers eliminate some of that risk and start your initiative off the right way. -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 Rick Cook [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 01/03/2007 08:35 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject ITSM 7 Patch 9001 ** Just noticed these on the patch page for PM/IM, AM CM. They're listed as ITSM 7 upgrade utilities, though I'll dig deeper when I can actually download them tonight. Anyone actually use them yet? -- Rick Cook Cook Enterprises 253-278-4112 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2
I worked with a DB once, don't remember which one (may have been Oracle) that allowed query monitoring to be turned on at the DB level and you could turn it on for a week or so and it would report to you the heaviest queries taking place during its monitoring time. I seem to remember it being a bit of a performance hit...but you can't do that type of thing without impacting performance -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Wednesday, January 03, 2007 7:57 AM To: arslist@ARSLIST.ORG Subject: Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2 Thanks you Axton, Patrick, Lars!!! We really appreciate the input so far and I've taken these suggestions to the powers that be for discussion!! I look forward to any other ideas that may be out there! Thank you all again!! Shawn Stonequist EMNS, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2
We have an active link on our biggest forms that checks the Advanced
Search Criteria field (ID 1005) along with some combinations of our
other fields. Something like this:
'Search Criteria' = $NULL$
AND
(
('Description' != $NULL$ OR 'Work Log' != $NULL$ OR 'Solution' !=
$NULL$)
AND
('Assignee' = $NULL$ AND 'User ID' = $NULL$ AND 'Create Date' =
$NULL$)
)
We have about 20 fields indexed on one big form and we actually check to
make sure that one of them has a value. If all of them are null, and
they specify something in a large text field, and the advanced search is
null, then we throw an error. I realize the advanced search still gives
them free reign to do whatever they want, but most of the people who
don't know how to form a good search also don't know how to use the
advanced search bar. It's the ones who know enough to try using the
advanced search but do so very poorly that still hurt us from time to
time. But this workflow cuts out a lot of bad QBE searches.
Chad Hall
(501) 342-2650
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: Wednesday, January 03, 2007 8:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance Issues caused by User Queries - Remedy
6.3/Oracle 10.0.2
Thanks you Axton, Patrick, Lars!!!
We really appreciate the input so far and I've taken these suggestions
to
the powers that be for discussion!!
I look forward to any other ideas that may be out there!
Thank you all again!!
Shawn Stonequist
EMNS, Inc.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are
*
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Answers Are
Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2
Oracle keeps stats on all active sessions. Since db connections from Remedy
are persistent, you can see what the heaviest sql is from the db side.
These are things your dba should know how to use/interpret. These are some
of the stats I find useful at times:
-- Disk Intensive SQL - origmod
set wrap on
set linesize 250
set pagesize 1000
column username format a20
column sql_text format a64
select a.USERNAME,
DISK_READS,
EXECUTIONS,
round(DISK_READS / decode(EXECUTIONS, 0, 1, EXECUTIONS)) Reads/Execs,
v$sqltext.SQL_TEXT
from dba_users a,
v$session,
v$sqlarea,
v$sqltext
where PARSING_USER_ID=USER_ID and
v$sqlarea.address = v$sqltext.address and
v$sqlarea.hash_value = v$sqltext.hash_value
and v$sqlarea.ADDRESS=SQL_ADDRESS(+)
and DISK_READS 1
order by DISK_READS desc, EXECUTIONS desc, piece asc;
-- Buffer Scan Intensive SQL
set wrap on
set linesize 250
set pagesize 1000
column sql_text format a80
select executions,
round(disk_reads / decode(executions, 0, 1, executions) / 400,2) as
Response,
sql_text
from v$sqlarea
where buffer_gets / decode(executions,0,1, executions) / 400 10
order by executions desc;
-- Shared Pool SQL With Most Loads
set wrap on
set linesize 250
set pagesize 1000
column sql_text format a80
select executions,
sql_text
from v$sqlarea
where loads 50
order by executions desc;
-- Wait Statistics
set wrap on
set linesize 250
set pagesize 1000
select class,
count,
time
from v$waitstat;
-- Disk Sorts
set wrap on
set linesize 250
set pagesize 1000
select name,
value
from v$sysstat
where name like 'sort%';
-- Tables With Questionable Indexes
set wrap on
set linesize 250
set pagesize 1000
column table_owner format a20
column table_name format a40
column column_name format a20
select table_owner,
table_name,
column_name
from all_ind_columns
where column_position=1
group by table_owner,
table_name,
column_name
having count(*) 1;
-- Buffer Cache hit Rate
select 100*(cur.value+con.value-phys.value)/(cur.value+con.value)
from v$sysstat cur,
v$sysstat con,
v$sysstat phys,
v$statname ncu,
v$statname nco,
v$statname nph
where cur.statistic# = ncu.statistic#
and ncu.name = 'db block gets'
and con.statistic# = nco.statistic#
and nco.name = 'consistent gets'
and phys.statistic# = nph.statistic#
and nph.name = 'physical reads';
Axton Grams
On 1/3/07, Hall Chad - chahal [EMAIL PROTECTED] wrote:
We have an active link on our biggest forms that checks the Advanced
Search Criteria field (ID 1005) along with some combinations of our
other fields. Something like this:
'Search Criteria' = $NULL$
AND
(
('Description' != $NULL$ OR 'Work Log' != $NULL$ OR 'Solution' !=
$NULL$)
AND
('Assignee' = $NULL$ AND 'User ID' = $NULL$ AND 'Create Date' =
$NULL$)
)
We have about 20 fields indexed on one big form and we actually check to
make sure that one of them has a value. If all of them are null, and
they specify something in a large text field, and the advanced search is
null, then we throw an error. I realize the advanced search still gives
them free reign to do whatever they want, but most of the people who
don't know how to form a good search also don't know how to use the
advanced search bar. It's the ones who know enough to try using the
advanced search but do so very poorly that still hurt us from time to
time. But this workflow cuts out a lot of bad QBE searches.
Chad Hall
(501) 342-2650
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist
Sent: Wednesday, January 03, 2007 8:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance Issues caused by User Queries - Remedy
6.3/Oracle 10.0.2
Thanks you Axton, Patrick, Lars!!!
We really appreciate the input so far and I've taken these suggestions
to
the powers that be for discussion!!
I look forward to any other ideas that may be out there!
Thank you all again!!
Shawn Stonequist
EMNS, Inc.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are
*
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where
the Answers Are
Re: arimportcmd
Okso Carey helped me with this offline...and it took a few days to get right...but here it is ARS 6.3 Windows 2003 Situation, I have users wanting to do a two step batch upload of data into the DB. Step 1 is specify a file to import and get it imported. If no errors are reported on import then process the records into their destination form. To accomplish this I built two forms, one is a console that has a few buttons to allow for adding attachments and loading the data, an attachment pool with two fields in it...one for the batch upload file and the other for the import log if there are errors and a table field to show the records that are imported. Here are the steps I take to get the file in. 1. Use button to attach file to form 2. Use button to set a checkbox and create a Remedy record in the console - I create a record on the console so that I can use filters to perform the import and such...I know I could use AL's...but I didn't want to in this case 3. On Create or Set of console record if the checkbox is checked I use filters to save the attachment to the server in a designated area with the name $GUID$.csv...$GUID$ being the name of field ID 179 4. Next filter fires off a setfield $PROCESS$ to execute the attached perl script, I'll go into the details later..but if the import encounters errors it will return a value of 1 from the setfields. 5. If previous filter caused an int field to be set to 1 I attach the log file to the console record in the second attachment field and then delete the log from the server...in the else action (no errors) I just delete the import log That's it for the remedy side...the real magic happens in the perl file and what it does with the arm file. Before you can import of course you must create your ARM file using Remedy Import GUI tool. Once the ARM is created with the appropriate mappings be sure to map the parentID field to some static value...I used ParentGUID as the static value. Now go in with a text editor and edit your arm file...the first line of the mapping is the 'mapping name', I set that to the same value as my static parent mapping so that the perl script can replace them with the same search string. I also modify the ServerName line so that this mapping can be used on the dev and production machines without mod ParentGUID ServerName: servername Mapping: field ID of relationship field=ParentGUID The perl script accepts two parameters...could be modified to accept more if you didn't want to hard code some of the hard coded values... Parm 1 - GUID Parm 2 - Server I believe that the script is commented well enough to allow you to modify it to meet your needs. There is obviously more workflow to push the records into the destination form once validation has occurred...but this is the method I used (thanks Carey) to import records associated with my parent record when the csv did not explicitly reference the parent record. Feel free to ask any questions -Original Message- From: L. J. Head [mailto:[EMAIL PROTECTED] Sent: Friday, December 29, 2006 11:23 AM To: 'arslist@ARSLIST.ORG' Subject: RE: arimportcmd Thank you Carey...if you could assist a bit more I like the idea you presented in 1...and I had considered it...but am not skilled enough personally to create this file. I am saving the csv file to the server with the name of the GUID of the record in form A. Perl is my preferred scripting language so if you have expertise in that I would appreciate your help writing that script. I assume it would go something like this Copy template mapping to guid.arm Edit guid.arm to change the name of it to some 8 digit equivalent of the guid Save the new guid.arm file Run arimport with appropriate command line syntax for new arm Does that sound about right? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, December 29, 2006 10:56 AM To: arslist@ARSLIST.ORG Subject: Re: arimportcmd L.J., RE: Is there something that can be done with the mapping to allow mapping a field not in the file with a command line argument? Not to my knowledge. However here are a few ideas 1) Edit the mapping file before you call arimportcmd. (This could be scripted so that you call a wrapper script that does this and then calls arimportcmd too.) 2) Edit the CSV file before import. 3) Do a second import (maybe to a display only form) so you can do one or more push actions to map the records that are not yet mapped to the record that had the CSV file. 4) On import(MERGE) have a filter look up the record that spawned the import process. (Assuming that this will be automated and that the import process is done via a Run Process action.) Note: If you can not do a select of Form A based on the data in the file then you might need to create a queue/log form that holds a record that says Form A, Entry 001 is waiting for it's CSV children
Re: Suppressing Web Service errors.
Chad, Funny enough, that is exactly what I have developed. I have an escalation that tests the web service (every 1 minute) and returns a timestamp. If there are any errors, the escalation fails and does not return the timestamp. I have not been able to get the web service to return an actual error code or message, it just fails and the error appears in the escalation log. How have you managed to capture the error? As you said, if there is a problem with the web service at least it does not stop the user from logging the record. I have another escalation that keeps retrying the failed records. Many thanks for your response. Mike. Michael Worts Remedy Specialist IGS, Business Consulting Services ITIL Service Manager Certified Tel: +44 (0)1962 822273 Mob: +44 (0)7801 755346 Internet: [EMAIL PROTECTED] Hall Chad - chahal [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/01/2007 15:02 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Suppressing Web Service errors. ** We call our external web services in escalations and have those external web services setup to return an error code which we store in a field on the Remedy form. We can then use filters on this field to trigger a notification or open a ticket if certain known unrecoverable errors occur that would need manual intervention. If it?s a recoverable error we simply let the escalation retry it during the next cycle. It works pretty well and prevents users from ever getting errors that would stop them from saving a ticket. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michael Worts Sent: Friday, December 22, 2006 9:24 AM To: arslist@ARSLIST.ORG Subject: Fw: Suppressing Web Service errors. ** Hi again, I am really struggling to find a solution for this one. I have tried executing the Web Service form an Escalation and it did suppress the error message but only because the escalation failed, which meant I never got my failure message. Any ideas? Half ideas? Mike. Michael Worts Remedy Specialist IGS, Business Consulting Services ITIL Service Manager Certified Tel: +44 (0)1962 822273 Mob: +44 (0)7801 755346 Internet: [EMAIL PROTECTED] - Forwarded by Michael Worts/UK/Contr/IBM on 22/12/2006 15:08 - Michael Worts/UK/Contr/IBM 21/12/2006 23:28 To arslist@arslist.org cc Subject Suppressing Web Service errors. Hello everyone, I would like the ability to suppress any error messages that are returned from my Web Services call. Say for example, if the web service I call is unavailable for whatever reason, I do not want the error to appear on the screen. I would prefer to do the error handling through workflow, it is much neater. Any ideas? Many thanks, Michael. AR 6.3 Patch 11, Oracle 9i, AIX 5.2 __20060125___This posting was submitted with HTML in it___ * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. * __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Suppressing Web Service errors.
Well, we actually have a separate middleware layer that is almost always available. That's actually the web service that Remedy calls. That middleware web service then turns around and calls the appropriate external web service and returns any error messages it gets back to Remedy. So as long as our middleware web service is running it works fine. It took a lot of coordination though to get that middleware web service setup to handle all the data that could come through it and make sure, based on some of that data, that it gets sent to the correct external web service. Our middleware web service uses the Java API to communicate with Remedy. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michael Worts Sent: Wednesday, January 03, 2007 10:35 AM To: arslist@ARSLIST.ORG Subject: Re: Suppressing Web Service errors. ** Chad, Funny enough, that is exactly what I have developed. I have an escalation that tests the web service (every 1 minute) and returns a timestamp. If there are any errors, the escalation fails and does not return the timestamp. I have not been able to get the web service to return an actual error code or message, it just fails and the error appears in the escalation log. How have you managed to capture the error? As you said, if there is a problem with the web service at least it does not stop the user from logging the record. I have another escalation that keeps retrying the failed records. Many thanks for your response. Mike. Michael Worts Remedy Specialist IGS, Business Consulting Services ITIL Service Manager Certified Tel: +44 (0)1962 822273 Mob: +44 (0)7801 755346 Internet: [EMAIL PROTECTED] Hall Chad - chahal [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 03/01/2007 15:02 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Suppressing Web Service errors. ** We call our external web services in escalations and have those external web services setup to return an error code which we store in a field on the Remedy form. We can then use filters on this field to trigger a notification or open a ticket if certain known unrecoverable errors occur that would need manual intervention. If it's a recoverable error we simply let the escalation retry it during the next cycle. It works pretty well and prevents users from ever getting errors that would stop them from saving a ticket. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michael Worts Sent: Friday, December 22, 2006 9:24 AM To: arslist@ARSLIST.ORG Subject: Fw: Suppressing Web Service errors. ** Hi again, I am really struggling to find a solution for this one. I have tried executing the Web Service form an Escalation and it did suppress the error message but only because the escalation failed, which meant I never got my failure message. Any ideas? Half ideas? Mike. Michael Worts Remedy Specialist IGS, Business Consulting Services ITIL Service Manager Certified Tel: +44 (0)1962 822273 Mob: +44 (0)7801 755346 Internet: [EMAIL PROTECTED] - Forwarded by Michael Worts/UK/Contr/IBM on 22/12/2006 15:08 - Michael Worts/UK/Contr/IBM 21/12/2006 23:28 To arslist@arslist.org cc Subject Suppressing Web Service errors. Hello everyone, I would like the ability to suppress any error messages that are returned from my Web Services call. Say for example, if the web service I call is unavailable for whatever reason, I do not want the error to appear on the screen. I would prefer to do the error handling through workflow, it is much neater. Any ideas? Many thanks, Michael. AR 6.3 Patch 11, Oracle 9i, AIX 5.2 __20060125___This posting was submitted with HTML in it___ * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. * __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Re: Need help constructing a URL
Great job, works fine Raj -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Sam Rx Sent: Wednesday, January 03, 2007 6:13 AM To: arslist@ARSLIST.ORG Subject: Re: Need help constructing a URL ** Hi, I wrote this simple url builder utility, to create mid tier and flashboard urls thanks, Samir On 12/27/06, Lucero, Michelle - IST contractor [EMAIL PROTECTED] wrote: ** Hi, Candace and Jenni: Not sure if this has been answered for you. http://midtier host/arsys/forms/ar server/HPD%3AHelpDesk/Support/?eid=H123456 Hope that helps, Michelle _ From: Action Request System discussion list(ARSList) [mailto: ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Time Scheduling
Task: Build a form (or forms) to hold a list of users and the hours they start and end their work day (24 hour clock): ie 08:00-17:00 or 22:00-0600. Do not want to store times for each day of the week. For each ticket submitted search the list of users and find one that is available at the time the ticket is being created. This means matching the current time between the start and end times for each user. Logically this sounded simple enough but the problem I'm having is when a ticket is submitted at say 3am. I have qualitication that is checking to see if the current time is between the start and end time for a user. So, if it is 16:00 and the user works 08:00 to 17:00 they are included. However, if is 02:00 and the users schedule spans two days, 22:00 one day till 06:00 the next, the qualification fails. I feel there is a simple solution to this issue but cannot sem to come up with it. I though of just creating mutiple entries for certain users whose schedule spans two days, one for 22:00 to 23:59 and one for 00:00 - 06:00, but was hoping someone had another thought. Thank you ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Time Scheduling
Hi Frank, I had a similar issue once and created fields for 'Shift', with values like 'Shift 1', 'Shift 2'etc. (including weekends) on the User form (or you could use a work schedule form) and had workflow to check which Shift range the timestamp fell into and then looked up active users (Assignees) on that shift. The WEEKDAY function is helpful in determining the day of the week. Hope this helps, Sylvia Holy -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Wednesday, January 03, 2007 12:59 PM To: arslist@ARSLIST.ORG Subject: Time Scheduling Task: Build a form (or forms) to hold a list of users and the hours they start and end their work day (24 hour clock): ie 08:00-17:00 or 22:00-0600. Do not want to store times for each day of the week. For each ticket submitted search the list of users and find one that is available at the time the ticket is being created. This means matching the current time between the start and end times for each user. Logically this sounded simple enough but the problem I'm having is when a ticket is submitted at say 3am. I have qualitication that is checking to see if the current time is between the start and end time for a user. So, if it is 16:00 and the user works 08:00 to 17:00 they are included. However, if is 02:00 and the users schedule spans two days, 22:00 one day till 06:00 the next, the qualification fails. I feel there is a simple solution to this issue but cannot sem to come up with it. I though of just creating mutiple entries for certain users whose schedule spans two days, one for 22:00 to 23:59 and one for 00:00 - 06:00, but was hoping someone had another thought. Thank you ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Mid Tier Access Logging/Usage
Is there a way to determine how many times a mid tier form is accessed or logged into the ARS via the mid tier? I thought about using Session Management logging option in the mid tier, but I don't know if that is going to give me what I was looking for, I believe that would only tell me when and whom accessed the mid tier not what form they were accessing. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid Tier Access Logging/Usage
Kyle, You could try running a Direct SQL everytime you open that form in question, when the CLIENT-TYPE = 9 and set an incremental counter on an underlying table created specifically for this. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Kyle Whitley [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, January 3, 2007 1:25:11 PM Subject: Mid Tier Access Logging/Usage Is there a way to determine how many times a mid tier form is accessed or logged into the ARS via the mid tier? I thought about using Session Management logging option in the mid tier, but I don't know if that is going to give me what I was looking for, I believe that would only tell me when and whom accessed the mid tier not what form they were accessing. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ITSM 7 Patch 9001
I Just wanted to share this exchange that I had with someone from Remedy about the availablity of the actual tool Hi Ed, The utility is available, however we are attempting to ensure a good migration success rate for our customers. See the exerpt from a migration communication below to understand our goals. If you choose not to work with a consultant and are attempting it on your own, then I just want to ensure that you are properly prepared to ensure success. Let me know your plans and I will assist you accordingly. Thanks ... Remedy Person (If you received the email about the release of the tool you know who this person is) - Remedy Person, Are they actually going to ever release the actual tool that will migrate data? Ed White - - - Remedy Person's response Hi Ed, The utility is available, however we are attempting to ensure a good migration success rate for our customers. See the exerpt from a migration communication below to understand our goals. If you choose not to work with a consultant and are attempting it on your own, then I just want to ensure that you are properly prepared to ensure success. Let me know your plans and I will assist you accordingly. Thanks ...Remedy Person The release of 7.0 has created significant interest amongst the customer base and many customers have been awaiting this tool to begin the migration process. As an initial step to assist in the migration process and ensure a good migration success rate, BMC offers customers the opportunity to consult BMC Professional Services or a qualified BMC partner. What do you need to know prior to beginning the migration of your current production system?... Version 7 of ITSM is an unprecedented release for BMC in that we have made a significant leap forward in architecture and functionality in this solution. As a result, this migration is an exception from BMC's typical upgrade process, but please be assured that it is BMC's intention to return to our typical upgrade path post this migration. However, due to the nature of the migration and implementation of version 7.0, BMC wants to ensure that all our customers are in the position to achieve a successful migration. This migration tool is not a typical upgrade, in that it is more about the process of implementing version 7, understanding the planning, and less about the actual software utility. BMC wants to assist with the thought preparation, pre-planning activities, business process considerations or reconsiderations, etc. required prior to running the actual migration utilities. Once decisions have been made regarding the best migration approach, your review of existing business processes and what data will be migrated, this migration utility will assist with the transfer of the data from your old system to version 7. This migration may be an appropriate time to take advantage of an opportunity to re-engineer your operational processes in support of your business processes. One benefit of contacting BMC Professional Services and/or a qualified BMC Partner is that BMC Professional Services has developed a Sure Start package offering a proven implementation methodology. Similarly, our approved partners have their own methodologies. Both will have tools to assist in the migration process. == From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, January 03, 2007 10:05 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7 Patch 9001 ** Hmmm...figures. Well, it's nice to know that marketing is still going strong, since most of my customers couldn't even tell me who their BMC sales reps are, much less the last time they actually saw them Rick On 1/3/07, Tony Worthington [EMAIL PROTECTED] wrote: Rick - It's just a set of pdfs explaining the possibilties for migration. No actual tool is included. It's mostly marketing material pushing professional services. The release of 7.0 has created significant interest amongst the customer base and many customers have been awaiting this tool to begin the migration process. As an initial step to assist in the migration process and ensure a good migration success rate, BMC offers customers the opportunity to consult BMC Professional Services or a qualified BMC partner. What do you need to know prior to beginning the migration of your current production system?... One benefit of
Remedy - Jira bridge
We are planning to use Jira as our bug tracking system. Remedy is already being used university wide for helpdesk tickets from clients. We are in the initial stages of exploring how we can use the two systems without a lot of manual duplication of data. Wondering if someone has already explored coupling/transferring information between Remedy and Jira? If so, would appreciate pointers to any more information on this. Thanks and Happy New Year to you all. -Jayashree Jayashree Nagaraj Web Academic Systems Analyst Stanford Business School 650-736-1433 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Remedy - Jira bridge
http://arswiki.org/wiki/index.php?title=How_to_get_data_in_and_out_of_the_AR_System Page covers bundled methods as well as third party apps. Axton Grams On 1/3/07, Nagaraj, Jayashree [EMAIL PROTECTED] wrote: We are planning to use Jira as our bug tracking system. Remedy is already being used university wide for helpdesk tickets from clients. We are in the initial stages of exploring how we can use the two systems without a lot of manual duplication of data. Wondering if someone has already explored coupling/transferring information between Remedy and Jira? If so, would appreciate pointers to any more information on this. Thanks and Happy New Year to you all. -Jayashree Jayashree Nagaraj Web Academic Systems Analyst Stanford Business School 650-736-1433 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Remedy - Jira bridge
Our JIRA expert tells me there's a similar request on the JIRA side: http://jira.atlassian.com/browse/JRA-5748 No real solution on that thread yet, but a good discussion to watch! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nagaraj, Jayashree Sent: Wednesday, January 03, 2007 1:43 PM To: arslist@ARSLIST.ORG Subject: [ARSLIST] Remedy - Jira bridge We are planning to use Jira as our bug tracking system. Remedy is already being used university wide for helpdesk tickets from clients. We are in the initial stages of exploring how we can use the two systems without a lot of manual duplication of data. Wondering if someone has already explored coupling/transferring information between Remedy and Jira? If so, would appreciate pointers to any more information on this. Thanks and Happy New Year to you all. -Jayashree Jayashree Nagaraj Web Academic Systems Analyst Stanford Business School 650-736-1433 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Email and Alert notifications....
Listers, Just a note. I just upgraded my server to ARS 7.1.0 and no emails or alerts worked. I had to set all bits to get anything to work. Set the External-Authentication-Return-Data-Capabilities value to 31. If you upgrade and are using AREA LDAP and no emails or alerts are going out, give this a shot. Ed From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, January 02, 2007 9:07 PM To: arslist@ARSLIST.ORG Subject: Re: Email and Alert notifications ** There is a parameter you have to set in your ar.conf to address this if the data (email address) is not available in your LDAP directory. quote External-Authentication-Return-Data-Capabilities A bit mask that allows you to specify the return data capabilities for the current AREA plug-in. This setting does not control the AREA plug-in, it merely describes the behavior of the plug-in, allowing for server optimization. Acceptable values are as follows: Bit 1 (Value=1)-No email address will be provided. Bit 2 (Value=2)-No notify mechanism will be provided. Bit 3 (Value=4)-No group identifiers will be provided. Bit 4 (Value=8)-No license information will be provided. Bit 5 (Value=16)-No notification user validation should occur. The default is 0, meaning the server will attempt to retrieve this information from AREA. A value of 7 will allow the server to potentially reduce the number of AREA related calls during notification processing. A value of 16 will allow the server to avoid using AREA for notification user validation and information retrieval. Use this setting for sites using a form of AREA that applies user names as email addresses and where there is no benefit to accessing an authentication database. /quote Axton Grams On 1/2/07, Joe DeSouza [EMAIL PROTECTED] wrote: ** Hello Listers, First of all wish all of you a very Happy new year... This is our configuration: ARS 6.3 Patch 19 We are on Solaris 5.10 Some of the users on our Remedy system are authenticated over LDAP while some are autheticated from the ARS. What we have noticed is if we try to send a notification to a group either an alert or an email using the Group name (groups reside in the ARS), only the users that are authenticated from within the ARS get these alerts or emails. In our LDAP configuration we have the Group container set to None. Every other functionality relating to resolving groups work with these externally authenticated users such as resolution of the keyword $GROUPS$ etc. What could be going wrong? Any help would be highly appreicated.. Cheers Joe __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: ITSM7 patch 9002 - Task template add-on!
** FYI ..This was released about 30 mins ago now on the patch dowloads form. You no longer have to go sifting through the FTP site to find it. There are dowloads for 7.0, 7.01, and 7.02From:Tony Worthington [EMAIL PROTECTED]Reply-To:arslist@ARSLIST.ORGTo:arslist@ARSLIST.ORGSubject:ITSM7 patch "9002" - Task template add-on!Date:Wed, 3 Jan 2007 08:55:31 -0600 Found this poking around on the patch site this morning...Not listed in the smbu patch form, you need to browse the ftp site. BMC® Remedy® Incident Management 7.0 Task Template Add-on Installation Guide BMC Remedy Incident Management 7.0 Task Template Add-on InstallationGuide describes how to install the new task template add-on for BMC Remedy Incident Management 7.0. -tony -- Tony Worthington [EMAIL PROTECTED] 262-703-5911 CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution oruse of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it andnotify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl'sreserves the right to retrieve and read any message created, sent andreceived.Kohl's reserves the right to monitor messages to or fromauthorized Kohl's Associates at any time without any further consent. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Wherethe Answers Are"CONFIDENTIALITY NOTICE:This is a transmission from Kohl's Department Stores, Inc.and may contain information which is confidential and proprietary.If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited.If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000.CAUTION:Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received.Kohl's reserves the right to monitor messages to or from authorized Kohl's Associates at any timewithout any further consent. __20060125___This posting was submitted with HTML in it___
Re: Mid Tier Access Logging/Usage
You can simply create an active that fires on window open and pushes whatever you want to a new form. We do this to find out who is logging in and what forms, views, submit mody, etc and what version of browser. *Rocky* Rocky Rockwell eMA Team – Remedy Developer [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Ph#1: 214-567-8874 Ph#2: 325-884-1263 Kyle Whitley wrote: Is there a way to determine how many times a mid tier form is accessed or logged into the ARS via the mid tier? I thought about using Session Management logging option in the mid tier, but I don't know if that is going to give me what I was looking for, I believe that would only tell me when and whom accessed the mid tier not what form they were accessing. Thanks Kyle ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Remedy - Jira bridge
Remedy's utility download page has a utility that could be used from the command line to create entries into Remedy if that could be of any use to use from Jira.. That would be useful to create an entry into Remedy from Jira if they have the capacity to execute a command from the CLI.. Joe - Original Message From: Pierce, Catherine A. [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, January 3, 2007 1:57:08 PM Subject: Re: Remedy - Jira bridge Our JIRA expert tells me there's a similar request on the JIRA side: http://jira.atlassian.com/browse/JRA-5748 No real solution on that thread yet, but a good discussion to watch! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nagaraj, Jayashree Sent: Wednesday, January 03, 2007 1:43 PM To: arslist@ARSLIST.ORG Subject: [ARSLIST] Remedy - Jira bridge We are planning to use Jira as our bug tracking system. Remedy is already being used university wide for helpdesk tickets from clients. We are in the initial stages of exploring how we can use the two systems without a lot of manual duplication of data. Wondering if someone has already explored coupling/transferring information between Remedy and Jira? If so, would appreciate pointers to any more information on this. Thanks and Happy New Year to you all. -Jayashree Jayashree Nagaraj Web Academic Systems Analyst Stanford Business School 650-736-1433 [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Email and Alert notifications....
Thanks. I bet this will be useful later on when we plan on upgrading... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: White, Ed [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, January 3, 2007 2:01:28 PM Subject: Re: Email and Alert notifications ** Listers, Just a note. I just upgraded my server to ARS 7.1.0 and no emails or alerts worked. I had to set all bits to get anything to work. Set the External-Authentication-Return-Data-Capabilities value to 31. If you upgrade and are using AREA LDAP and no emails or alerts are going out, give this a shot. Ed From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Tuesday, January 02, 2007 9:07 PM To: arslist@ARSLIST.ORG Subject: Re: Email and Alert notifications ** There is a parameter you have to set in your ar.conf to address this if the data (email address) is not available in your LDAP directory. quote External-Authentication-Return-Data-Capabilities A bit mask that allows you to specify the return data capabilities for the current AREA plug-in. This setting does not control the AREA plug-in, it merely describes the behavior of the plug-in, allowing for server optimization. Acceptable values are as follows: Bit 1 (Value=1)—No email address will be provided. Bit 2 (Value=2)—No notify mechanism will be provided. Bit 3 (Value=4)—No group identifiers will be provided. Bit 4 (Value=8)—No license information will be provided. Bit 5 (Value=16)—No notification user validation should occur. The default is 0, meaning the server will attempt to retrieve this information from AREA. A value of 7 will allow the server to potentially reduce the number of AREA related calls during notification processing. A value of 16 will allow the server to avoid using AREA for notification user validation and information retrieval. Use this setting for sites using a form of AREA that applies user names as email addresses and where there is no benefit to accessing an authentication database. /quote Axton Grams On 1/2/07, Joe DeSouza [EMAIL PROTECTED] wrote: ** Hello Listers, First of all wish all of you a very Happy new year... This is our configuration: ARS 6.3 Patch 19 We are on Solaris 5.10 Some of the users on our Remedy system are authenticated over LDAP while some are autheticated from the ARS. What we have noticed is if we try to send a notification to a group either an alert or an email using the Group name (groups reside in the ARS), only the users that are authenticated from within the ARS get these alerts or emails. In our LDAP configuration we have the Group container set to None. Every other functionality relating to resolving groups work with these externally authenticated users such as resolution of the keyword $GROUPS$ etc. What could be going wrong? Any help would be highly appreicated.. Cheers Joe __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Help files location
I know I have seen the answer to this but I can not find it again. I have a user that can not bring up the help files from the user client in 5.6. Just an hour glass and never loads. Where are the help files located and what points a user to them??? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Enhancement: Sync search database...
I wonder if an enhancement of this nature is possible.. Sometimes after an exercise of patching an application after bug fixing or an enhancement of an existing Remedy application where you have already undergone the process of syncronizing the search database prior to an enhancement, to reflect these changes to show up in the Related Workflow, we have to re-run the Sync Search Database. I wonder how hard it would be to enhance this feature where the Remedy Administrator has the capability to 'highlight' a form where the changes have taken place, and to run the Sync Search Database operation on only the affected forms.. It would not just significantly save time but also spare the database and the AR Server the hit it experiences during this operation. Just a thought that occurs to me everytime I run this operation when I know the update I would get after the operation would actually affect only a single form or a few forms... Today I ran this operation when the only change I had done since the previous run was adding a new form which had only 15 active links on it and another active link related to this form from another calling form.. If such a feature was available, this operation might have taken not more than 10 minutes or so while it took me nearly 3.5 hours with its current design... I wonder if this is already on the plate for a forthcoming AR Server version or a patch?? Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Help files location
Carl, If memory serves me correctly there were issues with help in various patches in the 5.x and 6.x versions. Some seemed to work fine but others never seemed to open. Sorry I can't remember the patch levels that I saw this behavior in. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carl Starkweather Sent: Wednesday, January 03, 2007 3:39 PM To: arslist@ARSLIST.ORG Subject: Help files location I know I have seen the answer to this but I can not find it again. I have a user that can not bring up the help files from the user client in 5.6. Just an hour glass and never loads. Where are the help files located and what points a user to them??? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid Tier Access Logging/Usage
Can the number of hits to the login page be counted, to see how many times the login page is hit prior to actually logging in? Thanks Kyle Joe DeSouza wrote: ** Kyle, You could try running a Direct SQL everytime you open that form in question, when the CLIENT-TYPE = 9 and set an incremental counter on an underlying table created specifically for this. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Kyle Whitley [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, January 3, 2007 1:25:11 PM Subject: Mid Tier Access Logging/Usage Is there a way to determine how many times a mid tier form is accessed or logged into the ARS via the mid tier? I thought about using Session Management logging option in the mid tier, but I don't know if that is going to give me what I was looking for, I believe that would only tell me when and whom accessed the mid tier not what form they were accessing. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___ -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid Tier Access Logging/Usage
Kyle, Using the same method - no its not possible... This is because when you have your login page open, you haven't as yet authenticated yourself into the application, so there is no capability to fire anything within the application before logging into the application. However, there are external utilities/functions you can embed in your web application that might be able to do what you want to do.. Examples for these could be:- 1) http://www.statcounter.com 2) http://www.easycounter.com 3) http://www.amazingcounter.com 4) http://www.free-counters.co.uk 5) http://www.digits.com These are results I found when I googled for such utilities... Try a web search and you might be luckier and find something more specific to what you might need.. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Kyle Whitley [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, January 3, 2007 3:56:39 PM Subject: Re: Mid Tier Access Logging/Usage Can the number of hits to the login page be counted, to see how many times the login page is hit prior to actually logging in? Thanks Kyle Joe DeSouza wrote: ** Kyle, You could try running a Direct SQL everytime you open that form in question, when the CLIENT-TYPE = 9 and set an incremental counter on an underlying table created specifically for this. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Kyle Whitley [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, January 3, 2007 1:25:11 PM Subject: Mid Tier Access Logging/Usage Is there a way to determine how many times a mid tier form is accessed or logged into the ARS via the mid tier? I thought about using Session Management logging option in the mid tier, but I don't know if that is going to give me what I was looking for, I believe that would only tell me when and whom accessed the mid tier not what form they were accessing. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___ -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
SLA - BRIE dies for no reason
Hello Listers, SLA 6.0 Has anyone ever had a problem with the SLA-BRIE engine just dying for no apparent reason? As I am creating SLA's and suddenly records just stop processing from the application pending form. I have enabled BRIE. logging from the SLA-Config Form, no errors. When I check, the BRIE service is running. I have exhausted support with this, they have no clue as to what would cause this problem. I am at my wit's end on this one. Been chasing it for over a month. Please advise, Thanks in Advance, Jase Brandon Remedy Administration/Development Customer Support Systems Group Desk - (615) - 320-4494 Cell - (334) - 318-5426 [EMAIL PROTECTED] DaVita Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid Tier Access Logging/Usage
I would use your web server for individual counters. The use of cookies or java-script should be able to give you the stats you are requesting. I don't know of free counters that will tell you how many times an individual will hit a page without requiring something more. Good luck. Nick Havin' Fun in Sacramento -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley Sent: Wednesday, January 03, 2007 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Access Logging/Usage Can the number of hits to the login page be counted, to see how many times the login page is hit prior to actually logging in? Thanks Kyle Joe DeSouza wrote: ** Kyle, You could try running a Direct SQL everytime you open that form in question, when the CLIENT-TYPE = 9 and set an incremental counter on an underlying table created specifically for this. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Kyle Whitley [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, January 3, 2007 1:25:11 PM Subject: Mid Tier Access Logging/Usage Is there a way to determine how many times a mid tier form is accessed or logged into the ARS via the mid tier? I thought about using Session Management logging option in the mid tier, but I don't know if that is going to give me what I was looking for, I believe that would only tell me when and whom accessed the mid tier not what form they were accessing. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___ -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: SLA - BRIE dies for no reason
I had similar experience. SLA Patch 1537 helps. Best Regards, Uday Joshi From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jase Brandon Sent: Thursday, January 04, 2007 01:57 AM To: arslist@ARSLIST.ORG Subject: SLA - BRIE dies for no reason ** Hello Listers, SLA 6.0 Has anyone ever had a problem with the SLA-BRIE engine just dying for no apparent reason? As I am creating SLA's and suddenly records just stop processing from the application pending form. I have enabled BRIE. logging from the SLA-Config Form, no errors. When I check, the BRIE service is running. I have exhausted support with this, they have no clue as to what would cause this problem. I am at my wit's end on this one. Been chasing it for over a month. Please advise, Thanks in Advance, Jase Brandon Remedy Administration/Development Customer Support Systems Group Desk - (615) - 320-4494 Cell - (334) - 318-5426 [EMAIL PROTECTED] DaVita Inc. __20060125___This posting was submitted with HTML in it___ The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Mid Tier Access Logging/Usage
Not being a Java expert I opted to create an alternative mid-tier logon page using ASP. Not only can I track who's logging in (or having trouble getting in) but I can capture information like IP address and the referring page (if they clicked an intranet link). This information can easily be written to a flat file or a database. (**I'm sure this can be done in Java somehow as well) Once the user is logged on I would use workflow to capture any other usage statistics you want to see. (As Joe said, don't forget to qualify with CLIENT-TYPE = 9) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kyle Whitley Sent: Wednesday, January 03, 2007 12:57 PM To: arslist@ARSLIST.ORG Subject: Re: Mid Tier Access Logging/Usage Can the number of hits to the login page be counted, to see how many times the login page is hit prior to actually logging in? Thanks Kyle Joe DeSouza wrote: ** Kyle, You could try running a Direct SQL everytime you open that form in question, when the CLIENT-TYPE = 9 and set an incremental counter on an underlying table created specifically for this. Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Kyle Whitley [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, January 3, 2007 1:25:11 PM Subject: Mid Tier Access Logging/Usage Is there a way to determine how many times a mid tier form is accessed or logged into the ARS via the mid tier? I thought about using Session Management logging option in the mid tier, but I don't know if that is going to give me what I was looking for, I believe that would only tell me when and whom accessed the mid tier not what form they were accessing. Thanks Kyle -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125___This posting was submitted with HTML in it___ -- Kyle Whitley IT System Support Professional Office of Information and Instructional Technology (OIIT) Board of Regents of the University System of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: SLA - BRIE dies for no reason
Thanks Uday, I already applied Patch 1537 with no different results. SLA BRIE still randomly stops processing and I have to stop/restart services for BRIE to come back to life. Can you think of anything else that may cause this? Thanks again! :) Jase Brandon Remedy Administration/Development Customer Support Systems Group Desk - (615) - 320-4494 Cell - (334) - 318-5426 [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Uday Joshi Sent: Wednesday, January 03, 2007 3:33 PM To: arslist@ARSLIST.ORG Subject: Re: SLA - BRIE dies for no reason ** I had similar experience. SLA Patch 1537 helps. Best Regards, Uday Joshi From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jase Brandon Sent: Thursday, January 04, 2007 01:57 AM To: arslist@ARSLIST.ORG Subject: SLA - BRIE dies for no reason ** Hello Listers, SLA 6.0 Has anyone ever had a problem with the SLA-BRIE engine just dying for no apparent reason? As I am creating SLA's and suddenly records just stop processing from the application pending form. I have enabled BRIE. logging from the SLA-Config Form, no errors. When I check, the BRIE service is running. I have exhausted support with this, they have no clue as to what would cause this problem. I am at my wit's end on this one. Been chasing it for over a month. Please advise, Thanks in Advance, Jase Brandon Remedy Administration/Development Customer Support Systems Group Desk - (615) - 320-4494 Cell - (334) - 318-5426 [EMAIL PROTECTED] DaVita Inc. __20060125___This posting was submitted with HTML in it___ The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: COLCOUNT Function
Where would you place this SQL code when you are in the Table Field on the form (in Remedy Admin tool)? Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bruce Sent: Tuesday, January 02, 2007 10:15 AM To: arslist@ARSLIST.ORG Subject: Re: COLCOUNT Function Hi Lisa, a direct SQL count should do the trick, unless you are resisting this idea. Example: select count(*) from your-table where particular-column = 'X' Jim Bruce TELUS Mobility 416-279-3455 On Fri, 29 Dec 2006 12:11:54 -0500, Kemes, Lisa [EMAIL PROTECTED] wrote: Listers, Would I be able to use the COLCOUNT function to count only the rows that have a specific value? (I do not want a count of all the rows, just the rows that have X in a particular field). Or will I just have to create a temp field and count the rows in a table loop? Thanks in advance! Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: COLCOUNT Function
I dont think Jim meant placing your SQL in the table field. He probably meant to tell you to run a direct sql through an AL to return the count of records using an equivalent condition that the table field uses, to an integer field... There is no way you can embed a sql statement in a table field otherwise... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Kemes, Lisa [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, January 3, 2007 6:40:26 PM Subject: Re: COLCOUNT Function Where would you place this SQL code when you are in the Table Field on the form (in Remedy Admin tool)? Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bruce Sent: Tuesday, January 02, 2007 10:15 AM To: arslist@ARSLIST.ORG Subject: Re: COLCOUNT Function Hi Lisa, a direct SQL count should do the trick, unless you are resisting this idea. Example: select count(*) from your-table where particular-column = 'X' Jim Bruce TELUS Mobility 416-279-3455 On Fri, 29 Dec 2006 12:11:54 -0500, Kemes, Lisa [EMAIL PROTECTED] wrote: Listers, Would I be able to use the COLCOUNT function to count only the rows that have a specific value? (I do not want a count of all the rows, just the rows that have X in a particular field). Or will I just have to create a temp field and count the rows in a table loop? Thanks in advance! Lisa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
