Re: security risk with attachment - Any ideas?

[ITSM.Support]

Hi,

I have found one thread on web
http://old.nabble.com/Re:-Virus-Scanning-Remedy-Attachments---p3614885.html


Which in short means:

We can make use of Filters that fire on Create/Modify that check to see if
there is a change in an attachment. 
The actions taken are

  1) Use special run process to Save the attachment to disk
PERFORM-ACTION-SAVE-ATTACHMENT

  2) Use special run process to Add the attachment just saved back to the
system
PERFORM-ACTION-ADD-ATTACHMENT

Virus checking software on server will check virus for saved attachment and
then we can load a "Scanned" copy of attachment.

HTH

--
Regards,
Ruksana

Vyom Labs Pvt. Ltd.
BSM Solutions & Services || ITIL Consulting & Training
Email: i...@vyomlabs.com  || Web Site: www.vyomlabs.com Follow Vyom Labs
http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of pascale.sterr...@daimler.com
Sent: Thursday, August 23, 2012 9:57 PM
To: arslist@ARSLIST.ORG
Subject: security risk with attachment - Any ideas?

HI all,

I am hoping that someone else on the list had to face this growing 
security concern and found a way to do this. 
This is the concern that came back from a security audit:

"Attachment are not being scanned at the server level and the application 
can only rely on the fact that the user may or may not use a scanning 
system (anti-virus for example). This does not prevent user to willingly 
add a malicious file.  The files should be scanned to stop SVG files to be 
uploaded at the server level."

I know I can have an API that would run on the server and would look at 
the tickets created and if there is an attachment, to extract it and scan 
it etc.  But any one has a better idea?  Or knows of some utility that is 
already out there that could do this?


Thank you,

Pascale 
Kenavo ar wech all


If you are not the intended addressee, please inform us immediately that you
have received this e-mail in error, and delete it. We thank you for your
cooperation.  

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.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"

WWRUG/ARSlist Awards 2012: Let the Voting Begin!

[Daniel Bloom]

So,  a big round of applause to this years nominees for the ARSlist MVP:

 

Daniel Bloom - yes, I was nominated, I decline the nomination, but thank-you
for the gesture

 

Jose Huerto

 

LJ Longwing 

 

Jason Miller

 

Voting starts now and ends Friday Sept. 7th at 5pm EST

 

There are over 4000 of you on the list, please lets see some support for
those that spend their free

time helping others!

 

 

 

* Voting is by the Individual REAL person, 

so redistribution lists don't vote, your identity must be known,

and those that have multiple subscriptions still get only one vote

 

* BMCSoftware employees on the ARSlist are eligible to vote

 

* All decisions of myself or  the oversight panel are final 

(if I have to make a controversial decision, I confer with 3 past MVP
winners for their opinion)

 

Thursday October  18th at WWRUG12: Award Ceremony during the WWRUG Awards
keynote.

 

[no one knows the winner(s) until then, well okay, except me and the plaque
company]

 

Please send nominations to d...@wwrug.com

 

 

Thanks . Daniel

Daniel Bloom

ARSlist Founder

RAC/RSP since 1995

WWRUG Co-Founder

Chairman of WWRUG12

 


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

Using overlays in a non-ITSM system.

[Reiser, John J]

Hello Listers,
MS SQL 2005
MS Windows Enterprise Server 2003 on a virtual machine
ARS 7.6.03 Build 001

Though we are not using the ITSM suite here I was wondering if there is any 
benefits to using either the best practice setting in the Dev Studio or 
incorporating overlays to my own forms and any additions to BMC system forms ( 
User, Group, AR System email Messages etc.)

I haven't had the chance to take any Developer classes utilizing Overlays, best 
practices, Panels, Data Visualization and just about anything new in the 
ARSystem for the last few years.

Could it be useful to manage my own updates if I build a core base and then put 
the customer changes into an overlay or am I wrong about how the overlay is 
used?

Thank you,
--- 
John J. Reiser 
Remedy Developer/Administrator 
Senior Software Development Analyst 
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 

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

SLM issue

[Rajesh Nair]

Hi listers,

need a small clarification,

7.5.00 Patch 006 SW00392339

have an issue here in Incident management.

was going through some ticket to be more precise got an issue reported,

a ticket was riased with goal time of 8 hrs and was assigned to 1st
level with 24hrs clock
SLA start when status = assigned ans stops when status= in progress(response)
Now the 1st level assigned the ticket after the ticket has gone past goal time
Now the ticket is with a new group and for this the business entiry is
9 hrs per day and as per calculation for this group the response shuld
show sa Met.

Both this SLA's are group as both runs for the same company, priorty
and other conditions.

Now my question is will the SLA status show as missed and will  it
change to Met when a new SLA is attached and is well within the time?
i doudt it will carry the same status as missed but i do not have a
concrete answer for giving the justication.

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

Re: Using overlays in a non-ITSM system.

[Misi Mladoniczky]

Hi,

I have used overlays just like you describe.

Do my changes in Best Practice Mode, and then propagate the changes to
Base Mode when they are approved. Or just delete the oberlays/custom
objects that did not get approved.

The current main problem with this is that there is no way in Dev Studio
to do this. I built RRR|DefBPCU to convert the exported def file
instead...

The other problem is that you can not work with Deployable Applications in
Best Practice Mode...

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* 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.

> Hello Listers,
> MS SQL 2005
> MS Windows Enterprise Server 2003 on a virtual machine
> ARS 7.6.03 Build 001
>
> Though we are not using the ITSM suite here I was wondering if there is
> any benefits to using either the best practice setting in the Dev Studio
> or incorporating overlays to my own forms and any additions to BMC system
> forms ( User, Group, AR System email Messages etc.)
>
> I haven't had the chance to take any Developer classes utilizing Overlays,
> best practices, Panels, Data Visualization and just about anything new in
> the ARSystem for the last few years.
>
> Could it be useful to manage my own updates if I build a core base and
> then put the customer changes into an overlay or am I wrong about how the
> overlay is used?
>
> Thank you,
> ---
> John J. Reiser
> Remedy Developer/Administrator
> Senior Software Development Analyst
> 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
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.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"

JOB: Senior Remedy Developer needed - Brooklyn, NY

[Qaiser Iqbal]

Looking for Senior Remedy Developer for a full time position with the City
of New York, Department of Information Technology & Telecommunications.
Interested candidates, please send your resume to
itrecr...@doitt.nyc.govwith the Subject line "Application for Remedy
Engineer, Job ID 101662"

Below is the job description:

*City of New York*

*Department of Information Technology & Telecommunications*

* Job Posting Notice***

* *

*Civil Service Title: *Computer Systems Manager

* *

*Level:*M1**

* *

*Title Code No:  *10050

* *

*Salary:   *$49,492/$53,373 - $110,000*   *

* *

*Office Title:*Remedy Engineer*  *

* *

*Work location:  *Brooklyn, NY* **   *

* *

*Division/Work Unit: *IT Services

* *

*Number of Positions:  *1

* *

*Job ID:  *101662*  *

* *

