Read data from a formsave in CSV file attach to Master Record.

2013-10-28 Thread Sahil Pathania
Hello ALL, I have following requirement. I would need your expertise. I have a master ticket in Master form. I need to read the child ticket data from child form, place in CSV file and attach to the Master ticket in a attachment field, so that I can send email to the customer with csv

Re: Read data from a formsave in CSV file attach to Master Record.

2013-10-28 Thread Joe D'Souza
Couldn't you just trigger an email notification from the child ticket with the child tickets URL embedded in the notification? What specific benefit would the receiving party have by receiving a CSV file that could not be achieved by other standard mechanisms of data exchange?? Cheers Joe

Re: Read data from a formsave in CSV file attach to Master Record.

2013-10-28 Thread Sahil
Thanks Joe for the reply, But the requirement is bit different. From a custom application Data (parent- children-children structure) is imported to Remedy interface forms, using a integration application from third party. When data is imported to remedy interface forms, we need to perform the

Re: Read data from a formsave in CSV file attach to Master Record.

2013-10-28 Thread LJ LongWing
Sahil, I have done something similar in the past utilizing a perl script. From the parent form you call a perl script with a filter and the script uses ARSPerl to log onto Remedy, gather the information and utilize perl modules to create a csv file, then once created, utilize either perl or

Multiple Mid-Tier, single Tomcat

2013-10-28 Thread LJ LongWing
I did this years ago, and can confirm that it worked in 7.6.04, but I'm trying it again in 8.1 and it's not working. In previous versions, if you created a second context of Mid-Tier, Tomcat would complain about native dll's being already loaded, and you needed to separate them out so that the

Change Management

2013-10-28 Thread Kathy Morris
Hi, When a user has a change request within your organization, does the Developer write up the CR for the user? My experience has always been the user writes up the request since it is their business requirement. Normally the developer is assigned a task. Just curious how other business are

Re: Change Management

2013-10-28 Thread Rick Cook
Depends on how things get done in your shop. The RFC is usually created by the person who can best speak to the change being requested. That may be a manager, BA, or developer. No wrong answer there, as long as the approver is someone different than the requester and/or Assignee. Rick On Oct

Re: Change Management

2013-10-28 Thread kunal das
Kathy thanks for your email. With Infrastructure Change User access the user will be permitted to open, query, submit and modify Infrastructure Change Requests. So yes as mostly used practices Change User submits and fill in all the related task for the developer in your organization. When any

Dates and Web Services

2013-10-28 Thread Warren R. Baltimore II
Good Morning/Afternoon/Evening fellow listers! It may be due to the heavy doses of cold medication that I have been taking over the last week, or just ignorance (or a combination of the two) but I am somewhat befuddled by dates and Web Services. I am trying to consume a WS from another ARS

Re: Change Management

2013-10-28 Thread Tommy Morris
Our developers open the CRQ. The business partners do not know the appropriate IT routing, approvals, Op/ ProdCats, schedule availabilities etc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Monday, October 28, 2013 9:12 AM To:

Re: Change Management

2013-10-28 Thread Pierson, Shawn
You can have the best of both worlds if you also use SRM. Developers can open CRQs directly, and users can go to a simplified form in SRM for enhancement requests that fill out the shell of a CRQ, which goes to a support group who assign the Change Coordinator to fill out the rest of the

Re: Email Notification Issue

2013-10-28 Thread Das, Anusha (non-US)
You need to have DL's for only the support groups that have more than 25 members and you should be good to go. You don't need to set it for all 250 groups. If that is not possible, it would need customization. You can try to use a table field, with the particular support group members in that

Re: Change Management

2013-10-28 Thread Randeep Atwal
The scenario I would recommend for true Œbusiness end users¹ submitting change requests is to have them submit the change via SRM. Depending on what is being requested, SRM can have various SRD¹s mapping to specific routing/approvals/prod cats/op cats etc. You want to hide the complexity for the

Re: Dates and Web Services

