Re: E-mailing a Report (UNCLASSIFIED)

2007-11-16 Thread Jason Miller
Glad that helps. I will have to try recording the credentials in the macro, that is a great tip! Since this is currently setup to run from an escalation it is already using admin rights. But now that I think about it I could create special report users with various group permission and record di

Re: E-mailing a Report (UNCLASSIFIED)

2007-11-16 Thread Jason Miller
That is exactly what the little Remedy app we wrote does. Do you have Crystal Reports? A quick win maybe using Crystal Reports Exporter from a scheduled task (it doesn't need to be run on the server). Jason -Original Message- From: Action Request System discussion list(ARSList)

Re: arslist Digest - 15 Nov 2007 to 16 Nov 2007 (#2007-508)

2007-11-16 Thread Sunshine.acosta
I will be on vacation Monday, November19, 2007 and returning Monday, November 26, 2007. I will respond to your email when I return. For immediate assistance regarding the Canon Project, please contact Norbert Gerlach at [EMAIL PROTECTED] ___

Re: Direct SQL Active Link to query Oracle from SQL Server

2007-11-16 Thread brooksm
I figured it out. In the Linked Server Properties under security, I needed to select "Be made using this security context" and fill in the Remote login and password with the ARAdmin credentials. So it worked fine when I did a query in SSMS, but when I tried the query in Remedy it did not work. Th

Re: Question: SLA/SLM - Business Hours / Holidays

2007-11-16 Thread Rabi Tripathi
For dates that are constant every year, such as Jan 1 July 4 Dec 25 or, ones such as US Labor day=1st Monday of September US Thanksgiving Day=4th Thu of Nov ..try playing with Recurrence Type = Yearly You will likely need another segment(s), with any level higher than 2. Higher than 2, differe

Re: CMDB 6.3 error "You have no write access to the field DataSet Name"

2007-11-16 Thread Moore, Chris
Wow- I can't believe I've been doing this as long as I have and didn't know about that >< Thanks a lot- this will be a huge help! Chris -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, Novem

Job: Remedy Administrator - Colorado Springs - Permanent

2007-11-16 Thread Kitchen, Joshua T
Dear List, Duration: Permanent Title: Remedy Administrator Salary Range: 70-75K Location: Colorado Springs, CO This project is for the Army Base in Colorado Springs, CO to work as a Permanent Employee with a Defense Contractor. Remedy(r) Administrator Colorado Springs, CO. Permanent Positi

Re: CMDB 6.3 error "You have no write access to the field DataSet Name"

2007-11-16 Thread Carey Matthew Black
Chris, In the Admin tool Connect to and select the server of interest.. File(menu) --> Server Information(Item) --> Log Files (Tab) There is a setting "Client-Side Logging Group". Set this to a Group (AKA: Group form entry) that you want to allow to do client side logs. (Filter/API/SQL) Make

Re: Direct SQL Active Link to query Oracle from SQL Server

2007-11-16 Thread brooksm
Gary, >From my Remedy server on SQL Server 2005 I am able to query the oracle dblink on Prod, but not the Oracle dblink on staging. Both Oracle db are on Red Hat Linux. I've gone through these KB articles and verified my settings. http://support.microsoft.com/kb/839279 http://support.microsoft.com

Re: Is there a URL parameter to control list/detail display?

2007-11-16 Thread Pargeter, Christie
If you do a View Properties then the Appearance tab. There is a box called Pane Banner Visibility, under that is 3 fields you can hide or keep visible: Details Pane Banner, Results Banner, Web Toolbar. We have the Web Tool bar set to Hidden. From: Action Reque

Re: Is there a URL parameter to control list/detail display?

2007-11-16 Thread Wacholz, Jeanette (Jenni)
I'm not seeing how to control it from the form view properties. All I see there is detail or result banner control and detail/result layout control, not how to hide the result pane completely. I've tried setting the banners to "hidden" but that's not hiding the results pane. I know it can be contro

Re: CMDB 6.3 error "You have no write access to the field DataSet Name"

2007-11-16 Thread Moore, Chris
Carey- How do you enable a non-admin user to log filter actions? I did not know such a thing was possible! Thanks, Chris -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, November 16, 2007 2:3

Re: CMDB 6.3 error "You have no write access to the field DataSet Name"

2007-11-16 Thread Carey Matthew Black
Chris, Enable a user (non-admin) to turn on Filter logs. Login with the user. Turn on filter AND active link logs. Do the thing that produces the error. Check the log and find the workflow (Active Link or Filter) that does the SET operation that fails. That should not take more than a few minutes

Re: CMDB 6.3 error "You have no write access to the field DataSet Name"

2007-11-16 Thread Moore, Chris
Thanks Kelly, Unfortunately we're on Oracle >< Chris From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gatewood Kelly Sent: Friday, November 16, 2007 2:16 PM To: arslist@ARSLIST.ORG Subject: Re: CMDB 6.3 error "

Re: CMDB 6.3 error "You have no write access to the field DataSet Name"

2007-11-16 Thread Gatewood Kelly
Chris, if you are on MS SQL server this may help identify the filter. Open Query Analyzer and run the following. select name from filter where filterid in (select filterid from filter_push where assignShort like '%DataSet Name%') and filterid in (select filterid from filter_mapping where schemaid

Friday Humor

2007-11-16 Thread David Yearsley
Bathroom Talk A 3-year-old tells all from his mother's restroom stall. By Shannon Popkin My little guy, Cade, is quite a talker. He loves to communicate and does it quite well. He talks to people constantly, whether we're in the library, the grocery store or at a drive-thru window. People oft

ITSM 7 in the Military Environment (UNCLASSIFIED)

2007-11-16 Thread Luttmann, Michael W CTR USA
Classification: UNCLASSIFIED Caveats: NONE Hooah, Military Listers! I'm setting up ARS 7.0.1/ITSM 7 for Fort Carson, hopefully to have a functional system by mid-December. We are currently on ARS/ITSM 6.3 (MS-SQL 2000, Win 2003). I'm NOT planning on migrating much data at all (maybe a CTI tra

Re: ITSM 7 in the Military Environment (UNCLASSIFIED)

2007-11-16 Thread Roger Justice
The only item that was requested when I set up ITSM 7 was to change the name of the Title field on CTM People to Rank/Title and make it required?and add the field to both Incident and Change with modified workflow to autopopulate when requester is selected. They used to Company at the major comm

Re: Work in Iraq is worth more now, it is Friday

2007-11-16 Thread Darrell Reading
Without going into much detail, I will say that I saw the help desk application first hand over there, and talked to a guy linked with the company. It's not too bad of a set up, except that if I recall correctly, a person would share living accommodations with one other for a while. I didn't reme

Re: Filter Guide table Loop - External Table qualification question. - Solved

2007-11-16 Thread Reiser, John J
Hello Listers, Sorry for the short cycle on this one. After I sent the email I tried adding my Set fields of the $table_qual$ in the calling filter , between the first and second Call guides. That was it. Having the EXTERNAL($table_qual$) set in the actual table looping filter seems to have no e

CMDB 6.3 error "You have no write access to the field DataSet Name"

2007-11-16 Thread Moore, Chris
Hey everyone- Administrators don't get this error, it must be a filter because I can't log it as a non-administrator. This is on the form AST:ComputerSystem. If a non-administrator changes, for instance, the serial number and tries to save, they get this error. The field DataSet Name is no

Re: Migration of Tickets

2007-11-16 Thread Rabi Tripathi
Rami, Can you explain how you did the "migration"? Where did the tickets come from? Older version? How many? And what do you mean "push ticket" from requester console? Create a ticket from requester console manually like a user would do in Remedy User? Turn on filter+active link+sql logging in Re

Re: Is there a URL parameter to control list/detail display?

2007-11-16 Thread Pargeter, Christie
I thought you could control this on the view properties of the form/view. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wacholz, Jeanette (Jenni) Sent: Friday, November 16, 2007 10:07 AM To: arslist@ARSLIST.ORG Subject

Filter Guide table Loop - External Table qualification question.

2007-11-16 Thread Reiser, John J
Hello Listers, ARS 6.3 Patch 021 MS SQL Server 2000 I am trying to use a Filter Guide table loop to select certain children records for inclusion in a Notification email. The children are created via AL Pushes during the entry of a new record. When the Submit occurs I use a Filter Guide Table lo

Is there a URL parameter to control list/detail display?

2007-11-16 Thread Wacholz, Jeanette (Jenni)
Hi list! I am implementing the OOB survey functionality. It's working as expected. However, one thing we don't like is that the survey response screen opens with a split pane...list above/details below. We would like it to open with just the details pane; no list since there will always only be th

Migration of Tickets

2007-11-16 Thread Rami S Ayoub
** Hi List, I'm trying to migrate Helpdesk ticket from system to system version 7.x After migration of tickets done, when trying to push ticket from requester consol I got this issue below ARCreateEntry - The value(s) for this entry violate a unique index that has been defined for

Job: Dayton, OH - Subject Matter Experts ITSM 7

2007-11-16 Thread Kitchen, Joshua T
Dear List, I am at it once again with the Dayton, OH - Remedy ITSM 7 Project. Just had a conference call with the Process/Project Manager these two positions are fully budgeted for and ready for hire. Candidates must have a DoD Secret Clearance or NAC. For first time readers on this project,

Re: Migration of Tickets

2007-11-16 Thread Rick Cook
Rami, you can't push tickets directly into the HPD:Help Desk form - you have to push them into the HPD:IncidentInterface_Create form, which will create the Incident records. And if you're pushing many thousands of records, there will be some performance enhancements you'll want to have put in plac

Re: Customization CMDB Asset Discovery

2007-11-16 Thread Easter, David
> I was told by a BMC representative that the CMDB does not cost us, is this correct? CMDB is not free. It is included at no additional charge with the purchase of many BMC products including the ITSM applications, Discovery, Configuration Automation and Service Impact Manager. If obtained as p

Re: Migration of Tickets

2007-11-16 Thread Rami S Ayoub
** Rick, the ticket most of them is resolved and close ticket, how I can push the data to HPD:IncidentInterface_Create. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Friday, November 16, 2007 6

OT: Work in Iraq is worth more now, it is Friday

2007-11-16 Thread Daniel Bloom
I would guess that the folks in the middle, as many of us speculated, were a bit greedy and could afford to pay those that risk their lives a bit more .. July: should exceed $235,000 based 52 weeks of in-country work August: should exceed $250,000 based 52 weeks of in-country work. October

Re: Question: SLA/SLM - Business Hours / Holidays

2007-11-16 Thread T. Dee
Rabi - thank you very much - this helped alot! Quick question - when I did holidays I used Level 2 and I select Recurrence Type as "Specific Dates" and I did the following: 12/24/07;12/25/07;12/26/07 The problem with this is this will have to be modified every year or I can put the holidays

Question: SLA - Milestones / Actions

2007-11-16 Thread T. Dee
I was wondering if anyone has created a Custom Action for an SLA that updates the Worklog in Help Desk? I'm trying to do this, but not having much luck. Any suggestions! Thanks! Happy Friday !!! ___ UNSUBSCRIBE or acc

Re: Migration of Tickets

2007-11-16 Thread Rick Cook
You will be creating Incidents in a Closed or Resolved state. You should dig into how Incidents are created in v7 - it's completely different than in previous versions, and there may be some validation Filters that prevent you from importing Closed tickets - I haven't tried importing them. I unde

Re: E-mailing a Report (UNCLASSIFIED)

2007-11-16 Thread Julie Rockwood
Hi Jason, Thank you for the overview. I was doing something similar, but it involved a cgi script that was hard to maintain, only worked on the mid-tier, and created a security hole. This is much better. By the way, you can put a login id and encrypted password in the macro (just record y

Re: Automated delete function (UNCLASSIFIED)

2007-11-16 Thread Alicea, Alex CTR USA
Classification: UNCLASSIFIED Caveats: NONE Thanks Gary. I believe this is exactly what we need. Alex -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Friday, November 16, 2007 10:56 AM

Re: Automated delete function (UNCLASSIFIED)

2007-11-16 Thread Opela, Gary L Contr OC-ALC/ITMA
You can set up a filter that runs on Delete that does a run process of Application-Delete-Entry and specify the form and the ticket number. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion l

Automated delete function (UNCLASSIFIED)

2007-11-16 Thread Alicea, Alex CTR USA
Classification: UNCLASSIFIED Caveats: NONE Listers, We have automated a process in which when we create a new user account it pushes there information to 2 other forms. Is it possible to create a Active Link, filter or macro, so when we delete a user, it also deletes the user from the othe

Re: How to stop a CREATE/MODIFY operation

2007-11-16 Thread Rabi Tripathi
Phani, May be. What's your goal? What problem are you trying to solve? Please provide some context. Why would displaying an error not work for you? --- "HonnourPrahalladachar, PhaniRaja" <[EMAIL PROTECTED]> wrote: > Hi List, > > Is there a way to stop a CREATE/MODIFY operation > other than dis

Re: Integration Right Answers with Solutions Database

2007-11-16 Thread Bill Hoffmeier
Environment details: ITSM 7.0.02 (Incident, Problem, Change, CMDB, SLM) NO RKM ARServer 7.01 patch 3 (soon patch 5) RightAnswers 3.5.1 Linux RHEL Oracle 10g Thank you Ben and Anne for your replies. The resolution tab I'm referring to is on the Incident Managemen

OT- Increase in compensation:::::Remedy Engineer - OCONUS-IRAQ

2007-11-16 Thread Jeff Glaser
The annualized compensation package for this position has been increased to $275,000 (inclusive-base plus foreign service and hazardous/dangerous duty pay). Remedy Engineer for deployment to IRAQ to work on a major contract which requires excellent skill sets, US Citizenship and a current

Re: SLM v7.1 software is out... but the docs are incomplete....(Was: Re: OT-Support Question - Whine - Rant )

2007-11-16 Thread Rick Cook
Good idea, Matt and Axton. Complete release notes, have, unfortunately, been an issue for recent Remedy patches, though. Apparently the product and/or release manager thinks that providing them is less important than we think it is. Changing that would make me happier. Rick -Original Messa

SLM v7.1 software is out... but the docs are incomplete....(Was: Re: OT-Support Question - Whine - Rant )

2007-11-16 Thread Carey Matthew Black
In case you care and missed it They appear to have released the v7.1 SLM software yesterday. However, they have yet to update the "Remedy Product Compatibility Matrices" page. (And some of the published product doc reference the "Remedy Product Compatibility Matrices" page for important details

Re: SLM v7.1 software is out... but the docs are incomplete....(Was: Re: OT-Support Question - Whine - Rant )

2007-11-16 Thread Axton
Release Notes would be a good home for such information. Could also be included in the release notes for each path level. Axton Grams On 11/16/07, Carey Matthew Black <[EMAIL PROTECTED]> wrote: > In case you care and missed it They appear to have released the > v7.1 SLM software yesterday. >

Re: Integration Right Answers with Solutions Database

2007-11-16 Thread Watson, Benjamin A.
Bill, based on your questions below, I cannot determine which "solutions database" you're using (Out of the Box, RKM, something else). You mention the "resolution tab", which I assume is akin to the Knowledgebase tab on the ITSM6 HPD:HelpDesk form after installing RKM. >>My questions: >>Are you

ADM: Please Ignore Test

2007-11-16 Thread Daniel Bloom
timing test 9:04am EST ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

ESS and ARDBC Plugins on ARS 7.0

2007-11-16 Thread Pierson, Shawn
Good morning folks, I've been successfully using the AREA and ARDBC plugins on Remedy for a while now, but we also own the BMC Identity Management suite. We've been looking into getting rid of the front end of that so we can put it in Remedy, and BMC has provided a plugin to the ESS module. Unfo

Re: Direct SQL Active Link to query Oracle from SQL Server

2007-11-16 Thread Pierson, Shawn
Every time this has happened to me, it has been because they don't have the MSDTC service running on the SQL Server, specifically. I would have the DBAs check that and if it's not running, turn it on. Shawn Pierson -Original Message- From: Action Request System discussion list(ARSList) [

Re: Direct SQL Active Link to query Oracle from SQL Server

2007-11-16 Thread Opela, Gary L Contr OC-ALC/ITMA
Brooks, I really think that it is the issue I pointed out the other day. I've run into this three times so far -- Once whenever they upgraded my remote server from server 2k to server 2k3, once when they upgraded my current server from server 2k to server 2k3, and once when they applied patches on

Re: E-mailing a Report (UNCLASSIFIED)

2007-11-16 Thread Alicea, Alex CTR USA
Classification: UNCLASSIFIED Caveats: NONE It doesn't have to be elaborate, just compile a weekly list of the tickets created on form and forwarded it on e-mail to someone. I know I can send a e-mail notification with the fields each time one is created but I was thinking that instead of bombar

Re: Error 302: Entry does not exist in database

2007-11-16 Thread Misi Mladoniczky
Hi! This message is given when the system tries to do an ARGetEntry and the records does not exist. The most common cause I have seen is that you do a Modify->Save or a Push->Fields, and somewhere along the way your record is deleted using Application-Delete-Entry or some such command. The other

Re: Floating licenses not recognized

2007-11-16 Thread Misi Mladoniczky
Hi Mike, If your server license works and the floating licenses do not, I suspect that you have received wrong licenses. Verify that the HostID-part of the floating licenses correspond to the server license. You can enter any license with a correct key into your system. If the HostID does not ma

Re: E-mailing a Report (UNCLASSIFIED)

2007-11-16 Thread Jason Miller
Hi Julie, I plan on putting together the files and a def for anybody that wants to use it. This was done as a proof of concept a while back for a coworker and not something I am actively using. I need to do a little bit of cleanup before I post it. Here are the ingredients: (FYI, this i

How to stop a CREATE/MODIFY operation

2007-11-16 Thread HonnourPrahalladachar, PhaniRaja
Hi List, Is there a way to stop a CREATE/MODIFY operation other than displaying a Error Message on the User Tool. ARS 7.0.1 SQL 2005 Regards, Phani. Voip: +44 20718 25413 This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary mater