*Hours/Shift:  *Day* *- Due to the necessary technical management duties of
this position in a 24/7 operation, candidate may be required to be on call
and/or work various shifts such as weekends and/or evenings.*  *
  Job Description

DoITT is responsible for modernizing, unlocking, and innovating to improve
IT infrastructure and service delivery in New York City government.
Modernizing by implementing state-of-the-art information technology to
improve services to New Yorkers. Unlocking by making government more
transparent and accountable to New Yorkers. Innovating by employing
cutting-edge tools, methods, and relationships to empower New Yorkers.

The successful candidate will serve as a Remedy Engineer reporting to the
IT Services division. Responsibilities will include: Manage the development
and configuration of the BMC Remedy ITSM 6.x, 7.x (Helpdesk, Change,
Request, SLM, Asset) and assist with internal application integration and
the migration of additional stakeholders; provide technical leadership and
configuration of the BMC tool; develop and implement BMC Remedy ITSM 6.x,
7.x and BMC CMDB; oversee the workflow/process definition in ITIL areas;
provide clients with assessment of IT operational maturity and identify
targets for process/technology improvement; oversee the definition of
technology requirements; prepare recommendations for the implementation of
new processes and procedures; provide technical management assistance with
system transitions; and manage special technology projects and initiatives
as assigned. The position’s responsibilities include commitment to and
compliance with the City’s EEO policy.
  Minimum Qualification Requirements

1. A master's degree in computer science from an accredited college and
three years of progressively more responsible, full-time, satisfactory
experience using information technology in computer applications
programming, systems programming, computer systems development, data
telecommunications, database administration, planning of data/information
processing, user services, or area networks at least 18 months of this
experience must have been in an administrative, managerial or executive
capacity in the areas of computer applications programming, systems
programming, computer systems development, data telecommunications, data
base administration, or planning of data processing or in the supervision
of staff performing these duties; or
2. A baccalaureate degree from an accredited college and four years of
experience as described in "1" above; or
3. A four-year high school diploma or its educational equivalent approved
by a State's department of education or recognized accrediting organization
and six years of experience as described in "1" above; or
4. A satisfactory combination of education and experience equivalent to
"1", "2" or "3" above. However, all candidates must have at least a
four-year high school diploma or its educational equivalent approved by a
State's department of education or recognized accrediting organization and
must possess at least three years of experience as described in "1" above,
including the 18 months of administrative, managerial, executive or
supervisory experience as described in "1" above.

*NOTE:* The following types of experience are not acceptable: superficial
use of preprogrammed software without complex programming, design,
implementation or management of the product; use of word processing
packages; use of a hand held calculator; primarily the entering or updating
of data in a system; the operation of data processing hardware or consoles.
  Preferred Skills

The preferred candidate should have the following: 5+ years experience in
BMC Remedy products, including product design, configuration and
integration with 3rd party tools; experience with installation and
configuration of AR Server group; detailed knowledge of AR System 6.x, 7.x
and Remedy ITSM (Helpdesk, Change, Request, SLM, Asset); strong Remedy ITSM
workflow and customization experience; proficiency with Remedy ITSM
Application Configuration; proficiency with Remedy Mid-Tier 6.x, 7.x; good
understanding of complete software life cycle; ability t

Auto-Import a Text File

[Kevin Shaffer]

ARS 7.6.04 SP2 I have a requirement that multiple text files will be placed on 
a network share drive every 30 minutes.  The requirement is for me to import 
these files into a custom form in Remedy.  The customer is set on using pipe 
delimited text files and is not interested in switching over to webservices or 
pushing the text file into a DB table and then create a View form.  The 
integration must be using pipe delimited text files.  Every 30 minutes, one or 
more files is dropped into a folder, i.e.  and  dropped at 
12:30; at 1:00 PM  is dropped in the folder.  I must grab the files at 
12:30 and import them into a custom form.  After they have imported into the 
custom form, I need to rename the file or move it to another directory so they 
dont import twice.  I then repeat the process at 1:00 PM. Can this be done 
using ARImport from an escalation or AIE or some other method other than 
webservices or a View form? Any suggestions would be appreciated. 
ThanksKevin
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

Re: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin!

[arslist]

Following my usual tradition of recording, copying and pasting a spelling
error:

It is Jose Huerta.

 

My apologies. Dan

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Bloom
Sent: August 27, 2012 9:14 AM
To: arslist@ARSLIST.ORG
Subject: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin!

 

** 

So,  a big round of applause to this years nominees for the ARSlist MVP:

 

Daniel Bloom - yes, I was nominated, I decline the nomination, but thank-you
for the gesture

 

Jose Huerto

 

LJ Longwing 

 

Jason Miller

 

Voting starts now and ends Friday Sept. 7th at 5pm EST

 

There are over 4000 of you on the list, please lets see some support for
those that spend their free

time helping others!

 

 

 

* Voting is by the Individual REAL person, 

so redistribution lists don't vote, your identity must be known,

and those that have multiple subscriptions still get only one vote

 

* BMCSoftware employees on the ARSlist are eligible to vote

 

* All decisions of myself or  the oversight panel are final 

(if I have to make a controversial decision, I confer with 3 past MVP
winners for their opinion)

 

Thursday October  18th at WWRUG12: Award Ceremony during the WWRUG Awards
keynote.

 

[no one knows the winner(s) until then, well okay, except me and the plaque
company]

 

Please send nominations to d...@wwrug.com

 

 

Thanks . Daniel

Daniel Bloom

ARSlist Founder

RAC/RSP since 1995

WWRUG Co-Founder

Chairman of WWRUG12

 

_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"

Re: SLM issue

[Jose Manuel Huerta Guillén]

