Re: Report on Users in Groups

2006-10-23 Thread Gareth Oliver
** Hi Harold,I recently had to provide this information, which I did via SQL MS-SQL version: select group_name, full_namefrom group_xjoin user_x on (group_list like '%' + cast(group_id as varchar(50)) + ';%')group by group_name, full_nameOracle version: select group_name, full_namefrom

How to determine a filter which denies deleting requests from a form?

2006-10-23 Thread Bezhenar, Dmitry
** Hello List, I am trying to delete requests from a form using "Ctrl + D", but nothing happens.Actions - Delete button in also "frozen". It seems to me that some filter denies deletes on this form, but I can not determine which one exactly.Could anybody tell me what should I search for in

Re: How to determine a filter which denies deleting requests from a form?

2006-10-23 Thread Misi Mladoniczky
Hi Dmitry, What do you mean by frozen? Do you mean disabled? In that case, I would check ARAdmin-Form-CurrentView-Properties-MenuAccess-Delete. A filter stopping the operation should give you an Error Message. Best Regards - Misi, RRR AB, http://www.rrr.se Hello List, I am trying to

Re: How to determine a filter which denies deleting requests from a form? - Resolved

2006-10-23 Thread Bezhenar, Dmitry
Hi Misi, Yes you're right. The problem was in MenuAccess for the current View. My assuption about filter limitations was wrong. Thank you. Kind Regards / C ? Dmitry Bezhenar -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On

RE : Badly displayed forms ** FIXED ***

