Re: Long Running Query

2013-01-09 Thread Ashtaputre, Anay
Following Defect Knowledge article can be referred - SW00443560 KA380785 Following fields will need to be indexed - 'C23009', 'C100079' 'C7' Indexing to be done at the db level for better performance and after indexing customer should get 'execution plan' aka 'explain plan' of the

Re: Long Running Query

2013-01-09 Thread Hullule, Kiran
Following solution works fine except db2 database, for db2 customer has to run runstat on db for T table in question and understand where exactly the time is taken, based on the output of runstat customer can implement indexes. From: Action Request System discussion list(ARSList)

Re: Long Running Query

2013-01-09 Thread Vishal Navale
Thanks Anay and Kiran. On Wed, Jan 9, 2013 at 3:49 AM, Hullule, Kiran kiran_hull...@bmc.comwrote: ** Following solution works fine except db2 database, for db2 customer has to run runstat on db for T table in question and understand where exactly the time is taken, based on the output of

Re: Sub Administrator delete records permissions

2013-01-09 Thread Mueller, Doug
The issue in this case was indeed a bug in the midtier. SubAdministrators do have delete permissions on the forms for which they are SubAdministrators. This capability is fully supported at the AR System level, through the API, from any API program written, and from the Windows User Tool.

All DECIMAL and CURRENCY data has been corrupted in AR Server 8.0.00

2013-01-09 Thread Misi Mladoniczky
Hi, I am having serious trouble with my Linux AR Server 8.0.00 (patch002 or unpatched), Linux, Oracle. All DECIMAL and CURRENCY data has been corrupted in the database. This has happened on ALL records which were merged into the new server. It also happens when you submit/modify any such fields

Re: Sub Administrator delete records permissions

2013-01-09 Thread Rick Westbrock
Right, there are rules in place that won't allow the user tool to even connect in the first place; only mid-tier access is allowed. Even so I will get back to support and let them know that there's a difference in behavior between the user tool and mid-tier since they really should behave the same

JOB ADVERTISEMENT

2013-01-09 Thread Scott Parrish
Title: Remedy Technical Team Lead/Programmer Location: Nashville, TN This is a critical key position that will work with the Remedy team (to include business analysts, developers), and customers as well as various process teams to provide input and direction for the implementation and

How do I check for a flashboard license?

2013-01-09 Thread richard....@bwc.state.oh.us
I want to check to see if we have a flashboard license in use, but when I look at the add/remove license form it doesn't show any flashboard license. Is it listed somewhere else? Thanks. Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal

Re: How do I check for a flashboard license?

2013-01-09 Thread Mueller, Doug
Richard, You didn't mention the version of the system you are using. As of about 7.0 of the product, Flashboards is simply a feature of the AR System and is not a separately licensed capability. My guess is that you acquired the system when it was a separately licensed piece and are

Re: How do I check for a flashboard license?

2013-01-09 Thread Longwing, LJ CTR MDA/IC
If you are on 7.6.04 (if I remember the version correctly...might have been one or two before that) you don't need a license anymore. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of richard@bwc.state.oh.us Sent:

Re: All DECIMAL and CURRENCY data has been corrupted in AR Server 8.0.00

2013-01-09 Thread Joe D'Souza
Misi, This indeed sounds quite bizarre. And the only thing that I can think of, which I'm pretty sure you have as well and checked and crossed out - but just in case you haven't - is there a funky piece of workflow (AL's or F's) that manipulates the value to adjust that fraction by a tiny bit,

Re: How do I check for a flashboard license?

2013-01-09 Thread Easter, David
To clarify, it was AR System version 7.5.00 where this occurred. This is confirmed in the compatibility matrix: Known Issues for Remedy Applications and Products [...] 3. In AR System 7.5.00 and higher, unlimited flashboards no longer require an additional license add-on In versions prior to

RANT: Downloading Patches for AR System and related / dependant applications...

2013-01-09 Thread Joe D'Souza
This used to be quite simple and easy using that little web application to pick up the product, version, and search which would list all the options (in a table field) available for that application. Its appearance was 'very organized'. For 7.6.04, this seems to have been taken away as none

SLA Service Targets

2013-01-09 Thread bob lind
Using ITSM 7.6.04 with SLM installed, I would like to set up a series of service targets that are ordered. For example: For an op cat that is a password reset use PasswordReset Service Target For any other op cats that are Account Management use Account Management Service Target For a customer

Re: How do I check for a flashboard license?

2013-01-09 Thread Brock, Anne
Not to be picky, but I believe it was version 7.5 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Wednesday, January 09, 2013 11:23 AM To: arslist@ARSLIST.ORG Subject: Re: How do I check for a flashboard license? ** Richard,

Rép : RANT: Downloading Patches for AR System and related / dependant applications...