I don't know if i understood well your question, but if the objective is
broken it will remain at this status (unless it is restarted, (the check
box), in that case I'm not sure what will happen)

What I do at these cases is to set one SVT per group. So each group has
it's own time counter. It's the only way to see if one group broken the
SLA, or both.


Jose Manuel Huerta
http://theremedyforit.com/




On Mon, Aug 27, 2012 at 3:57 PM, Rajesh Nair wrote:

>
> Both this SLA's are gro

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

Re: SLM issue

[Rajesh Nair]

That make sense., the problem is j am new to this org and i need to have
astrong ponit to say that once the status of SLA says mssed, it will be the
same even it is assigned to the group w
Even if the goal time is not missed as  calculated
On Aug 27, 2012 7:27 PM, "Rajesh Nair"  wrote:

> Hi listers,
>
> need a small clarification,
>
> 7.5.00 Patch 006 SW00392339
>
> have an issue here in Incident management.
>
> was going through some ticket to be more precise got an issue reported,
>
> a ticket was riased with goal time of 8 hrs and was assigned to 1st
> level with 24hrs clock
> SLA start when status = assigned ans stops when status= in
> progress(response)
> Now the 1st level assigned the ticket after the ticket has gone past goal
> time
> Now the ticket is with a new group and for this the business entiry is
> 9 hrs per day and as per calculation for this group the response shuld
> show sa Met.
>
> Both this SLA's are group as both runs for the same company, priorty
> and other conditions.
>
> Now my question is will the SLA status show as missed and will  it
> change to Met when a new SLA is attached and is well within the time?
> i doudt it will carry the same status as missed but i do not have a
> concrete answer for giving the justication.
>

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

Re: SLM issue

[Rajesh Nair]

Jose
Can you tell me more on "unless it is restarted"
On Aug 27, 2012 10:27 PM, "Jose Manuel Huerta Guillén" <
arsl...@theremedyforit.com> wrote:

> ** I don't know if i understood well your question, but if the objective
> is broken it will remain at this status (unless it is restarted, (the check
> box), in that case I'm not sure what will happen)
>
> What I do at these cases is to set one SVT per group. So each group has
> it's own time counter. It's the only way to see if one group broken the
> SLA, or both.
>
>
> Jose Manuel Huerta
> http://theremedyforit.com/
>
>
>
>
> On Mon, Aug 27, 2012 at 3:57 PM, Rajesh Nair wrote:
>
>>
>> Both this SLA's are gro
>
>
> _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"

Re: Auto-Import a Text File

[Longwing, LJ CTR MDA/IC]

Kevin,
Data Import tool, to the best of my knowledge, does not support pipe 
delineationso you would need to use some sort of script to convert it to 
comma delimited.  The entire process can be done relatively easily with Perl if 
you are familiar with it...I'm sure there is a module which will convert the 
data from one to another for you, and the rename/move/etc would be easy enough 
as well.

-Original Message-
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Shaffer
Sent: Monday, August 27, 2012 10:19 AM
To: arslist@ARSLIST.ORG
Subject: Auto-Import a Text File

** 
ARS 7.6.04 SP2
 
I have a requirement that multiple text files will be placed on a network share 
drive every 30 minutes.  The requirement is for me to import these files into a 
custom form in Remedy.  The customer is set on using pipe delimited text files 
and is not interested in switching over to webservices or pushing the text file 
into a DB table and then create a View form.  The integration must be using 
pipe delimited text files. 
 
Every 30 minutes, one or more files is dropped into a folder, i.e.  and 
 dropped at 12:30; at 1:00 PM  is dropped in the folder.  I 
must grab the files at 12:30 and import them into a custom form.  After they 
have imported into the custom form, I need to rename the file or move it to 
another directory so they dont import twice.  I then repeat the process at 1:00 
PM.
 
Can this be done using ARImport from an escalation or AIE or some other method 
other than webservices or a View form?   
 
 
Any suggestions would be appreciated.
 
Thanks
Kevin

_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"

Re: Tomcat 7.0.29

[Brian Pancia]

I just loaded this in a lab and we are in the process of moving into
production.  I haven't seen any issues yet.  We are having issues getting
the isap_redirect to work with IIS 7.5, so if anyone has insight that would
be great.  For Analytics we ended up running a seperate Tomcat 7.0.29
server and installed it under the Business Objects install directory.
During the BOXI install it does ask for the Tomcat 5.5 path.  We were able
to put the 7.0.29 path and the install went through.  When we setup BOXI on
the same tomcat as mid-tier it was painfully slow.  The difference was
night and day with the seperate tomcats, so far no issues on that either.

Brian



On Thu, Aug 23, 2012 at 9:03 AM, SUBSCRIBE arslist S Fish <
sf...@attivasoft.com> wrote:

> Has anyone used Tomcat 7.0.29 for their mid-tier in production yet?  We
> have it in a LAB environment with Windows 2008  R2 64-Bit servers with SQL
> 2008, Java 1.6.0_26 64/32 bit, ARS Server, Atrium, and ITSM 7.6.04 SP2 and
> have not found any issues yet but there are only a couple of us on there.
>  Just checking if anyone has gone with it in production.  I heard one
> mention it has issues with Business Objects but we have not verified that
> yet.
>
> Also, has anyone security hardened Apache Tomcat 6.x or newer?
>
>
> http://tomcat.apache.org/tomcat-7.0-doc/security-howto.html
>
> http://www.mulesoft.com/tomcat-security
>
> http://blogs.mulesoft.org/is-your-tomcat-secure/
>
> https://www.owasp.org/index.php/Securing_tomcat
>
> Above are some links I have found and will go through and test in our LAB
> environment but again if someone has performed and can provide some gotchas
> or lessons learned they would be greatly appreciated...  :)
>
> TIA,
>
> Shane
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.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"

Re: Auto-Import a Text File

[Ben Chernys]

Meta-Update can use any delimiter and will log every invocation.
Meta-Update can also move the files once imported.

 

For more information, please feel free to contact me on +1 403 240 4377 (MDT
/ GMT -6)

 

Cheers

Ben Chernys
Senior Software Architect
Description: logoSthInc-sm  

Canada / Deutschland
Mobile:  +49 171 380 2329GMT + 1 + [ DST ]
Email:
Ben.Chernys_AT_softwaretoolhouse.com
Web:   www.softwaretoolhouse.com

Check out Software Tool House's free Diary Editor and out Freebies

Section for an ITSM 7.6.04 Forms and Fields spreadsheet.

Meta-Update, our premium ARS Data tool, lets you automate 
your imports, migrations, in no time at all, without programming, 
without staging forms, without merge workflow. 
  http://www.softwaretoolhouse.com/  

 

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Shaffer
Sent: August-27-12 10:19
To: arslist@ARSLIST.ORG
Subject: Auto-Import a Text File

 

** 

ARS 7.6.04 SP2
 
I have a requirement that multiple text files will be placed on a network
share drive every 30 minutes.  The requirement is for me to import these
files into a custom form in Remedy.  The customer is set on using pipe
delimited text files and is not interested in switching over to webservices
or pushing the text file into a DB table and then create a View form.  The
integration must be using pipe delimited text files. 
 
Every 30 minutes, one or more files is dropped into a folder, i.e. 
and  dropped at 12:30; at 1:00 PM  is dropped in the folder.
I must grab the files at 12:30 and import them into a custom form.  After
they have imported into the custom form, I need to rename the file or move
it to another directory so they dont import twice.  I then repeat the
process at 1:00 PM.
 
Can this be done using ARImport from an escalation or AIE or some other
method other than webservices or a View form?   
 
 
Any suggestions would be appreciated.
 
Thanks
Kevin

_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"
<>

smime.p7s
Description: S/MIME cryptographic signature

Re: SLM issue

[Jose Manuel Huerta Guillén]

At the SVT definition, if set at advanced mode there is a check box that
you can use:

Reset goal: When some conditions are met, the current measure is closed and
a new one starting from 0 is created. That means that a single request can
create multiple SVT measures.

The reset goal condition is defined at the data source.

Using the reset goal condition you can measure if one group has taken more
than 8 hours to go to In Progress state. But you won't know which group has
been. To know it you need separate SVT for each case.


Jose Manuel Huerta
http://theremedyforit.com/




On Mon, Aug 27, 2012 at 8:02 PM, Rajesh Nair wrote:

> Jose
> Can you tell me more on "unless it is restarted"
>

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

Re: CMDB Fields for FTS indexing

[rahul2007k...@gmail.com]

Hi,

Has anyone encountered the same kind of issue before with FTS enable on
CMDB fields.

Regards.
RK


On Sun, Aug 26, 2012 at 5:31 PM, rahul2007k...@gmail.com <
rahul2007k...@gmail.com> wrote:

> Hi All,
>
> Please let me know if anyone has done FTS indexing on CMDB fields like CI
> ID, CI Name etc.
> I have currently enable FTS indexes on above fields on
> BMC.Core:Base_Element form but when ever i search newly created CI I am not
> able to search it until i re index whole FTS .
>
> I have seen that there are some FTS limitation for data re-indexing on
> join form and need to schedule the data scan for those join forms which
> causes very high CPU & memory utilization.
> Also the Best practice development mode doesn't allow to modify the fields
> on join form and i need to switch base development to modify those forms &
> its property which i think is not a good idea.
>
> I am not sure how to achieve this on CMDB forms as everything is based on
> join form structure and its very difficult to enable FTS on all the CMDB
> classes.
>
> Thanks,
> RK
>

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

Re: Auto-Import a Text File

[arslist]

Ben,

 

And others. You know who you are.

 

If your contribution to a discussion is "buy/use my product", please
remember to mention AD in the Subject line.

 

Thanks Dan

Disclaimer: I am neither endorsing or being negative about the product with
this comment

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys
Sent: August 27, 2012 2:47 PM
To: arslist@ARSLIST.ORG
Subject: [SPAM]Re: Auto-Import a Text File

 

** 

Meta-Update can use any delimiter and will log every invocation.
Meta-Update can also move the files once imported.

 

For more information, please feel free to contact me on +1 403 240 4377 (MDT
/ GMT -6)

 

Cheers

Ben Chernys
Senior Software Architect
Description: logoSthInc-sm  

Canada / Deutschland
Mobile:  +49 171 380 2329GMT + 1 + [ DST ]
Email:   Ben.Chernys_AT_softwaretoolhouse.com
Web:   www.softwaretoolhouse.com

Check out Software Tool House's free Diary Editor and out Freebies

Section for an ITSM 7.6.04 Forms and Fields spreadsheet.

Meta-Update, our premium ARS Data tool, lets you automate 
your imports, migrations, in no time at all, without programming, 
without staging forms, without merge workflow. 
  http://www.softwaretoolhouse.com/  

 

 

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kevin Shaffer
Sent: August-27-12 10:19
To: arslist@ARSLIST.ORG
Subject: Auto-Import a Text File

 

** 

ARS 7.6.04 SP2
 
I have a requirement that multiple text files will be placed on a network
share drive every 30 minutes.  The requirement is for me to import these
files into a custom form in Remedy.  The customer is set on using pipe
delimited text files and is not interested in switching over to webservices
or pushing the text file into a DB table and then create a View form.  The
integration must be using pipe delimited text files. 
 
Every 30 minutes, one or more files is dropped into a folder, i.e. 
and  dropped at 12:30; at 1:00 PM  is dropped in the folder.
I must grab the files at 12:30 and import them into a custom form.  After
they have imported into the custom form, I need to rename the file or move
it to another directory so they dont import twice.  I then repeat the
process at 1:00 PM.
 
Can this be done using ARImport from an escalation or AIE or some other
method other than webservices or a View form?   
 
 
Any suggestions would be appreciated.
 
Thanks
Kevin

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ 

_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"
<>

Re: CMDB Fields for FTS indexing

[Nathan Aker]

Not directly on topic, but we've basically put a moratorium on any additional 
indexing of fields by the FTS engine as it seems to have more than enough 
trouble handling the load from the base application functionalities with 
7.6.04.   Careful how much you ask it to index, I know we're not alone as I've 
seen a number of posts from others having to monkey with the FTS configuration 
to get this beast to simply do the jobs BMC has asked it to do in the 7.6.04 
ITSM apps.  We've got all FTS plugins now running on one server per BMC 
direction and still have hiccups from time to time with it getting choked up.

Nate.

Nathan Aker
ITSM Solution Architect
McAfee, Inc.


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of rahul2007k...@gmail.com
Sent: Monday, August 27, 2012 1:55 PM
To: arslist@ARSLIST.ORG
Subject: Re: CMDB Fields for FTS indexing

** Hi,

Has anyone encountered the same kind of issue before with FTS enable on CMDB 
fields.

Regards.
RK

On Sun, Aug 26, 2012 at 5:31 PM, 
rahul2007k...@gmail.com 
mailto:rahul2007k...@gmail.com>> wrote:
Hi All,

Please let me know if anyone has done FTS indexing on CMDB fields like CI ID, 
CI Name etc.
I have currently enable FTS indexes on above fields on BMC.Core:Base_Element 
form but when ever i search newly created CI I am not able to search it until i 
re index whole FTS .

I have seen that there are some FTS limitation for data re-indexing on join 
form and need to schedule the data scan for those join forms which causes very 
high CPU & memory utilization.
Also the Best practice development mode doesn't allow to modify the fields on 
join form and i need to switch base development to modify those forms & its 
property which i think is not a good idea.

I am not sure how to achieve this on CMDB forms as everything is based on join 
form structure and its very difficult to enable FTS on all the CMDB classes.

Thanks,
RK

_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"

Re: Auto-Import a Text File

[Misi Mladoniczky]

Hi,

The ARImport .ARM file format support any delimiter.

It might be difficult to build a robust 30-minute import using arimportcmd
though.

You might consider building an API-program to do this, including error
handling. C, Java, ARSperl, .Net come to mind.

Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)

Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
* 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.