2006-10-23 Thread Frex Popo
** A member of the ARLIST helped me resolve this ... The midtier was not set to prefer windows view over Web view!!In case someone forgets to set this option and wonders why the hell the forms are all over the place :)thanks to everyone for their assistanceFrexpopoFrex Popo [EMAIL

Re: Enhancement: Schema ID on AR Admin tool...

2006-10-23 Thread Lucero, Michelle - IST contractor
Jay, Did you already submit an enhancement request for this? Because I would definitely see the benefit in this. I'll go one a little further. Add an extra tab to the AL/FIL guide that lists all of the AL/FILs that actually do the calling. I too had to grab this through SQL. Michelle

Re: ARERR [90] Cannot establish a network connection to the AR System server : arserver (0) : RPC: Program not registered (U)

2006-10-23 Thread Dan Caissie
Title: Message ** This fixed the issue with a little tweaking. Thanks! Dan Caissie Remedy Administrator / Developer United Natural Foods, Inc From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hennigan, Sandra H CTR OSD-CIO

BMC Discovery Suite

2006-10-23 Thread Pierson, Shawn
Title: BMC Discovery Suite ** Hello folks, My company is looking into using the BMC Discovery Suite (Foundation, Topology, Configuration) to populate our CMDB and leverage that for our ITSM applications. I'm wondering if any of you have experience with it and what your general opinion is.

Re: ARERR [90] Cannot establish a network connection to the AR System server : arserver (0) : RPC: Program not registered (U)

2006-10-23 Thread Hennigan, Sandra H CTR OSD-CIO
Title: Message ** UNCLASSIFIED Great! Sandra Hennigan OSD Remedy Administrator Office # 703-602-2525 x251 CACI - Ever Vigilant Apparently, there is nothing that cannot happen today. Mark Twain -Original Message-From: Action Request System discussion list(ARSList)

Re: BMC Discovery Suite

2006-10-23 Thread Rick cook
Title: BMC Discovery Suite ** For a competitor, try FrontRange ITSM if you want. The problem may be that it shows very well, and has a couple of very nice features that Remedy doesn't have, but the engineering and support underneath it is not nearly as good as ARS. Also, don't even try to

Re: Enhancement: Schema ID on AR Admin tool...

2006-10-23 Thread Joe DeSouza
** Troubleshootingone of my customers application for performance, so since SQL logs show TschemaId on SQL logs, I have to query the arschema table all the time before opening the form in question in the Admin tool.. which is where I found that if the admin tool listed the schemaId's with their

Creating an Email Template to Search Using a Qualification

2006-10-23 Thread Marquez Rankin
** This seems like it could work well for simple reporting requirements.It isdetailed in the Email Engine Guide but I have not had success with this. Has anyone gotten this to work? -SMR __20060125___This posting was submitted with HTML in it___

Re: Creating an Email Template to Search Using a Qualification

2006-10-23 Thread Julie Rockwood
** SMR, Here is a slightly updated version (from the August thread automatically generate email with report included of how I do it. By using the key rather than a password, anyone who stole the key would only be able to use it to perform email queries. Has anyone else found a more secure way of

Re: OT: DB design multiple joins

2006-10-23 Thread Reiser, John J
Carey, Scott, Axton Rick, Thanks for the ideas. I will give the GUID a try but I also have to account for the migration of data that is not in the exact same table structure as I am creating here. I plan to make my import files with Request_IDs for keys and then I can enable and distribute the

Re: Creating an Email Template to Search Using a Qualification

2006-10-23 Thread Julie Rockwood
** SMR, Query templates and results templates are totally different concepts in the Email Engine and it is very confusing that they call them both the templates. The query template is supplied in the Text field of the Notify Action. It contains the qualification for the report. The result

Sensing more than 1 table row selected

2006-10-23 Thread Frank Caruso
Anybody have any quick ways of telling whether a user has selected more than 1 row in a table field? I know I can do a table walk but that will require roughly 3-4 objects. Thank you. ___ UNSUBSCRIBE or access ARSlist

Re: Cannot find Escalated? Escalation

2006-10-23 Thread Thomas Bean
Title: Cannot find Escalated? Escalation ** I'm using Help Desk 5.5, but I'm guessing the workflow probably didn't change much in version 5.6. The escalation that triggers the process is "RSM:ESC-SendNotification", this updates the RSM:Escalation form. A filter on this form named

Re: Enhancement: Schema ID on AR Admin tool...

2006-10-23 Thread remedy
ARUtilities lists all the schema IDs with the schema names. When doing a View By the schema IDs are included. Hope this helps. Les Troubleshooting one of my customers application for performance, so since SQL logs show TschemaId on SQL logs, I have to query the arschema table all the time

distinct search on a table field

2006-10-23 Thread Halstead, Robert
** I was wondering if it's possible to do a "distinct" search on a table qualification. Distinct meaning SQL's "distinct" keyword. I have a form built kindof like how CTI is designed and I would like to return, in this case, the Type but not have the duplicate results. Is there a search

Re: Enhancement: Schema ID on AR Admin tool...

2006-10-23 Thread McKenzie, James J C-E LCMC HQISEC/L3
Title: RE: Enhancement: Schema ID on AR Admin tool... ** Les: I used to work in a shop where we built a custom form that would list the available schemas, the schemaid. This was done through an SQL Menu. Clicking on one of the available schemas gave you the current value of the nextid. This

Re: distinct search on a table field

2006-10-23 Thread Frank Caruso
** Nothing like a KEYWORD but you could create a View form of the table and use DISTINCT in the SQL statement. Then use that View form in your table field.On 10/23/06, Halstead, Robert [EMAIL PROTECTED] wrote: ** I was wondering if it's possible to do a distinct search on a table

Re: distinct search on a table field

2006-10-23 Thread Halstead, Robert
** would I be able to use a view form on a form inside remedy? I'd just use the form name as the table name? Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank CarusoSent: Monday, October 23, 2006 1:21 PMTo:

Re: distinct search on a table field

2006-10-23 Thread Frank Caruso
** That is correct. You can use the Remedy View name. You could also use the table name (T142,etc) but that would mean all your Remedy servers would need to have the same ID for that table. it would also make the SQL al little more involved. On 10/23/06, Halstead, Robert [EMAIL PROTECTED] wrote:

Re: distinct search on a table field

2006-10-23 Thread Halstead, Robert
** how would I do the SQL query? doesn't seem like I can do it with the creation of the view form. Sorry, kindof dumb when it comes to the view form. I haven't used it much at all. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of

Re: distinct search on a table field

2006-10-23 Thread Frank Caruso
** YOu create the view of the Remedy form after the form is creates\modified. Something like:create view test_view as select DISTINCT col1,col2,col3 from view_nameCheck out page 174 in the Basic Guide v6.3 On 10/23/06, Halstead, Robert [EMAIL PROTECTED] wrote: ** how would I do the SQL query?

Re: distinct search on a table field

2006-10-23 Thread Frank Caruso
** You got it :)On 10/23/06, Halstead, Robert [EMAIL PROTECTED] wrote: ** ahh, I get it now. I create a database view then attach the view form to that database view. Bob Halstead From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank

Using a 7.0 Midtier with a 5.1.2 Server

2006-10-23 Thread Kaiser Norm E CIV USAF 96 CG/SCWOE
** Hello everyone, Is it possible to use a 7.0 Midtier and a 5.1.2 server? Has anyone ever tried to do such a thing? I know it sounds weird, but I have good reason for trying this. As it stands, I'm getting the "Authentication Failed" error and am wondering if this is due to the old

Re: Cannot find Escalated? Escalation RESOLVED

2006-10-23 Thread Shane Buchholz
Title: Cannot find Escalated? Escalation ** Thats the one. Don't know how I missed that. Must be Monday. Thanks, Shane -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Thomas BeanSent: Monday, October 23, 2006

Re: Using a 7.0 Midtier with a 5.1.2 Server

2006-10-23 Thread Rick Cook
** Norm, I think that's probablythe result of ARS 7.0 requiring authentication in ways that previous versions of ARS did not. Ensure that in your Admin tool's connection settings, you have set your MT Password. Rick On 10/23/06, Kaiser Norm E CIV USAF 96 CG/SCWOE [EMAIL PROTECTED] wrote: **

Re: ARS as a development system

2006-10-23 Thread Hendershot,Bruce D.
Rick, Do you think anyone at that bank would be willing to have a phone conversation with me or an email exchange on the subject? Or, If you're willing to share their name with me or my BMC Rep. I'll go through the proper protocol for requesting it. Bruce [EMAIL PROTECTED] -Original

ARServer 7.0.01 SEGV

2006-10-23 Thread Axton
Has anyone received an error along these lines when starting ARServer 7.0.01? Mon Oct 23 14:38:18 2006 390600 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Mon Oct 23 14:38:18 2006 11 Timestamp: Mon Oct 23 2006 14:38:18.9069 Thread Id: 4

Re: ARS as a development system

2006-10-23 Thread Hendershot,Bruce D.
Thanks Tayler. We're in a similar situation in that we purchased the AR System about 10 years ago to build our ITSM tools and have since expanded it's scope significantly within IT, but only in a few instances outside of IT. Do you have any documented guidelines stating when it's appropriate to

Re: ARS as a development system

2006-10-23 Thread David Charters
I have been a consultant in the Remedy world for 10 years now. I can tell you there are countless companies that use ARS as a development environment. There are also companies (I believe Buoyant Solutions is one) that have developed custom products for sale in ARS. I would say there is huge

Re: Using a 7.0 Midtier with a 5.1.2 Server

2006-10-23 Thread Kaiser Norm E CIV USAF 96 CG/SCWOE
** Rick, Yes, I've synchronized the passwords in the Admin tool and the Midtier config page. So your suggestion of the 7.0 authentication not playing nice with the old 5.1.2 way was what bubbled to my mind first...but I was hoping we could confirm that to be true. Norm

Re: Using a 7.0 Midtier with a 5.1.2 Server

2006-10-23 Thread Grooms, Frederick W
** Norm, You didn't specify what patch level of 5.1.2 server you are on. As I remember you had to be atpatch 1389 or higher to use the Mid-Tier 6.3 with the 5.1.2 server. Could that be the problem? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On

Re: Remedy Support Site - STILL broken

2006-10-23 Thread Lammey, Peter A.
** When I had login issues before I forwarded them to my Sales Rep and eventually got a person to help but I didnt figure out how to solve it until I saw a response from Jim McKenzie on ARSList. On a Support ticket, I did also note to the tech support analyst that I couldnt attach anything

Re: Remedy Support Site - STILL broken

2006-10-23 Thread Rick cook
** I'm glad you got what you needed - my issues go beyond yours, I'm afraid, and no one has even attempted to get me past them. No excuses even offerred. Rick From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Lammey, Peter A.Sent: Monday, October

Re: Remedy Support Site - STILL broken

2006-10-23 Thread James Van Sickle
** Rick I submitted a ticket about all the issues I am having with the new support website on Friday. I came in to work today to find an email in my Inbox. The support rep who looked at my ticket only stated that he had passed my issues on to management, and opened an internal customer service

Re: ARS as a development system

2006-10-23 Thread CONDREA, Daniel
Hi All, Rapid Dev environment for this reason I hope that soon I get rid of ARS and replace with Windows Workflow Foundation. Regards, Daniel -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of David Charters Sent: 23 October

Re: ARServer 7.0.01 SEGV

2006-10-23 Thread Jarl Grøneng
Yes, had the same on a server ugraded from 5.1.2 to 7.0.1 running on solaris and oracle. The last action in sql log was a select against the Role form. The last action when truss'ing the arserverd was something about display properties. However, when doign the upgrade again and then from 5.1.2

Re: Enhancement: Schema ID on AR Admin tool...

2006-10-23 Thread Jarl Grøneng
Remedy had(has?) a tool to convert sql logfile schemaid's and fieldis to schemanames and fieldnames. -- Jarl On 10/23/06, Joe DeSouza [EMAIL PROTECTED] wrote: ** Troubleshooting one of my customers application for performance, so since SQL logs show TschemaId on SQL logs, I have to query