Hi,
In the test version of RRR|License, there is a Change Planner designed to
tell you how many fixed/floating licenses you will need to buy, if you add
people with the same usage pattern as your current user base.
Here is a sample, where you can change the number of users you want to add:
Hi all -
I would like to know if the following will automatically 'commit' to the
database for me or not:
-- Direct SQL with an Update command
-- Push fields (destination=Server, Form = Same form as the AL's Primary
Form)
Or do I have to specifically request a commit?
I am hoping that the
okay I see that Direct SQL will do a 'commit' for me.
(I'm in ITSM 7.6.03 on MS sql server) In an Active Link.
But I don't see why 'Push Fields' wouldn't do a commit for me too.
So if they both do 'commits' for me without being specified, I think the
Direct SQL will NOT trigger the filters
I'm looking at the Help documentation about Direct SQL's: (note it says
'non-AR' databases... but I need to update an AR database...)
Use the Direct SQL action to submit any legal SQL command to a non-AR System
database. Use this command only if it is required for integration with
another
So how would I format this SQL statement???
There doesn't seem to be any info there about updating a field on an AR
system form...
example:
UPDATE HPD:Help Desk SET UM_Opened_By = '$USER$' WHERE '$Incident
Number$' = 'Incident Number';
Since they (BMC) don't want you to do it, then they don't
Found it! One of the AL's had 2 forms defined in the 'Associated Forms'
area. Therefore the 2nd form caused that AL to run, and the other AL was
never invoked because its 1 form was not opened.
--
View this message in context:
All the transactions triggered by a specific action (e.g., active link push
field, which in turn triggers filter processing) are processed in a single
transaction. If an error is encoutered, the entire set of transactions are
rolled back. If not error is encountered, the entire set of
Yes, running a SQL statement from an active link will update the record
directly at the database level. Just like running a SQL statement from SQL
studio. Bypassing filter execution and system update fields.
The documentation is worded to discourage people from making changes directly
to the
Hi all -
Wow - I was able to run a SQL statement in ARUtilities!
SELECT * FROM HPD_Help_Desk
And I can see all the column names but have no clue how to map them to
the name of the fields...
(Thank you JLBess and Axton for your replies!!!)
how can I find the name of my new columns so I can
You do not do a select *..
If you want to map specific values to specific known number of fields, you
select those individual fields..
select field1, field2, field3, field4 from table_view where ...
To map the results to fields on a form in a set field, you use $1$ for
field1, $2$ for
Guns come with the same kind of warning, as do most power tools. If used
properly, it is a powerful tool; if used irresponsibly, you assume some
degree of risk. Even coffee cups come with disclaimers these days. It's
the mindset today to protect everyone from themselves. Gone are the days
Hi Joe!
I only did the Select * because I'm trying to find out the NAMES of the
COLUMNS so I can find my fields.
I hope to use the Direct SQL to update my fields as to who is in the
incident and at what time-stamp.
so my final SQL will be something like:
UPDATE HPD_Help_Desk SET $xxx$ = $USER$
I haven’t really found this documented anywhere or maybe I have missed it..
What do each of these symbols denote..??
* * *
* * *
Joe
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend
I'm not sure if I have correctly understood your question yet then..
Do you mean to ask how do you know what column maps to what field ID???
If so that could be easily determined from the field meta table..
select name, fieldid from field where schemaid in (select schemaid from
arschema where
Yes! that is it! Thank you!!!
--
View this message in context:
http://ars-action-request-system.1093659.n2.nabble.com/to-commit-or-not-to-commit-that-is-the-question-tp7535439p7535900.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
My bad... the query should actually be..
select fieldname, fieldid from field where schemaid in (select schemaid from
arschema where name = 'HPD:Help Desk') order by fieldid;
I typed name for fieldname by mistake..
Sorry about that..
Joe
-Original Message-
From: smiley
Sent:
well close but still no cigar.
I'm in ARUtilities in the SQL section, to see the views and columns.
If I do a simple SQL like this - SELECT * FROM HPD_Help_Desk --- what I see
are rows with COLUMN names.
The COLUMN NAMES are: Column 1, Column 2, etc until I see Column
237... which
Incorrect code written by another developer, to create People Permission Group
records for new users that were added from an external data source (LDAP) got
the information in the People Permission Groups form out of sync with the Group
List information on the User form. The bad code modified
Wait a minute.. what exactly are you after here..
1) Are you attempting to write a Direct SQL in a Set Field action an set
values from a SQL to certain fields on the current form? (In which case the
$1$, etc values will apply).. In this case results are returned back to the
fields mapped
FYI, this issue has been duplicated by BMC and is being tracked as SW00430296
against 7.6.04. Can't say when it will be addressed, but at least it has been
formally identified.
-David J. Easter
Manager of Product Management, Remedy Platform
BMC Software, Inc.
The opinions, statements, and/or
Joe,
I think Smiley is heading down the wrong path using Direct SQL. Seems like
what Smiley really wants to do can be done with a push fields.
Dave
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Hi again -
Here is my (hopefully) correct Direct Sql (which is an Action within my
Active Link):
UPDATE HPD_Help_Desk SET C95018 = $USER$, C95019 = $TIMESTAMP$
WHERE C100161 = $Incident Number$
The 'C' numbers are my Field ID's. I'm not sure if I'm supposed to indicate
the form
Joe,
People Permission Groups contains data NOT held in the User table (or anywhere
else). Remember that you can have many equal permissions and people based on
the other data in the record. See the structure of the table and see some of
the records you do have.
A push to People
Just as a quick FYI, this has been duplicated back at BMC and tentatively
corrected in the upcoming mid-2012 release. It's also under consideration for
a future service pack to 7.6.04.
My apologies that it is taking this long for something first introduced in 2009
to be corrected to a usable
Hi Dave -
I need to NOT trigger the Filters when I set this field.
The purpose is to set a field that says hey! I'm already opened by this
user id! back off!...
:)
Hope that helps
--
View this message in context:
Just an FYI, the process you are using to reply makes it tough to understand
which email you are replying to. I'm assuming that you are replying through
Nabble instead of through email. I'm also assuming the reply is in reference
to my email?
Dave
-Original Message-
From: Action
Yes. Sorry don't know another way to reply. It looks fine to me in nabble
because I'm using 'Threaded' view. :)
--
View this message in context:
http://ars-action-request-system.1093659.n2.nabble.com/to-commit-or-not-to-commit-that-is-the-question-tp7535439p7536404.html
Sent from the ARS
The majority of us are subscribed through www.arslist.org and email is sent
directly to our email addresses.
Dave
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of smiley
Sent: Monday, May 07, 2012 2:18 PM
To:
Hey Ben,
Thanks for your response.. I know what you are trying to caution me on and I
appreciate that.. I know I’ll need to consider license info etc. while doing
this..
The PPG has rows that correspond to data present in the C104 (Group List) field
from the User form.. For *almost every*
oh yes I get the emails too... so you Reply to the email?
--
View this message in context:
http://ars-action-request-system.1093659.n2.nabble.com/to-commit-or-not-to-commit-that-is-the-question-tp7535439p7536442.html
Sent from the ARS (Action Request System) mailing list archive at
Yes
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of smiley
Sent: Monday, May 07, 2012 2:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: to commit or not to commit... that is the question
oh yes I get the emails too... so you
yup.. the reply would have the address arslist@arslist.org and it will make
it to the list plus you will see the entire trail of the message instead of
a truncated threaded view which sometimes keep some of the readers wondering
what the thread started out like if they wanted to chime in to
Hello,
I have a question about SRM 7.6.00. We are running a 7.5.00 environment with
SRM 7.6.00 and are trying to disable or hide the buttons Add to Cart and
Request Now in SRM. Realizing that it would be a pretty much all or nothing
sort of thing has anyone ever done this? Clearly it isn't as
Hi Joe,
Modify works fine – as long as the DO field is set. So, IF the DO field was
set and the push fields set the wrong user name, then that user’s group list
will probably also be bad.
Not with standing that, how do you intend to generate the missing data? It’s a
rhetorical
If you're going to use C id's instead of your field names, you need to replace
HPD_HELP_DESK with the T table.
The views like HPD_HELP_DESK don't have the C names, they have the database
name you gave your field. (replace spaces with underscore)
You also need to put single quotes around
After installing Analytics and we are now seeing the following error message
when trying to attach a file larger than 65536...any idea in SQL where to
adjust this size constraint?
The SQL database operation failed. : The statement has been terminated.Length
of LOB data (549551) to be
The idea is in theory too..
I was intending to create a csv file based on an SQL output, by parsing the
contents of the C104 field..
For eg if a C104 field contained ;1;16;17; for login name XYZ,
I’d want 3 rows
“XYZ”,”1”
“XYZ”,”16”
“XYZ”,”17”
This just an
Just to add to Jason, replace spaces special characters with _.
You should see all your columns in your DB table or view if you describe
(describe or desc) it..
eg:
Desc HPD_Help_Desk
Desc Tnnn (replace nnn with the schemaid as appropriate)
This works on Oracle..
If you are using MS SQL or
Log in to the Application Administration Console and go to the Advanced tab,
then select SRM Advanced Preferences and you can turn the Cart
functionality via the Show Cart field, or are you trying to do this on a case
by case basis?
Thanks,
Shawn Pierson
Remedy Developer | Energy Transfer
I have 470 users that I need to remove a permission set from. I tried to use
the People Management console but that did not work. Any ideas other than
going one by one?
ITSM 7.6.04.02
ARS 7.6.0.4.03
___
I do not know this error off the cuff: something to remember:: mysql
install has a bug: (X86) install directory. I.E C:\program files(X86)\. the
characters ( ) cannot be in the install directory structure..
Ensure you put it in a special name.. we did something like bubbajoe
instead..
Finding those buttons can be tricky. I'm not sure why you want to hide
Request Now but open the SRS:ServiceRequestConsole form in Dev Studio.
Select Edit Find/Replace from the menu bar.
Type Request Now in Find Field (type = label) click Find
Dev Studio will find the button outline in it
Mike,
At the risk of suggesting something you might have already tried, take an
SQL log while reproducing the error so you get to see what is the offending
form and field that is causing this error..
If this doesn't yield anything, search for all fields in your database that
has a max
Search for that permission for those users in the People Permission Groups
form assuming you are using ITSM..
Deleting these correct rows there will trigger delete filters that will make
the necessary changes to the User form..
Perform this with care and make sure you are deleting the right
Find the form in the user tool;
enter a query to delete (ie perm = xx and (person =a or person=b ...)) ;
delete.
The workflow on the form should fix up the User record's Permission Groups
without any DO field being set.
It's a 5-minute Meta-Update script if you have a list of those people in
This is a dev system right? It appears you are getting a handle on a few
different techniques and concepts here. I bet there are probably a few of
us wincing while reading this thread. When working with Direct SQL your
gun is always loaded. Be careful where you point that thing and make sure
I found out how to do this after I asked the question. Thanks for the response
though Any idea how to do the same thing for the Request Now button? It's
not configurational and I can't find anything that actually builds the HTML or
whatever is being used in the Display field.
Dave
From:
Wow – I just found out I can use the ‘SQL’ thing in ARUtilities to actually
SEE my Data!!!
I’m so excited!!!
Okay I’ll try to hold myself back on the ‘!’s and smileys…
The C95019 field is a new field that I added to hold the ‘opened’
date-time for the incident. It is a ‘date/time’ type
I found it! CTM:PeoplePermissionGroups!
-Original Message-
From: Sanford, Claire
Sent: Monday, May 07, 2012 2:08 PM
To: 'arslist@ARSLIST.ORG'
Subject: Remedy 7.6.04 Removing Permission group
I have 470 users that I need to remove a permission set from. I tried to use
the People
I didn't think of the meta update actually.. does it do foundation records
such as the people group permissions?
I cannot delete from the user as doing so will mean it will take off the
permissions from the user form. I do not want that to happen. Those
permissions are correct and should be
Joe,
You should be able to split the group_list string into an array of values.
What DB are you on? In Oracle you can create a split function and use it as
in inline table to join to.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
Yes. Meta-Update can update (or extract) any data - foundation, CMDB, Root
Requests or bespoke data.
In 2 minutes you could have your CSV from the user form for any list of
people that you had. You could even exclude those groups where a permission
record exists.
No updates to ARS data needed.
Two identical records on the People permission group form could have a
problem actually I think.. if you delete one of the records, it would delete
it from the user form, but the other record would still remains on the PPG
form depending on what the query is to delete the record that is
How would I be able to split:
Hi All,
I have a Change form that has several pages. Once page is for simple changes
and another page is used for complex changes. In both pages I need to have a
Maintenance Start Date and a Maintenance End Date field. If I share fields then
they appear on all pages and in the same position.
Sharing fields on pages – I just thought you ought to know that this function
is deprecated as of AR Server 7.5 onwards.. You no longer would be able to do
that.. If you already are upgrading this from previous customizations or
development, it will upgrade but you can no longer create new
In Oracle you have to create the function:
CREATE OR REPLACE TYPE SPLIT_TBL as table of varchar2(32767);
CREATE OR REPLACE FUNCTION SPLIT (p_list varchar2, p_del varchar2 := ',')
return split_tbl pipelined
is
l_idxpls_integer;
l_listvarchar2(32767) := p_list;
l_value
So what is this supposed to do? How would this function know it has to
delimit at every ; and strip of the string in between?
-Original Message-
From: Grooms, Frederick W
Sent: Monday, May 07, 2012 5:04 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject:
You pass it the delimiter split(u.GROUP_LIST, ';')
By using the Table function you can treat the result as its own table
select u.LOGIN_NAME, s.COLUMN_VALUE as Permission_Value
from USER_X u, table(split(u.GROUP_LIST, ';')) s
Where u.login_name = 'dsouzaj'
-Original
Here is an example I used to update record 1 in a form called
+TemplateFrom updating a new field called Date/Time Field using the
Remedy generated SQL View via a Filter. I was not able to get $TIMESTAMP$
to resolve using ARUtilities so I had to build it using Remedy workflow.
UPDATE
This is related to max text repl size Server Configuration
Check: http://msdn.microsoft.com/en-us/library/ms179573.aspx
Ravi
Date: Mon, 7 May 2012 15:11:18 -0400
From: jdso...@shyle.net
Subject: Re: Remedy 7.6.04 SQL Error Message
To: arslist@ARSLIST.ORG
Mike,
At the risk of
That’s pretty much what I want to do! Let me see how I could use this and
generate the data I want.. I was looking for the ; in the function
definition and didn't notice it used below..
Cheers!!
Joe
-Original Message-
From: Grooms, Frederick W
Sent: Monday, May 07, 2012 6:06 PM
62 matches
Mail list logo