>
> ARS 7.6.04 SP2 I have a requirement that multiple text files will be
> placed on a network share drive every 30 minutes.  The requirement is for
> me to import these files into a custom form in Remedy.  The customer is
> set on using pipe delimited text files and is not interested in switching
> over to webservices or pushing the text file into a DB table and then
> create a View form.  The integration must be using pipe delimited text
> files.  Every 30 minutes, one or more files is dropped into a folder, i.e.
>  and  dropped at 12:30; at 1:00 PM  is dropped in
> the folder.  I must grab the files at 12:30 and import them into a custom
> form.  After they have imported into the custom form, I need to rename the
> file or move it to another directory so they dont import twice.  I then
> repeat the process at 1:00 PM. Can this be done using ARImport from an
> escalation or AIE or some other method other than webservices or a View
> form? Any suggestions would be appreciated. ThanksKevin
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug12 www.wwrug12.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"

Re: Auto-Import a Text File

[Jose Manuel Huerta Guillén]

We planned an integration using a similar communication link, a file placed
at a FTP account. The idea was to integrate with a CMMS. The solution we
provided was to create a java script that fired when creating a file at a
forlder, read it and sent it using a web service. The java analyst said one
day for developing and testing, so I assume it was easy. Fortunately, the
IT office declined this integration method and required the CMMS developers
to create a web service interface.

I think that it would be easier to develop an external agent that uses the
API, or if you don't have any API expert, using a web service would be
easier.

Regards,

Jose Manuel Huerta
http://theremedyforit.com/




On Mon, Aug 27, 2012 at 9:59 PM, Misi Mladoniczky  wrote:

