Info on Inline Forms
Hi All, I need some info on the inline forms in remedy.Few examples were they have been used. How do i create them? ThanksPB ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field
Hi,
It seems like you have made this over complex there is no need to add things
together.
The original advanced search should be:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
This replace string would equal what you have:
REPLACE($Detailed Description$, [0-9], XX)
If you want the filter to match use the leading match in the advanced search
example, it would be enough to use it as it is.
Run If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
or
Set-Fields If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
What the REPLACE does is to change the literal string [0-9] to XX. It does
not make sense to me.
I presume you want to replace the leading string 012-34-5678 with something
else??? In that case you could use something like the following that first
strips the 11 characters and adds the new prefix XX:
XX + SUBSTR($Field$, 11)
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.
Hi Listers,
Just as the subject line describes it, I am trying to replicate a search
performed in the User Tool:
'Notes' LIKE [0-9][0-9][0-9] + - + [0-9][0-9] + - +
[0-9][0-9][0-9][0-9]%, which returns records with a matching number string
successfully.
However, I need to use the same search in a filter that is using the REPLACE()
function.
I believe the problem lies with the way MS SQL handles the [ and ]
characters.
My Replace FUNCTION is currently:
REPLACE($Detailed Decription$, ((([ + 0) + -) + 9) + \], XX)
I know it's probably something very simple that's not correct but I cannot
seem to get this to work.
Anyone know what the proper syntax would be to get this to work with number
strings?
Specs:
Windows Server 2008 R2
ARS 7.6.3sp3
ITSM 7.6.3
MS SQL 2008
Thanks,
Keith Sinclair
Sr. Application Developer
DeVry Education Group
814 Commerce Dr.
Oakbrook, IL 60523-8822
p: 630.645.1143
e: ksincl...@devry.commailto:ksincl...@devry.com
w: www.devryeducationgroup.comhttp://www.devryeducationgroup.com
___
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: ITSM on a Laptop Question
Hi James, This is possible indeed. I have done this many times in the past for my previous company (another BMC Partner) in order to do development and demo's on ITSM etc. The catch here is that you are guaranteed to have BAD performance of an ITSM VM if you only have 8GB RAM or less. If you use a laptop with 16GB RAM, i7 CPU and a fast set of disks, you are ok. I would also recommend for ITSM VM's to run a single VM due to the extra RAM you are wasting to run the second VM OS. I am currently using a two-VM set with CentOS 5.10, Oracle 11g, ARS 7.1.0 on my laptop for RD. (Yes, we're still on 7.1 here, but that is a different long story. We are also busy with an upgrade project at the moment) There's 12Gb RAM allocated to these two VM's in total (10 for DB and 2 for AR) and it performs well until I start 2 or 3 copies each of Admin tool and User Tool alongside Toad, Excel, Outlook and Notepad++ as the host machine goes over 15GB RAM and starts to swap heavily. (Unfortunately, my two internal HDD's are spinning @5400RPM. I'd recommend having =2 disks @7200RPM in RAID config for best performance/cost/reliability ratio. SSD's will be best for performance, but come at a crazy cost and seldom lasts for long if pounded with lots of writes, like what Remedy does to the DB) Maximum RAM availability and disk performance is the key here to have something that is not going to buckle under the slightest of duress. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: 08 April 2014 20:22 To: arslist@ARSLIST.ORG Subject: Re: ITSM on a Laptop Question James: This portable server would run using a demo license from BMC, and would primarily serve as a reference instance. My company is a BMC partner, so BMC would give us a demo license to support their end customer. BMC used to produce VM images for sales partners to use to demonstrate the product to potential customers, but I haven't seen one of them in a few years. HTH, --Phil From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of James Smith [bmcremedyarslis...@gmail.com] Sent: Tuesday, April 08, 2014 11:38 To: arslist@ARSLIST.ORG Subject: Re: ITSM on a Laptop Question Is there a way to create an VM Image for remedy and use it commercially for trainings or leaning on multiple systems? How can you install ITSM on laptop? Don't you need a license from BMC? ___ 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
The best method of balancing for BMC Remedy ITSM 7.6.04
Hello, friends! Which method of balancing - weithted round-robin or weighted least connection suites better for BMC Remedy ITSM 7.6.04? Our configuration includes 2 web-servers, 2 application-servers and database-server. Thank in advance, Andrey. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: ITSM on a Laptop Question
Theo: Good observation on your part to mention the SSD lifespan. I can personally attest to ITSM causing the DB to burn through the maximum number of write operations for an SSD in a few months of light usage. I'm on my second pair of SSDs in a RAID 0 config. Once my laptop is upgraded to 16GB RAM, then the config will probably change to a pair of 7200 RPM spinning disks in RAID 0, because I won't have so much swap I/O on the host or guests. --Phil From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of Theo Fondse (Gmail) [theo.fon...@gmail.com] Sent: Wednesday, April 09, 2014 04:23 To: arslist@ARSLIST.ORG Subject: Re: ITSM on a Laptop Question Hi James, This is possible indeed. I have done this many times in the past for my previous company (another BMC Partner) in order to do development and demo's on ITSM etc. The catch here is that you are guaranteed to have BAD performance of an ITSM VM if you only have 8GB RAM or less. If you use a laptop with 16GB RAM, i7 CPU and a fast set of disks, you are ok. I would also recommend for ITSM VM's to run a single VM due to the extra RAM you are wasting to run the second VM OS. I am currently using a two-VM set with CentOS 5.10, Oracle 11g, ARS 7.1.0 on my laptop for RD. (Yes, we're still on 7.1 here, but that is a different long story. We are also busy with an upgrade project at the moment) There's 12Gb RAM allocated to these two VM's in total (10 for DB and 2 for AR) and it performs well until I start 2 or 3 copies each of Admin tool and User Tool alongside Toad, Excel, Outlook and Notepad++ as the host machine goes over 15GB RAM and starts to swap heavily. (Unfortunately, my two internal HDD's are spinning @5400RPM. I'd recommend having =2 disks @7200RPM in RAID config for best performance/cost/reliability ratio. SSD's will be best for performance, but come at a crazy cost and seldom lasts for long if pounded with lots of writes, like what Remedy does to the DB) Maximum RAM availability and disk performance is the key here to have something that is not going to buckle under the slightest of duress. Best Regards, Theo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Murnane, Phil Sent: 08 April 2014 20:22 To: arslist@ARSLIST.ORG Subject: Re: ITSM on a Laptop Question James: This portable server would run using a demo license from BMC, and would primarily serve as a reference instance. My company is a BMC partner, so BMC would give us a demo license to support their end customer. BMC used to produce VM images for sales partners to use to demonstrate the product to potential customers, but I haven't seen one of them in a few years. HTH, --Phil From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of James Smith [bmcremedyarslis...@gmail.com] Sent: Tuesday, April 08, 2014 11:38 To: arslist@ARSLIST.ORG Subject: Re: ITSM on a Laptop Question Is there a way to create an VM Image for remedy and use it commercially for trainings or leaning on multiple systems? How can you install ITSM on laptop? Don't you need a license from BMC? ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: The best method of balancing for BMC Remedy ITSM 7.6.04
I've never considered Round Robin to be a 'good' balancing method, I've always gone with a least connection scenario. On Wed, Apr 9, 2014 at 5:22 AM, Andrey Blednykh blednyk...@mail.ru wrote: ** Hello, friends! Which method of balancing - weithted round-robin or weighted least connection suites better for BMC Remedy ITSM 7.6.04? Our configuration includes 2 web-servers, 2 application-servers and database-server. Thank in advance, Andrey. _ARSlist: 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: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field
Hi Misi,
What I am trying to do is to have the REPLACE function find a number in a
filter, any number, in the 'Notes' field and replace it with an X. We are
trying to create a process that searches for Government ID number strings
entered into the system and replace it with Xs to remove any personally
identifiable information.
The problem lies in trying to get the [ and ] characters to be seen as
breakout characters by MS SQL at the Application/DB level. The user tool
handles this without issue, but the workflow handles this differently.
Hope this helps clarify.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, April 09, 2014 3:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi,
It seems like you have made this over complex there is no need to add things
together.
The original advanced search should be:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
This replace string would equal what you have:
REPLACE($Detailed Description$, [0-9], XX)
If you want the filter to match use the leading match in the advanced search
example, it would be enough to use it as it is.
Run If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
or
Set-Fields If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
What the REPLACE does is to change the literal string [0-9] to XX. It does
not make sense to me.
I presume you want to replace the leading string 012-34-5678 with something
else??? In that case you could use something like the following that first
strips the 11 characters and adds the new prefix XX:
XX + SUBSTR($Field$, 11)
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.
Hi Listers,
Just as the subject line describes it, I am trying to replicate a
search performed in the User Tool:
'Notes' LIKE [0-9][0-9][0-9] + - + [0-9][0-9] + - +
[0-9][0-9][0-9][0-9]%, which returns records with a matching number
string successfully.
However, I need to use the same search in a filter that is using the
REPLACE() function.
I believe the problem lies with the way MS SQL handles the [ and ]
characters.
My Replace FUNCTION is currently:
REPLACE($Detailed Decription$, ((([ + 0) + -) + 9) + \],
XX)
I know it's probably something very simple that's not correct but I
cannot seem to get this to work.
Anyone know what the proper syntax would be to get this to work with
number strings?
Specs:
Windows Server 2008 R2
ARS 7.6.3sp3
ITSM 7.6.3
MS SQL 2008
Thanks,
Keith Sinclair
Sr. Application Developer
DeVry Education Group
814 Commerce Dr.
Oakbrook, IL 60523-8822
p: 630.645.1143
e: ksincl...@devry.commailto:ksincl...@devry.com
w: www.devryeducationgroup.comhttp://www.devryeducationgroup.com
__
_ 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
Re: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field
Ah ... The Replace function in ARS is not a regex type replacement. It is a
straight character replacement. (The Run-If can look for patterns like you are
doing not the REPLACE function)
What you can do is
Run-If:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set Fields
REPLACE($Detailed Description$, 0, X)
Set Fields
REPLACE($Detailed Description$, 1, X)
Set Fields
REPLACE($Detailed Description$, 2, X)
Set Fields
REPLACE($Detailed Description$, 3, X)
Set Fields
REPLACE($Detailed Description$, 4, X)
Set Fields
REPLACE($Detailed Description$, 5, X)
Set Fields
REPLACE($Detailed Description$, 6, X)
Set Fields
REPLACE($Detailed Description$, 7, X)
Set Fields
REPLACE($Detailed Description$, 8, X)
Set Fields
REPLACE($Detailed Description$, 9, X)
To replace it as a pattern you would have to do something different (like using
an SQL Set Fields action)
(I'm an Oracle person so here it would be in Oracle format)
SELECT REGEXP_REPLACE ('$Detailed Description$',
'[0-9]{3}-[0-9]{2}-[0-9]{4}', 'XXX-XX-') FROM DUAL
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: Wednesday, April 09, 2014 8:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi Misi,
What I am trying to do is to have the REPLACE function find a number in a
filter, any number, in the 'Notes' field and replace it with an X. We are
trying to create a process that searches for Government ID number strings
entered into the system and replace it with Xs to remove any personally
identifiable information.
The problem lies in trying to get the [ and ] characters to be seen as
breakout characters by MS SQL at the Application/DB level. The user tool
handles this without issue, but the workflow handles this differently.
Hope this helps clarify.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, April 09, 2014 3:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi,
It seems like you have made this over complex there is no need to add things
together.
The original advanced search should be:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
This replace string would equal what you have:
REPLACE($Detailed Description$, [0-9], XX)
If you want the filter to match use the leading match in the advanced search
example, it would be enough to use it as it is.
Run If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
or
Set-Fields If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
What the REPLACE does is to change the literal string [0-9] to XX. It does
not make sense to me.
I presume you want to replace the leading string 012-34-5678 with something
else??? In that case you could use something like the following that first
strips the 11 characters and adds the new prefix XX:
XX + SUBSTR($Field$, 11)
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.
Hi Listers,
Just as the subject line describes it, I am trying to replicate a
search performed in the User Tool:
'Notes' LIKE [0-9][0-9][0-9] + - + [0-9][0-9] + - +
[0-9][0-9][0-9][0-9]%, which returns records with a matching number
string successfully.
However, I need to use the same search in a filter that is using the
REPLACE() function.
I believe the problem lies with the way MS SQL handles the [ and ]
characters.
My Replace FUNCTION is currently:
REPLACE($Detailed Decription$, ((([ + 0) + -) + 9) + \],
XX)
I know it's probably something very simple that's not correct but I
cannot seem to get this to work.
Anyone know what the proper syntax would be to get this to work with
number strings?
Specs:
Windows Server 2008 R2
ARS 7.6.3sp3
ITSM 7.6.3
MS SQL 2008
Thanks,
Keith Sinclair
Sr. Application Developer
DeVry Education Group
814 Commerce Dr.
Oakbrook, IL 60523-8822
p: 630.645.1143
e: ksincl...@devry.commailto:ksincl...@devry.com
w: www.devryeducationgroup.comhttp://www.devryeducationgroup.com
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Re: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field
Yep, I re-read Misi's email and understood what he was getting at. It has been
awhile since I had to use the REPLACE function and spaced that it was limited
to literal strings.
Apart from doing multiple REPLACE and STRSTR functions, etc. and creating
complexity, is there any simple method for removing/redacting Government ID
numbers from Notes fields whilst leaving the rest of the data intact? I cannot
imagine I am the only person who's been asked to scrub PII from company data.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, April 09, 2014 9:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Ah ... The Replace function in ARS is not a regex type replacement. It is a
straight character replacement. (The Run-If can look for patterns like you are
doing not the REPLACE function)
What you can do is
Run-If:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set Fields
REPLACE($Detailed Description$, 0, X)
Set Fields
REPLACE($Detailed Description$, 1, X)
Set Fields
REPLACE($Detailed Description$, 2, X)
Set Fields
REPLACE($Detailed Description$, 3, X)
Set Fields
REPLACE($Detailed Description$, 4, X)
Set Fields
REPLACE($Detailed Description$, 5, X)
Set Fields
REPLACE($Detailed Description$, 6, X)
Set Fields
REPLACE($Detailed Description$, 7, X)
Set Fields
REPLACE($Detailed Description$, 8, X)
Set Fields
REPLACE($Detailed Description$, 9, X)
To replace it as a pattern you would have to do something different (like using
an SQL Set Fields action)
(I'm an Oracle person so here it would be in Oracle format)
SELECT REGEXP_REPLACE ('$Detailed Description$',
'[0-9]{3}-[0-9]{2}-[0-9]{4}', 'XXX-XX-') FROM DUAL
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: Wednesday, April 09, 2014 8:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi Misi,
What I am trying to do is to have the REPLACE function find a number in a
filter, any number, in the 'Notes' field and replace it with an X. We are
trying to create a process that searches for Government ID number strings
entered into the system and replace it with Xs to remove any personally
identifiable information.
The problem lies in trying to get the [ and ] characters to be seen as
breakout characters by MS SQL at the Application/DB level. The user tool
handles this without issue, but the workflow handles this differently.
Hope this helps clarify.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, April 09, 2014 3:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi,
It seems like you have made this over complex there is no need to add things
together.
The original advanced search should be:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
This replace string would equal what you have:
REPLACE($Detailed Description$, [0-9], XX)
If you want the filter to match use the leading match in the advanced search
example, it would be enough to use it as it is.
Run If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
or
Set-Fields If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
What the REPLACE does is to change the literal string [0-9] to XX. It does
not make sense to me.
I presume you want to replace the leading string 012-34-5678 with something
else??? In that case you could use something like the following that first
strips the 11 characters and adds the new prefix XX:
XX + SUBSTR($Field$, 11)
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.
Hi Listers,
Just as the subject line describes it, I am trying to replicate a
search performed in the User Tool:
'Notes' LIKE [0-9][0-9][0-9] + - + [0-9][0-9] + - +
[0-9][0-9][0-9][0-9]%, which returns records with a matching number
string successfully.
However, I need to use the same search in a filter that is using the
REPLACE() function.
I believe the problem lies with the way MS SQL handles the [ and ]
characters.
My Replace FUNCTION is currently:
REPLACE($Detailed Decription$, ((([ + 0) + -) + 9) + \],
XX)
I know it's probably something very simple that's not correct but I
cannot seem to
Problem with driver 7.6.04
Hi listers, I am running driver.exe 7.6.04 and I get the following error: The ordinal 240 could not be located in the dynamic link library arapi7604_build002.dll Indeed, the Dependency Walker shows i240 does not exist. Any idea? Is there a more recent version of this DLL? Thanks André ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
moving saved searches from User client to Mid Tier client.
Hello Listers, ARS 7.6.04 MS SQL Server 2005 We are in the process of moving people from the user tool to the mid tier client. A few of these users have saved searches stored in the AR System User Central File. They want to know how to get their searches through the mid tier client. Recreating them is time consuming. I am trying to figure out the best way to get the saved searches form the user central form to the AR System Searches Preference form. Has anyone used the Application-Parse-Qual 'form' qualificationString? I'm thinking of making a filter on create and then I can copy the form name and qualification string from the User Central File record and it will give me the proper internal format. 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 Where the Answers Are, and have been for 20 years
Re: Notify Alerts in ARS 8.1
Hello Laurent/Mikhail Did either have a solution for this error __ I think that the classic notification alerts should work in 8.1. In aralerts.log I see **Error (22) in binding send socket for address :0**. When I set *Alert-Outbound-Port: 50005* in ar.conf, then in aralert.log there is the same error **Error (22) in binding send socket for address :50005**. Deyon ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Notify Alerts in ARS 8.1
DEE wrote Hello Laurent/Mikhail Did either have a solution for this error __ I think that the classic notification alerts should work in 8.1. In aralerts.log I see **Error (22) in binding send socket for address :0**. When I set *Alert-Outbound-Port: 50005* in ar.conf, then in aralert.log there is the same error **Error (22) in binding send socket for address :50005**. Deyon This notification alerts issue is fixed in ARS 8.1.00 Patch002 and in ARS 8.1.01. -- View this message in context: http://ars-action-request-system.1.n7.nabble.com/Re-Notify-Alerts-in-ARS-8-1-tp116627p116628.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Asset Console query, related issues
Hello listers... Vital stats: SuSe Linux running ARS 7.6.04 p2, CMDB 7.6.04 p4, ITSM 7.6.04 p2. Oracle 11g RAC backend DB on Linux My question is also at the end, but I'll add a tl;dr version here: Does anyone else know of places where the app is querying all of BMC Computer System besides the Asset Console? We have 781,000+ CI's in the BMC Computer System class. By default when you open the Asset Console a table field refreshes to show all of the CI's in your class set in your preferences. If you do not have one it uses BMC Computer System. The query it issues is really ridiculous. Here's an example (user ID removed for privacy reasons): SELECT C7,COUNT(*) FROM T1347 WHERE ((T1347.C400079600 = 'BMC_COMPUTERSYSTEM') AND ((T1347.C112 LIKE '%;''USER_ID_GOES_HERE'';%') OR (T1347.C112 LIKE '%;0;%') OR (T1347.C112 LIKE '%;-1098;%') OR (T1347.C112 LIKE '%;-2;%') OR (T1347.C112 LIKE '%;-20032;%') OR (T1347.C112 LIKE '%;100266;%') OR (T1347.C112 LIKE '%;100264;%') OR (T1347.C112 LIKE '%;17;%') OR (T1347.C112 LIKE '%;20403;%') OR (T1347.C112 LIKE '%;20316;%') OR (T1347.C112 LIKE '%;20315;%') OR (T1347.C112 LIKE '%;20313;%') OR (T1347.C112 LIKE '%;20302;%') OR (T1347.C112 LIKE '%;20302;%') OR (T1347.C112 LIKE '%;20055;%') OR (T1347.C112 LIKE '%;20032;%') OR (T1347.C112 LIKE '%;20012;%') OR (T1347.C112 LIKE '%;20007;%') OR (T1347.C112 LIKE '%;20003;%') OR (T1347.C112 LIKE '%;2;%') OR (T1347.C112 LIKE '%;13010;%') OR (T1347.C112 LIKE '%;13007;%') OR (T1347.C112 LIKE '%;13006;%') OR (T1347.C112 LIKE '%;804;%') OR (T1347.C112 LIKE '%;803;%') OR (T1347.C112 LIKE '%;440;%'))) GROUP BY C7 ORDER BY C7 As a bonus, If you change your preferences anywhere in the suite of ITSM apps, it appears to change this back to BMC Computer System. The query above is exceptionally time-consuming at the database level out of the box (15 minutes in some cases). Our DBA's have done some tuning and gotten the query faster, and BMC support is having us add an index on BMC:Base_Element which appears to drop the query time substantially. We don't have this in production yet but we think we will As a stop-gap we changed everyone's preferences to use a different class in the app, but we are still seeing this query over and over again in the logs. It brought down two servers today so far. Does anyone else know of places where the app is querying all of BMC Computer System besides the Asset Console? Also, this is a known problem with BMC. See below: article KA314201 https://kb.bmc.com/infocenter/index?page=contentid=KA314201actp=searchviewlocale=en_USsearchid=1396926399792 William Rentfrow wrentf...@stratacominc.com Office: 715-204-3061 Cell: 715-398-5056 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: moving saved searches from User client to Mid Tier client.
If the qualificationString that you are looking to convert to human readable format is stored in the AR System qualification format (which looks something like a string of numbers separated by a few forward slash characters), then yes, you could use that function to build a human readable qualification from it, if that is what you want to do. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Wednesday, April 09, 2014 11:42 AM To: arslist@ARSLIST.ORG Subject: moving saved searches from User client to Mid Tier client. Hello Listers, ARS 7.6.04 MS SQL Server 2005 We are in the process of moving people from the user tool to the mid tier client. A few of these users have saved searches stored in the AR System User Central File. They want to know how to get their searches through the mid tier client. Recreating them is time consuming. I am trying to figure out the best way to get the saved searches form the user central form to the AR System Searches Preference form. Has anyone used the Application-Parse-Qual 'form' qualificationString? I'm thinking of making a filter on create and then I can copy the form name and qualification string from the User Central File record and it will give me the proper internal format. 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 _ARSlist: 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: EXTERNAL: Re: moving saved searches from User client to Mid Tier client.
Actually that command converts human readable to internal format /1/5001/1/etcetera OK if that is the only way to get these searches moved to the Mid Tier I'll throw together a form and a filter and then move the internal search string to the AR System Searches Preference form. 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 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Wednesday, April 09, 2014 4:12 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: moving saved searches from User client to Mid Tier client. ** If the qualificationString that you are looking to convert to human readable format is stored in the AR System qualification format (which looks something like a string of numbers separated by a few forward slash characters), then yes, you could use that function to build a human readable qualification from it, if that is what you want to do. Joe From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Wednesday, April 09, 2014 11:42 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: moving saved searches from User client to Mid Tier client. Hello Listers, ARS 7.6.04 MS SQL Server 2005 We are in the process of moving people from the user tool to the mid tier client. A few of these users have saved searches stored in the AR System User Central File. They want to know how to get their searches through the mid tier client. Recreating them is time consuming. I am trying to figure out the best way to get the saved searches form the user central form to the AR System Searches Preference form. Has anyone used the Application-Parse-Qual 'form' qualificationString? I'm thinking of making a filter on create and then I can copy the form name and qualification string from the User Central File record and it will give me the proper internal format. 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 _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: 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: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field
You could also use a single set field with a nested REPLACE instead of 10
separate set field actions.
Given your description of what you want to do, aren't you worried though
that it will replace even non Government ID kind of numerical strings that
might be important to your data? For eg, if there is information about some
IP address or contact information within the notes that contain numbers,
etc. will also get replaced thus you may loose potentially important
information too.
An automated approach that may be more acceptable and perhaps a lot more
cleaner, is if you have an available database of Government ID's which you
can compare the notes field against to find a match, and replace that ID if
a match it found with a * string or maybe **GovtID** to indicate the
masked characters represent a Government ID.
Or the old school expensive method of a manual cleanup instead of an
automated one, in case other numerical data within notes might be critical
to your business.
Personally I would opt for the comparison method and replace the found
strng, assuming you do have an available and COMPLETE list of Government
ID's you wish to protect.
Cheers
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, April 09, 2014 10:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Ah ... The Replace function in ARS is not a regex type replacement. It is
a straight character replacement. (The Run-If can look for patterns like
you are doing not the REPLACE function)
What you can do is
Run-If:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set Fields
REPLACE($Detailed Description$, 0, X)
Set Fields
REPLACE($Detailed Description$, 1, X)
Set Fields
REPLACE($Detailed Description$, 2, X)
Set Fields
REPLACE($Detailed Description$, 3, X)
Set Fields
REPLACE($Detailed Description$, 4, X)
Set Fields
REPLACE($Detailed Description$, 5, X)
Set Fields
REPLACE($Detailed Description$, 6, X)
Set Fields
REPLACE($Detailed Description$, 7, X)
Set Fields
REPLACE($Detailed Description$, 8, X)
Set Fields
REPLACE($Detailed Description$, 9, X)
To replace it as a pattern you would have to do something different (like
using an SQL Set Fields action)
(I'm an Oracle person so here it would be in Oracle format)
SELECT REGEXP_REPLACE ('$Detailed Description$',
'[0-9]{3}-[0-9]{2}-[0-9]{4}', 'XXX-XX-') FROM DUAL
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: Wednesday, April 09, 2014 8:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi Misi,
What I am trying to do is to have the REPLACE function find a number in a
filter, any number, in the 'Notes' field and replace it with an X. We are
trying to create a process that searches for Government ID number strings
entered into the system and replace it with Xs to remove any personally
identifiable information.
The problem lies in trying to get the [ and ] characters to be seen as
breakout characters by MS SQL at the Application/DB level. The user tool
handles this without issue, but the workflow handles this differently.
Hope this helps clarify.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, April 09, 2014 3:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi,
It seems like you have made this over complex there is no need to add things
together.
The original advanced search should be:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
This replace string would equal what you have:
REPLACE($Detailed Description$, [0-9], XX)
If you want the filter to match use the leading match in the advanced search
example, it would be enough to use it as it is.
Run If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
or
Set-Fields If: ('Notes' LIKE
[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
What the REPLACE does is to change the literal string [0-9] to XX. It
does not make sense to me.
I presume you want to replace the leading string 012-34-5678 with
something else??? In that case you could use something like the following
that first strips the 11 characters and adds the new prefix XX:
XX + SUBSTR($Field$, 11)
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
Re: EXTERNAL: Re: moving saved searches from User client to Mid Tier client.
There is an available way to reverse that function then - I do not recall what it is off hand. Look up the available list of functions when you list them on the Dev Studio. It should be in that list. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Wednesday, April 09, 2014 4:22 PM To: arslist@ARSLIST.ORG Subject: Re: EXTERNAL: Re: moving saved searches from User client to Mid Tier client. Actually that command converts human readable to internal format /1/5001/1/etcetera OK if that is the only way to get these searches moved to the Mid Tier I'll throw together a form and a filter and then move the internal search string to the AR System Searches Preference form. 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 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Wednesday, April 09, 2014 4:12 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: Re: moving saved searches from User client to Mid Tier client. ** If the qualificationString that you are looking to convert to human readable format is stored in the AR System qualification format (which looks something like a string of numbers separated by a few forward slash characters), then yes, you could use that function to build a human readable qualification from it, if that is what you want to do. Joe _ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J Sent: Wednesday, April 09, 2014 11:42 AM To: arslist@ARSLIST.ORG Subject: moving saved searches from User client to Mid Tier client. Hello Listers, ARS 7.6.04 MS SQL Server 2005 We are in the process of moving people from the user tool to the mid tier client. A few of these users have saved searches stored in the AR System User Central File. They want to know how to get their searches through the mid tier client. Recreating them is time consuming. I am trying to figure out the best way to get the saved searches form the user central form to the AR System Searches Preference form. Has anyone used the Application-Parse-Qual 'form' qualificationString? I'm thinking of making a filter on create and then I can copy the form name and qualification string from the User Central File record and it will give me the proper internal format. 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 _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: 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: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field
An Oracle set fields action was given to you by Fred. There will be (should
be) an equivalent MS SQL set fields action. What complexity? The fact that
you are adding a piece of workflow? That is the only way to do it as the data
is being updated. There are after-the-fact alternatives (including a 3 line
Meta-Update script) but a simple set fields by sql will be correct (the
replace will replace any such numbers - not ones matching the regex).
Cheers
Ben Chernys
www.softwaretoolhouse.com
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: April-09-14 16:56
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Yep, I re-read Misi's email and understood what he was getting at. It has been
awhile since I had to use the REPLACE function and spaced that it was limited
to literal strings.
Apart from doing multiple REPLACE and STRSTR functions, etc. and creating
complexity, is there any simple method for removing/redacting Government ID
numbers from Notes fields whilst leaving the rest of the data intact? I cannot
imagine I am the only person who's been asked to scrub PII from company data.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, April 09, 2014 9:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Ah ... The Replace function in ARS is not a regex type replacement. It is a
straight character replacement. (The Run-If can look for patterns like you
are doing not the REPLACE function)
What you can do is
Run-If:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set Fields
REPLACE($Detailed Description$, 0, X)
Set Fields
REPLACE($Detailed Description$, 1, X)
Set Fields
REPLACE($Detailed Description$, 2, X)
Set Fields
REPLACE($Detailed Description$, 3, X)
Set Fields
REPLACE($Detailed Description$, 4, X)
Set Fields
REPLACE($Detailed Description$, 5, X)
Set Fields
REPLACE($Detailed Description$, 6, X)
Set Fields
REPLACE($Detailed Description$, 7, X)
Set Fields
REPLACE($Detailed Description$, 8, X)
Set Fields
REPLACE($Detailed Description$, 9, X)
To replace it as a pattern you would have to do something different (like
using an SQL Set Fields action)
(I'm an Oracle person so here it would be in Oracle format)
SELECT REGEXP_REPLACE ('$Detailed Description$',
'[0-9]{3}-[0-9]{2}-[0-9]{4}', 'XXX-XX-') FROM DUAL
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: Wednesday, April 09, 2014 8:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi Misi,
What I am trying to do is to have the REPLACE function find a number in a
filter, any number, in the 'Notes' field and replace it with an X. We are
trying to create a process that searches for Government ID number strings
entered into the system and replace it with Xs to remove any personally
identifiable information.
The problem lies in trying to get the [ and ] characters to be seen as
breakout characters by MS SQL at the Application/DB level. The user tool
handles this without issue, but the workflow handles this differently.
Hope this helps clarify.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, April 09, 2014 3:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi,
It seems like you have made this over complex there is no need to add things
together.
The original advanced search should be:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
This replace string would equal what you have:
REPLACE($Detailed Description$, [0-9], XX)
If you want the filter to match use the leading match in the advanced search
example, it would be enough to use it as it is.
Run If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
or
Set-Fields If: ('Notes' LIKE
[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
What the REPLACE does is to change the literal string [0-9] to XX. It does
not make sense to me.
I presume you want to replace the leading string 012-34-5678 with something
else??? In that case you could use something like the following that first
strips the 11 characters and adds the new prefix XX:
XX + SUBSTR($Field$, 11)
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,
Re: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field
Hi,
If the format always match nnn-nn-, you can do some filter looping to mask
it out without affecting performance too much.
Start Filter:
Run If: 'Notes' LIKE %[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set-Fields:
tmp = $Notes$
Call Guide: Remove Ids
Guide Remove Ids
label: loop
Filter Remove Id
Run If: 'tmp' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set-Fields: Notes = REPLACE($Notes$, LEFT($tmp$, 11), xxx-xx-)
Set-Fields: tmp = SUBSTR($tmp$, 11)
Filter Next Number 0
Run If: 'tmp' LIKE %0[0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set-Fields: tmp = SUBSTR($tmp$, STRSTR($tmp$, 0))
Goto Guide Label: loop
Filter Next Number 1
Run If: 'tmp' LIKE %1[0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set-Fields: tmp = SUBSTR($tmp$, STRSTR($tmp$, 1))
Goto Guide Label: loop
...
Filter Next Number 9
Run If: 'tmp' LIKE %9[0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set-Fields: tmp = SUBSTR($tmp$, STRSTR($tmp$, 9))
Goto Guide Label: loop
I confess that the 10 loop filter got a little more complex than I would have
liked, but it seemed bad practice to step one character at a time forward.
There is just no function to find the position of the first number...
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.
You could also use a single set field with a nested REPLACE instead of 10
separate set field actions.
Given your description of what you want to do, aren't you worried though
that it will replace even non Government ID kind of numerical strings that
might be important to your data? For eg, if there is information about some
IP address or contact information within the notes that contain numbers,
etc. will also get replaced thus you may loose potentially important
information too.
An automated approach that may be more acceptable and perhaps a lot more
cleaner, is if you have an available database of Government ID's which you
can compare the notes field against to find a match, and replace that ID if
a match it found with a * string or maybe **GovtID** to indicate the
masked characters represent a Government ID.
Or the old school expensive method of a manual cleanup instead of an
automated one, in case other numerical data within notes might be critical
to your business.
Personally I would opt for the comparison method and replace the found
strng, assuming you do have an available and COMPLETE list of Government
ID's you wish to protect.
Cheers
Joe
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, April 09, 2014 10:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Ah ... The Replace function in ARS is not a regex type replacement. It is
a straight character replacement. (The Run-If can look for patterns like
you are doing not the REPLACE function)
What you can do is
Run-If:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set Fields
REPLACE($Detailed Description$, 0, X)
Set Fields
REPLACE($Detailed Description$, 1, X)
Set Fields
REPLACE($Detailed Description$, 2, X)
Set Fields
REPLACE($Detailed Description$, 3, X)
Set Fields
REPLACE($Detailed Description$, 4, X)
Set Fields
REPLACE($Detailed Description$, 5, X)
Set Fields
REPLACE($Detailed Description$, 6, X)
Set Fields
REPLACE($Detailed Description$, 7, X)
Set Fields
REPLACE($Detailed Description$, 8, X)
Set Fields
REPLACE($Detailed Description$, 9, X)
To replace it as a pattern you would have to do something different (like
using an SQL Set Fields action)
(I'm an Oracle person so here it would be in Oracle format)
SELECT REGEXP_REPLACE ('$Detailed Description$',
'[0-9]{3}-[0-9]{2}-[0-9]{4}', 'XXX-XX-') FROM DUAL
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: Wednesday, April 09, 2014 8:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi Misi,
What I am trying to do is to have the REPLACE function find a number in a
filter, any number, in the 'Notes' field and replace it with an X. We are
trying to create a process that searches for Government ID number strings
entered into the system and replace it with Xs to remove any personally
identifiable information.
The problem lies in trying to get the [ and ] characters to be seen as
breakout characters by MS SQL at the
How to investigate if Remedy Page is delayed.
Hi Experts, Please help to investigate if its really from remedy end, We have Pager service configured for Incident management. there are few service targets configured for say P1 tickets and under the milestone tab we have Action- Pager or Run Process Action. We have one pager command in this action. /opt/telalert/bin/telalertc -l $Assigned Group$, $Company$P1, GLIP1 -m P1 $Company$ reported at $Reported Date$: $Incident Number$; $Description$ $Assigned Group$ -host XXX*.*xxx*.* How to investigate when user report issue like Remedy Page is delayed by say 15 min. Thanks, Harry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How to investigate if Remedy Page is delayed.
Does your paging system have any logs or history? We use HipLink and anytime we receive a report of a missed or delayed page we check in the HipLink UI. If we find a record of the page then Remedy sent it. As long as there wasn't a delay from when the pageable even happened in Remedy and the HipLink history then all is well. Since we use SNPP with our paging vendor we know if the history shows successful then know their system accept it and the delay/failure was on the provider's side (or the page was just lost in thin air, which comes with the territory of using pagers). Jason On Wed, Apr 9, 2014 at 1:57 PM, Harry amrutharida...@gmail.com wrote: ** Hi Experts, Please help to investigate if its really from remedy end, We have Pager service configured for Incident management. there are few service targets configured for say P1 tickets and under the milestone tab we have Action- Pager or Run Process Action. We have one pager command in this action. /opt/telalert/bin/telalertc -l $Assigned Group$, $Company$P1, GLIP1 -m P1 $Company$ reported at $Reported Date$: $Incident Number$; $Description$ $Assigned Group$ -host XXX*.*xxx*.* How to investigate when user report issue like Remedy Page is delayed by say 15 min. Thanks, Harry _ARSlist: 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: How to investigate if Remedy Page is delayed.
In your TelAlert install folder you will see a telalert.trail file. This will give you a bit more information about the message that the system sent out. 2014/02/02 07:51:16Event [70]Send Change (53905/53905), Status: [81]Message sent 2014/02/02 07:51:16Event [21]Alert Completed (53905), Status: [81]Message sent, LHSWCTP If you start your TelAlert with “telalert -debugprotocol 1” you will get more information: 2014/04/09 13:59:26Event [20]Alert Started (4967), Status: [20]Alert Started, VerizonPhone 2014/04/09 13:59:26Event [80]Send Started (4967/4967), Status: [80]Message issued, VerizonPhone(lhsmailcon:smtp, PIN=1234567890): INC0011, Medium, Allyson Anderson, 1 123 456-7890, Non-Urgent: Help with my computer - no internet access assigned to group XXX 2014/04/09 13:59:27Event [70]Send Change (4967/4967), Status: [81]Message sent 2014/04/09 13:59:27Event [21]Alert Completed (4967), Status: [81]Message sent, VerizonPhone Christie Pargeter | Sr Technical Analyst | tel 503-415-5149 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Harry Sent: Wednesday, April 09, 2014 1:57 PM To: arslist@ARSLIST.ORG Subject: How to investigate if Remedy Page is delayed. ** Hi Experts, Please help to investigate if its really from remedy end, We have Pager service configured for Incident management. there are few service targets configured for say P1 tickets and under the milestone tab we have Action- Pager or Run Process Action. We have one pager command in this action. /opt/telalert/bin/telalertc -l $Assigned Group$, $Company$P1, GLIP1 -m P1 $Company$ reported at $Reported Date$: $Incident Number$; $Description$ $Assigned Group$ -host XXX.xxx. How to investigate when user report issue like Remedy Page is delayed by say 15 min. Thanks, Harry _ARSlist: 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: EXTERNAL: Re: moving saved searches from User client to Mid Tier client.
John, You could sell a tool that does that conversion into mid-tier searches easily. We'd be interested in hearing your progress and success in this method. Thanks, Susan On Wed, Apr 9, 2014 at 3:22 PM, Reiser, John J john.j.rei...@lmco.comwrote: ** Actually that command converts human readable to internal format /1/5001/1/etcetera OK if that is the only way to get these searches moved to the Mid Tier I'll throw together a form and a filter and then move the internal search string to the AR System Searches Preference form. 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 *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Joe D'Souza *Sent:* Wednesday, April 09, 2014 4:12 PM *To:* arslist@ARSLIST.ORG *Subject:* EXTERNAL: Re: moving saved searches from User client to Mid Tier client. ** If the qualificationString that you are looking to convert to human readable format is stored in the AR System qualification format (which looks something like a string of numbers separated by a few forward slash characters), then yes, you could use that function to build a human readable qualification from it, if that is what you want to do. Joe -- *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Reiser, John J *Sent:* Wednesday, April 09, 2014 11:42 AM *To:* arslist@ARSLIST.ORG *Subject:* moving saved searches from User client to Mid Tier client. Hello Listers, ARS 7.6.04 MS SQL Server 2005 We are in the process of moving people from the user tool to the mid tier client. A few of these users have saved searches stored in the AR System User Central File. They want to know how to get their searches through the mid tier client. Recreating them is time consuming. I am trying to figure out the best way to get the saved searches form the user central form to the AR System Searches Preference form. Has anyone used the Application-Parse-Qual '*form' qualificationString*? I'm thinking of making a filter on create and then I can copy the form name and qualification string from the User Central File record and it will give me the proper internal format. 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 _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: 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: Notify Alerts in ARS 8.1
thank Applied, 8.1.00 patch 2 -- issue resolved immediately. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field
Joe, Misi, I am using the specific pattern of the ID, NNN-NN- as the key on the searches, as well as the key to the error handling so that I won't affect an IP or a phone number, etc. Essentially, the process I have implemented is this, in a nut shell: 3 fields on HPD:Help Desk - 1 integer (A), 2 character fields (B C). Filter one fires off and does the following: A STRSTRC($Detailed Decription$, -) - look for the first hyphen in the string, set character number B SUBSTRC($Detailed Decription$, $A$ + 3) look for a second hyphen two characters after finding first hyphen C SUBSTRC($Detailed Decription$, $A$ - 3, $A$ + 7) Puts down string found B LEFTC($B$, 1) trims it down to 1 character used in error checking Filter two fires off only if second hyphen entered in B is in the field as a literal character. Then performs: 'Detailed Decription (sic)' REPLACE($Detailed Decription$, $C$, XXX-XX-) Still in work in progress but I want to see if I can fully flesh this out before giving up and handing it over to the DBA to have them do it as it could not only scrub past data but as people save tickets in the present. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, April 09, 2014 3:48 PM To: arslist@ARSLIST.ORG Subject: Re: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field Hi, If the format always match nnn-nn-, you can do some filter looping to mask it out without affecting performance too much. Start Filter: Run If: 'Notes' LIKE %[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]% Set-Fields: tmp = $Notes$ Call Guide: Remove Ids Guide Remove Ids label: loop Filter Remove Id Run If: 'tmp' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]% Set-Fields: Notes = REPLACE($Notes$, LEFT($tmp$, 11), xxx-xx-) Set-Fields: tmp = SUBSTR($tmp$, 11) Filter Next Number 0 Run If: 'tmp' LIKE %0[0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]% Set-Fields: tmp = SUBSTR($tmp$, STRSTR($tmp$, 0)) Goto Guide Label: loop Filter Next Number 1 Run If: 'tmp' LIKE %1[0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]% Set-Fields: tmp = SUBSTR($tmp$, STRSTR($tmp$, 1)) Goto Guide Label: loop ... Filter Next Number 9 Run If: 'tmp' LIKE %9[0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]% Set-Fields: tmp = SUBSTR($tmp$, STRSTR($tmp$, 9)) Goto Guide Label: loop I confess that the 10 loop filter got a little more complex than I would have liked, but it seemed bad practice to step one character at a time forward. There is just no function to find the position of the first number... 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. You could also use a single set field with a nested REPLACE instead of 10 separate set field actions. Given your description of what you want to do, aren't you worried though that it will replace even non Government ID kind of numerical strings that might be important to your data? For eg, if there is information about some IP address or contact information within the notes that contain numbers, etc. will also get replaced thus you may loose potentially important information too. An automated approach that may be more acceptable and perhaps a lot more cleaner, is if you have an available database of Government ID's which you can compare the notes field against to find a match, and replace that ID if a match it found with a * string or maybe **GovtID** to indicate the masked characters represent a Government ID. Or the old school expensive method of a manual cleanup instead of an automated one, in case other numerical data within notes might be critical to your business. Personally I would opt for the comparison method and replace the found strng, assuming you do have an available and COMPLETE list of Government ID's you wish to protect. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 09, 2014 10:48 AM To: arslist@ARSLIST.ORG Subject: Re: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field Ah ... The Replace function in ARS is not a regex type replacement. It is a straight character replacement. (The Run-If can look for patterns like you are doing not the REPLACE function) What you can do is Run-If: 'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]% Set Fields REPLACE($Detailed Description$, 0, X) Set Fields REPLACE($Detailed
Re: Syntax needed for a filter to find a number string in HPD:Help Desk Notes field
Hey Ben,
I am going to turn it over to the DBAs as a last resort. I'll let you know the
outcome if that is what ends up happening.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ben Chernys
Sent: Wednesday, April 09, 2014 3:48 PM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
An Oracle set fields action was given to you by Fred. There will be (should
be) an equivalent MS SQL set fields action. What complexity? The fact that
you are adding a piece of workflow? That is the only way to do it as the data
is being updated. There are after-the-fact alternatives (including a 3 line
Meta-Update script) but a simple set fields by sql will be correct (the
replace will replace any such numbers - not ones matching the regex).
Cheers
Ben Chernys
www.softwaretoolhouse.com
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: April-09-14 16:56
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Yep, I re-read Misi's email and understood what he was getting at. It has been
awhile since I had to use the REPLACE function and spaced that it was limited
to literal strings.
Apart from doing multiple REPLACE and STRSTR functions, etc. and creating
complexity, is there any simple method for removing/redacting Government ID
numbers from Notes fields whilst leaving the rest of the data intact? I cannot
imagine I am the only person who's been asked to scrub PII from company data.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, April 09, 2014 9:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Ah ... The Replace function in ARS is not a regex type replacement. It is a
straight character replacement. (The Run-If can look for patterns like you
are doing not the REPLACE function)
What you can do is
Run-If:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
Set Fields
REPLACE($Detailed Description$, 0, X)
Set Fields
REPLACE($Detailed Description$, 1, X)
Set Fields
REPLACE($Detailed Description$, 2, X)
Set Fields
REPLACE($Detailed Description$, 3, X)
Set Fields
REPLACE($Detailed Description$, 4, X)
Set Fields
REPLACE($Detailed Description$, 5, X)
Set Fields
REPLACE($Detailed Description$, 6, X)
Set Fields
REPLACE($Detailed Description$, 7, X)
Set Fields
REPLACE($Detailed Description$, 8, X)
Set Fields
REPLACE($Detailed Description$, 9, X)
To replace it as a pattern you would have to do something different (like
using an SQL Set Fields action)
(I'm an Oracle person so here it would be in Oracle format)
SELECT REGEXP_REPLACE ('$Detailed Description$',
'[0-9]{3}-[0-9]{2}-[0-9]{4}', 'XXX-XX-') FROM DUAL
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sinclair, Keith
Sent: Wednesday, April 09, 2014 8:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi Misi,
What I am trying to do is to have the REPLACE function find a number in a
filter, any number, in the 'Notes' field and replace it with an X. We are
trying to create a process that searches for Government ID number strings
entered into the system and replace it with Xs to remove any personally
identifiable information.
The problem lies in trying to get the [ and ] characters to be seen as
breakout characters by MS SQL at the Application/DB level. The user tool
handles this without issue, but the workflow handles this differently.
Hope this helps clarify.
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky
Sent: Wednesday, April 09, 2014 3:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Syntax needed for a filter to find a number string in HPD:Help
Desk Notes field
Hi,
It seems like you have made this over complex there is no need to add things
together.
The original advanced search should be:
'Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%
This replace string would equal what you have:
REPLACE($Detailed Description$, [0-9], XX)
If you want the filter to match use the leading match in the advanced search
example, it would be enough to use it as it is.
Run If: ('Notes' LIKE [0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
or
Set-Fields If: ('Notes' LIKE
[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]%)
What the REPLACE does is to change the literal string [0-9] to XX. It does
not make sense to me.
I presume you want to replace the leading string 012-34-5678 with something
else??? In that case you could use
Atrium 7.6.04 SP5 Upgrade Issues
Since we upgraded our 7.6.04 SP4 environment to SP5 for ARS and Atrium to fix a memory leak within our CMDB we've noticed that for our ADDM dataset populated with a sync from ADDM the number of CI's normalised and reconciled has gone through the roof against what is actually coming through from ADDM. Previously we had around 11000 CI's normalised each night against the ADDM dataset and some 40ooo CI's reconciled as well. Normalization normally took just under an hour and recon around 2 hrs. Now were seeing nearlt 4 CI's normalised each night and around 16 CI's reconciled as well, with normalization taking some 7 hrs and recon upto 4 hrs and both jobs now cross one another. Has anyone else who has upgraded to 7.6.04 SP5 Atrium had any similar issues or can anyone suggest anything untoward that may be happening. We've had the ADDM sync turned off now for two days and we're still seeing huge numbers normlised and reconciled each night, yet no updates are coming in from ADDM. yours puzzled ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Analytics - scheduled report does not show file extenstion like. MyReport.xls
Hi Team, Where scheduling a report within analytics on a regular bases and sending file to a fileshare, the extension of file type isn't showing on file within the file share. If we save a report directly to the file share (not scheduled) the extension is visible. appreciate your help... -Harry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Port and Queue Server Admin Display issue in MT
Hello. ARS Version: 8.1.00 201301251157 OS VERSION: 7100-02-03-1334 DB Version :: 11.2.0.3.0 - 64bit Production ARServer and DB are local. MT VERSION: Version 8.1.00 201401101150 Hotfix WEBSPHERE VERSION: IBM WebSphere Application Server/8.5 OS VERSION OF MT : AIX 6.1 JAVA VERSION: 1.6 Upgraded form 7.5. Pacth 4 to 8.1.00 Patch 2 Custom environment Issue: On the MT: Server Admin: Port and Queue, the list of threads are not displayed. The table should be displaying, this information. It does have the 7 lines, but on displays - 1st line Alert. In the client, the information is displayed correctly. Private-RPC-Socket: 390601 1 1 Debug Private-RPC-Socket: 390603 1 1 Private-RPC-Socket: 390620 2 2 Private-RPC-Socket: 390635 2 2 Private-RPC-Socket: 390680 1 1 Private-RPC-Socket: 390681 1 1 Private-RPC-Socket: 390682 1 1 I have a request with BMC; however, i hope I have much better luck here. this is what I have found, MT user logging, shows that workflow in the Active Link guide: AR System Administration: AL Guide To Parse Server Ports - is not functioning correctly, this after comparing to the production 7.5.X environmnet. MT USER SIDE LOGGING Version 8.1.00 201401101150 Hotfix -- Guide Called AR System Administration: AL Guide To Parse Server Ports On Server arstest - ActiveLink Start:- AR System Administration: Server Ports - Parse1 | AR System Administration: Server Information/Web True actions: action 0 SetFields: temp server port setting(16216) = 390601:1 1 Debug;390603:1 1;390620:2 2;390635:2 2;390680:1 1;390681:1 1;390682:1 1; action 1 SetFields: temp server port setting(16216) = 390601:1 1 Debug psrpcsockettemp(16147) = 390601:1 1 Debug Compared to MT USER SIDE LOGGING Version 7.5.00 Patch 004 201002051027 ARACTCallGuide(@, AR System Administration: AL Guide To Parse Server Ports, false, undefined, undefined) ActiveLink: AR System Administration: Server Ports - Parse1 True actions: action 0 Set-fields 16216 = 390601:1 1;390603:1 2;390620:6 12;390635:6 12;390680:1 2;390681:1 2;390682:1 2; action 1 Set-fields 16147 = 390603:1 2;390620:6 12;390635:6 12;390680:1 2;390681:1 2;390682:1 2; Set-fields 16216 = 390601:1 1 Issue 2: Looking at the workflow from both versions, they match. however, the 8.1 active link AR System Administration: Server Ports - Parse1 is not calculating the second setfield correctly, there all subsequent workflow fails. any idea who to resolve this? temp server port setting = LEFT($temp server port setting$, STRSTR($temp server port setting$, ;)) psrpcsockettemp = RIGHT($temp server port setting$, (LENGTH($temp server port setting$) - STRSTR($temp server port setting$, ;)) - 1) FAILED psrpcsockettemp(16147) = 390601:1 1 Debug CORRECTION BASED ON BELOW psrpcsockettemp(16147) = 390603:1 1;390620:2 2;390635:2 2;390680:1 1;390681:1 1;390682:1 1; ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Port and Queue Server Admin Display issue in MT
Well one thing you could try is upgrading to the latest, you are on 8.1 patch 2, but you could upgrade to 8.1 SP1 patch 1, see if that fixes it :) On Apr 9, 2014 7:56 PM, Deyon ddus...@aim.com wrote: Hello. ARS Version: 8.1.00 201301251157 OS VERSION: 7100-02-03-1334 DB Version :: 11.2.0.3.0 - 64bit Production ARServer and DB are local. MT VERSION: Version 8.1.00 201401101150 Hotfix WEBSPHERE VERSION: IBM WebSphere Application Server/8.5 OS VERSION OF MT : AIX 6.1 JAVA VERSION: 1.6 Upgraded form 7.5. Pacth 4 to 8.1.00 Patch 2 Custom environment Issue: On the MT: Server Admin: Port and Queue, the list of threads are not displayed. The table should be displaying, this information. It does have the 7 lines, but on displays - 1st line Alert. In the client, the information is displayed correctly. Private-RPC-Socket: 390601 1 1 Debug Private-RPC-Socket: 390603 1 1 Private-RPC-Socket: 390620 2 2 Private-RPC-Socket: 390635 2 2 Private-RPC-Socket: 390680 1 1 Private-RPC-Socket: 390681 1 1 Private-RPC-Socket: 390682 1 1 I have a request with BMC; however, i hope I have much better luck here. this is what I have found, MT user logging, shows that workflow in the Active Link guide: AR System Administration: AL Guide To Parse Server Ports - is not functioning correctly, this after comparing to the production 7.5.X environmnet. MT USER SIDE LOGGING Version 8.1.00 201401101150 Hotfix -- Guide Called AR System Administration: AL Guide To Parse Server Ports On Server arstest - ActiveLink Start:- AR System Administration: Server Ports - Parse1 | AR System Administration: Server Information/Web True actions: action 0 SetFields: temp server port setting(16216) = 390601:1 1 Debug;390603:1 1;390620:2 2;390635:2 2;390680:1 1;390681:1 1;390682:1 1; action 1 SetFields: temp server port setting(16216) = 390601:1 1 Debug psrpcsockettemp(16147) = 390601:1 1 Debug Compared to MT USER SIDE LOGGING Version 7.5.00 Patch 004 201002051027 ARACTCallGuide(@, AR System Administration: AL Guide To Parse Server Ports, false, undefined, undefined) ActiveLink: AR System Administration: Server Ports - Parse1 True actions: action 0 Set-fields 16216 = 390601:1 1;390603:1 2;390620:6 12;390635:6 12;390680:1 2;390681:1 2;390682:1 2; action 1 Set-fields 16147 = 390603:1 2;390620:6 12;390635:6 12;390680:1 2;390681:1 2;390682:1 2; Set-fields 16216 = 390601:1 1 Issue 2: Looking at the workflow from both versions, they match. however, the 8.1 active link AR System Administration: Server Ports - Parse1 is not calculating the second setfield correctly, there all subsequent workflow fails. any idea who to resolve this? temp server port setting = LEFT($temp server port setting$, STRSTR($temp server port setting$, ;)) psrpcsockettemp = RIGHT($temp server port setting$, (LENGTH($temp server port setting$) - STRSTR($temp server port setting$, ;)) - 1) FAILED psrpcsockettemp(16147) = 390601:1 1 Debug CORRECTION BASED ON BELOW psrpcsockettemp(16147) = 390603:1 1;390620:2 2;390635:2 2;390680:1 1;390681:1 1;390682:1 1; ___ 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: Port and Queue Server Admin Display issue in MT
Thanks longwing, That would be may next option, as BMC is still researching the issue. Trying to see if this can be resolved at this level, before moving to the next and have new issues to resolve, also. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: How to investigate if Remedy Page is delayed.
Hi Christie, On Incident form, when I see the submit date and ( from SLM Status link ) the Milestone for that Service target, where, one of the Milestone- say XYZ shows execution time are as follow. *4/9/2014 12:30:50 PM* === Incident *submit date* *4/9/2014 12:54:21 PM* === *XYZ milestone* - performed at this time. we have the Actions configured for this* XYZ milestion*. (to be performed after 1 min from SLA clock start) say its *Action_ABC* with Pager or Run Process Action. We have one pager command in this action.- /opt/telalert/bin/telalertc -l $Assigned Group$, $Company$P1, GLIP1 -m P1 $Company$ reported at $Reported Date$: $Incident Number$; $Description$ $Assigned Group$ -host XXX*.*xxx *.* *Does this Difference of 24:29 mm/ss, shows BMC Remedy SLM engine performing SLOW and so there is a delay of 25 mins to receive its alert ?* On Wednesday, April 9, 2014 4:11:59 PM UTC-5, Pargeter, Christie :CO IS wrote: ** In your TelAlert install folder you will see a telalert.trail file. This will give you a bit more information about the message that the system sent out. 2014/02/02 07:51:16Event [70]Send Change (53905/53905), Status: [81]Message sent 2014/02/02 07:51:16Event [21]Alert Completed (53905), Status: [81]Message sent, LHSWCTP If you start your TelAlert with “telalert -debugprotocol 1” you will get more information: 2014/04/09 13:59:26Event [20]Alert Started (4967), Status: [20]Alert Started, VerizonPhone 2014/04/09 13:59:26Event [80]Send Started (4967/4967), Status: [80]Message issued, VerizonPhone(lhsmailcon:smtp, PIN=1234567890): INC0011, Medium, Allyson Anderson, 1 123 456-7890, Non-Urgent: Help with my computer - no internet access assigned to group XXX 2014/04/09 13:59:27Event [70]Send Change (4967/4967), Status: [81]Message sent 2014/04/09 13:59:27Event [21]Alert Completed (4967), Status: [81]Message sent, VerizonPhone *Christie Pargeter | Sr Technical Analyst | tel 503-415-5149* *From:* Action Request System discussion list(ARSList) [mailto: ars...@arslist.org javascript:] *On Behalf Of *Harry *Sent:* Wednesday, April 09, 2014 1:57 PM *To:* ars...@arslist.org javascript: *Subject:* How to investigate if Remedy Page is delayed. ** Hi Experts, Please help to investigate if its really from remedy end, We have Pager service configured for Incident management. there are few service targets configured for say P1 tickets and under the milestone tab we have Action- Pager or Run Process Action. We have one pager command in this action. /opt/telalert/bin/telalertc -l $Assigned Group$, $Company$P1, GLIP1 -m P1 $Company$ reported at $Reported Date$: $Incident Number$; $Description$ $Assigned Group$ -host XXX*.*xxx*.* How to investigate when user report issue like Remedy Page is delayed by say 15 min. Thanks, Harry _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: 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
Remedy, OpenSSL, and the Heartbleed bug
Everyone, I am sure that most if not all of you have seen the reports in the media about the security bug (called the Heartbleed bug) that has been found out on the internet. Some details: OpenSSL is the source of the bug. It is a technology used for encryption. The AR System environment uses this technology for password encryption and to encrypt the data as it flows across the wire. The issue was introduced in version 1.0.1 of OpenSSL (released March 2012) and is present in 1.0.1 and 1.0.1a through 1.0.1f of that product. There is a corrected version that was released April 7, 2014 that corrects the error. The error is NOT present in the 0.9.8 or 1.0.0 versions of the product. The AR System uses the 0.9.8 version of the OpenSSL libraries. We have gone through the build trees to confirm this for versions 7.6.04, 8.0, and 8.1 and the service packs and patches for those releases. For all of them, we are using the 0.9.8 version. This means that the AR System, its plugins, its applications, the CMDB, the API, and etc... is not affected by the Heartbleed bug and there is no action you need to take on your environment. BMC is investigating all of the products it ships to check which ones of them may have issues due to this bug. There will be a formal announcement in the near future of BMCs exposure and the remediation plans for any exposure found. This will include the official announcement from BMC about the AR System environment. I just wanted to share the information with this list as soon as it was confirmed that there was no issue with the Remedy product line. Doug Mueller ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Remedy, OpenSSL, and the Heartbleed bug
Thank you Doug, This is perfect. DEE -Original Message- From: Mueller, Doug doug_muel...@bmc.com To: arslist arslist@ARSLIST.ORG Sent: Wed, Apr 9, 2014 11:30 pm Subject: Remedy, OpenSSL, and the Heartbleed bug ** Everyone, I am sure that most if not all of you have seen the reports in the media about the security bug (called the Heartbleed bug) that has been found out on the internet. Some details: OpenSSL is the source of the bug. It is a technology used for encryption. The AR System environment uses this technology for password encryption and to encrypt the data as it flows across the wire. The issue was introduced in version 1.0.1 of OpenSSL (released March 2012) and is present in 1.0.1 and 1.0.1a through 1.0.1f of that product. There is a corrected version that was released April 7, 2014 that corrects the error. The error is NOT present in the 0.9.8 or 1.0.0 versions of the product. The AR System uses the 0.9.8 version of the OpenSSL libraries. We have gone through the build trees to confirm this for versions 7.6.04, 8.0, and 8.1 and the service packs and patches for those releases. For all of them, we are using the 0.9.8 version. This means that the AR System, its plugins, its applications, the CMDB, the API, and etc… is not affected by the Heartbleed bug and there is no action you need to take on your environment. BMC is investigating all of the products it ships to check which ones of them may have issues due to this bug. There will be a formal announcement in the near future of BMCs exposure and the remediation plans for any exposure found. This will include the official announcement from BMC about the AR System environment. I just wanted to share the information with this list as soon as it was confirmed that there was no issue with the Remedy product line. Doug Mueller _ARSlist: 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: Port and Queue Server Admin Display issue in MT
I have seen the similar issue. Any time you make changes and commit in Admin Console in midtier it is actually deleting all the threads in ar.conf And the server will end up running the default admin thread upon next restart. It has been fixed in the 8.1SP1. If you are not interested in upgrading, the fix is very simple. Just change an ActiveLink SetField fields into different setfield actions. *ActiveLink name -- AR System Administration: Server Ports - Parse1* Follow the discussion below. https://communities.bmc.com/thread/96989 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Without using /arsys how to point the remedy login page.
Team, Our remedy web URL is remedy.upc.biz. when we try this URL it showing like Tomcat is running. Instead of this, enter like remedy.upcoming.biz/arsys its pointing to login page. How to point the remedy login page with out using the /arsys. Can you please advise? Regards, Suresh Loganathan. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Without using /arsys how to point the remedy login page.
There are multiple ways you can do it. The way we do it is create an index.html page under tomcat ROOT folder with the following html head meta http-equiv=refresh content=1;URL=arsys/shared/login.jsp?/arsys/home /head body /body /html ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
