Re: 9.1 Data Import Tool Command Line Utility

[Curtis Gallant]

It's been rebuilt as a Java utility.  Docs on how to use it in the official
documentation:

https://docs.bmc.com/docs/display/public/ars91/Data+Import+command-line+utility+options


On Wed, Jan 4, 2017 at 3:12 PM, Sinclair, Keith 
wrote:

> **
>
> Did BMC do away with the command line utility for the 9.1 Data Import
> tool? I used to have a batch file that would run periodically but now
> refuses to run since I upgraded from 8.1. I cannot find any documentation
> online in regards to the 9.1 version.
>
>
>
>
>
> *Keith Sinclair*
>
> Remedy Development
>
> ShopperTrak Chicago, USA
>
> *O* 312.676.8289 <(312)%20676-8289>
>
> ksincl...@shoppertrak.com | shoppertrak.com
>
> *Retail Profitability, Improved.*
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_




-- 
:wq cuga

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Ticket Data Migration from 7.5 to 8.1

[Curtis Gallant]

Something I haven't seen mentioned but is very important as well is one
needs to be careful when crossing over multiple major versions.  The data
models from ITSM 7.5 to 8.1 are not fully equivalent so if you just
straight try and move all the data from a 7.5 system into an 8.1 system (A
-> A), expect some breakage somewhere, typical examples could be changes
with multiple approvals that are pending (in 8.0/8.1 there was some under
the hood changes as well as consolidation of change approval processes).
This is one of the reasons for a tool like DDM that does the version by
version conversion in steps (albeit painfully in the setup and execution
sometimes with workarounds needed but it's getting better and better
documented with every release it seems).

Straight shot tools from point A to point B are great for keeping say a QA
environment in sync with PROD since they will be at the same version (and
other similar requirements)  but unless you are sure of your data model
(e.g you are running custom apps), a straight shot movement of the data
from an older BMCs ITSM suite has some risks in an upgrade scenario that
need to be fully vetted as breakage can and do happen very subtly sometimes.

On a different but related topic, that CMT tool Sean mentioned a few emails
up looks pretty neat, kinda how DDM 'should' be if what it says is all true
:)

On Tue, Nov 18, 2014 at 7:23 AM, Jarl Grøneng 
wrote:

> **
> Hi
>
> You does not need to freeze anything. The requirement from the inital
> poster was to set up a new server.
>
> With a new server you can move all your data. When the first load is done,
> you start it over again. The next run will take just a few hours. And when
> your ready to switch production to your new server, you run the rrrChive
> again.
>
> Using this approach you can have a cut-over in just av few minutes.
>
> --
> J
>
> 2014-11-18 12:07 GMT+01:00 Sean Harries :
>
>> **
>>
>> Hi Kiran, Jarl, Listers,
>>
>>
>> While RRRchive has some great improvements in terms of handling the
>> deletion of data and configurability, the main issue you're likely to face
>> is performance. If you are able to agree the data freeze and data catch up
>> management around a 20 day delta process then that is OK. On many of our
>> projects, we found that was difficult to agree with the business and stake
>> holders so we developed the Customer Move Tool.
>>
>>
>> The Remedy API is great at a number of things, but bulk data migration is
>> not among them. Using RRRchive, it previously took us over thirty days to
>> accomplish a full data migration from a full copy of a Production system.
>> After that migration, we then had to perform multiple delta migration runs
>> leading up to go-live. The inherent limitation of the Remedy API has been
>> recognised by BMC, and for the DDM product, some Forms like Audit and
>> Worklogs are now migrated at the database level.
>>
>>
>> The CMT Tool has a number of advantages over other tools currently
>> available;
>>
>>  1. Moves data at the database level - we are typically able to move an
>> entire ITSM application within a single day, rather than several weeks. The
>> final delta migration for the Production cutover is less than an hour.
>>
>>  2. Automated discovery and analysis - CMT will discover a Remedy
>> application including customizations and map the data. Any discrepancies
>> like mismatched field lengths, missing enums or missing fields are
>> identified and presented in the CMT Workbench web UI. This is a distinct
>> advantage over other tools, which require you to mess about with XML files
>> and will not automatically identify differences or pick up customisations.
>> For a lightly customised system we would typically be ready to move data
>> within a couple of days - which believe me compares very favourably to the
>> effort expended in previous upgrade projects I've been involved in!
>>
>> 3. Relationship Aware – while other tools migrate on a simple
>> form-by-form basis, CMT builds a data model of your Remedy application
>> which it uses to migrate data.. This opens up a number of capabilities such
>> as being able to migrate individual ITSM companies between Remedy systems,
>> consolidating multiple Remedy systems into a single multi-tenancy system,
>> performing archiving of data during data migration, etc.
>>
>> 4. Flexible and Powerful Mapping and Transformation– using the CMT web
>> user interface you have full control over the way data is migrated and can
>> transform and map data to handle a range of scenarios, including populating
>> new fields with defaults, transforming Product Catalog data, selectively
>> mapping data to new Forms, fields or entities.
>>
>>
>> Finally CMT handles data deletions, has outstanding exception management
>> (no more searching through log files) and very good operational
>> capabilities Please let me know if you'd like to discuss this further (
>> sean.harries@alderstone,com) or you could sign up for one of our
>> webinars

Re: Hude Login ID Conversion

[Curtis Gallant]

I have published a free utility written that has similar capabilities to
Misi's RRR|LoginConv using the Java API and posted the write-up and
download here:

http://soleauthority.net/login-converter-utility-for-mass-updating-login-ids/

It hasn't gone through exhaustive testing as of yet but I would welcome
anybody testing it and providing feedback for further improvements.

Here is a quick list of capabilities it provides:

   - High performance updates from an old LoginID to a new LoginID
   utilizing merge action that bypasses workflow
   - Single update or define multiple Login ID updates for a single pass
   - Updates all Character Fields (regardless of size)
   - Match exact
  - (optional) Match surrounded by single/double quotes
  - (optional) Match surrounded by separators such as white-space,
  comma, period, pipe, semi-colon or colon
   - (optional) Updates all Status History entries
   - (optional) Updates all Diary Field entries

And here is a list of nice features above and beyond the core capability:

   - Two progress bars show displaying progress by the currently processing
   form and the overall end to end process.
   - Ability to control the speed by way of a delay slider that will slow
   down or speed up the processing dynamically
   - Ability to pause / resume the processing
   - Ability to cancel in-flight updates (doesn’t not roll back, just stops
   wherever it happens to be)
   - Ability to toggle on/off the scope/matching capabilities
   - Ability to specify all forms to be checked or a specific form only
   - Ability to ‘simulate’ the run without actually make any changes
   - Detailed output provided on forms processed and matches found

Cheers,


On Mon, Sep 29, 2014 at 3:01 PM, Misi Mladoniczky  wrote:

> Hi,
>
> The RRR|LoginConv worked just fine, but it is written in ARSperl which has
> kind not been recently updated. So there is a problem when getting the
> field
> list from some forms in ITSM (not data, just info about the fields)...
>
> I am looking for a sponsor to be able to rewrite it in C or Java. Please
> let
> me know if that could be you. It is not a big program, and might take
> around
> 40 hours or so to re-write.
>
> Using the API, as RRR|LoginConv does, takes considerable time to complete.
> But
> by prioritizing the order in which forms and records are converted, you
> should
> be able to do the important stuff during a weekend. Then the tool can
> munch on
> to convert historical data in a more leisurely manner.
>
> RRR|LoginConv exchanges text fields up to 254 characters in length. It does
> fix the lists in the 112 and 60xxx fields, as well as Status-History and
> Diary-fields. If it finds a quoted match in a char-field, that will be
> exchanged as well.
>
> It performs one read and one write per record, regardless of the number of
> fields/logins that is converted on that record, and you should be able to
> run
> several in parallel to speed things up.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
> > I would recommend
> >
> > https://rrr.se/cgi/tools/main?tool=rrrLoginConv
> >
> > On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso 
> > wrote:
> >
> >> ITSM 764 sp2, Oracle, Weblogic
> >>
> >> We have been asked to determine the difficulty/feasibility in converting
> >> all Login IDs and Corporate IDs to new values. The unique values
> currently
> >> used must be eliminated from "every" field in the application:
> Submitter,
> >> Last Modified By, contained within a notes/description field and all
> custom
> >> forms. We have over 1 million HPD records and millions of other
> ancillary
> >> tables; audit, work log, assignments, searches, etc. I looked at the
> Data
> >> Wizard Console (DWC) and it does allow Login IDs to be changed; it
> appears
> >> to search across 408 tables in ITSM. But it does not handle corporate
> id,
> >> can only be run for a single ID, does not search inside text fields and
> >> does not handle custom forms. It also looks like a process that will
> take a
> >> very long time to run.
> >>
> >> Looking for any thoughts on performing such a task; maybe some tricks
> >> other have come up?
> >>
> >> Thank you.
> >>
> >> Frank Caruso
> >>
> >>
> >>
> ___
> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> >> "Where the Answers Are, and have been for 20 years"
> >>
> >
> >
> ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > "Where the Answers Are, and have been for 20 years"
> >
>
>
> _

Re: Hude Login ID Conversion

[Curtis Gallant]