> Hi,
>
> The ARImport .ARM file format support any delimiter.
>
> It might be difficult to build a robust 30-minute import using arimportcmd
> though.
>
> You might consider building an API-program to do this, including error
> handling. C, Java, ARSperl, .Net come to mind.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * 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.
>
> >
> > ARS 7.6.04 SP2 I have a requirement that multiple text files will be
> > placed on a network share drive every 30 minutes.  The requirement is for
> > me to import these files into a custom form in Remedy.  The customer is
> > set on using pipe delimited text files and is not interested in switching
> > over to webservices or pushing the text file into a DB table and then
> > create a View form.  The integration must be using pipe delimited text
> > files.  Every 30 minutes, one or more files is dropped into a folder,
> i.e.
> >  and  dropped at 12:30; at 1:00 PM  is dropped in
> > the folder.  I must grab the files at 12:30 and import them into a custom
> > form.  After they have imported into the custom form, I need to rename
> the
> > file or move it to another directory so they dont import twice.  I then
> > repeat the process at 1:00 PM. Can this be done using ARImport from an
> > escalation or AIE or some other method other than webservices or a View
> > form? Any suggestions would be appreciated. ThanksKevin
> >
> ___
> > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> > attend wwrug12 www.wwrug12.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"
>

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

Updating the SVT requests

[Jose Manuel Huerta Guillén]

Hi listers,

I need to create a report on daily basis using BOXI. This report reads the
SLM:Measurement form and HPD:Help Desk, looking for all measures for open
incidents. This report will be generated automatically by night and the PDF
sent to a Sharepoint site. Thus, the manager can see at the morning a
summary of its service. But I noticed that the SLM:Measurement request do
not update so frequently as expected. In fact I have an incident that is
not updated for a week, and the SLM:Measurement is also one week old.

Do you know how to force to recompute an SLM:Measurement. Thus I could run
an escalation two hours before generating the report, recomputing all
opened measurements.

Regards,

Jose Manuel Huerta
http://theremedyforit.com/

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

Re: Auto-Import a Text File

[Shafqat Ayaz]

Jose
I have done something similar. Drop me a line offline and I will give you the 
details.

 


Shafqat Ayaz





>
> From: Jose Manuel Huerta Guillén 
>To: arslist@ARSLIST.ORG 
>Sent: Monday, August 27, 2012 9:38 PM
>Subject: Re: Auto-Import a Text File
> 
>
>** 
>We planned an integration using a similar communication link, a file placed at 
>a FTP account. The idea was to integrate with a CMMS. The solution we provided 
>was to create a java script that fired when creating a file at a forlder, read 
>it and sent it using a web service. The java analyst said one day for 
>developing and testing, so I assume it was easy. Fortunately, the IT office 
>declined this integration method and required the CMMS developers to create a 
>web service interface.
>
>
>I think that it would be easier to develop an external agent that uses the 
>API, or if you don't have any API expert, using a web service would be easier.
>
>
>Regards,
>Jose Manuel Huerta
>http://theremedyforit.com/ 
>
>
>
>
>
>On Mon, Aug 27, 2012 at 9:59 PM, Misi Mladoniczky  wrote:
>
>Hi,
>>
>>The ARImport .ARM file format support any delimiter.
>>
>>It might be difficult to build a robust 30-minute import using arimportcmd
>>though.
>>
>>You might consider building an API-program to do this, including error
>>handling. C, Java, ARSperl, .Net come to mind.
>>
>>        Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>>Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>>* 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.
>>
>>
>>>
>>> ARS 7.6.04 SP2 I have a requirement that multiple text files will be
>>> placed on a network share drive every 30 minutes.  The requirement is for
>>> me to import these files into a custom form in Remedy.  The customer is
>>> set on using pipe delimited text files and is not interested in switching
>>> over to webservices or pushing the text file into a DB table and then
>>> create a View form.  The integration must be using pipe delimited text
>>> files.  Every 30 minutes, one or more files is dropped into a folder, i.e.
>>>  and  dropped at 12:30; at 1:00 PM  is dropped in
>>> the folder.  I must grab the files at 12:30 and import them into a custom
>>> form.  After they have imported into the custom form, I need to rename the
>>> file or move it to another directory so they dont import twice.  I then
>>> repeat the process at 1:00 PM. Can this be done using ARImport from an
>>> escalation or AIE or some other method other than webservices or a View
>>> form?     Any suggestions would be appreciated. ThanksKevin
>>
>>> ___
>>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>> attend wwrug12 www.wwrug12.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"
>>
>_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"

Re: Auto-Import a Text File

[Shafqat Ayaz]

Sorry sent the email to the wrong guy!
Kevin contact me offline and I will tell you the way I did something similar.

 


Shafqat Ayaz





>
> From: Kevin Shaffer 
>To: arslist@ARSLIST.ORG 
>Sent: Monday, August 27, 2012 5:18 PM
>Subject: Auto-Import a Text File
> 
>
>**  
>ARS 7.6.04 SP2
> 
>I have a requirement that multiple text files will be placed on a network 
>share drive every 30 minutes.  The requirement is for me to import these files 
>into a custom form in Remedy.  The customer is set on using pipe delimited 
>text files and is not interested in switching over to webservices or pushing 
>the text file into a DB table and then create a View form.  The integration 
>must be using pipe delimited text files. 
> 
>Every 30 minutes, one or more files is dropped into a folder, i.e.  
>and  dropped at 12:30; at 1:00 PM  is dropped in the folder.  
>I must grab the files at 12:30 and import them into a custom form.  After they 
>have imported into the custom form, I need to rename the file or move it to 
>another directory so they dont import twice.  I then repeat the process at 
>1:00 PM.
> 
>Can this be done using ARImport from an escalation or AIE or some other method 
>other than webservices or a View form?   
> 
> 
>Any suggestions would be appreciated.
> 
>Thanks
>Kevin
>
_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"

Re: Using overlays in a non-ITSM system.