2013-01-09 Thread laurent matheo
** I agree.Perhaps they could use the doc wiki to do a summary, but cross modules, not just only ARS in ars page, just CMDB in cmdb page (and so on).A common page to all modules, pretty much a summary with an array and links, nothing fancy but just something like that so you could see in a glance

Re: RANT: Downloading Patches for AR System and related / dependent applications...

2013-01-09 Thread Sanford, Claire
AOL Mode |ON - Me Too! From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe D'Souza Sent: Wednesday, January 09, 2013 1:52 PM To: arslist@ARSLIST.ORG Subject: RANT: Downloading Patches for AR System and related / dependant applications... ** This

Re: RANT: Downloading Patches for AR System and related / dependent applications...

2013-01-09 Thread Joe D'Souza
The other pain point (no big deal though) is that personally I would rather see the file name as is on the link, than a descriptive hyperlink to that file that is being downloaded - for the simple reason as these files are mostly in excess of a gig or so. If I have downloaded on two different

Rép : Re: RANT: Downloading Patches for AR System and related / dependent applications...

2013-01-09 Thread laurent matheo
** Indeed.It happened a couple of times where I just gave up and downloaded everything again :)I don't know which sp it was, but I think the ARS and cmdb or ITSM weren't released exactly at the same time so I was "out of sync".Le 09 jan 2013 à 21:48, Joe D'Souza jdso...@shyle.net a écrit :The

Re: All DECIMAL and CURRENCY data has been corrupted in AR Server 8.0.00

2013-01-09 Thread Misi Mladoniczky
Hi, No, there is no workflow. Especially when I originally merged the data. This happened, and happens, to EVERY field (currency and decimal). Some data that did not have any decimal portion has been left intact. But some of that data ha been changed anyway. I see no big pattern, except that it

OT: All DECIMAL and CURRENCY data has been corrupted in AR Server 8.0.00

2013-01-09 Thread Misi Mladoniczky
Hi, One more thing... Nora is still too small for the shirt, but she plans to join me at the next WWRUG. She should have grown in to it by that time ;-) Best Regards - Misi, RRR AB, http://rrr.se Misi, This indeed sounds quite bizarre. And the only thing that I can think of, which

Re: All DECIMAL and CURRENCY data has been corrupted in AR Server 8.0.00

2013-01-09 Thread Shellman, David
That's great. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, January 09, 2013 4:14 PM To: arslist@ARSLIST.ORG Subject: OT: All DECIMAL and CURRENCY data has been corrupted in AR Server

Re: RANT: Downloading Patches for AR System and related / dependent applications...

2013-01-09 Thread Joe D'Souza
Yes that too – when these patches are not released around the same date, sorting the date doesn’t help too much in arranging them all in a good order. And the hyperlinks to the files are so inconsistent in their naming format that sometimes some cases patch 1, 2 3 and 4 could appear in the

Re: All DECIMAL and CURRENCY data has been corrupted in AR Server 8.0.00

2013-01-09 Thread Joe D'Souza
She should be given a free guest entry as the youngest participant at a RUG :) Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Shellman, David Sent: Wednesday, January 09, 2013 4:31 PM To: arslist@ARSLIST.ORG Subject:

Re: All DECIMAL and CURRENCY data has been corrupted in AR Server 8.0.00

2013-01-09 Thread Joe D'Souza
I wonder if its some sort of a 'rounding up' built in function gone bad. Have you tested the feature along with the same code in earlier versions? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent:

Re: RANT: Downloading Patches for AR System and related / dependent applications...

2013-01-09 Thread Rick Cook
Joe, I'm with you on this one. Going through the BMC Download page is frustrating, because even though I have saved My Applications, the screen never really has the appearance of something that I have in any way customized, and it doesn't act in a way that would reward me for having preloaded

Re: All DECIMAL and CURRENCY data has been corrupted in AR Server 8.0.00

2013-01-09 Thread Grooms, Frederick W
Have you checked to see if the Decimal still has the same Precision between the 7.6.04 and the 8.0.0 ? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, January 09, 2013 3:10 PM To:

Re: Rép : Re: RANT: Downloading Patches for AR System and related / dependant applications...

2013-01-09 Thread Joe D'Souza
And I think it’s a great idea to keep a matrix kind of an index of all the products, patches and going one step further hotfixes if made public to existing customers. It will serve as a quick cheat sheet to system admins as well as us consultants. Its easy to forget that there was no ITSM patch

Re: SLA Service Targets

2013-01-09 Thread Schon, Stuart
We wrote a bespoke side solution to get over this problem - had it from 6.3 days but still appropriate at 7.6.04. Basically we created 2 forms to contain various combinations of 'criteria' which are searched for a hit. Criteria being Customer, Op Cat, Prod Cat, Location, VIP, Priority and SLA

