Incident Auto Closure calculating Business Days - High Priority

2013-02-05 Thread syed Ziyan
Hi All, We are using ITSM 7.6.04 sp3 We need to configure Incident Auto closure for 10 Business Days. I would like to know if we configure Rules in Custom Configuration > Incident Management > Advanced Options> Rules Auto Closed Resolved in Days - is this value calculating Business Days ? if no

Task DB Name for Reporting

2013-02-05 Thread Rick Sharp
Hi All - Were looking for the table name(s) that contain CRQ Task assignments. I've tried sampling the most obvious TMS:Task and other in the TMS: list, to no avail. Have you been successful reporting on CRQ Tasks? Thanks. Rick Sharp via BB _

Re: List of table modifications and data additions done by 7.6.04 SP4 upgrade

2013-02-05 Thread Joe D'Souza
You will not get one finite list - you will but this list will greatly depend on what applications you have selected as also some of the many installation choices you can make while installing the AR System as well as the other applications. There are at least as many as 10 different combination

Re: Restarting the db but not ARS

2013-02-05 Thread Jason Miller
I agree. I prefer to stop an app gracefully (Remedy or any other server app) any time it is an option. Why force the system into a failure state? Seems like a bad practice. Jason On Tue, Feb 5, 2013 at 1:07 PM, Joe D'Souza wrote: > ** > > Apart from this, if you do not mind the ARERR connec

Re: Returning SQL results as a single string.

2013-02-05 Thread Joe D'Souza
An option (never tried it but no reason why it shouldn't work), is to create a bat file, that runs the sql statement using SQLPlus (assuming you are on Oracle), and spool those results to a text file, which name could be generated by a GUID. You can set that file then to a View field which will

Re: Pending Time in ITSM 7.6

2013-02-05 Thread Schon, Stuart
Assuming you have both ITSM and SLM installed then yes in the SLM:Measurement form, also in the Incident/Measurement join. If you new to ITSM you need to build the view as part of your initial config. Stuart Schon Service Desk Systems - Manager From: Action Request System discussion list(ARSLi

Re: Returning SQL results as a single string.

2013-02-05 Thread Brittain, Mark
Hi Brad, You might actually need a join form to do this but here is how to get around the First Matching. Create a Table field for the data source and fields you need. Create the character field Create a filter: Character field set field ($Character Field$ + Column1$) + "," (or other separat

Returning SQL results as a single string.

2013-02-05 Thread Brad Fike
Hello Team, I have a have sql statement and i want to store the results in a character field during a filter set fields action not just 'Use First Matching Request' this is my example sql statement... select f.fieldName from arschema a, field f where a.schemaId = f.schemaId and a

Re: Restarting the db but not ARS

2013-02-05 Thread Joe D'Souza
Apart from this, if you do not mind the ARERR connection errors in the arerror.log file, its ok to leave it on. I usually like to keep that file as clean as is possible if I am the only Remedy hand on site. So if you are like me, I would stop the services and then start after its restarted. In eith

Re: Restarting the db but not ARS

2013-02-05 Thread ravi rai
Arsystem retries and connect to the DB when it becomes available There is a bug in 7604 SP3 . If Arserver loose connection with DB it will not reconnect and restart after 15 Minute They have a hotfix for this It is always safe to restart services after DB restart. Thanks Ravi Date: Tu

Re: Restarting the db but not ARS

2013-02-05 Thread Pargeter, Christie :CO IS
It depends. I have had my dba do some restarted that didn't require me to restart the ARS service but other times I did. It depends on how long the db is down and if your system will reconnect on its own or not. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]

Restarting the db but not ARS

2013-02-05 Thread Brittain, Mark
Hi All, I have two AR Servers in a server group that are using a remote oracle database. My dba is making some changes to the db and needs to restart the db for the changes to take effect. Do I need to stop the AR Servers before the db is restarted? I would think so, but the dba thinks not. A

List of table modifications and data additions done by 7.6.04 SP4 upgrade

2013-02-05 Thread Campbell, Paul (Paul)
We are upgrading our 7.5 Solaris/Oracle custom apps arserver to 7.6.04 SP4 and my change control group and DBAs are wanting to what tables are modified (and what are the changes) and how many data records are inserted/updated as part of the upgrade process. Are these changes documented anywhere

Re: Query external database

2013-02-05 Thread Joe D'Souza
I kept wondering the same thing for a while because I did use external DB links on a few occasions on 7.6.04. :-) Web Services definitely look like the next best viable option if the other application you are talking about is capable of it. Atrium Integration Engine could potentially be another o

Re: FIXED - RE: Error on View form to an External Oracle Table

2013-02-05 Thread Joe D'Souza
That is a strange way for the application to report that indeed! I guess what its doing is that if the application cannot resolve the given table or view, it assumes it is the Request ID field, and returns that as a generic error, instead of running doing something like a DO CASE, to test several

FIXED - RE: Error on View form to an External Oracle Table

2013-02-05 Thread Olds, Kimberly M
Thanks for the help. My issue is fixed. >From Support: "However, there have been reports in previous versions of Remedy (6.3), whereby this error is misleading - and that the view form was corrupted. If you enable SQL logging and reproduce the problem - it may show an API call is failing on thi

Re: Query external database

2013-02-05 Thread Longwing, LJ CTR MDA/IC
Ahdidn't know it was a 'process' 'cant' :)so, in those situations I have setup external scripts that do a timed sync of data, and then use that 'local' table to do what was needed. I personally think the entire discussion is stupid, because they are trying to save bandwidth, but end up

Re: Query external database

2013-02-05 Thread Brittain, Mark
LJ, Technically I know I can do it but I was told I could not use a db link. So I am stuck looking for an alternative. If none exist then maybe I can get that changed. Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf O

Re: Pending Time in ITSM 7.6

2013-02-05 Thread Brittain, Mark
The pending status is an excluded condition. What I am trying to determine is the duration of the incident minus the time the incident in a pending status. I would think the time in pending status or the calculation of create to close minus pending is captured someplace. From: Action Request Sy

Re: Query external database

2013-02-05 Thread Longwing, LJ CTR MDA/IC
Mark, I'm not sure who told you that, but I'm not familiar with any changes to the Remedy architecture that would prevent that type of thing, in fact I know I did it in 7.5...and think I did it as late as 7.6.04...but I'm not sure the info you received was correct. Now, I know that some network

Query external database

2013-02-05 Thread Brittain, Mark
Hi All, Back in the day of 6.3, I could run SQL queries in active links or filters like select first_name, last_name, from employeetable@xyz where active = 'A'. There was a database link set up between the AR Server and the database. I could also set up views using the same table reference. Th

Re: Pending Time in ITSM 7.6

2013-02-05 Thread Karthik
Mark, On 7.6, you need to configure pending status as an exclude condition when building service targets on SLM. The SLM link on the left hand side on the best practice view opens a pop up that shows the due date and time. Regards, Karthik On Feb 5, 2013 10:30 PM, "Brittain, Mark" wrote: > **

Pending Time in ITSM 7.6

2013-02-05 Thread Brittain, Mark
HI All, Back in the day of 6.3, on a custom form called Trouble Ticket I had built some workflow that would capture the number of minutes the ticket was in a Pending status. Then I could calculate Closed Date - Create Date - Pending Minutes =Time-to-Close In ITSM 7.6 I am pretty sure that Pe

Re: Error on View form to an External Oracle Table

2013-02-05 Thread Joe D'Souza
Fred is on the right track here.. For a simple sanity check, to ensure that the field you are mapping to the Request ID is indeed a unique character field: 1) Check its data type and ensure its varchar (varchar2 gets rejected) 2) Do a select count(*) on the table or view and then a select distinct