[Joe Martin D'Souza]

The only place it would be useful is when maintaining modifications done to 
any of the OTB workflow if any such as the core forms and workflow..


Else it won't quite gain you much, at least not in the current versions.

There was talk about future versions of overlays that would change in its 
design, which may benefit an all custom shop, but in its current version, 
there is no benefit I can think of, since you are the master of it all and 
are free to add or delete from what you currently have with little or no 
impact, if done the right way..


Joe

-Original Message- 
From: Reiser, John J
Sent: Monday, August 27, 2012 9:35 AM Newsgroups: 
public.remedy.arsystem.general

To: arslist@ARSLIST.ORG
Subject: Using overlays in a non-ITSM system.

Hello Listers,
MS SQL 2005
MS Windows Enterprise Server 2003 on a virtual machine
ARS 7.6.03 Build 001

Though we are not using the ITSM suite here I was wondering if there is any 
benefits to using either the best practice setting in the Dev Studio or 
incorporating overlays to my own forms and any additions to BMC system forms 
( User, Group, AR System email Messages etc.)


I haven't had the chance to take any Developer classes utilizing Overlays, 
best practices, Panels, Data Visualization and just about anything new in 
the ARSystem for the last few years.


Could it be useful to manage my own updates if I build a core base and then 
put the customer changes into an overlay or am I wrong about how the overlay 
is used?


Thank you,
--- 
John J. Reiser

Remedy Developer/Administrator
Senior Software Development Analyst
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 


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

Re: Remedy form object and Oracle table relationships

[Jason Miller]

Hi Susan,

I agree that what Misi describes is the best way to go about it.
 Admittedly I have never had to resolve this issue but it is consistent
with the other Remedy data translation/transition scenarios.  A while back
I was talking to a Remedy admin who's DBA told him the DB was Unicode when
it wasn't. He installed ARS as Unicode and some time later issues began to
arise.  BMC's recommendation was to build a new system with matching
character sets and to export the data out of the broken system and import
into the new system using the AR API (import tool, etc.).

Jason

On Sun, Aug 26, 2012 at 10:09 PM, Misi Mladoniczky  wrote:

> Hi Susan,
>
> Why not remove all complex manual thinking, guessing and planning?
>
> 1. Do a fresh install
> 2. Export your def and import it the new system
> 3. Copy your data using RRR|Chive
> 4. Stop your users from accessing the servers, stop escalations, email etc
> 5. Do a final delta-transfer using RRR|Chive (~1 hour)
> 6. Switch your users to the new server
>
> You might get data that does not fit into the new syst, if you have a lot
> of 128+ ascii codes in your current data. But step 4 above can be run
> multiple times, until you have corrected all errors.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * 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.
>
> > Hi everyone,
> >
> > It seems my life is complicated this week.  Again I need to draw on your
> > experiences and I'm looking for your opinions and cautionary statements.
> >
> > Background:  We use an outsourcer company to do the bulk of our database
> > work.  When we built new servers last year and they build the new oracle
> > 10g databases we didn't notice that they were not Unicode.  Apparently
> the
> > previous ones were, but in actuality we didn't really have a need for it.
> > About 5 years ago we opened a China office requiring all staff to be
> > English proficient so everything was still ok.  But now we're finding
> that
> > customer information which arrives in simplified Chinese, which they
> > translate into English, which then needs to be re-translated back to
> > Chinese to meet government requirements for billing is not as straight
> > forward as it may sound.  So they were trying to type more Chinese in and
> > of course since the new server databases were not Unicode it didn't work
> > like it did before.  Then to  add to the pain, no one said anything.  So
> > here we are a year later and now it's a big deal.
> >
> > So, we are endeavoring to change to Unicode.  Our approach is to create a
> > new server space, create a new Unicode database, and get the data in
> there
> > converted, and then install the application again.  No upgrades of db or
> > application involved, only the Unicode aspect of it.
> >
> > Well, that sounds so much easier than it's turning out to be.  Our dba
> has
> > run CSSCAN various times and finally came up with a list of forms/fields
> > that have potential problems with the conversion.  The current field
> > length
> > is being totally used so in the conversion to Unicode it needs more field
> > length.  The dba is suggesting that he just expand the database field
> > lengths with no need to touch the form objects.  This sets off all sort
> of
> > red flags for me.  I never let anyone  go directly to the database for
> > data
> > updates.  Other applications we use can read data but if they need to
> > write
> > there they use the Remedy API.  There can be no manipulation of the
> tables
> > in the database, it must all be done via developer tool.
> >
> > What else is troubling is that in the list of tables/fields that have a
> > problem some tables/fields that should be listed because that's where the
> > data originated and was pushed down from are not listed.  Many of the
> > records in question are older and if some data gets 'cut off' or what I
> > used to think truncated meant we can live with that.  We're talking
> > several
> > thousand records in 15-25 tables.
> >
> > The dba is proposing the following:
> >
> > I will export the table metadata and data of the tables, listed in the
> > spreadsheet with NLS_LANG set to AMERICAN_AMERICA.WE8ISO8895P1.
> >
> > I will then truncate the tables and drop the tables.
> >
> > The CSALTER program will then be ran against the database.
> >
> > I will then import the table metadata and data, using NLS_LANG set to
> > AMERICAN_AMERICAN.AL32UTF8
> >
> >
> >
> > This will cause the internal expansion of the column from bytes to chars
> > and some of the tables will fail to import because some of the characters
> > may take up to 3 bytes instead of 1.
> >
> >
> >
> > You said there would be a problem with the forms and I know what you are
> > saying. But

OT: WWRUG/ARSlist Awards 2012: Let the Voting Begin!

[Joe Martin D'Souza]

Congratulations Jose Huerta, LJ Longwing and Jason Miller on your nominations 
and Dan off course although you choose to decline the nomination :-)

Joe

From: arslist 
Sent: Monday, August 27, 2012 12:54 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG 
Subject: Re: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin!

** 
Following my usual tradition of recording, copying and pasting a spelling error:

It is Jose Huerta.

 

My apologies. Dan

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Bloom
Sent: August 27, 2012 9:14 AM
To: arslist@ARSLIST.ORG
Subject: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin!

 

** 

So,  a big round of applause to this years nominees for the ARSlist MVP:

 

Daniel Bloom – yes, I was nominated, I decline the nomination, but thank-you 
for the gesture

 

Jose Huerto

 

LJ Longwing 

 

Jason Miller

 

Voting starts now and ends Friday Sept. 7th at 5pm EST

 

There are over 4000 of you on the list, please lets see some support for those 
that spend their free

time helping others!

 

 

 

* Voting is by the Individual REAL person, 

so redistribution lists don't vote, your identity must be known,

and those that have multiple subscriptions still get only one vote

 

* BMCSoftware employees on the ARSlist are eligible to vote

 

* All decisions of myself or  the oversight panel are final 

(if I have to make a controversial decision, I confer with 3 past MVP winners 
for their opinion)

 

Thursday October  18th at WWRUG12: Award Ceremony during the WWRUG Awards 
keynote.

 

[no one knows the winner(s) until then, well okay, except me and the plaque 
company]

 

Please send nominations to d...@wwrug.com

 

 

Thanks … Daniel

Daniel Bloom

ARSlist Founder

RAC/RSP since 1995

WWRUG Co-Founder

Chairman of WWRUG12

 

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_

_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"

Re: Remedy form object and Oracle table relationships

[Susan Palmer]

Jason/Misi,

Thanks for your interest.  I already knew the answer but was hoping for
some 'miracle'.  We just  basically did the full build new dbs/servers last
year when we couldn't make our 7.01 to 7.5 upgrade work.  It should be
noted that when using oracle you don't actually choose unicode in Remedy,
it installs based on how oracle is installed.  Wish I had paid more
attention to that fact last year.

Regarding the import of tables/objects, that was not a pleasant
experience.  It changes all the table ID's which caused problems in other
applications using Remedy.  Of course now we have a list of those, guess
they can be modified again.  Hopefully they took my advice to use table
names not ID's.

We have a freeze beginning in November during our customer's busy season so
we've basically run out of time this year.  We'll tackle it next year and
since it's a total new install may consider ARS v8.0 right away, and oracle
11g.  I was looking at the compatibility chart regarding linux but that
seems a little confusing about using that and I haven't checked further.
We'd really like to move away from the oracle costs.

We're also moving to a new location in April so I'm think we'll be
postponed until June/July which may work well with v8.  Gives the early
adopters time to work out the kinks!

Thanks again for your input ...

Susan

See you at RUG!

On Mon, Aug 27, 2012 at 7:18 PM, Jason Miller wrote:

> ** Hi Susan,
>
> I agree that what Misi describes is the best way to go about it.
>  Admittedly I have never had to resolve this issue but it is consistent
> with the other Remedy data translation/transition scenarios.  A while back
> I was talking to a Remedy admin who's DBA told him the DB was Unicode when
> it wasn't. He installed ARS as Unicode and some time later issues began to
> arise.  BMC's recommendation was to build a new system with matching
> character sets and to export the data out of the broken system and import
> into the new system using the AR API (import tool, etc.).
>
> Jason
>
>
> On Sun, Aug 26, 2012 at 10:09 PM, Misi Mladoniczky  wrote:
>
>> Hi Susan,
>>
>> Why not remove all complex manual thinking, guessing and planning?
>>
>> 1. Do a fresh install
>> 2. Export your def and import it the new system
>> 3. Copy your data using RRR|Chive
>> 4. Stop your users from accessing the servers, stop escalations, email etc
>> 5. Do a final delta-transfer using RRR|Chive (~1 hour)
>> 6. Switch your users to the new server
>>
>> You might get data that does not fit into the new syst, if you have a lot
>> of 128+ ascii codes in your current data. But step 4 above can be run
>> multiple times, until you have corrected all errors.
>>
>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
>>
>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>> * 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.
>>
>> > Hi everyone,
>> >
>> > It seems my life is complicated this week.  Again I need to draw on your
>> > experiences and I'm looking for your opinions and cautionary statements.
>> >
>> > Background:  We use an outsourcer company to do the bulk of our database
>> > work.  When we built new servers last year and they build the new oracle
>> > 10g databases we didn't notice that they were not Unicode.  Apparently
>> the
>> > previous ones were, but in actuality we didn't really have a need for
>> it.
>> > About 5 years ago we opened a China office requiring all staff to be
>> > English proficient so everything was still ok.  But now we're finding
>> that
>> > customer information which arrives in simplified Chinese, which they
>> > translate into English, which then needs to be re-translated back to
>> > Chinese to meet government requirements for billing is not as straight
>> > forward as it may sound.  So they were trying to type more Chinese in
>> and
>> > of course since the new server databases were not Unicode it didn't work
>> > like it did before.  Then to  add to the pain, no one said anything.  So
>> > here we are a year later and now it's a big deal.
>> >
>> > So, we are endeavoring to change to Unicode.  Our approach is to create
>> a
>> > new server space, create a new Unicode database, and get the data in
>> there
>> > converted, and then install the application again.  No upgrades of db or
>> > application involved, only the Unicode aspect of it.
>> >
>> > Well, that sounds so much easier than it's turning out to be.  Our dba
>> has
>> > run CSSCAN various times and finally came up with a list of forms/fields
>> > that have potential problems with the conversion.  The current field
>> > length
>> > is being totally used so in the conversion to Unicode it needs more
>> field
>> > length.  The dba is suggesting that he just expand the database field
>> > lengths with no need to touch the f

Re: Remedy form object and Oracle table relationships

[Pat Zandi]

Fresh install is always best.  I have brought the system over from a copy and 
it is really amazing that BMC embeds and has so many individual configuration 
files (I would think progress would bring them to 1 main configuration file) 
rather than some 35 file system locations / if I include java locations and 
host names and ip's some 45 or so locations plus several locations in the 
schemas it is really nutty ! 

Sent from my iPhone

On Aug 27, 2012, at 20:18, Jason Miller  wrote:

> ** Hi Susan,
> 
> I agree that what Misi describes is the best way to go about it.  Admittedly 
> I have never had to resolve this issue but it is consistent with the other 
> Remedy data translation/transition scenarios.  A while back I was talking to 
> a Remedy admin who's DBA told him the DB was Unicode when it wasn't. He 
> installed ARS as Unicode and some time later issues began to arise.  BMC's 
> recommendation was to build a new system with matching character sets and to 
> export the data out of the broken system and import into the new system using 
> the AR API (import tool, etc.).
> 
> Jason
> 
> On Sun, Aug 26, 2012 at 10:09 PM, Misi Mladoniczky  wrote:
> Hi Susan,
> 
> Why not remove all complex manual thinking, guessing and planning?
> 
> 1. Do a fresh install
> 2. Export your def and import it the new system
> 3. Copy your data using RRR|Chive
> 4. Stop your users from accessing the servers, stop escalations, email etc
> 5. Do a final delta-transfer using RRR|Chive (~1 hour)
> 6. Switch your users to the new server
> 
> You might get data that does not fit into the new syst, if you have a lot
> of 128+ ascii codes in your current data. But step 4 above can be run
> multiple times, until you have corrected all errors.
> 
> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
> 
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
> * 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.
> 
> > Hi everyone,
> >
> > It seems my life is complicated this week.  Again I need to draw on your
> > experiences and I'm looking for your opinions and cautionary statements.
> >
> > Background:  We use an outsourcer company to do the bulk of our database
> > work.  When we built new servers last year and they build the new oracle
> > 10g databases we didn't notice that they were not Unicode.  Apparently the
> > previous ones were, but in actuality we didn't really have a need for it.
> > About 5 years ago we opened a China office requiring all staff to be
> > English proficient so everything was still ok.  But now we're finding that
> > customer information which arrives in simplified Chinese, which they
> > translate into English, which then needs to be re-translated back to
> > Chinese to meet government requirements for billing is not as straight
> > forward as it may sound.  So they were trying to type more Chinese in and
> > of course since the new server databases were not Unicode it didn't work
> > like it did before.  Then to  add to the pain, no one said anything.  So
> > here we are a year later and now it's a big deal.
> >
> > So, we are endeavoring to change to Unicode.  Our approach is to create a
> > new server space, create a new Unicode database, and get the data in there
> > converted, and then install the application again.  No upgrades of db or
> > application involved, only the Unicode aspect of it.
> >
> > Well, that sounds so much easier than it's turning out to be.  Our dba has
> > run CSSCAN various times and finally came up with a list of forms/fields
> > that have potential problems with the conversion.  The current field
> > length
> > is being totally used so in the conversion to Unicode it needs more field
> > length.  The dba is suggesting that he just expand the database field
> > lengths with no need to touch the form objects.  This sets off all sort of
> > red flags for me.  I never let anyone  go directly to the database for
> > data
> > updates.  Other applications we use can read data but if they need to
> > write
> > there they use the Remedy API.  There can be no manipulation of the tables
> > in the database, it must all be done via developer tool.
> >
> > What else is troubling is that in the list of tables/fields that have a
> > problem some tables/fields that should be listed because that's where the
> > data originated and was pushed down from are not listed.  Many of the
> > records in question are older and if some data gets 'cut off' or what I
> > used to think truncated meant we can live with that.  We're talking
> > several
> > thousand records in 15-25 tables.
> >
> > The dba is proposing the following:
> >
> > I will export the table metadata and data of the tables, listed in the
> > spreadsheet with NLS_LANG set to AMERICAN_AMERICA.WE8ISO8895P1.
> >
> > I will then truncate 

Re: WWRUG/ARSlist Awards 2012: Let the Voting Begin!

[Maddala, Venkat]

Congrats to all nominees Jose Huerta, LJ Longwing, and Jason Miller.

Regards,
Venkat Maddala
http://RemediesForRemedy.com


From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza
Sent: Monday, August 27, 2012 8:35 PM
To: arslist@ARSLIST.ORG
Subject: OT: WWRUG/ARSlist Awards 2012: Let the Voting Begin!

**

Congratulations Jose Huerta, LJ Longwing and Jason Miller on your nominations 
and Dan off course although you choose to decline the nomination :-)