Re: RANT: Downloading Patches for AR System and related / dependent applications...

2013-01-09 Thread Joe D'Souza
Yes I agree, there is so little advantage of pre-selecting those, that I do not even bother to do that nowadays when I am given a new contract ID at a new site. This site has one product only anyways, and despite that I’m having a little bit of a frustration trying to find all the stuff I needed.

Rép : Re: Re: RANT: Downloading Patches for AR System and related / dependant applications...

2013-01-09 Thread laurent matheo
** Yep, I'll post on the community to get in touch with the doc team (or perhaps some of them are on arslist) (?).Le 10 jan 2013 à 00:18, Joe D'Souza jdso...@shyle.net a écrit :And I think it’s a great idea to keep a matrix kind of an index of all the products, patches and going one step further

Re: ITSM 7.6.04 Panel Permissions

2013-01-09 Thread Jason Miller
Are you getting an error or does it just ignore what you are trying to do? Jason On Tue, Jan 8, 2013 at 2:37 PM, Sanford, Claire claire.sanf...@memorialhermann.org wrote: I know this is basic Roles and Permissions, but I am having trouble with ITSM and a panel. I have a panel that I

Re: ITSM 7.6.04 Panel Permissions

2013-01-09 Thread Sanford, Claire
It blanks out the permissions I gave the panel. It goes from 1 Permission to 0 Permission ITSM doesn't like it when you create your own roles either! Very frustrating! I hear - We used to do this in the old Remedy, why can't we do it in the new better Remedy?? I reply - Because the

Rép : Re: ITSM 7.6.04 Panel Permissions

2013-01-09 Thread laurent matheo
** Did you check my previous email?Hi Claire :)I just tried on 7.6.04 sp2.Indeed if you choose "Asset admin" as "group" it won't stay, when I choose "Asset Admin" as "Role" (I got both on my list) then it staid.I tried on the panel "Impacted

Re: Rép : Re: ITSM 7.6.04 Panel Permissions

2013-01-09 Thread Jason Miller
Yeah, after I replied :) Gmail didn't thread your reply so I it looked like there wasn't a reply yet. (I blame Apple) Jason On Wed, Jan 9, 2013 at 3:54 PM, laurent matheo lm...@me.com wrote: ** Did you check my previous email? Hi Claire :) I just tried on 7.6.04

Rép : Re: Re: ITSM 7.6.04 Panel Permissions

2013-01-09 Thread laurent matheo
** Hummm perhaps it's due to the "icloud.com" online email handler... It's so lame, search function in it is so bad...I guess I'll switch to thunderbird.Le 10 jan 2013 à 01:01, Jason Miller jason.mil...@gmail.com a écrit :**Yeah, after I replied :)Gmaildidn't thread your reply so I it looked like

Re: ITSM 7.6.04 Panel Permissions

2013-01-09 Thread Jason Miller
ITSM shouldn't care. It is an AR function (at least at the core until you start making ITSM config records that go along with the roles). Did you try what Laurent suggested? On Wed, Jan 9, 2013 at 3:51 PM, Sanford, Claire Claire.Sanford@ memorialhermann.org wrote: ** It blanks out the

Re: Rép : Re: Re: ITSM 7.6.04 Panel Permissions

2013-01-09 Thread Jason Miller
I have to admit the iOS is email client is the only thing I have found that can thread BMC Communities emails. Jason On Wed, Jan 9, 2013 at 4:03 PM, laurent matheo lm...@me.com wrote: ** Hummm perhaps it's due to the icloud.com online email handler... It's so lame, search function in it is

Rép : Re: RANT: Downloading Patches for AR System and related / dependent applications...

2013-01-09 Thread laurent matheo
** I actually created an idea:https://communities.bmc.com/communities/ideas/1598Le 10 jan 2013 à 00:27, Joe D'Souza jdso...@shyle.net a écrit :Yes I agree, there is so little advantage of pre-selecting those, that I do not even bother to do that nowadays when I am given a new contract ID at a new

Re: Rép : Re: Re: RANT: Downloading Patches for AR System and related / dependent applications...

2013-01-09 Thread Easter, David
FYI, the “old PDF” compatibility is still available until the new SPAC utility can be enhanced to provide the same information as the PDF. http://www.bmc.com/support/reg/remedy-compatibility-tables.html -David J. Easter Manager of Product Management, AR System BSM Atrium Solutions Management

Rép : Re: Re: Re: RANT: Downloading Patches for AR System and related / dependent applications...

2013-01-09 Thread laurent matheo
** Ah cool, missed that :)Thanks.Le 10 jan 2013 à 01:59, "Easter, David" david_eas...@bmc.com a écrit :FYI, the “old PDF” compatibility is still available until the new SPAC utility can be enhanced to provide the same information as the