Hi All,
Do anyone know how to retrieve the Field Label for a particular Form
through SQL Query??
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
**
select Schemaid from arschema where name= 'Your Form Name'
select fieldname, fieldid from field where schemaid = schemaid retrieved from the first query
HTH
On 10/16/06, Sujatha Shanmugasundaram [EMAIL PROTECTED] wrote:
Hi All,Do anyone know how to retrieve the Field Label for a particular
**
Hi Sam,
The field name specifies the database name,but i need the label of the field,not the database name/
On 10/16/06, Sam Rx [EMAIL PROTECTED] wrote:
**
select Schemaid from arschema where name= 'Your Form Name'
select fieldname, fieldid from field where schemaid = schemaid retrieved from
Sujatha,
If you haven't changed the name of the label after creating it once, then it
would be the same as the database name and you can use this query to get that
name which corresponds to the Label name.
SELECT Fieldname FROM field WHERE schemaId =Schema_ID AND
fieldName='Field_name'
to
**
Listers,
Need some help quick! We just upgraded to AR 7.0 in a
server group, load balanced environment. We have run into several problems
with the migration, one of them being that all the filter or escalation notify
actions that have a Remedy User Group in the User Name: field
does
**
Actually, I still use this command about once or twice
a year. I use it to create a quick batch file when I am using DOS (boot to
a DOS disk). For example:
C:\ COPY CON g.bat press
enter
ghost -z9 -skip=\pagefile.sys -span
-split=695 press enter
Ctrl+Z this marks the end of the
file
**
Do you
want the new Application Server to help improve performance of the
existing applications, or was the goal to have a second set of
applications on the
same
database server, which would mean a second instance of Remedy in the
database?
Darren's answer is correct for the former,
**
Darren,
Here is something that *may* work - I haven't tried
it.
1. Create a full SQL database backup, just in
case.
2. Delete the new Group form within the Administrator
Tool.
3. Write down the value of schemaId in the 'control'
table.
4. Change the schemaId value in the 'control'
**
Thanks Ankur..its working Fine
On 10/16/06, Gulati, Ankur [EMAIL PROTECTED] wrote:
**
Hi Sujatha
I went in to archives and found out this query to get the field lables from SQL Query. Just replace the schemaid in all the three places in there. It works perfect.
select vuiname, fieldName,
**
Stephen,
We dont want the original table
because it is the old 5.x version. Before I did the delete and replace, I
tried importing the new Group form over the old one but it wouldnt let
me and just errored out.
Darren Lau
From: Action Request
System discussion
**
Thanks for the suggestion. Our
original table number for the Group form was 80. Wouldnt we want
to use that instead of 20? Also I installed a fresh, out of the box
installation of AR 7.0 on a test machine and the table number for Group was 21.
FYI.
Darren Lau
ATT Advanced
**
Darren,
If you have another 5.x installation (even on your own
computer) you could run the 7.0 upgrade. This will convert the Group
formto 7.0. Then, export the Group form and import into your 7.0
load balanced environment.
Stephen
From: Action Request System discussion
list(ARSList)
**
In my environment (6.3) the Group form uses 20 for
tables. Use the number of your original Group tables. I am not sure
if the number itself is that relevant, except perhaps that the ARS system
"knows" which number it is expecting for Group.
Stephen
From: Action Request System
Hi,
Trying to run runmacro from a Linux ES3 box. Took the binary and cat files
from installation archive.
Having problems with runmacro binary not able to locate the runmacro.cat
file. Can anyone maybe help me of what Im doing wrong?!
Thanks!!
Best regards,
Rasmus
Adding a scenario showing my
**
Listers,
I need a way to run a report [or populate a form] that contains a record
for each user in each group. This would be similar to the data contained
in the SHR:Assignments form in the Service Desk module, but alas, the
large company I am working for does not have the module in place.
Listers,
I'm trying to find a way to re-sync the groups listed in the Group List
field in User form to the records in a Group Membership form that contains
records for each group and member for a table report.
A sample user in User form shows 500;1188;499;501;511;5169;510;453; in the
Group
**
Hi, All -
We are developing our first true Mid
Tier application, and are finding that anytime we perform an Admin cache
of the mid tier server, the first time an end user then loads the applet,
it is taking 15 - 30 seconds. This seems long to us.
Can we please get input from others
about
**
That's not all that atypical, Lori. You probably also noticed that subsequent loads are on the order of 1-2 seconds. If you can upgrade your Mid-Tier to 7.0 (OK with ARS 6.3), you'll see a performance increase.
Rick
On 10/16/06, Lori Gumbiner [EMAIL PROTECTED] wrote:
** Hi, All - We are
Title: Message
**
Lori,
Unfortunately it is hard to compare load times for forms because it
partially depends on the complexity of the form (e.g. number of fields, number
of extra items like tabs, view fields, etc) and the performance of the mid tier
server itself.
In my
experience when it
**
Every time you clear and reload the cache
on the server you will experience this issue. As the users constantly login/out
of the midtier and you dont re-cache the server, the times will decrease
to the point where 2 seconds or less is normal.
Thank You,
Chris
Doble
Title: RE: Mid Tier - Long Applet Load Time
**
Lori:
Looks about right. The system has to generate the Java Server Pages code for the form and that definitely takes time. Second and later loads of the page should be one second.
James McKenzie
L-3 GSI
Title: RE: Mid Tier - Long Applet Load Time
**
A question about first load caching... Does Mid
Tier simply download one or more files to the local client OR does Mid Tier
first "compile" or "assemble" one or more files and then download to the
client? If it's the later then is there a way to
ARS 5.01.02 p?
Sybase on Solaris
DSO
Have a filter that runs on MODIFY only. However, have found instances where
the filter is running on a MERGE action. So, I added a Run Process action to
log to a file when the filter runs and am outputting the following:
$USER$ $SERVER$ $SCHEMA$
**
If you record the macro with the user toolverify it
creates the csv in the place that you want. Then have the Escalation
execute a run process that calls runmacro.exe. Then a second action that
performs a PERFORM-ACTION-ADD-ATTACHMENT field_ID [file_name] to
attach the file to a
ARS 7.0.1
I was not able to get the Alt-M, 1 option to work.
I am looking for a way for users to press a key combination that can be
detected by the Windows User Tool and trigger an active link.
Specifically, I would like to be able to press something like Ctrl-S or
Ctrl-Enter on a *Display
Title: RE: Mid Tier - Long Applet Load Time
**
Mid-Tier "compiles" to the Java heap memory (this is for
6.3, I don't know about 7 yet).
Remedy has a script you can request that basically just
does a request on each of the forms you use to have the Mid-Tier load them into
memory.
Fred
Looks like they will have some serious bug-suppression to do on the new
SupportWeb. The patches pages is only showing one patch per product for
most products, and it is never the most current patch on the ones that I
looked at (usually not even the current version of the product). Other
searches -
**
The conversion actually went better than I thought it would, based on past experience. I agree that they still have some data to backfill, but it seems pretty functional overall.
My only quibble is with how they set my profile up. They nowuse an email address for a login ID, which isn't so bad
I see two major issues.
1) I am seeing the wrong Support ID tickets. (Same company, different
department. At least it is that close, but it is just as wrong as me
seeing Rick's tickets.)
2) I am not seeing the Mid-Tier being used
What the @[EMAIL PROTECTED] is this ASP/CFM stuff? ( I
I will go you one better. They don't even have my profile on record. I
have attempted to correct this now for the last 3 hours and no luck. I
am pulling my hair out over this one.
Christopher Pruitt
Consultant Specialist
EDS - Bank of America
mailto:[EMAIL PROTECTED]
-Original
You're lucky, we can't even log in properly - it recognises our names
but then won't show us our issues.
Susan Bentley
Service Management Analyst
ICT Services
Corporate Resources Directorate
West G
East Sussex County Council
P.O. Box 3
County Hall
St. Anne's Crescent
Lewes BN7 1SF
Tel: (01273)
**
Im pretty sure I have seen the ability to make
multiple selections from a drop-down list by using ctrl-left click. This isnt
a feature out-of-the-box so what is entailed in the workflow to do so? Could
someone kindly provide details of whats involved?
Thanks,
Richard
I notice that the main supportweb login uses my email address, but the
community downloads section still uses the old username.
Stephen
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pruitt, Christopher J
Sent: Monday,
I had the same issue with mine logon. I ended up just creating a new profile.
I use IE7, and another thing I keep seeing on the new site is the following
error:
Security Information
This page contains both secure and nonsecure items.
Do you want to display the nonsecure items?
This
I can see none of my issues (past and/or present).
- Why are they using cfm for the whole site? What kind of message are
they sending?
- When I drop down the nav menus at the top, if I am viewing a midtier
page, the menu chops off where it meets the mid-tier form. I
basically can't navigate
Title: RE: Try this out...
**
It's been so long since I powered it up... I remember the
Apple ][ used PR# and IN# (I think you opened "print" as a file inside basic
code, but you could also reference it by slot so a reboot to a disk drive on
slot 6 was PR#6)
When you added the CPM80 card it
**
I did notice that the email login mirrors what they're using for partner pages - I think it's a Siebel back-end.I hope I'm wrong. I hope more that they quickly see the problem behind using email addresses as apermanent primary key. What are we supposed to do if we change companies, create a
In the older versions of ARS, it was necessary to have a form view
called ARNotification in order to get the fields in your notifications
in the order you wanted them to be in.
Unless I missed it (possible) is it necessary in the newer versions that
use the email engine and templates?\
Thanks!
**
Rick -
It is a Siebel back end. This
was mentioned during my support tour in Pleasanton last week.
-tony
--
Tony Worthington
[EMAIL PROTECTED]
262-703-5911
Rick Cook [EMAIL PROTECTED]
Sent by: Action Request System
discussion list(ARSList) arslist@ARSLIST.ORG
10/16/2006 10:09 AM
**
Last week before they upgraded I went in and checked my
email address just to be safe.
You can go in and change your support contract
IDs.
It's strange that logout is in the little box on the left
instead of the top menu.
From: Action Request System discussion
list(ARSList)
**
Hi,Let us hope they compile a list of all the errors/bugs we have seen so far and resolve them asap..
Another problem I saw :
When I select an Issue and click the "Modify/View Issue" button and then click "Cancel" to close the issue dialog window, the Issue support page just hangs. I cannot
**
Darren,
I did run into this when I upgraded from 5.1.2 to 6.3. It turned
out I had to add External-Authentication-Return-Data-Capabilities: 31 to
my ar.cfg.
I hope this helps.
Julie
At 05:34 AM 10/16/2006, you wrote:
**
Listers,
Need some help quick! We just upgraded to AR 7.0 in a server
**
I checked my email address
last week as well.
Unfortunately, today
my 'Primary Support ID' is incorrect.Like Rick or someone
else, it's associated with a support contract that I haven't worked for in more
than a year. They didn't even have my current one listed. Even when
I manually
**
On another note...
Someone mentioned a Siebel
backend. We were told that the application was Remedy Customer Support.
To clarify... they are using CS, but
one of the backend feeds is Siebel.
--
Tony Worthington
[EMAIL PROTECTED]
262-703-5911
Lucero, Michelle
- IST contractor [EMAIL
**
The way I have seen (and personally use check fields) is to
delete the label and set the only option to the value I'm looking for. It
isn't possible to have a check field with no valueswhat would you then be
checking when you checked the field?
L. J. HeadSoftware EngineerRemedy
**
Yes, I do use AREA, and
External-Authentication-Return-Data-Capabilities: 31 may not work
for you. But it's worth a try.
Good luck!
At 09:50 AM 10/16/2006, you wrote:
**
Thanks Julie. Just curious, were you
using AREA? Cause we are not and it would seem that this parameter
has nothing to do
**
If you mean that you want one box with no value beside it, you put a space in the only value there.
Rick
On 10/16/06, Mimi Lakew [EMAIL PROTECTED] wrote:
**
Hi all,
I am creating a check field and I tried to delete all the selection values from attribute, however, I could not delete the last
Title: RE: SupportWeb
**
Fred:
Looks like Support Web is now broken. The link from BMCs support page loops back to itself...
James Mckenzie
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick
Hi, Folks:
Customer Service answered the phone. Yippee!!
They said that they are still working on the site. The individual who
answered the phone said to please give them about 1.5 hours. I think
I'm going to be nice and give them until tomorrow.
Thanks,
Michelle
ESM Mission: To provide the
Title: RE: SupportWeb
**
Fred:
Update: Yes it does work. Have to change my favorites tho'.
I got in and found all of the issues for myself, including one from my old employer. I do agree that an email address is a poor login choice, but it is better than some of the stuff I've had to put up
**
Exactly! it works with the space, I appreciate your helpRick Cook [EMAIL PROTECTED] wrote: ** If you mean that you want one box with no value beside it, you put a space in the only value there.Rick On 10/16/06, Mimi Lakew [EMAIL PROTECTED] wrote: ** Hi all,I am creating a check
**
Darren, Stephen
ARS does not care what table number the
Group and User forms are. The forms are recognized by the reserved field
IDs of the fields in the forms. In fact, you can have multiple copies of
the User and Group forms with different names, and they will all work. Do
not
**
Hello List, Is there anyway thatI don't know to convert an existing field type to anotherfield type,eg. character field to numeric field? I just want to check with you before I tell the user it is impossible.Thanks,
How low will we go? Check out Yahoo! Messengers low PC-to-Phone
**
Sara,
The only way I have done this in the past is
tofist create the new field. Run an
escalation to populate the data from
theexisting field you want to change
to the new field. Once completed, delete
the old field.
You need to ensure that the data you are putting in the
few field
**
Keep in mind that if you create a new field, you will lose any workflow or reports that used the original field.
To maintainreports and workflow,you will want to keep the same field ID. For this you could create a temporary field of the correct type, port the data to that temp field. Then
**
Here is a slightly different approach that maintains
the same field Id.
For this example, Field1 is the name of the existing
field and Field2 is the name of the temp field.
1. Add new Field2field and
Save.
2. In your DBMS
query tool run: UPDATE My_Form SET Field2 = Field1
3. Delete the
L.J., I think that's a much better answer than to have a space character for
the selection value.
I also create checkbox fields with null labels, for two reasons. First, when
you look at most examples of Windows GUIs, the checkbox is on the left and the
text is on the right. We should
**
I agree that some kind of label/value needs to be present. Your solution works best if you want that value on the right side of the box, the space works for people who want it on the other side.
I'd let the users decide what makes sense to them, and stay consistent with that.
Rick
On 10/16/06,
Hi all,
We are interested in doing a sanity check on what impact we
will have if we change a particular form in remedy system. I am looking for
both upward and downward dependency.
Does anyone have a script and/or direct sql logic to do
this?
Thanks
Kamlesh
Title: RE: Notify Action To Group Not Working
**
David:
I can add my USD.02 to this. Each installation of ARS will create new forms and they may have different schemaids. This is the brilliance of ARS. You do not have to worry (mostly) about the underlying layout of the actual database
**
For those that are interested, I never
did track down the root cause of this issue, but it resolved itself after
our weekly reboot of the AR Server.
The date/times on the DB server and
ARS Server were within seconds. The logs between dev and prod were
different, but nothing about the
The CI Viewer for ITSP color-codes the CI based on whether it's In Service
(green), Down (red), In Inventory (yellow), to be deleted (black),
Requested/Ordered (orange), etc. Does anyone know if this functionality is
available in ITSM 7.0? I can't seem to find it. Is there a separate
I have a web form that is used to submit an email to Remedy ((V 6.03) to
create a HD ticket. I'd like to include an attachment. I have added a
line at the bottom of my email body that reads...
Attachment1 !300615200!: c:\work\REMEDY\Documentation\HDMail_Template.doc
I get a remedy error...
There are no entries for this. I searched on upgrade to see how often
this message is popping up. It makes no sense. Here is an example:
FLOAT WRITE UPGRADE tedwards (13 of 33 write)
As you can see this user was given he 13th out of 33 licenses. There are
plenty of licenses available. This
There was a lengthy discussion not too long back around whether people
are granted a write token when they are authenticated. The conclusion
I drew/observed is that people are not automatically granted a
floating write token when authenticated (if a floating license is
allocated to that
Yes I remember that discussion. What I don't know is why this message
suddenly started. It says a license has become available. Well that is
not true there was always one available. The users should not be seeing
this message.
-Original Message-
From: Action Request System discussion
**
You are welcome to contact me off line about how Xinify can help you.
Xinify is in the unique position of being a both CA Clairty and BMC Remedy
consulting partner. We have integrated the 2 products in the past and
can do it again with OOTB apps or custom apps.-Kelly
We have a very strange problem with CR, some user get 'Field name not known'
or 'error in formula'. The workaround to solve this, for a while are two
methods I've seen can fix this. Delete contents in the home folder (keep
dde.ini), or delete the user preference request. Some users have no
**
Is there some reason that attachment command buttons would not appear in a web view? There are values entered in the attachment label fields for the attachment pool, but the buttonsdon't show up at all.
ARS/MT 7.0 patch 2 AND ARS/MT 6.3 patch 16 (both are having the problem).
Win2k3/SQL2k
IE
**
Listers,
So is anyone else experiencing really bad problems with the
support website. Particularly, logging in? Ive tried everything
using the email address associated to my old loginid, re-registering, calling
support to which I received a let me put in a ticket answer.
Nothing
**
Lots of us are. Wrong information about our accounts seems to be the norm. Why they would have made no known effort to engage the users to update their data prior to this is beyond me.
Rick
On 10/16/06, Gillman, Chris [EMAIL PROTECTED] wrote:
**
Listers,
So is anyone else experiencing
**
Hello, Dudes and Dudettes;
I truly believe that their support site is going to have
issues for at leastthe next 24 hours until they work out the
kinks.
I'm going to try really hard to be
patient.
Calling Customer Support is making the long-distance
companies a lot of money, today.
**
Agreed.
But, Rick.
I did update my dataa year ago. I also asked
them a year ago to remove the support contract ID that is now showing up as my
primary ID. Whenever I logged into the website, prior to Friday, it always
displayed my current account as my primary. The old-expired one
**
It let me sign on... I hate having to type out the entire email
address
But when I tried to look at existing tickets I got
this
You have reached this page due to not having an ID in the
Customer Support System.
Please contact Customer
**
Well, I agree with you, Michelle, and like you, I keep my data up to date, which is more than I can say for those who helped me by migrating incomplete or bad data to the new site. Why would I have for a default Support ID a customer I haven't seen in 5 years that doesn't even have active
**
Well, they're starting to at least acknowledge tickets, though the Indian tech that just called me about the attachment label issue was asking me to tell her the nature of the problem because apparentlythe Summary field containing what I had typed in the web submit had not shown up for her
**
Hi Everyone,
I would appreciate some help on this one. I want to click on a button and open a Word or pdfdocument. I'm so used to saying I can do anything in Remedy I forget sometimes I forget how to do everything ... :(
I was thinking I could do this through OLE but cannot seem to find the
**
I got logged in but could not get my new license keys ... luckily I have temp ones that are still active !
Susan
On 10/16/06, Rick Cook [EMAIL PROTECTED] wrote:
**
Well, they're starting to at least acknowledge tickets, though the Indian tech that just called me about the attachment label
I would have to agree, same thing is happening to me...I haven't worked for my
old company in 2 years yet that is showing up as my primary id, and it is
saying it is expired...Has anyone seen the new Knowledge base? I had to search
for something this morning and am finding it hard to navigate
**
I was experiencing this over the weekend and this AM, but
it seems to be better now.I did notice that if you click to a non-Remedy
area (BMC Distributed, Marimba, etc...), and you didn't have support for that
area before, it gives you an cryptic error message about not having an ID for
Hi Carey,
It does look like Mid Tier is being used in *some* areas - when you
click certain Remedy specific links it breaks out of the CFM stuff and
goes to Mid Tier views (on some screens you can see Remedy Mid Tier
6.3 in the page header).
Interesting that Mid Tier 6.3 is being used instead of
81 matches
Mail list logo