Joe

From: arslist
Sent: Monday, August 27, 2012 12:54 PM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin!

**
Following my usual tradition of recording, copying and pasting a spelling error:
It is Jose Huerta.

My apologies. Dan

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Bloom
Sent: August 27, 2012 9:14 AM
To: arslist@ARSLIST.ORG
Subject: [SPAM]WWRUG/ARSlist Awards 2012: Let the Voting Begin!

**
So,  a big round of applause to this years nominees for the ARSlist MVP:

Daniel Bloom – yes, I was nominated, I decline the nomination, but thank-you 
for the gesture

Jose Huerto

LJ Longwing

Jason Miller

Voting starts now and ends Friday Sept. 7th at 5pm EST

There are over 4000 of you on the list, please lets see some support for those 
that spend their free
time helping others!



* Voting is by the Individual REAL person,
so redistribution lists don't vote, your identity must be known,
and those that have multiple subscriptions still get only one vote

* BMCSoftware employees on the ARSlist are eligible to vote

* All decisions of myself or  the oversight panel are final
(if I have to make a controversial decision, I confer with 3 past MVP winners 
for their opinion)

Thursday October  18th at WWRUG12: Award Ceremony during the WWRUG Awards 
keynote.

[no one knows the winner(s) until then, well okay, except me and the plaque 
company]