I've got the bulk of the framework already developed using the Java API for
this that I would just need to finish.  Right now it will update loginIDs
based on exact match of any character field (regardless of size) but
extending it out to do inline replace across fields where it 'contains' the
loginID rather then being an exact match only isn't that much additional
work (and also diaries & status-history).  I'd also need to add a parser so
that you can pass it in a list of login IDs to check/update similar to
RRR|LoginConv.  All the other stuff your tool does would be gravy but not
critical to the core usecase and could be added over time.

I figure I'll have time to spend on it between now and BMC Engage so I'll
hopefully have the utility posted on my site (http://www.soleauthority.net)
before then.  If anybody is interested in being a guinea pig and have a DEV
system they don't mind backing up / restoring as needed that has a lot of
actual data (e.g. year or more of buildup), you can contact me offlist.

Cheers,

On Mon, Sep 29, 2014 at 3:01 PM, Misi Mladoniczky  wrote:

> Hi,
>
> The RRR|LoginConv worked just fine, but it is written in ARSperl which has
> kind not been recently updated. So there is a problem when getting the
> field
> list from some forms in ITSM (not data, just info about the fields)...
>
> I am looking for a sponsor to be able to rewrite it in C or Java. Please
> let
> me know if that could be you. It is not a big program, and might take
> around
> 40 hours or so to re-write.
>
> Using the API, as RRR|LoginConv does, takes considerable time to complete.
> But
> by prioritizing the order in which forms and records are converted, you
> should
> be able to do the important stuff during a weekend. Then the tool can
> munch on
> to convert historical data in a more leisurely manner.
>
> RRR|LoginConv exchanges text fields up to 254 characters in length. It does
> fix the lists in the 112 and 60xxx fields, as well as Status-History and
> Diary-fields. If it finds a quoted match in a char-field, that will be
> exchanged as well.
>
> It performs one read and one write per record, regardless of the number of
> fields/logins that is converted on that record, and you should be able to
> run
> several in parallel to speed things up.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
> > I would recommend
> >
> > https://rrr.se/cgi/tools/main?tool=rrrLoginConv
> >
> > On Mon, Sep 29, 2014 at 11:02 AM, Frank Caruso 
> > wrote:
> >
> >> ITSM 764 sp2, Oracle, Weblogic
> >>
> >> We have been asked to determine the difficulty/feasibility in converting
> >> all Login IDs and Corporate IDs to new values. The unique values
> currently
> >> used must be eliminated from "every" field in the application:
> Submitter,
> >> Last Modified By, contained within a notes/description field and all
> custom
> >> forms. We have over 1 million HPD records and millions of other
> ancillary
> >> tables; audit, work log, assignments, searches, etc. I looked at the
> Data
> >> Wizard Console (DWC) and it does allow Login IDs to be changed; it
> appears
> >> to search across 408 tables in ITSM. But it does not handle corporate
> id,
> >> can only be run for a single ID, does not search inside text fields and
> >> does not handle custom forms. It also looks like a process that will
> take a
> >> very long time to run.
> >>
> >> Looking for any thoughts on performing such a task; maybe some tricks
> >> other have come up?
> >>
> >> Thank you.
> >>
> >> Frank Caruso
> >>
> >>
> >>
> ___
> >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> >> "Where the Answers Are, and have been for 20 years"
> >>
> >
> >
> ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > "Where the Answers Are, and have been for 20 years"
> >
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>



-- 
:wq cuga

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

AD: Entry Inspector – View, Modify, Export & Delete Data Quickly

[Curtis Gallant]

Hi ARSListers,

I have rarely posted to the ARSList in the past as I have mostly 
benefited from the various discussions (especially from this account) so 
many here may not know me however I have been trying to be more active 
in the Remedy ecosystem as of late.  Some may have seen my many posts / 
tutorials on leveraging the BMC Remedy Java API on the BMC Communities 
and on my own blog site (www.soleauthority.net).


The purpose of this email is I would like to share information about a 
new productivity tool that I have just released for mainstream 
consumption which happens to be my first ever commercial tool.  I have 
been evolving this tool over the past few weeks/months in my spare time 
and I'm comfortable now that it's grown to the point I would love to get 
it out there to the masses as it has been quite useful for to myself to 
date and I would it would be to others as well.


I named the tool "Entry Inspector" and it is a Java based GUI utility 
designed to leverage the power of the BMC Remedy Java API to give you 
back some control & finesse over your Remedy data that used to be much 
easier prior to the shift to Mid-Tier only setups.


In summary, Entry Inspector is a utility that puts the power to 
manipulate, explore, export & delete data from any BMC Remedy system 
quickly and accurately all wrapped into a simple to use interface.  It 
is meant as a productivity tool for Administrators, Developers and 
Consultants.  It’s purpose is not to bring back the full BMC Remedy User 
Tool experience however it attempts to rectify certain gaps left by it’s 
departure.


Specifically, at a high level, here is a list of the capabilities 
provided:


- The ability to Query and display data from any form, including fields 
that normally are hidden

- The ability to Modify single or bulk entries extremely quickly
- The ability to Export single, selected or all entries within a Remedy 
form, in both ARX and CSV format
- The ability to Delete single, selected or all entries within a Remedy 
form extremely quickly


I have a write up of the utility as well as a bit of a feature walk on 
my site, it can be directly reached from this link (also includes the 
download link as well as the purchasing link):


http://www.soleauthority.net/entry-inspector-view-modify-export-delete-data-quickly/

I would love feedback on this tool and have provided a fully functional 
evaluation version that can be downloaded where the only restriction is 
that it will limit all actions to a maximum of five (5) entries and a 
small nag label will be present on the main interface.  For those who 
decide to purchase the full version, I will strive to get your license 
keys as quickly as I can which will remove the nag screen and 
limitations imposed to truly have the power of this tool unleashed.


I will continue to add new capabilities into this tool that makes sense 
and those who purchase a license will benefit from that at no additional 
cost for all future versions of this software.


Cheers,

--
Curtis Gallant
SoleAuthority Consulting

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: server.ParseQualification error

[Curtis Gallant]

You can simply use the overloaded version of parseQualification method
where you provide the viewID of the view of the form you want to use field
labels of in your query (or simply "" to use the default view).  The reason
you need to provide the viewID is simply because your labels can be
different from view to view on the form so in order to it to make sense and
parse the query that uses views it needs to know the view the labels are on.

>From the documentation:
parseQualification

public QualifierInfo

*parseQualification*(String

form,
String

vui,
String

qualification)
 throws ARException


Parses a given qualification into internal structure. This overload allows
specifying a vuiName so that qualification parsing can use field display
labels per the given vui. Field database ids can always be used in
qualifications.

*Parameters:*form - Form against which this qualification is definedvui -
One of the following values:
null - no display labels be considered;
"" - field display label per the default vui;
"SomeVuiLabelHere" - the field display labels per this vuiqualification -
Readable qualification string*Returns:*QualifierInfo parsed qualification
*Throws:*ARException
-
denoting any parsing errors


On Wed, Dec 11, 2013 at 7:16 PM, LJ LongWing  wrote:

> **
>
> Yes, you will need to know the form, and the view that they are looking
> at, retrieve the form object, get the view id's, then look through the view
> for the field with that label, get the field id, then get the field for the
> form and get that field so you know it's db name, for each field, and then
> perform the query using those valuesactually, you don't need the field
> name, you can perform the query with just the field id's
> On Dec 11, 2013 4:31 PM, "James Smith" 
> wrote:
>
>> What is that "another level of processing" - I am sorry but I did not
>> understand you.
>>
>> Do I need to manually perform this processing ?
>>
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> "Where the Answers Are, and have been for 20 years"
>>
> _ARSlist: "Where the Answers Are" and have been for 20 years_




-- 
:wq cuga

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Issues/Questions on ARS Java API

[Curtis Gallant]

For #1, look at ARServerUser.formatQualification()

For #2, look at ARServeUser.formatSetIfQualification()

For #3, look at ARServerUser.formatAssignment()


On Thu, Jun 27, 2013 at 3:31 AM, Anandsagar Sah wrote:

> **
>
> Hello All,
>
> ** **
>
> I have 3 questions around ARS Java API.
>
> **1.   **I have a Active Link Object, how do I get the human readable
> Run If Qualification ?
>
> i.e. 
>
> ActiveLink arObject = server.getActiveLink(arObjectName);
>
> System.out.println("Run If: " + *arObject.getQualifier());*
>
> ** **
>
> *This prints*  Run If: [Operation=1,Operand Left=[Operation=1,Operand
> Left=[Operation=1,Operand Left=[Operation=4,Operand
> Left=[Operation=2,Operand Left=[Operand
> Type=[type=99],Operand=65563],Operand Right=[Operand
> Type=[type=2],Operand=0]],Operand Right=],Operand
> Right=[Operation=4,Operand Left=[Operation=1,Operand Left=[Operand
> Type=[type=50],Operand=70010],,….
>
> ** **
>
> I want it to print like Run If: ‘65563’ > 24…. i.e. in a string format
> that Developer Studio shows on screen. So is there any API method for this
> one ?
>
> ** **
>
> **2.   **Set/Push Qualification returns null, even if there’s a
> qualification given. Always return null for all Filters/Active link.
>
> ActiveLinkAction action = any Push Action of Active link.
> com.bmc.arsys.api.PushFieldsAction s =
> (com.bmc.arsys.api.PushFieldsAction) action
>
> System.out.println("\t\t Push Qualification: " + *
> s.getPushIfQualificationAsString()*);
>
> * *
>
> *This prints*  Push Qualification: null
>
> ** **
>
> **3.   **Set Field Action field mapping returns null, for e.g. below
> code is reading assigned values to field. However this works fine for
> com.bmc.arsys.api.PushFieldsAction.
>
> com.bmc.arsys.api.SetFieldsFromForm s =
> (com.bmc.arsys.api.SetFieldsFromForm) action;
>
> List setFieldsList = s.getSetFieldsList();
>
> for (FieldAssignInfo sfi : setFieldsList) {
>
> AssignInfo assignment = sfi.getAssignment();
>
> System.out.println("\t\t\t" + sfi.getFieldId() + " = " + *
> sfi.getAssignmentAsString()*);
>
> }
>
> *This prints*  605121212 = null
>
> Whereas I am expecting it to print : 605121212 = $assignment$
>
> ** **
>
> Does anyone has solution to above issues ?
>
> ** **
>
> I have tried with 701 and 7604 version of Java API on 701 server
> environment.
>
> ** **
>
> ** **
>
> Thanks & Regards,
>
> Anandsagar
>  _ARSlist: "Where the Answers Are" and have been for 20 years_




-- 
:wq cuga

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: how to identify FTS-indexed fields from the DB?

[Curtis Gallant]

I just took a quick look again and the query needs a slight tweak, on the
DB it will store other possible values in the fullTextOptions if some of
the other FTS options are selected, like "Literal FTS Index".  So instead
of = '1' you should use > 0.

select schemaId, fieldId from field_char where fullTextOptions > 0
UNION
select schemaId, fieldId from field_diary where fullTextOptions > 0
UNION
select schemaId, fieldId from field_attach where fullTextOptions > 0

On the API side, a slight change as well:

public static void getFTSIndexedFields() {
   try {
   List schemaList = server.getListForm(0,
Constants.AR_LIST_SCHEMA_ALL_WITH_DATA|Constants.AR_HIDDEN_INCREMENT);
   System.out.println("\"Schema Name\",\"Field Name\",\"Field ID\"");
   for (String schema : schemaList) {
   List schemaFields = server.getListFieldObjects(schema,
Constants.AR_FIELD_TYPE_DATA);
   for (Field field : schemaFields) {
   FieldLimit fLimit = field.getFieldLimit();
   if (fLimit != null) {
   if (fLimit.getDataType() == Constants.AR_DATA_TYPE_CHAR)
{
   if
(((CharacterFieldLimit)fLimit).getFullTextOption() >
Constants.AR_FULLTEXT_OPTIONS_NONE) {
   System.out.println("\"" + schema + "\"," + "\""
+ field.getName() + "\"," + "\"" + field.getFieldID() + "\"");
   }
   }
   else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_DIARY) {
   if (((DiaryFieldLimit)fLimit).getFullTextOption() >
Constants.AR_FULLTEXT_OPTIONS_NONE) {
   System.out.println("\"" + schema + "\"," + "\""
+ field.getName() + "\"," + "\"" + field.getFieldID() + "\"");
   }
   }
   else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_ATTACH ) {
   if
(((AttachmentFieldLimit)fLimit).getFullTextOption() >
Constants.AR_FULLTEXT_OPTIONS_NONE) {
   System.out.println("\"" + schema + "\"," + "\""
+ field.getName() + "\"," + "\"" + field.getFieldID() + "\"");
       }
   }
   }
   }
   }
   } catch (ARException e) {
   System.out.println(e.getMessage());
   }
}


On Tue, May 28, 2013 at 3:07 PM, Andrew Hicox  wrote:

> **
>
> EXCELLENT, dude! That's exactly what I was looking for.
> Rock on!
>
> thanks again,
>
> -Andy
>
>
> On May 28, 2013, at 1:57 PM, Curtis Gallant wrote:
>
> **
> While you've gotten some direction with FT_Pending which is good, to
> answer your original question on a query for seeing what fields are
> currently set to be indexed (full list)... you simply look to see what
> fields have FTS attribute set.  FTS will work against character, diary and
> attachment fields so you just need to query those field_* tables and see
> where the fullTextOptions is set to '1'.
>
> e.g.
>
> select schemaId, fieldId from field_char where fullTextOptions = '1'
> UNION
> select schemaId, fieldId from field_diary where fullTextOptions = '1'
> UNION
> select schemaId, fieldId from field_attach where fullTextOptions = '1'
>
> If you want to use that to pull in field names and form names you can
> easily build out the query to pull that in with the info provided by also
> querying the field table and arschema table.
>
> Hope this helps.
>
> Also, to get at this info via Java API, you could have a method that looks
> something this to give a CSV style output of "Form Name","Field
> Name","Field ID":
>
> public static void getFTSIndexedFields() {
>try {
>List schemaList = server.getListForm(0,
> Constants.AR_LIST_SCHEMA_ALL_WITH_DATA|Constants.AR_HIDDEN_INCREMENT);
>System.out.println("\"Schema Name\",\"Field Name\",\"Field ID\"");
>for (String schema : schemaList) {
>List schemaFields = server.getListFieldObjects(schema,
> Constants.AR_FIELD_TYPE_DATA);
>for (Field field : schemaFields) {
>FieldLimit fLimit = field.getFieldLimit();
>if (fLimit != null) {
>if (fLimit.getDataType() ==
> Constants.AR_DATA_TYPE_CHAR) {
>if
> (((CharacterFieldLimit)fLimit).getFullTextOption() == 1) {
>System.out.println("\"" + sche

Re: how to identify FTS-indexed fields from the DB?

[Curtis Gallant]

While you've gotten some direction with FT_Pending which is good, to answer
your original question on a query for seeing what fields are currently set
to be indexed (full list)... you simply look to see what fields have FTS
attribute set.  FTS will work against character, diary and attachment
fields so you just need to query those field_* tables and see where the
fullTextOptions is set to '1'.

e.g.

select schemaId, fieldId from field_char where fullTextOptions = '1'
UNION
select schemaId, fieldId from field_diary where fullTextOptions = '1'
UNION
select schemaId, fieldId from field_attach where fullTextOptions = '1'

If you want to use that to pull in field names and form names you can
easily build out the query to pull that in with the info provided by also
querying the field table and arschema table.

Hope this helps.

Also, to get at this info via Java API, you could have a method that looks
something this to give a CSV style output of "Form Name","Field
Name","Field ID":

public static void getFTSIndexedFields() {
   try {
   List schemaList = server.getListForm(0,
Constants.AR_LIST_SCHEMA_ALL_WITH_DATA|Constants.AR_HIDDEN_INCREMENT);
   System.out.println("\"Schema Name\",\"Field Name\",\"Field ID\"");
   for (String schema : schemaList) {
   List schemaFields = server.getListFieldObjects(schema,
Constants.AR_FIELD_TYPE_DATA);
   for (Field field : schemaFields) {
   FieldLimit fLimit = field.getFieldLimit();
   if (fLimit != null) {
   if (fLimit.getDataType() == Constants.AR_DATA_TYPE_CHAR)
{
   if
(((CharacterFieldLimit)fLimit).getFullTextOption() == 1) {
   System.out.println("\"" + schema + "\"," + "\""
+ field.getName() + "\"," + "\"" + field.getFieldID() + "\"");
   }
   }
   else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_DIARY) {
   if (((DiaryFieldLimit)fLimit).getFullTextOption() ==
1) {
   System.out.println("\"" + schema + "\"," + "\""
+ field.getName() + "\"," + "\"" + field.getFieldID() + "\"");
   }
   }
   else if (fLimit.getDataType() ==
Constants.AR_DATA_TYPE_ATTACH ) {
   if
(((AttachmentFieldLimit)fLimit).getFullTextOption() == 1) {
   System.out.println("\"" + schema + "\"," + "\""
+ field.getName() + "\"," + "\"" + field.getFieldID() + "\"");
   }
   }
   }
   }
   }
   } catch (ARException e) {
   System.out.println(e.getMessage());
   }
}



Cheers,


On Tue, May 28, 2013 at 1:43 PM, Andrew Hicox  wrote:

> Hello everyone,
>
> I currently find myself in the third circle of ARS hell ... debugging FTS
> on ARS 7.6.03 (it's a long story on why we're not on 7.6.04 yet, but
> suffice it to say, I have no immediate control of that situation).
>
> We have had an FTS re-index procedure running for more than a month now. I
> need to get an idea on where it is, and how much longer it needs to finish.
> I can trace some of this through the arftsindex.log(s). It seems to iterate
> per-form, per-indexed field. So ... form A, indexed field 1 ... then
> indexed field 2, etc, etc cycling through every record in the form N times
> where N is the number of indexed columns in the form.
>
> So ... part of this is that I need to be able to know exactly how many
> such fields and forms I'm looking at.
> I need a better way of doing this than to open each form on the server,
> and pick through the field properties on every form.
>
> I've tried running the sql log on server startup to try and capture
> whatever it is the ft dispatcher executes in the DB to find the indexed
> fields, but if it's there I sure as heck can't find it. There do not appear
> to be any obvious columns on the 'FIELD' table that would indicate FTS
> indexing mode, nor do there appear to be any adjunct tables (like the
> various FIELD_* tables) that would contain this data.
>
> I'd like very much to be able to execute a query on the DB that would
> return schemaid and fieldid of all the fields that the FTS indexer is going
> to try and run through.
>
> Does anyone know of a way to do this?
>
> -Andy
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>



-- 
:wq cuga

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Allowing Status Change By Group Membership

[Curtis Gallant]

Hi Yolanda,

Using $GROUPS$ or $GROUPID$ to query for membership is always a bit messy
and error prone.  There is a run process purpose built for this type of
activity, you just need to do a 2 step process instead of trying to do it
all in your Run If qual.

You set a field with this run process with the appropriate groupID
specified and then if the contents of the field you set is a 1 then qualify
your workflow on that, if it's a 0, they are not part of the group.  If you
want to check multiple groups usually you would have multiple hidden fields
that can be leveraged and all checked in your target workflow, BMC does
this in many areas of ITSM already to confirm the user is part of specific
groups to qualify workflow from.

Application-Confirm-Group groupID
Verifies that the current user is a member of the specified group. Returns
one of the following integers:

- *1*-The user is a member of the group.
- *0*-The user is *not* a member of the group, or the specified group
   ID does not correspond to a valid group



On Mon, Apr 22, 2013 at 12:12 PM, Yolanda Collier <
yolanda.collier@navy.mil> wrote:

> We have a custom application and the customer would like to limit the
> user's ability to change the status, unless that person is a member of a
> particular organization. You must be a member of certain groups in order to
> change the status to Scheduled, Cancelled, or Denied.
>
> We have attempted to used ($GROUPS$ LIKE "%ABC%") OR ($GROUPS$ LIKE
> "%XYZ%") OR (($GROUPS$ LIKE "%DFG%") AND ('Status' = "Scheduled")) OR
> ('Status' = "Cancelled") OR (('Status' = "Denied") AND ('Organization' =
> "EAST"))
>
> and we have attempted to use (NOT ($GROUPS$ LIKE "%ABC%") and it is still
> not working.
>
> Any suggestions on how to successfully implement would be greatly
> appreciated.
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>



-- 
:wq cuga

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: AR System 8.1: Why is the BMC AREA LDAP plugin not working?

[Curtis Gallant]

Hi John,

In 8.1 the default LDAP plugins are based on Java plugins but they are not
the AtriumSSO ones.  What you are basically doing here is disabling the
newer Java plugin for AREA so that it falls back to the C plugin.

The java plugin is actually arealdapplugin81_build001.jar which is supposed
to be a like for like re-write of the C plugin and have nothing to do with
the AtriumSSO ones (at least that I can see).  Once you install/integrate
in AtriumSSO this may change though but I don't have it installed so I
can't confirm if installing/integration AtriumSSO actually changes anything
about this specific plugin but doubt it as I assume it's no longer used
since instead you configure everything in AtriumSSO which is a different
story all together and I still like your plugin better :)

See here for more info:

https://docs.bmc.com/docs/display/public/ars81/Troubleshooting+AREA+LDAP+plug-in+issues

Because this is now a Java plugin, you won't see anything in the arplugin
log files, you need to check the javaplugin logs (and potentially enable
the logging itself).

Cheers,




On Fri, Mar 15, 2013 at 9:59 AM, John Baker
wrote:

> Hello
>
> When installing AR System 8.1, you may expect to be able to carry on using
> the BMC AREA LDAP plugin. It appears BMC have switched on the AtriumSSO
> AREA plugin by default, and would prefer you ran this product to achieve
> what the AREA LDAP plugin does without the overhead of extra hardware, load
> balancers, configuration nightmares, etc.
>
> If you're wondering why the BMC AREA LDAP or BMC AREA Hub plugins aren't
> working (ie why authentication events aren't going to the arplugin log
> file) search for this line in ar.cfg:
>
> Server-Plugin-Alias: AREA 
>
> and comment it out, ie.
>
> #Server-Plugin-Alias: AREA 
>
> This will send authentication events back to the C plugin server to which
> you're accustomed.
>
>
> John
>
> __**__**
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>



-- 
:wq cuga

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Stop/Activate Escalations

[Curtis Gallant]

I noticed it wasn't in the main list describing setServerInfo &
getServerInfo possible values as well which seemed odd as most of the
toggles you'd want to play with on the Server Information screen are there
so I just grep'd through the Constants class for other Constants that start
with AR_SERVER_INFO and there are quite a few others, not all are probably
valid for the method but DISABLE_ESCALATION jumped out right away there.
 Tested it and it worked for me.

It's also in the ar.h header files listed along side all the other options:
#define AR_SERVER_INFO_DISABLE_ESCALATIONS  143/* int  - 0 - enabled
   */
   /*1 - not enabled
   */

Cheers,
Curtis Gallant


On Wed, Sep 12, 2012 at 1:05 PM, Longwing, LJ CTR MDA/IC <
lj.longwing@mda.mil> wrote:

> Curtis,
> I was looking for the property for Disable Escalations, but it wasn't
> listed (that I saw) as an option that could be setdid I miss it or is
> the documentation wrong?
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Curtis Gallant
> Sent: Wednesday, September 12, 2012 11:04 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Stop/Activate Escalations
>
> ** Here is a simple java method that does the same thing, assumes you have
> the rest of the required boilerplate in place for your context.
>
> void disableEscalations() {
> try {
> ServerInfoMap serverSettings = new ServerInfoMap();
>
> serverSettings.put(Constants.AR_SERVER_INFO_DISABLE_ESCALATIONS, new
> Value(1));
> context.setServerInfo(serverSettings);
> } catch (ARException e) {
> System.out.println(e.getMessage());
> }
> }
>
> On Wed, Sep 12, 2012 at 11:52 AM, Longwing, LJ CTR MDA/IC <
> lj.longwing@mda.mil> wrote:
>
>
> I was figuring there was a way, but despite looking, didn't see
> it, thanks :)
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Sylvain YVON
> Sent: Wednesday, September 12, 2012 9:00 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Stop/Activate Escalations
>
> Hi,
>
> You can do it with the API like LJ suggested, with the driver
> program if you just want to script, or in a program of your own.
>
> If you open ar.h on your server, you can see all the server
> settings you can change :
> [...]
> #define AR_SERVER_INFO_DISABLE_ESCALATIONS  143  /* int  - 0 -
> enabled
>  */   /*
>  1
> - not enabled  */
> [...]
>
> Note the number 143.
>
> The "driver" programs offer a CLI to use the AR System API. For
> example, to disable escalations on a server, simply launch "driver"
> and use the following commands :
>
> Command: init
> INITIALIZATION
>
>ARInitialization  results
> ReturnCode:  OK
> Status List : 0 items
>
> Command: log
> Control record:
>Authentication string () :
>User name () : 
>Password () : 
>Locale[.charSet] () :
>Time zone () :
>Server () : 
>
> Command: ssp
> SET SERVER PORT
> The port number of server (0):  Using
> private socket? (0):
>
>ARSetServerPort  results
> ReturnCode:  OK
> Status List : 0 items
>
> Command: ssi
> SET SERVER INFO
>Number of server info operations (0): 1 Server info list entry
> Operation (1-334) (1): 143 Datatype
> Null/Key/Int/Real/Char/Diary/Enum/Time/Bitmask/Byte/Decimal/attach/
>
>  currency/date/timeofday/join/trim/control/Table/Column/ulong/
>  coords/view/display (0-14, 30-34, 40-43) (0): 0
>
>ARSetServerInfo  results
> ReturnCode:  OK
> Status List : 0 items
>
>
>
> Now you can easily script this by writing all your answers, with
> the blank lines, into a text file, and run "driver < commands.txt".
>
>
>
>
>
> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
>



-- 
Curtis Gallant

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Stop/Activate Escalations

[Curtis Gallant]

Here is a simple java method that does the same thing, assumes you have the
rest of the required boilerplate in place for your context.

void disableEscalations() {
try {
ServerInfoMap serverSettings = new ServerInfoMap();

serverSettings.put(Constants.AR_SERVER_INFO_DISABLE_ESCALATIONS, new
Value(1));
context.setServerInfo(serverSettings);
} catch (ARException e) {
System.out.println(e.getMessage());
}
}

On Wed, Sep 12, 2012 at 11:52 AM, Longwing, LJ CTR MDA/IC <
lj.longwing@mda.mil> wrote:

> I was figuring there was a way, but despite looking, didn't see it, thanks
> :)
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Sylvain YVON
> Sent: Wednesday, September 12, 2012 9:00 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: Stop/Activate Escalations
>
> Hi,
>
> You can do it with the API like LJ suggested, with the driver program if
> you just want to script, or in a program of your own.
>
> If you open ar.h on your server, you can see all the server settings you
> can change :
> [...]
> #define AR_SERVER_INFO_DISABLE_ESCALATIONS  143  /* int  - 0 - enabled
>  */   /*1
> - not enabled  */
> [...]
>
> Note the number 143.
>
> The "driver" programs offer a CLI to use the AR System API. For example,
> to disable escalations on a server, simply launch "driver"
> and use the following commands :
>
> Command: init
> INITIALIZATION
>
>ARInitialization  results
> ReturnCode:  OK
> Status List : 0 items
>
> Command: log
> Control record:
>Authentication string () :
>User name () : 
>Password () : 
>Locale[.charSet] () :
>Time zone () :
>Server () : 
>
> Command: ssp
> SET SERVER PORT
> The port number of server (0):  Using private
> socket? (0):
>
>ARSetServerPort  results
> ReturnCode:  OK
> Status List : 0 items
>
> Command: ssi
> SET SERVER INFO
>Number of server info operations (0): 1 Server info list entry
> Operation (1-334) (1): 143 Datatype
> Null/Key/Int/Real/Char/Diary/Enum/Time/Bitmask/Byte/Decimal/attach/
>  currency/date/timeofday/join/trim/control/Table/Column/ulong/
>  coords/view/display (0-14, 30-34, 40-43) (0): 0
>
>ARSetServerInfo  results
> ReturnCode:  OK
> Status List : 0 items
>
>
>
> Now you can easily script this by writing all your answers, with the blank
> lines, into a text file, and run "driver < commands.txt".
>
>
>
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: Anyway to populate ardb.conf other than manual?

[Curtis Gallant]

Here is pretty much the same thing in Java using the BMC Remedy Java API.
 I basically just re-implemented Matts script with a few changes
like dropping the ARGetSQL call in favor of a plain getListForm call since
it essentially does the same thing without having to resort to a direct SQL
query. I use MSSQL Server on my dev box so the default clause in there is
worded using MSSQL speak (partitions rather then tablespaces like in
Oracle) but you can adjust the clauses List object as needed to do
whatever you would like.  See the comments for where you should be making
changes potentially.

Just remember to have the BMC Java API in your classpath before attempting
to run this for it to work and adjust the connection info for your own
environment (I didn't bother adding an argument parser or making it
interactive like Matt's script for entering connection info as this was
just a quick throw together as I don't use Perl much these days and wanted
to quickly generate an ardb.cfg file, i'll probably clean it up and add
some argument parsing later on when I have time so its all not so
'hardcoded' like below).

Hope this is helpful.

<<>>

import com.bmc.arsys.api.ARException;
import com.bmc.arsys.api.ARServerUser;
import com.bmc.arsys.api.Constants;
import com.bmc.arsys.api.Form;
import com.bmc.arsys.api.IndexInfo;

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

public class ARDBGenerator {
private static ARServerUser server;

public ARDBGenerator(String Server, String User, String Password, int
Port) {
server = new ARServerUser();
server.setServer(Server);
server.setUser(User);
server.setPassword(Password);
server.setPort(Port);
}

public static void main(String[] args) {
/* Change variable to suit target AR System Environment */
String Server = "";  // Set this to the proper server
name for your environment
String User = "";  // Set this to the proper user name
for your environment
String Password = ""; // Set this to the proper password
for the user specified above
int Port = ;  // Set this to the proper port or comment out
if using portmapper

ARDBGenerator ars = new ARDBGenerator(Server, User, Password, Port);
ars.connect();
ars.GenerateARDBConfiguration();
server.logout();
}

void connect() {
System.out.println();
try {
server.verifyUser();
} catch (ARException e) {
System.out.println(e.getMessage());
System.exit(1);
}
}

/**
 * The following method will auto-generate a Remedy ardb.conf/cfg file
for all schemas with indexes on the system
 */
void GenerateARDBConfiguration() {
try {
File file = new File("ardb.cfg");
if (!file.exists()) {
file.createNewFile();
}
FileWriter fw = new FileWriter(file.getAbsoluteFile());
BufferedWriter bw = new BufferedWriter(fw);
List schemaList;
List clauses = new ArrayList();
clauses.add("on INDEXPartition");  // Set this to the proper
partition created for indexes if different from primary

schemaList = server.getListForm(0,
Constants.AR_LIST_SCHEMA_REGULAR);

for (String schema : schemaList) {
Form schemaObject = server.getForm(schema);
bw.write("Form:" + schema + "\n");
for (IndexInfo indexInfo : schemaObject.getIndexInfo()) {
if (indexInfo.getIndexFields() != null) {
bw.write("Index {\n");
for (Integer indexedField :
indexInfo.getIndexFields()) {
bw.write("Id:" + indexedField + "\n");
}
for (String clause : clauses) {
bw.write("Clause:" + clause + "\n");
}
bw.write("}\n");
}
}
}
bw.close();
} catch (ARException e) {
System.out.println(e.getMessage());
} catch (IOException e) {
System.out.println(e);
}
}
}


On Wed, Sep 5, 2012 at 2:39 PM, Grooms, Frederick W <
frederick.w.gro...@xo.com> wrote:

> It looks like your perl installation does not have the ARSPerl module
> installed.
>
> You can get the ARSPerl module from
> http://sourceforge.net/projects/arsperl/
>
> Fred
>
>
> -Original Message-
> From: Action Request System discussion list(ARSList) [mailto:
> arslist@ARSLIST.ORG] On Behalf Of Jamie
> Sent: Wednesday, September 05, 2012 1:13 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Anyway to populate ardb.conf other than manual?
>
> I got some internal help with trying to run this, but running into

Re: Tomcat and MidTier 7.1

[Curtis Gallant]

> > > > > java.lang.UnsatisfiedLinkError: CCPUtilApp
> > > > >com.bmc.arsys.util.ARUtilEgcp.CCPUtilApp(Native Method)
> > > > >com.remedy.arsys.config.Configuration.login(Unknown Source)
> > > > >com.remedy.arsys.config.ConfigServlet.login(Unknown Source)
> > > > >com.remedy.arsys.config.ConfigServlet.doLogin(Unknown Source)
> > > > >com.remedy.arsys.config.ConfigServlet.performOperation(Unknown
> > > > Source)
> > > > >com.remedy.arsys.config.ConfigServlet.doRequest(Unknown Source)
> > > > >com.remedy.arsys.config.ConfigServlet.postInternal(Unknown
> > Source)
> > > > >com.remedy.arsys.config.ConfigServlet.doPost(Unknown Source)
> > > > >javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> > > > >javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> > > > >
> > > > > The only difference is the new version 7 install. Everything else has
> > > > > remained the same. This is pretty much the same procedure used in the
> > > > > past with no issues.
> > > > >
> > > > > Any thoughts?
> > > > >

Looks like your LD_LIBRARY_PATH is not set as it can't access the ARS APIs.
Make sure the user you start tomcat as has his LD_LIBRARY_PATH set including the
path to the .../webapps//WEB-INF/lib directory.

Cheers,

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: OT: Rant - SLA - Change / Task

[Curtis Gallant]

On Thu, Dec 13, 2007 at 09:32:06AM -0500, T. Dee wrote:
> 
>**
> 
>At least someone agrees with me :-)
> 
> 
> 
>Now for the big one million dollar question is how in ITSM 7 to create
>OLAs for Change Tasks using SLM.
> 
> 
> 
>Anyone out there done this?
> 
> 
> 
>Thank you!!!

SLM 7 can integrate to pretty much any backend form... That is the beauty
of its design, simply add the datasource and its parameters and it will
build all the filters for you.  Tasks in the end is just another
request-based datasource.  This could be better documented in the
guides but it is pretty straightforward to get it mesuring.  If you want
the equivalent of the SLM tab to show on tasks, then you need to
build/copy those objects from change and build the workflow to display
it/update it if you use any of the tabs functionality.

Now what will make things shine in your setup will be to have your OLAs
as dependencies of the SLAs attached to Change.  This would let you
measure real penalties in relation to your service level agreements and
put in some foundation work for operational chargebacks for breaches.
This can also be setup from SLM but for it to give you any practical
comparission metrics you need to do some work.

Cheers,

Curtis Gallant
Consultant

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: OT: ITSM 7.0 - Patch 6

[Curtis Gallant]

> I see 144 bugs that were fixed once.
> I see 154 bugs that were fixed twice.
> I see 4 bugs that were fixed three times.
> I see 7 bugs that were fixed four times.
>
> And I see 305 total unique bug ID's. (That were fixed)
>   I wonder how many remain outstanding?
>   I wonder how many customers reported each of those 305 bugs?
>   I wonder how many customers it took to find those 305 bugs? (vs
> internally found)
>

The reason for this is you need to realize that not all customers
install all ITSM modules.  What this means is that BMC must include
common foundation/integration fixes in every patch set for all the
modules because say a customer only installs Problem Management, they
still need all the fixes to core foundation objects and integration
points.  Individual modules get bugs reported against them
individually and this can cause duplicate bugs to be listed under
different defects which end up with different descriptions when in the
end a single code update might close the same bug across all modules.
This may be confusing to those who run all ITSM modules but in
reality, there is no other way without splitting out the patch sets
into more logical sections... say a section for the module specific
code updates, section for integrations specific code updates and a
final section for core foundation object updates.

I agree that a list of object updates per patch would definitely be
welcomed... It's not like the ITSM workflow is hidden in anyway so
what is the point of not including this information as part of the
defect fix.  If remedy objects were 'closed source' I could
understand...  They are slowly rectifying this situation though, the
patch notes are starting to get better and things at BMC are starting
to stir in the right direction of disclosure and open source
initiatives (I am very excited that BMC has chosen Eclipse as the
framework to release the new Developer Studio for ARS going forward,
this flexibility is definitely the shot in the arm BMC needed to get
developers excited again IMO).

Happy patching ;)

-- 
---
Curtis Gallant
Senior ITSM Consultant
KOAN-IT Corp

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: SQL Update to a table with a special character +HPD_Helpdesk

[Curtis Gallant]

> All,
> 
> I am running 6.3 on an Oracle Server. I want to run an update and have a 
> form with a + in front of it.  Does anyone know how I run an update to a 
> table with a special character in front of it? I have tried using 
> _Form_Name and +Form_Name, but these do not work.
> 

You can use its T tables as a quick workaround

Incase you have never had to do that, to find out which table it is:

SELECT NAME,SCHEMAID FROM ARSCHEMA WHERE NAME = 'XXX:XXX' 
-- REPLACE XXX:XX with the actual fuzzy name of the form

Add a T to the front of the int value returned as schemaid and you have
your base T table.

Hope this helps,

Cheers,
-- 
Curtis Gallant
[EMAIL PROTECTED]

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: upgrading to CMDB 2.0.1 patch 2, error message

[Curtis Gallant]

Look in the CMDB Install/Log directory.  The logs there will put you on
the right path.  I had a similar issue where there were some
BMC.CORE:BMC_FederatedProduct entries missing which was causing a
failure at the same point as you describe below.

My fix was to look at an existing CMDB 2.0.1 database and re-create the
missing entries.


-
Curtis Gallant 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Juan Carlos Figueroa
Sent: Wednesday, March 14, 2007 1:54 PM
To: arslist@ARSLIST.ORG
Subject: upgrading to CMDB 2.0.1 patch 2, error message

Greetings,
While trying to upgrade to cmdb 2.0.1 patch 2 from cmdb 2.0.0 patch 001
, I received the following error message:

"There was a problem during upgrade to BMC Atrium CMDB 2.0.1 patch 000
stage
1 using wf-RIK.xml"

We are running ARS 7.0.1, Windows Server 2003. Oracle 10g.

Thanks for your help!

Juan

_
Get a FREE Web site, company branded e-mail and more from Microsoft
Office Live!
http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Remedy's ENCRYPT function

[Curtis Gallant]

I recently had to do some research involving exportable cryptography and that 
lead me to this page which to put bluntly was like finding a diamond in the 
ruff.
 
http://www.efc.ca/pages/doc/crypto-export.html
 
This page specifically goes over export restrictions from a Canadian standpoint 
(since I am located in Canada this was exactly what I was looking for).  It 
breaks down country by country the restrictions and how they apply to exports.
 
For US based exports of cryptography, see points 4 and 5 where it talks 
explicitly about exporting from the US and what kind of restrictions and paper 
work needs to be filed.
 
Just food for thought really for those interested in the subject.
 
Cheers,
 


Curtis Gallant 

 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Joe DeSouza
Sent: Wednesday, December 13, 2006 6:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy's ENCRYPT function


** 
The 56 bit key is for free and is the default level of encryption when you 
enable it on the ARS Servers.. Anything higher you need to buy and I believe 
the maximum strenght of encryption you can buy is 128 bit for the ARS...
 
Joe


- Original Message 
From: "Reiser, John J" <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, December 13, 2006 5:56:55 PM
Subject: Re: Remedy's ENCRYPT function

** 
Joe et al,
The ENCRYPT function uses a key that you provide either as a hardcode text or 
stored in a field. I believe it is 56bit but I could be wrong. I know you need 
a lot more room in the character field if you encrypt data. I tried it once , 
just for fun, and my 11 character string would not fit in a 50 character field.
 
Sorry, I never tested it much past that.
 
 
 

John J. Reiser
Software Development Analyst
Remedy Administrator/Developer
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me



 



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Joe DeSouza
Sent: Wednesday, December 13, 2006 5:49 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy's ENCRYPT function


** 
Yes, but don't you have to use an encryption key to perform that encryption? 
Thats what I thought as these functions are disabled by default if you do not 
have encryption enabled on your ARS server...
 
Joe


- Original Message 
From: L. J. Head <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, December 13, 2006 5:23:46 PM
Subject: Re: Remedy's ENCRYPT function

** 
I'm not sure if that is the encryption that Aaron is talking about.  I believe 
he is talking about the ability to encrypt data in a character field before 
putting it in the DB...and then decrypt it once it's in the client



From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
On Behalf Of Joe DeSouza
Sent: Wednesday, December 13, 2006 2:33 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy's ENCRYPT function


** 
If i remember right, Remedy sells the 64 and the 128 bit encryption keys. 
Depending on how good your nephew is in breaking into security, the 128 bit key 
encryption is pretty good. I haven't used it but its the maximum security 
allowed to be used in the US..
 
Joe D'Souza
Remedy Developer / Consultant,
BearingPoint,
Virginia.


- Original Message 
From: Aaron Keller <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Wednesday, December 13, 2006 3:36:47 PM
Subject: Remedy's ENCRYPT function

** 

I’m looking at the ENCRYPT function, and its definition is pretty vague.  Does 
anyone use it?  Does anyone know:

- what algorithm is used?

- what size limitations are there on the key?

- on a scale of 1 (my nephew could crack it in an afternoon) to 10 (a 
supercomputer would take a year), how secure is it? 

 

-Aaron

* Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 




Have a burning question? Go to Yahoo! Answers 
<http://answers.yahoo.com/;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx>
  and get answers from real people who know. 
__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___




Want to start your own business? Learn how on Yahoo! Small Business. 
<http://us.rd.yahoo.com/evt=41244/*http://smallbusiness.yahoo.com/r-index>  
__20060125___This posting was submitted with HTML in it___ 
__20060125___This posting was submitted with HTML in it___




Want to start your own business? Learn how

Re: Can I call a filter inside an Escalation ???

[Curtis Gallant]

Why not just create a hidden field on the form the escalation is running
against.  Say Z_DO_ESCALATION.  Then have the escalation modify this
field and add modification of this field to the qualifier of the filters
you wish to fire? 

Think of it as an execution flag for the filter that gets set by the
escalation.

Cheers,



Curtis Gallant 
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Tarun Kumar SHARMA
Sent: Wednesday, December 13, 2006 8:58 AM
To: arslist@ARSLIST.ORG
Subject: Can I call a filter inside an Escalation ???

Hello,

Can we directly call a filter to execute, inside any action (may be in
Run Process) of an Escalation ?
We are using ARS 6.3 & HD6.0.

Regards,
Tarun


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Mid-Tier config question

[Curtis Gallant]

The actual option to hide this bar from mid-tier is in Form | Current
View | Properties | Click Appearence tab | Bottom left has webtool bar
dropdown, set this to hidden.
 
Cheers,
 


Curtis Gallant 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Barber
Sent: Wednesday, December 06, 2006 11:58 AM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier config question


** 
Frank,
 
Thanks for that, but it doesn't work.  I'm pretty sure that something is
seriously wrong with parts of our mid-tier.  Turns out that the Toolbar
option was already un-checked.  I've checked it, flushed the cache,
tried it, unchecked it, flushed the cache, tried it again, and it makes
no difference to the status. 
 
Thing is that the server is running 5.1.2, but the mid tier config says
6.3.
 
The problem is that it doesn't display correctly
 
You get something like :
 
v Current mode : Search
 I I Advanced searchI
 I (partial text)   I  (partial text)  I (partial text)
 
It doesn't display the lower lines correctly.  Clicking the "v"
minimises the section, but its still there.  Would be great if it could
be switched off, but it doesn't appear possible.
 
Regards

Dave

 
On 06/12/06, Frank Caruso <[EMAIL PROTECTED]> wrote: 

** Personally I think the MidTier dispay of the tool bar is
pretty nice. However, if you do not want to see it then using the 6.0
Admin tool, open the form, goto Form | Current View | Properties and
then click on the Menu Access tab and uncheck the Toolbar item. 


On 12/6/06, Dave Barber <[EMAIL PROTECTED] > wrote: 

** 

All,
 
Have a question on mid-tier setup.
 
We're running ARS 5.1.2 on SQL server, and (according to
the system info), the mid tier is running v 6.3 patch 010.
 
For the most part the mid tier is workable, but one area
doesn't appear correctly - at the top you have the search mode and the
search/advanced search buttons attempting to appear (and doing a sucky
job of it), this is running on either IE6, IE7 or Firefox 2.  Is there
any way to force these to not display, just to tidy up the interface a
little? 
 
Regards
 
Dave
__20060125___This posting was
submitted with HTML in it___ 




-- 
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer, ITIL Foundation Certified
www.specificintegration.com
<http://www.specificintegration.com/> 
703-376-1249 __20060125___This posting was
submitted with HTML in it___ 


__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: How to clear table field through workflow

[Curtis Gallant]

Right click -> Clear
 
Or
 
Using a run process on an Active link 
 
PERFORM-ACTION-TABLE-CLEAR 

Clears the contents of the table field.

For list view table fields, tree view table fields, and alert list
fields, returns

the table to its initial state.

For results list fields, fires workflow and then resets the mode to
Query.

This is equivalent to pressing the New Search form action button.

 

----
Curtis Gallant 

 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Anoop Sasidharan
Sent: Tuesday, November 28, 2006 11:53 AM
To: arslist@ARSLIST.ORG
Subject: How to clear table field through workflow


** Hi All,
 
How to clear the table field, thru a back end workflow?
 
Thanks
Anoop




Get the new Windows Live Messenger! Try it!
<http://get.live.com/messenger/overview>
__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Changing Port # on Tomcat 5.x for Mid-Tier 7

[Curtis Gallant]

You need to modify the following in your server.xml file in the conf
directory of TomCat
 
Find this section:
 

 
In that section is where you define the port to bind to.  Make sure that
you don't already have something listening on port 80, then set
port="80" and restart tomcat and it should now be bound to port 80.
 
Cheers,

   
Curtis Gallant 
 



From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of LAU, DARREN (ASI)
Sent: Wednesday, November 22, 2006 1:17 PM
To: arslist@ARSLIST.ORG
Subject: Changing Port # on Tomcat 5.x for Mid-Tier 7


** 

Hi Listers,

 

I was able to successfully install Tomcat 5.x standalone and Mid-Tier 7
patch 1 on our test environment.  It was actually a lot easier than I
had anticipated.  So far everything is working great and it seems to be
a bit faster than IIS/ServletExec from some seat of the pants testing.
Anyways my question is how can we change it so that the default port
8080 is not needed in the URL?  Right now we have to use http://:8080/arsys.  How can we get it to work like this...  http:///arsys?  TIA.

 

 

Darren Lau

 

__20060125___This posting was submitted with HTML in
it___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"

Re: Java AR API weirdness

[Curtis Gallant]

Yeah I've never actually tried createEntry in a join, you could say its
broken but I believe its just not fully implemented, remember that a
join form in remedy is nothing but a DB View which joins 2 T tables and
stores relationships and joinIDs in a separate table.  So by using
createEntry against a join may work and create the entry, you will not
get a return ID or a JoinEntryID since data is not stored in the join so
(its like sending data down a black hole), rather in the underlying
tables that create the link.

I agree this makes it very difficult when trying to work with the CMDB
which is a mess of Joins ontop of Joins, easy solution if you require an
ID to return is to look at the base forms of the join and push directly
to those, which will then inherent into the Join.

Hope this helps at least a bit, I've only begun API work with the C API
myself so my word is far from an experienced cry.  If you find a way to
get that information returned I'd love to hear it.

Cheers,


----
Curtis Gallant

-Original Message-
From: John Baker [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 25, 2006 11:24 AM
To: arslist@arslist.org
Cc: Curtis Gallant
Subject: Re: Java AR API weirdness

Chris,

It must be a bug. I'm looking at the Entry in the debugger once it's
been created, and the EntryKey Object has three values:

 * EntryID ("")
 * JoinEntryID (null)
 * SchemaID ("The Join Form")

Clearly the JoinEntryID should have a value, and therefore I deem it
broken. 
Which is a little annoying for anyone attempting to work with the CMDB.


John

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Java AR API weirdness

[Curtis Gallant]

Not sure if the same applies for the Java API, but for the C API
according to documentation, you can't createEntry to a Join, you should
createEntry to the base forms that make up the Join.

I might be way off but I hope this helps

Cheers, 



Curtis Gallant

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of John Baker
Sent: Wednesday, October 25, 2006 9:34 AM
To: arslist@ARSLIST.ORG
Subject: Java AR API weirdness

Hello,

Consider the following:

  EntryFactory entryMan = EntryFactory.getFactory();
  Entry entry = (Entry)entryMan.newInstance();
  entry.setContext(serverUser);
  entry.setEntryItems(items);
  entry.setSchemaID(new NameID(schema));
  entry.create();
  System.out.println(entry.getEntryID().toString());

Should create a new Entry and output the EntryID. This works fine,
unless the entry was created in a Join Form, in which case an empty
string (not null) is output.

I've tested with the v7.0 API (patch 1 & 2). 

Has anyone else seen this behaviour? Is it really a bug or just
incorrect use of the API?


John

Java System Solutions : http://www.javasystemsolutions.com


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Mid-Tier 7.0.01 and Tomcat

[Curtis Gallant]

Yeah I can't find it anymore myself (and I'm not very pleased that the
KB Searching doesn't work with firefox either :S), contact me offlist if
you would like me to forward it to you.

Cheers, 

----
Curtis Gallant

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of strauss
Sent: Tuesday, October 24, 2006 2:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.0.01 and Tomcat

Thanks. If I could FIND a statement of direction on the new SupportWeb,
now that would be a miracle. All of my entries in the custom
documentation list just evaporated for the second time in two days.
Thanks for the info on the install; it did appear to install the web
server if I selected Other. Now I just have to figure out the arcane
setup of the thing.

Christopher Strauss, Ph.D.
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/helpdesk/

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Curtis Gallant
Sent: Tuesday, October 24, 2006 12:09 PM
To: arslist@ARSLIST.ORG
Subject: Re: Mid-Tier 7.0.01 and Tomcat

If you read the statement of direction released by BMC which explains
why they moved from Servlet Exec to Tomcat, it also informs you that the
'webserver' component of Tomcat will be install from the MidTier
installer if you select 'Other' option when you get to the question.

Excerpt from the SOD:
___CUT
The compatibility matrix lists Tomcat as a Web server, as well. What
happens if I install Tomcat without a Web server (such as IIS or
Apache)?


If Tomcat is installed with BMC Remedy AR System version 7.0.01, and
"other" is selected as the Web server, BMC Remedy AR System will
automatically default to the use of Tomcat as both Web server and
servlet engine.


A different Web server can also be installed at a later time if so
desired. Please ensure that the Web server you install is consistent
with the compatibility matrix for BMC Remedy AR System.
___EOF

My personal experience with Tomcat is much more favorable then
ServletExec and I'm sure others would state the same.  I am also very
pleased that they choose an open source solution for both supportability
and active development.  Tomcat is very actively developed in the
community whereas ServletExec has been stale for years.

Cheers,


Curtis Gallant


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Mid-Tier 7.0.01 and Tomcat

[Curtis Gallant]

If you read the statement of direction released by BMC which explains
why they moved from Servlet Exec to Tomcat, it also informs you that the
'webserver' component of Tomcat will be install from the MidTier
installer if you select 'Other' option when you get to the question.

Excerpt from the SOD:
___CUT
The compatibility matrix lists Tomcat as a Web server, as well. What
happens if I install Tomcat without a Web server (such as
IIS or Apache)?


If Tomcat is installed with BMC Remedy AR System version 7.0.01, and
"other" is selected as the Web server,
BMC Remedy AR System will automatically default to the use of Tomcat as
both Web server and servlet
engine.


A different Web server can also be installed at a later time if so
desired. Please ensure that the Web server you
install is consistent with the compatibility matrix for BMC Remedy AR
System.
___EOF

My personal experience with Tomcat is much more favorable then
ServletExec and I'm sure others would state the same.  I am also very
pleased that they choose an open source solution for both supportability
and active development.  Tomcat is very actively developed in the
community whereas ServletExec has been stale for years.

Cheers,


Curtis Gallant

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of strauss
Sent: Tuesday, October 24, 2006 11:35 AM
To: arslist@ARSLIST.ORG
Subject: Mid-Tier 7.0.01 and Tomcat

On the SupportWeb (if you can get to it) under ARS 7.0.01 documentation
there is a new white paper on "Benchmark Comparison of the ServletExec
and Tomcat Engines" with some interesting results and confusing
terminology. They had a performance and scalability session at UserWorld
from the new BMC Remedy benchmarking group that got into this a little
bit, but this is the first whitepaper I have seen from them.

According to the results of their tests, all on Windows Server 2003 (the
only platform I care about), IIS 6 and ServeltExec 5p10 was faster than
IIS 6 and Tomcat 5.5 (which they are now bundling in the mid-tier 7.0.01
installer) because of the JK connector required for Tomcat to talk to
IIS. My testing yesterday bore this out, plus Tomcat crashed several
times when trying to load ITSM 7 consoles (not an auspicious start). The
whitepaper says that Tomcat performs better __only__ when run as Tomcat
5.5 "standalone" meaning on a Tomcat web server instead of IIS. What is
not clear to me is what the "Tomcat web server" is. It does not offer to
install it with mid-tier 7.0.01 if you don't have IIS on the server, so
it's not in the bundle. If they mean the Apache web server, my previous
experience was that Apache has never run well on Windows and is not
preferable to IIS on that platform.

Has anyone else played with this on Windows 2003 and figured out what
they meant by Tomcat web server? The main reason for considering Tomcat
is that ServletExec has memory issues that were evident in testing, plus
stability problems up to and definitely beyond 500 virtual users (a load
that I will never see here). Tomcat 5.5 "Standalone" appears to be some
variation of Tomcat beyond what they bundled in the installer, but that
is not clear in the benchmarking paper. With the salient exception of
Perl/ARSPerl, I don't use open source stuff as a rule so I am not that
savvy about rolling my own or departing from what the Remedy installer
will do, which appears to be limited to adding the Tomcat JSP engine and
JK connector to IIS.

BTW, if you are looking for the documentation on installing mid-tier
7.0.01 with Tomcat, it is in the ARS 7.0.01 Release Notes (English) that
are conspicuously ABSENT from the SupportWeb documentation page (if you
read any of the other supported languages, those Release Notes are
available). Support sent me a copy that was clearly a review document,
and that is what I have been working from.

Christopher Strauss, Ph.D.
Remedy Database Administrator
University of North Texas Computing Center
http://remedy.unt.edu/helpdesk/


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: Advantages/Disadvantages between platforms running Remedy

[Curtis Gallant]

Hey Guillaume,

I agree, in my oppinion Unix is a much better platform for production
systems but your argument belows is not completely accurate in all
situations, yes Solaris 10 X86 can run on a multitude of cheap
hardware/laptops but in relation to AR System itself, it has not been
ported to Solaris X86 and from my conversations with BMC will not
anytime soon unless more people start requesting and sending in business
cases as I did.  AR System will only run on the Sparc version of Solaris
running on native Sparc hardware which locks us into expensive (but very
robust) hardware.

The day I can have Solaris X86 on my laptop with a full AR System
running would be a good day ;)

Cheers,



Curtis Gallant

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Rheault
Sent: Thursday, October 05, 2006 1:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advantages/Disadvantages between platforms running Remedy

Hey Axton,
 
At least for Solaris, you can run it almost anywhere, even laptops. So
the argument that UNIX only runs on expensive hardware does not apply to
Solaris at all.
I have seen myself Solaris 10 running on laptops, how about that?
 
BTW, here is the hardware compatibility list (HCL) for Solaris 10:
 
http://www.sun.com/bigadmin/hcl/data/sol/
 
Here is the compatibility list for Solaris 10 on laptops, as incredible
as it sounds:
 
http://www.sun.com/bigadmin/hcl/data/sol/systems/views/all_laptops_all_r
esults.page1.html
 
 
Guillaume



From: Action Request System discussion list(ARSList) on behalf of Axton
Grams
Sent: Wed 10/04/06 6:18 PM
To: arslist@ARSLIST.ORG
Subject: Re: Advantages/Disadvantages between platforms running Remedy



MSSQL Advantages:
- Case insensitive

MS OS Disadvantages:
- When things break a reboot is in order, when things really break a
rebuild is in order
- c api development typically requires purchasing an MS compiler and
learning an MS tool
- Open software sometimes has trouble working properly/reliably and is
subject to breaking with MS updates

UNIX Advantages:
- people proficient in unix/linux can actually investigate and resolve
issues
- Open software usually works

UNIX Disadvantages:
- expensive hardware

Linux/MS Advantages:
- cheap hardware

Some questions to ask that I can't answer:
- Is clustering more robust in unix/linux environment?

Apart from a technological standpoint, there are other things to
consider:
- what skills are at your disposal in your organization?
- what skills do your remedy people have?

Axton Grams

Scott Neeb wrote:
> We have an initiative at my work entitled "Why Not Microsoft?".  We're

> supposed to ask ourselves at critical application milestones if we 
> should contemplate moving Remedy to the Windows platform.  We 
> currently reside on UNIX with an Oracle database, so Remedy is always 
> being evaluated as a candidate for the move.  They asked me today if 
> there are any advantages/disadvantages between running Remedy on 
> UNIX/Oracle as compared to Windows/SQL Server.  I haven't seen any 
> documentation or user comments anywhere on the internet, so I was 
> wondering if any of you have any prior experience with this type of 
> move, and if you've seen any advantages or disadvantages to this type 
> of move as it relates to the ARSystem.  Thanks in advance.
>
> __
> _ UNSUBSCRIBE or access ARSlist Archives at 
> http://www.wwrug.org
>


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org




___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARS 7 - Patch 2 Sever Patch?

[Curtis Gallant]

It is very often that things show up on the patch download site but have
either broken links or the Download button is disabled.  Most of the
time it is because BMC have not included the proper URL as part of the
selected entry(as in the Migrator patch003 link) or they are holding
back for an announcement.

What I normally do is go back to the previous patch, go up a directory
or two to get to the root of a certain application then climb up the
directory tree myself.  This allows me to see what is actually published
as opposed to what is made available via direct links from their 'patch'
web application.

Hope that helps.

Cheers,

----
Curtis Gallant

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mohan Panchangmath
Sent: Wednesday, September 20, 2006 2:47 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 - Patch 2 Sever Patch?

Hey Curtis,

Thanks for the extra information..it is available.
How did you figure out though???
Cheers,
Mohan

--- Curtis Gallant <[EMAIL PROTECTED]> wrote:

> Migrator patch 3 is available, the problem is the link is going to
> patch003 when the acktual directory is Patch003 (capitol P).  So easy 
> way to get to the proper link is to make it to the
> 404 the patch site
> gives you and re-write the URL as /Patch003/
> 
> Cheers,
> 
> 
> 
> Curtis Gallant
> 
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Bryan.Waters
> Sent: Wednesday, September 20, 2006 1:14 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARS 7 - Patch 2 Sever Patch?
> 
> Good Afternoon,
> 
> The readme files are now available for ARS v7 Patch 2.  However, the 
> link for Migrator v7 Patch 3 is still broken.
> 
> Enjoy,
> Bryan
> 
> -Original Message-
> From: Action Request System discussion list(ARSList) 
> [mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt
> Sent: Wednesday, September 20, 2006 11:09 AM
> To: arslist@ARSLIST.ORG
> Subject: Re: ARS 7 - Patch 2 Sever Patch?
> 
> No Mike, I see the same thing.  There are also no README files, which 
> is abnormal.  It's almost like part of the patch didn't get published 
> yet.
> I'm
> waiting to see if it gets cleaned up today or not.
> 
> Matt R.
> 
> -Original Message-
> From: Mike Parker
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 20, 2006 9:57 AM
> To: arslist@ARSLIST.ORG
> Subject: ARS 7 - Patch 2 Sever Patch?
> 
> Good Morning List:
> 
> I just checked out the patches for 7.0, and patch 2 was there, and it 
> says that there is a server patch (in the Problem Symptoms), but when 
> I went to download it, I don't see it.
> 
> All I see is:
> Assignment
> Clients
> Mid-Tier
> Email
> 
> Am I the only one who's experiencing this?
> 
>
_
> Get today's hot entertainment gossip
> http://movies.msn.com/movies/hotgossip
> 
>

> 
> ___
> UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
> 
>

> ___
> UNSUBSCRIBE or access ARSlist Archives at
> http://www.wwrug.org
> 
>

> ___
> UNSUBSCRIBE or access ARSlist Archives at
> http://www.wwrug.org
> 
>

___
> UNSUBSCRIBE or access ARSlist Archives at
> http://www.wwrug.org
> 


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: ARS 7 - Patch 2 Sever Patch?

[Curtis Gallant]

Migrator patch 3 is available, the problem is the link is going to
patch003 when the acktual directory is Patch003 (capitol P).  So easy
way to get to the proper link is to make it to the 404 the patch site
gives you and re-write the URL as /Patch003/

Cheers, 



Curtis Gallant

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Bryan.Waters
Sent: Wednesday, September 20, 2006 1:14 PM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 - Patch 2 Sever Patch?

Good Afternoon,

The readme files are now available for ARS v7 Patch 2.  However, the
link for Migrator v7 Patch 3 is still broken.

Enjoy,
Bryan

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Matt Reinfeldt
Sent: Wednesday, September 20, 2006 11:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARS 7 - Patch 2 Sever Patch?

No Mike, I see the same thing.  There are also no README files, which is
abnormal.  It's almost like part of the patch didn't get published yet.
I'm
waiting to see if it gets cleaned up today or not.

Matt R.

-Original Message-
From: Mike Parker [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 20, 2006 9:57 AM
To: arslist@ARSLIST.ORG
Subject: ARS 7 - Patch 2 Sever Patch?

Good Morning List:

I just checked out the patches for 7.0, and patch 2 was there, and it
says that there is a server patch (in the Problem Symptoms), but when I
went to download it, I don't see it.

All I see is:
Assignment
Clients
Mid-Tier
Email

Am I the only one who's experiencing this?

_
Get today's hot entertainment gossip
http://movies.msn.com/movies/hotgossip



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

SQL Server Reporting Services

[Curtis Gallant]

Has anybody successfully used the SQL Server Reporting Services to
generate reports against a Remedy system of any version?

If so could you please let us know any gotchas you might have had to
overcome.

Cheers,

--
Curtis Gallant
Burntsand Inc.
Systems Integration Specialist
 
Office:   416-234-3861
Cell: 416-786-2842
Email:[EMAIL PROTECTED]
Web site: www.burntsand.com  
 

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Re: How do I REinstall an ITSM application

[Curtis Gallant]

If you want the installer to not just bork when trying to install again,
simply delete the Incident application record from
SHARE:Application_Properties and the installer should run again. 

Cheers,



Curtis Gallant

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Monday, July 31, 2006 6:56 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Something to try:

Copy the "C:\Program Files\AR System Applications\\BMC
Remedy Incident Management" folder to another drive.  If you do not have
access to another drive then copy to a folder outside of "C:\Program
Files".  Then delete the "C:\Program Files\AR System Applications\\BMC Remedy Incident Management" folder.

You want to keep a copy of the folder in case deleting it causes any
problems.

Run the install again.  If it works then delete the backup copy of the
folder you created above.

Stephen



-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 8:49 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Stephen,
I don't have an entry for Incident Mgmnt in Add/Remove Programs - but do
have for AR System Server, Approval, Assignment, & Email Engine. 

Thanks

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:37
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

"Add or Remove Programs" in the Windows Control Panel.

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 8:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Thanks Stephen, but where do I find the Uninstall?

Kieran

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: 31 July 2006 13:15
To: arslist@ARSLIST.ORG
Subject: Re: How do I REinstall an ITSM application

Kieran,

Can you run the Uninstall for Incident Management?

Stephen

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare
Sent: Monday, July 31, 2006 6:22 AM
To: arslist@ARSLIST.ORG
Subject: How do I REinstall an ITSM application

After a botched Incident Management 7 install, I now wish to reinstall
it. I I don't have any other ITSM 7 applications installed.

However, when I try to rerun the installer I get a message

'all requirement systems are present. Nothing to install' and it doesn't
go any further.

What do I need to do to allow a reinstall? I didn't find any help on
this in the ITSM 7 installation guide. Am I correct in saying it
involves entries in SHARE:Application Properties and if so what entries?


Thanks,

Kieran O'Hare
Programmer
Information Systems Services
200/201 Pearse St.
Trinity College
Dublin 2
Phone +353 1 8962774


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org



___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org


___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org