2013-10-28 Thread Grooms, Frederick W
When you map an ARS Date/Time field in a filter consume web service call the web service plugin will automatically convert to a valid XML DateTime fiormat -mm-ddThh:mm:ss-oh:om. It sounds like the web service you are consuming is not accepting the time zone offset (Which is part of the XML

Re: BIRT Reports and Layout (Orientation)

2013-10-28 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
Well that's just depressing -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kumar, Amit (Remedy-Dev Studio RD) Sent: Friday, October 25, 2013 12:18 AM To: arslist@ARSLIST.ORG Subject: Re: BIRT Reports and Layout

Re: [EXTERNAL] BIRT Reports and Layout (Orientation)

2013-10-28 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
Thanks Natalie! I'm going to see what I can do with this, I'll let you know if I'm successful. Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Stroud, Natalie K Sent: Thursday, October 24, 2013 3:53 PM To:

Re: Dates and Web Services

2013-10-28 Thread Warren R. Baltimore II
Fred, Thank you so much! I knew I was making this to difficult! Any idea where that setting might be? He's using a straight old Remedy Web Service to create what I am consuming. Otherwise I'll just convert it myself. Thanks for your help I really appreciate it! On Mon, Oct 28, 2013

Reset CRQ on Change

2013-10-28 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
We created a couple of tests on our prod system (before turning it loose) and we would like to reset the CRQ number. Where do you do this? Lisa Kemes Remedy Consultant Dev Technology Group DLA Office: (717) 770-6437 Cell Phone: (717) 602-9460 lisa.ke...@devtechnology.com

Re: Reset CRQ on Change

2013-10-28 Thread Roger Justice
There is a Number Generation form for each application. It needs to be reset using the ARSchema table. -Original Message- From: Kemes, Lisa A DLA CTR INFORMATION OPERATIONS lisa.kemes@dla.mil To: arslist arslist@ARSLIST.ORG Sent: Mon, Oct 28, 2013 12:51 pm Subject: Reset CRQ on

Re: Reset CRQ on Change

2013-10-28 Thread Kemes, Lisa A DLA CTR INFORMATION OPERATIONS
Whoops, 7.6.04 SP4 -Original Message- From: Kemes, Lisa A DLA CTR INFORMATION OPERATIONS Sent: Monday, October 28, 2013 12:37 PM To: arslist@ARSLIST.ORG Subject: Reset CRQ on Change We created a couple of tests on our prod system (before turning it loose) and we would like to reset the

How to determine when a user last logged in

2013-10-28 Thread SUBSCRIBE ARSLIST theReel
Hi Guys, Is there a way to determine when a user last logged into Remedy/ITSM without having to enable the user logs. Basically I want to identify any user accounts that have not logged into Remedy in X months. We have a multi-tenant ITSM 8.1 environment and do not have full control of our

Re: How to determine when a user last logged in

2013-10-28 Thread LJ LongWing
Tony, The only way I'm familiar with is to write workflow that stores the value somewhere in your system. On Mon, Oct 28, 2013 at 10:55 AM, SUBSCRIBE ARSLIST theReel tony.r...@bt.com wrote: Hi Guys, Is there a way to determine when a user last logged into Remedy/ITSM without having to

Re: How to determine when a user last logged in

2013-10-28 Thread tboot...@objectpath.com
** You can investigate this: Onthe ARSystem Server configuration tab - enable the field : License Tracking Peridocially check the form called" ARSystem Administration: License Review" form for entries (userids)that do not appear in this form that appear in your User or appropriate CTM:People

Re: How to determine when a user last logged in

2013-10-28 Thread Misi Mladoniczky
Hi, Why not enable the user-log or the historical-license-usage form as suggested by Terry? I guess if you want to go back in history from today, this would not be an option. And you need to track user-updates to the system, which can be a bit tricky... Best Regards - Misi, RRR AB,

Re: How to determine when a user last logged in

2013-10-28 Thread Brian Goralczyk
I second LJ's response. It is a simple task to update a field created in the system. There is no way you are going to get information that if you didn't gather it. But it is easy to start gathering it and you can also then assume that anyone that doesn't have the field filled in hasn't logged

Re: Change Management

2013-10-28 Thread patchsk
In my current and previous organizations BSAs submit the CRQs, schedule the timeslots and get the approvals working in close coordination with main dev team handling the majority of the change. They create tasks for respective dev teams, and then developers update the tasks with the

Multiple Mid-Tier, single Tomcat

2013-10-28 Thread John Baker
LJ, Perfectly valid but I don't think it's going to be the best way to deploy Mid Tier. The biggest issue with Mid Tier, the issue that hasn't been correctly addressed in the last 8 years, is the poor memory consumption and cache performance. As such, multiple Mid Tiers means multiple sets of

Re: How to determine when a user last logged in

2013-10-28 Thread Misi Mladoniczky
Hi, How do you gather a login? In Mid-Tier there is no general trigger. You can put workflow on common forms where users usually go. For example the home-page. But any such change is customization. Using the user-log or historical-license-usage-form is configuration. You can then leverage that

Re: How to determine when a user last logged in

2013-10-28 Thread LJ LongWing
Terry, One problem I have with the BMC's provided historical license usage form is that it doesn't cover 'all' users...only users with write licenses...why does this matter you ask? Well, Read and Read Restricted users are completely valid users of the system, but because their licenses don't

Re: Multiple Mid-Tier, single Tomcat

2013-10-28 Thread LJ LongWing
I agree that it's not ideal, nor is it recommended by BMC...but I have had reasons to run in this configuration MANY times over the years. and BTW...I figured out what was happening. The PermGen space was being exhausted (by the memory hungry application)...so increasing the permgen space

Multiple Mid-Tier, single Tomcat

2013-10-28 Thread John Baker
PermGen is for long term storage, ie class file definitions, and I thought (but am not sure) that the memory would be shared between different classloader and hence web applications. Therefore, the AR API Field class is stored once and shared between multiple Mid Tier instances. But maybe I'm

Service Request Approval from mobile device

2013-10-28 Thread Rudra Kamat
Hi Team, We are using out-of the box functionality of approving request from email, when I approve request from outlook it works perfectly,but I approve request from mobile(smartphone), Its not executing modify action in AP:Details-Signature form, request still keep in Pending Approval Status.

Re: How to determine when a user last logged in

2013-10-28 Thread Theo Fondse (Gmail)
Hi Tony, This is easy if you create a simple data form and an active link that gets attached to all your active forms used by your users on Window open. I have created such a form for the same reason and it works well. You can use archiving to clear old data from this form. Also make

Re: How to determine when a user last logged in

2013-10-28 Thread Misi Mladoniczky
Hi, Even more importantly, from a cost perspective, the AR System Historical License Usage form does not track FLOATING-READ licenses, only FIXED-WRITE and FLOATING-WRITE... Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I.

Re: How to determine when a user last logged in

2013-10-28 Thread Misi Mladoniczky
Hi, From a performance perspective, it is not good to add extra transactions to the server on any form you open. It might not be much of a hit if you look on it separately, but things (and latency) ads up. You might want to limit it to as few forms as possible, and you might also consider

Re: How to determine when a user last logged in

2013-10-28 Thread Carl Wilson
Hi, If you are API savy, you can do this using the API using the following class (this is a Java reference): ListUserInfo // public ListUserInfo getListUser(int type) throws ARException // Returns a list of users on the specified AR System server. You can retrieve information about the

Re: How to determine when a user last logged in

2013-10-28 Thread LJ LongWing
Carl, I have similar tools, but the problem with this approach is that it's polling based, meaning that your program must poll the server every x seconds/minutes to gather the list and do something about it. While this will grab 'broad strokes' of user activity...it won't provide the finer

Re: How to determine when a user last logged in

2013-10-28 Thread Eric Roys
I wrote something with java api a few years back that would track the user login, license consumed, whether they were denied a token because there were not enough available at the time, and then correlate it with which company/org, and other things that mattered in an MSP environment. It ran as

Re: How to determine when a user last logged in

2013-10-28 Thread Carl Wilson
Hi LJ, Maybe true, but if you do this correctly then you do not miss information - including Read and Paper based licenses, which my application will pick up Unfortunately, I come across a number of organisations who are not willing to do the log file approach. I have a number of

Re: How to determine when a user last logged in

2013-10-28 Thread Misi Mladoniczky
Hi, Unfortunately the UserInfo-API-call does not give you information about if a FLOATING-READ has been granted because of a lack of licenses on the server, or because the user did not yet access any form data. I have also written a polling tool that produces a log file based periodic API-calls.

Re: How to determine when a user last logged in

2013-10-28 Thread LJ LongWing
Misi, About a year ago I figured out a way to determine Floating-Read users. There are two methods (in Java)...one is .getLicenseType(), which gives you the users license type, then there is another of .getCurrentLicenseType(), which at least in the case of Floating users, if they are assigned a

Re: How to determine when a user last logged in

2013-10-28 Thread Eric Roys
LJ, Sounds about right. I'm sure there was probably additional extrapolation beyond that even. Like I said, it's been a few years. (early version 7ish). -Eric From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Monday, October 28,

Re: Reset CRQ on Change

2013-10-28 Thread Schon, Stuart
Best not to reset the number but more it forward to a good new start point, there are too many cross dependencies that will use the existing numbers to easily reset the start number back As others have said there is a separate table that is used to provide the next number Stuart Schon Service

Re: How to determine when a user last logged in

2013-10-28 Thread Ars Lister
Most environments, including multi-tenant environments, use Active Directory or an outside data source (Peoplesoft, Oracle Apps, etc.) to manage People entries and hence access.  If that is the case with your environment, I strongly suggest that you reconcile against the outside data on a

Re: How to determine when a user last logged in

2013-10-28 Thread Carl Wilson
Hi, Here is some further information to LJ's . ListUserInfo // 0 = AR User License, 1 = FTS License, 2 = Reserved (Ignore) // License is worked out on LicenseType and CurrentLicenseType for Floating and Fixed // [License Tag = Write, License Type = Floating,Current License Type =

v8.1 email engine - truncated incoming message

2013-10-28 Thread Susan Palmer
Hi everyone, We've started receiving incoming emails from a customer. The email engine retrieves them and I see the full message in the AR Email Messages form. The template in the email contains the form (staging form) that the message should populate. And it does populate the staging form,