Please send nominations to d...@wwrug.com


Thanks … Daniel
Daniel Bloom
ARSlist Founder
RAC/RSP since 1995
WWRUG Co-Founder
Chairman of WWRUG12

_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers 
Are"_
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers 
Are"_
_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"

Re: Remedy form object and Oracle table relationships

[Jason Miller]

We will gladly adopt early for you :)

On Mon, Aug 27, 2012 at 6:01 PM, Susan Palmer  wrote:

> ** Jason/Misi,
>
> Thanks for your interest.  I already knew the answer but was hoping for
> some 'miracle'.  We just  basically did the full build new dbs/servers last
> year when we couldn't make our 7.01 to 7.5 upgrade work.  It should be
> noted that when using oracle you don't actually choose unicode in Remedy,
> it installs based on how oracle is installed.  Wish I had paid more
> attention to that fact last year.
>
> Regarding the import of tables/objects, that was not a pleasant
> experience.  It changes all the table ID's which caused problems in other
> applications using Remedy.  Of course now we have a list of those, guess
> they can be modified again.  Hopefully they took my advice to use table
> names not ID's.
>
> We have a freeze beginning in November during our customer's busy season
> so we've basically run out of time this year.  We'll tackle it next year
> and since it's a total new install may consider ARS v8.0 right away, and
> oracle 11g.  I was looking at the compatibility chart regarding linux but
> that seems a little confusing about using that and I haven't checked
> further.  We'd really like to move away from the oracle costs.
>
> We're also moving to a new location in April so I'm think we'll be
> postponed until June/July which may work well with v8.  Gives the early
> adopters time to work out the kinks!
>
> Thanks again for your input ...
>
> Susan
>
> See you at RUG!
>
> On Mon, Aug 27, 2012 at 7:18 PM, Jason Miller wrote:
>
>> ** Hi Susan,
>>
>> I agree that what Misi describes is the best way to go about it.
>>  Admittedly I have never had to resolve this issue but it is consistent
>> with the other Remedy data translation/transition scenarios.  A while back
>> I was talking to a Remedy admin who's DBA told him the DB was Unicode when
>> it wasn't. He installed ARS as Unicode and some time later issues began to
>> arise.  BMC's recommendation was to build a new system with matching
>> character sets and to export the data out of the broken system and import
>> into the new system using the AR API (import tool, etc.).
>>
>> Jason
>>
>>
>> On Sun, Aug 26, 2012 at 10:09 PM, Misi Mladoniczky  wrote:
>>
>>> Hi Susan,
>>>
>>> Why not remove all complex manual thinking, guessing and planning?
>>>
>>> 1. Do a fresh install
>>> 2. Export your def and import it the new system
>>> 3. Copy your data using RRR|Chive
>>> 4. Stop your users from accessing the servers, stop escalations, email
>>> etc
>>> 5. Do a final delta-transfer using RRR|Chive (~1 hour)
>>> 6. Switch your users to the new server
>>>
>>> You might get data that does not fit into the new syst, if you have a lot
>>> of 128+ ascii codes in your current data. But step 4 above can be run
>>> multiple times, until you have corrected all errors.
>>>
>>> Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP
>>> 2011)
>>>
>>> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11):
>>> * 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
>>> .
>>>
>>> > Hi everyone,
>>> >
>>> > It seems my life is complicated this week.  Again I need to draw on
>>> your
>>> > experiences and I'm looking for your opinions and cautionary
>>> statements.
>>> >
>>> > Background:  We use an outsourcer company to do the bulk of our
>>> database
>>> > work.  When we built new servers last year and they build the new
>>> oracle
>>> > 10g databases we didn't notice that they were not Unicode.  Apparently
>>> the
>>> > previous ones were, but in actuality we didn't really have a need for
>>> it.
>>> > About 5 years ago we opened a China office requiring all staff to be
>>> > English proficient so everything was still ok.  But now we're finding
>>> that
>>> > customer information which arrives in simplified Chinese, which they
>>> > translate into English, which then needs to be re-translated back to
>>> > Chinese to meet government requirements for billing is not as straight
>>> > forward as it may sound.  So they were trying to type more Chinese in
>>> and
>>> > of course since the new server databases were not Unicode it didn't
>>> work
>>> > like it did before.  Then to  add to the pain, no one said anything.
>>>  So
>>> > here we are a year later and now it's a big deal.
>>> >
>>> > So, we are endeavoring to change to Unicode.  Our approach is to
>>> create a
>>> > new server space, create a new Unicode database, and get the data in
>>> there
>>> > converted, and then install the application again.  No upgrades of db
>>> or
>>> > application involved, only the Unicode aspect of it.
>>> >
>>> > Well, that sounds so much easier than it's turning out to be.  Our dba
>>> has
>>> > run CSSCAN various times and finally came up with a list of
>>> forms/fields
>>> > that