Re: Error on View form to an External Oracle Table

2013-02-05 Thread Grooms, Frederick W
The error simply states that the field you have mapped the Request ID to has some records with NULL in it. Did you map the Request ID to an integer or a character field? Turn on SQL logging to see exactly which field ARS thinks has NULL Fred -Original Message- From: Action Request Sy

Re: Error on View form to an External Oracle Table

2013-02-05 Thread Tauf Chowdhury
Kim, did you try to restart the ar server service? Sent from my iPhone On Feb 5, 2013, at 11:11 AM, "Olds, Kimberly M" wrote: ** Hello! I am hoping someone can provide some guidance for me to give my DBA. Environment - Oracle 11g Windows 2008 Server AR System version – 7.6.04 SP3 I am g

ARSmarts Data Manager Build 419 available from our website

2013-02-05 Thread Support
Hello List, ARSmarts Data Manager build 419 is available from our website. Compared to 418, it fixes all the issues that were brought to our knowledge. No new functionality this time. If you already registered to the beta program, you can download build 419 (password did not change) and ins

Error on View form to an External Oracle Table

2013-02-05 Thread Olds, Kimberly M
Hello! I am hoping someone can provide some guidance for me to give my DBA. Environment - Oracle 11g Windows 2008 Server AR System version - 7.6.04 SP3 I am getting the following error on a view form that worked yesterday. "ARERR [482] This View Form contains empty Request IDs. Ensure that the ke

Re: FTS on Virtual Machines - 7.6.04

2013-02-05 Thread William Rentfrow
We did do this configuration - and had sketchy results. BMC did update this document though - there's a new version. We just got it from support yesterday and we will look at the recommended changes and go from there. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIS