Re: Common Table Expression SQL for menus

2019-02-19 Thread Charlie Lotridge
Thanks for the suggestion Phil. I just tried it and unfortunately ARS said "no". I'll keep digging, but I guess for now I'll just need to use a SQL view. Thanks again, Charlie On Tue, Feb 19, 2019 at 11:00 AM Phil Murnane wrote: > Hi Charlie, > > > >

Common Table Expression SQL for menus

2019-02-19 Thread Charlie Lotridge
's failing or perhaps developed a better workaround? Incidentally, this is on an ARS system running v8.1. Thanks, Charlie -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist

Re: Where do I configure "Save Successful With Warnings"?

2019-01-23 Thread Charlie Lotridge
> Remedy Engineer > > 404-582-5699 (Desk) > 704-301-1047 (Mobile) > > > > *From:* ARSList [mailto:arslist-boun...@arslist.org] *On Behalf Of *Charlie > Lotridge > *Sent:* Wednesday, January 23, 2019 1:34 PM > *To:* ARSList > *Subject:* [EXTERNAL] Where do I configu

Where do I configure "Save Successful With Warnings"?

2019-01-23 Thread Charlie Lotridge
t piece of info has fallen out. Here are some examples of the warnings I mean: The field label 'Help' is duplicated on this form., 5026, MD_People The field on this form with the name or ID of MDLEPXFilter:Include:Assigned By needs a label., 5033, MD_People ... Thanks, Charlie

Issue with SQL Set Fields that uses a Common Table Expression

2018-07-09 Thread Charlie Lotridge
re" that BMC's installed to prevent SQL injection or something. Has anyone else seen this behavior? Is there an easy workaround or fix? Yes, in this particular case I can probably refactor the SQL to eliminate the CTE, but for a few reasons this is not a convenient solution. FYI...

Re: Help with odd set of SQL operations by ARS

2018-06-19 Thread Charlie Lotridge
> be wonky. > > On Mon, Jun 18, 2018 at 8:47 AM Charlie Lotridge > wrote: > >> Hi, >> >> I'm not exactly sure when this started, but within the past few weeks my >> production ARS has started repeatedly issuing the following three SQL >> st

Help with odd set of SQL operations by ARS

2018-06-18 Thread Charlie Lotridge
7:34:34.8580 */OK /* Mon Jun 18 2018 07:34:34.8580 */SELECT MAX(timestamp) FROM group_cache /* Mon Jun 18 2018 07:34:34.8580 */OK Thanks, Charlie -- ARSList mailing list ARSList@arslist.org https://mailman.rrr.se/cgi/listinfo/arslist

Re: Run API from filter deadlocks

2017-03-15 Thread Charlie Lotridge
n 1 finishesthus > deadlock > > simply....you can't have the doctor operate on himself > > On Wed, Mar 15, 2017 at 12:01 PM, Charlie Lotridge > wrote: > >> ** >> LJ, >> >> Thanks for the suggestion. >> >> Unfortunately filterAPI

Re: Run API from filter deadlocks

2017-03-15 Thread Charlie Lotridge
ond. Still, just to test, I did try setting the "Process Timeout" to 25 seconds. Regardless, the documentation, and my vague recollection from the last time I tried this, suggest that it can be made to work and my question is: why isn't it working? I *am* running this in a SERVICE o

Run API from filter deadlocks

2017-03-15 Thread Charlie Lotridge
ot suitable. Also FYI, it's a fully licensed development system with absolutely nothing else going on (no other person or processes are using it). I've done this kind of thing before, but it's been a long time and my best recollection is that increasing the thread count sol

Re: BoF Groups in Communities

2015-05-04 Thread Charlie Lotridge
"...those of us custom shops that may not be watching the BMC Communities much". Yeah, that would be me. Great idea...voted up. -charlie On Mon, May 4, 2015 at 11:36 AM, Jason Miller wrote: > ** > Hello all, > > I am posting this BMC Communities Idea here for those of

Re: .Net API Wrapper Framework Version

2015-04-01 Thread Charlie Lotridge
me. If you're at all interested in discussing further, I'd be happy to take it offline with you and show you how it works and some samples. -charlie On Wed, Apr 1, 2015 at 6:42 AM, Wilson, Bruce B wrote: > ** > > Hello All, > > > > I am working with Visual Studio 2013

Re: Refresh my Memory Please

2015-03-25 Thread Charlie Lotridge
emedy view at all. Hope this helps. -charlie On Wed, Mar 25, 2015 at 8:58 AM, Tanner, Doug wrote: > ** > > Dear List, > > I am going from Memory here, so I need some assistance > (Senior Moment) > > > > Configurati

Re: need some ideas from you how to show incidents recordsover4hrinred color.

2014-12-10 Thread Charlie Lotridge
local display only field so the > users can see what was selected > > > > Fred > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge > *Sent:* Wednesday, December 10, 2014 10:31 AM &

Re: need some ideas from you how to show incidents recordsover4hrinred color.

2014-12-10 Thread Charlie Lotridge
r. Anyone use this? And if so how & why? On Wed, Dec 10, 2014 at 8:12 AM, LJ LongWing wrote: > ** > Sorry...forgot to credit the source of the 2 ideas I said were still in > play :) > > On Wed, Dec 10, 2014 at 9:09 AM, Charlie Lotridge > wrote: > >> ** >>

Re: need some ideas from you how to show incidents recordsover4hrinred color.

2014-12-10 Thread Charlie Lotridge
I think there are only two options truly in play > > 1 - View form that calculates the color automatically in a DB view without > any Remedy workflow > 2 - JavaScript magic > > The other options, as explored seem to either not work, or are too > resource intensive. > &

Re: need some ideas from you how to show incidents records over4hrinred color.

2014-12-09 Thread Charlie Lotridge
the table while running a filter log and you will NOT see any of the filters being run. I think you'll need to consider one of the other solutions. -charlie On Tue, Dec 9, 2014 at 4:16 AM, Omega LiPO wrote: > ** > Thanks. I knew the enable/disable filter log at server side and client. >

Re: need some ideas from you how to show incidents records over 4hrinred color.

2014-12-08 Thread Charlie Lotridge
h do let me know what you discover (or does someone else already know the answer...?). Thanks, Charlie On Mon, Dec 8, 2014 at 2:40 PM, Omega LiPO wrote: > ** > Hi Charlie, > > How to do the filter-log ? You mean turn on the filter log. I did not get > it. > > Thanks, >

Re: need some ideas from you how to show incidents records over 4hrin red color.

2014-12-08 Thread Charlie Lotridge
ne of the APIs that retrieves multiple entries in a single call (e.g. ARGetListEntryWithFields, ARGetMultipleEntries, ARGetListEntryBlocks). I'm not sure if these will invoke the Get Entry filter on the individual entries (and don't have time to test it myself right now). Hope this helps. -

Re: need some ideas from you how to show incidents records over 4 hr in red color.

2014-12-05 Thread Charlie Lotridge
'd be welcome to the source code for this (or even the compiled assembly if you prefer). But I don't have a comparable solution for any other DB platform. If you're interested in learning more let me know and perhaps it would be most considerate to the rest of the community to take it o

Re: .Net api 64 bit version

2014-11-13 Thread Charlie Lotridge
ou probably have a body of work based on the community version and don't want to consider refactoring to use mine. But if you do find you're interested I'd be willing to consider distributing it to you, including source code, under GPLv3. I'd also be happy to help bring you up to sp

Bug using Status History value in filter Run If?

2014-11-04 Thread Charlie Lotridge
OM H492 WHERE entryId = N'LEDCASE-026'. Clearly it's pulling ALL of the values it needs in a single run of the query, but for some reason it's doing it twice. For fun I also added pulling $Status History.Draft.USER$ and $Status History.Draft.TIME$ and the server corresponding

Re: Request ID Numbering recovery

2014-11-03 Thread Charlie Lotridge
st issue this SQL: UPDATE arschema SET nextId = 6002 where name = '' NOTE THAT if you have the "Enable Next RequestID Block Size" option enabled, you may need to bounce the server (but maybe not). I do NOT have it enabled on my Test6 form and did not have to bounce the server f

Re: NOT SOLVED: PERFORM-ACTION-OPEN-URL to open internal network site

2014-10-10 Thread Charlie Lotridge
lient where you then present it using a PERFORM-ACTION-OPEN-ATTACHMENT. Of course, this solution requires that the Adobe reader is available on the client's machine, but that's not too much of an ask. Just a suggestion... -charlie On Fri, Oct 10, 2014 at 9:43 AM, Sinclair, Keith wrote:

Re: RRR|Chive vs. DDM

2014-10-07 Thread Charlie Lotridge
the data transfers through a database link between the legacy and new DBs (e.g. SELECT INTO and UPDATE FROM type statements). It was very fast. If you don't find another solution and are interested, I'd be happy to provide more details about how this thing worked. -charlie On Tue, Oct

Re: Diary field usage

2014-09-29 Thread Charlie Lotridge
fields are difficult to use. On the other hand, if you plan to use the content only for review (e.g. users will only need to read through them to see what happened and when), then diary fields are perfect for the job. Hope this helps. -charlie On Mon, Sep 29, 2014 at 3:35 PM, Rick Cook wrot

Re: Server side filter log not getting captured!

2014-09-28 Thread Charlie Lotridge
View button. I've had weird results using it in the past, where it would (consistently) show the most recent prior version of the file, instead of the current content (I've since switched to always opening the log files directly using Windows). Hope this helps. -charlie On Sun, Sep 28

Re: Escalation does not seem to complete its run over all the records..

2014-09-24 Thread Charlie Lotridge
f the escalation). Hope this helps. -charlie On Wed, Sep 24, 2014 at 7:34 AM, Joe D'Souza wrote: > ** > > I have a simple escalation that triggers on the form CTM:LoadPostalCodes > with a condition > > > > 'DL_Status' = "Unvalidated" > > >

Re: Escalation qualification : DSO

2014-09-08 Thread Charlie Lotridge
antly mitigate the issue described. Sorry for the sidetrack. -charlie On Mon, Sep 8, 2014 at 7:58 AM, Vikrant Kulkarni wrote: > ** > > I would suggest look into RRR|Chive from rrr.se it just works fine in > this case. > On Sep 8, 2014 8:25 PM, "LJ LongWing" wrote: >

Re: *Ancient* bug with Set Field from a SQL transaction still present...

2014-09-04 Thread Charlie Lotridge
FYI this "comma counting" only affects what appears in the list of "field" choices. There's nothing stopping you from hand typing, say, $10$ or $100$ into a Set Fields value, even if the drop-down shows only (say) 5 choices. Of course, your SQL had then better have at least that many columns of d

Re: *Ancient* bug with Set Field from a SQL transaction still present...

2014-09-04 Thread Charlie Lotridge
to hit the wire (6). -charlie On Thu, Sep 4, 2014 at 5:49 AM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > ** > > I’m not sure if it would be the API or just the code that is used in > Developer Studio (Possibly the same code that was used in the Admin tool). >

Re: Permission problem

2014-08-07 Thread Charlie Lotridge
nd the only person that can address that is BMC...and being > you are running the latest version, latest service pack, latest > patchthere would obviously need to be another fix put in place. > > > On Thu, Aug 7, 2014 at 10:05 AM, Charlie Lotridge > wrote: > >> ** >

Re: Permission problem

2014-08-07 Thread Charlie Lotridge
Greg, I'm also concerned about the problem coming back (I mentioned in another email I've also seen this happen). Did you ever try manually clearing the cache directories as LJ & Ryan suggested? -charlie On Thu, Aug 7, 2014 at 8:23 AM, Givens, Gregory CTR NPC, Pers 54 &l

Re: Permission problem

2014-08-07 Thread Charlie Lotridge
Thanks for these additional suggestions. Lisa, yes, I did uncheck that option (but it didn't help). Ryan, so far I've only deleted the cache directory. If the problem re-manifests I'll try your more extensive approach. -charlie On Thu, Aug 7, 2014 at 8:12 AM, Kemes,

Re: Permission problem

2014-08-07 Thread Charlie Lotridge
ncluding adding Administrator) did resolve the problem, but only for short periods of time. It would then come back after a while. I'm crossing my fingers that this solution will persist. Thanks LJ! -charlie On Thu, Aug 7, 2014 at 8:06 AM, LJ LongWing wrote: > ** > Charlie, &

Permission problem

2014-08-07 Thread Charlie Lotridge
v8.1.01 Has anyone seen this before? Any suggestions on how to fix this? I haven't gone as far as uninstalling/reinstalling the mid-tier or tomcat yet, do anyone think this will help? Thanks, Charlie ___ UNSUBS

Re: EXTERNAL: Re: using SQL soundex function to find similar names

2014-08-04 Thread Charlie Lotridge
d with your sql log to make sure that some filter isn't nulling the field before it gets written to the DB? -charlie On Mon, Aug 4, 2014 at 8:59 AM, Reiser, John J wrote: > ** > > Charlie, > > > > I did as you suggested. The workflow showed up as select soundex(N’STEH

Re: using SQL soundex function to find similar names

2014-07-31 Thread Charlie Lotridge
then this should be a sufficient workaround: you don't ever *really* need to visualize the soundex data at the app level anyway (do you?). And you've seemed to indicate that this is true (it's isolated). If it's not isolated, then, obviously, you really need to figure out what&#x

Re: View DDL for ARSystem tables

2014-06-12 Thread Charlie Lotridge
T name FROM arschema WHERE schemaId = where, probably obviously, here is the number next to the "T" in the UPDATE statement as shown above. Hopefully this is all clear and easy to follow. Let me know, though, if you have any questions. -charlie On Thu, Jun 12, 2014 at 7:1

Re: View Form Not Picking Up Char(1) columns

2014-06-11 Thread Charlie Lotridge
happy to help craft the create statement for the SQL view. -charlie On Wed, Jun 11, 2014 at 10:10 AM, Mr Bodie wrote: > ** > Hi folks, > > Need some help again. > > I created a view form in remedy but I notice that I does not show any of > the columns in the table that are Char(1

Re: Remedy Developer Performance Metrics

2014-06-04 Thread Charlie Lotridge
ct something within a day or so. Thanks, Charlie On Wed, Jun 4, 2014 at 7:05 AM, LJ LongWing wrote: > ** > Charlie, > I have a long standing hatred of performance metrics, that I won't go into > the background for here, but I'll attempt to answer the basis of your >

Re: Remedy Developer Performance Metrics

2014-06-03 Thread Charlie Lotridge
ust one object on the low end, and it's never going to be a thousand on the high end. So for me, min to max, my answer would be 15 to, say, 400. And, on average, I'd say it's probably around 30 or so. So, anyone willing to answer, I'd appreciate the data points. Thanks,

Re: Remedy Developer Performance Metrics

2014-06-03 Thread Charlie Lotridge
ases? Finally, a disclaimer: I don't now or have any near future plans to use such metrics to evaluate anyone...I don't have anyone to evaluate. And while my interest in the topic is more than just idle curiosity, I won't be using it to fire anyone soon. For me, this infor

Remedy Developer Performance Metrics

2014-06-03 Thread Charlie Lotridge
In other words for code generation. So for example, you might tell me that a good developer can create at least 50 logic objects (active links/filters/escalations) in a day. Or create & format one form/day. What are you opinions? T

Re: Active-link Associated with from

2014-05-26 Thread Charlie Lotridge
.schemaId WHERE s.name = 'User' -charlie On Mon, May 26, 2014 at 12:50 PM, Rajesh Singh wrote: > Hi , > > > Could anyone of you please help me to , to know the SQL query to find the > no of active-link, filter and escalation associated with

Re: Transactional (TR) and Database (DB)

2014-05-19 Thread Charlie Lotridge
lter associated with a form that uses a 'DB.' construct in it's qualification, ARS is going to perform a full read of the record before filter processing. -charlie On Mon, May 19, 2014 at 6:04 AM, Misi Mladoniczky wrote: > Hi, > > The only reason I can see for this is so

Re: Transactional (TR) and Database (DB)

2014-05-18 Thread Charlie Lotridge
I'm curious, what's the 0.1% case when it would be useful? I'm just not seeing any unique use for it at all. -charlie On Sat, May 17, 2014 at 1:04 PM, Misi Mladoniczky wrote: > Hi, > > It is up to the client. > > If this for example was done through a Push-Field

Re: Transactional (TR) and Database (DB)

2014-05-17 Thread Charlie Lotridge
kflow of my tests for anyone who might want to play around with it. In it I define a regular form with a regular field 'Regular' and a display field 'Display'. I then have filter workflow that checks each for each of the following conditions: * 'TR.Field' != 'DB.Field

Re: Indirect reference to form field value

2014-05-12 Thread Charlie Lotridge
'Source Field ID', 'Target Field ID', and other field values and Save to test it Incidentally, I did confirm that the mechanism will do data conversions (try using one of the integer fields as the source or target, and one of the character fields as the other). Let m

Re: Dynamic user-specific color coding for table field rows and columns

2014-05-07 Thread Charlie Lotridge
Like I said though, it's pretty involved and would take a bit of time to put together. Charlie On Tue, May 6, 2014 at 11:56 PM, Robin Mathew wrote: > Hi all, > > I request your help for the following requirement. > > Requirement > > I need to provide a configuratio

Re: Self-Terminating/disabling Escalation

2014-05-04 Thread Charlie Lotridge
tion's actions resets the filter counter, lessening the probability of hitting the limit. -charlie On May 3, 2014 5:48 AM, "LJ LongWing" wrote: > ** > Doug/All, > I'll let you know about a 'problem' I have come across with this approach. > Unfortunately, or fo

Re: Self-Terminating/disabling Escalation

2014-05-02 Thread Charlie Lotridge
ver on which it's run, but it would not propagate to any other servers until they reload their caches (I don't know much about server groups...would other servers in the group notice such changes and automatically reload?). I hope this helps. -charlie On Wed, Apr 30, 2014 at 12

Re: Indirect reference to form field value

2014-04-30 Thread Charlie Lotridge
ample) are being set correctly? If you still can't get it working, would it help if I cobble together a small working demo and send it in a .def file? You could then "morph" it into the workflow you need. Question, are you doing this at the active link level or the filter level? -char

Re: Filed attributes

2014-04-25 Thread Charlie Lotridge
ext' to "Yes" when 'Text' is set to "Yes", and "No" when 'Text' is set to "No" 6. Create an Active Link triggered on Return with the Field set to 'DO Text' that sets 'Text' to "Yes" when 'D

Re: Indirect reference to form field value

2014-04-24 Thread Charlie Lotridge
ime, and DateTime field types. I also have NOT tried to use this to move a value from one data type to another...I'm not sure it'll do the conversion that a "normal" Set Fields would do. Let me know if this works for you or if any of this is not clear. Thanks, Charlie On T

Re: OpenWindow vs. PERFORM-ACTION-OPEN-URL

2014-04-23 Thread Charlie Lotridge
have that Check Interval set to 0), I of course have this unchecked because I don't want to wait (in some cases up to 1/2 minute) to open an entry, but it'll probably be selected to use URLs in production. Thanks, Charlie On Wed, Apr 23, 2014 at 9:17 AM, Mueller, Doug wrote: >

Re: Filed attributes

2014-04-20 Thread Charlie Lotridge
mapping. I'd recommend using SQL to execute a command like the following (let's assume the form name is "SomeForm"): UPDATE SomeForm SET Text = CASE WHEN Text = 0 THEN 1 ELSE 0 END Note that I'm assuming that your enumeration doesn't have any other values besides Ye

Re: Moving Large Amount of Data to External Remedy System

2014-04-20 Thread Charlie Lotridge
B of data in about a day - not crazy quick but sufficient for our needs at the time. If you can't find a better solution I'd be happy to discuss the strategy in more detail. -charlie On Wed, Apr 16, 2014 at 11:23 AM, Kathy Morris wrote: > ** > > Hi, > > > > ITSM

Re: OpenWindow vs. PERFORM-ACTION-OPEN-URL

2014-04-14 Thread Charlie Lotridge
just more convenient for me to test it using "forward". Unfortunately I still don't know just why the OpenWindow method is faster than URL. I really like the functionality and usability of the URL method over OpenWindow, and am debating if it's worth the extra cost (or, more pr

Re: OpenWindow vs. PERFORM-ACTION-OPEN-URL

2014-04-13 Thread Charlie Lotridge
performing some additional network transactions, though (again) I really don't how to interpret these results yet. -charlie On Sun, Apr 13, 2014 at 1:57 PM, Joe D'Souza wrote: > ** > > I won’t pretend to know the answer – but have you ruled out some piece of > search workflow t

OpenWindow vs. PERFORM-ACTION-OPEN-URL

2014-04-13 Thread Charlie Lotridge
7;d switch my generalized workflow to use it except for the performance issue. Any thoughts? Thanks, Charlie ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

Re: Filter Push to View Form

2014-04-05 Thread Charlie Lotridge
this kind of thing all the time. Without actually seeing the problem myself I can only describe this process in generalities, but if I'm not being clear please let me know. Or, if you can post these definition files and sufficient context so that I can try it myself, I'd be happy to try to h

Re: Esoteric Bugs relating to ARS View forms

2014-03-28 Thread Charlie Lotridge
I'm running on server version 8.1.00 201301251157. Of course, I guess they may've fixed this in a subsequent patch... -charlie On Fri, Mar 28, 2014 at 1:58 PM, LJ LongWing wrote: > ** > Charlie, > All I can say is 'WOW' :).that's just insane. Can you

Esoteric Bugs relating to ARS View forms

2014-03-28 Thread Charlie Lotridge
e and hopefully I haven't left anyone interested too confused...let me know if you have any questions. I don't currently have a client, so I have no active support id through which I can submit a ticket on this. So, anyone, feel free to do so if this affects you. Thanks, Charlie __

Re: $NULL$ = $NULL$?

2014-03-20 Thread Charlie Lotridge
sly substituted $NULL$. -charlie On Thu, Mar 20, 2014 at 9:08 AM, Joe D'Souza wrote: > It shouldn't harm anything as the system will evaluate it like 1=1 and > return TRUE always on that part of the qualification. > > At worst it would just require a tiny extra micro mil

Re: Menu Bar in mid-tier (v8.1)

2014-03-20 Thread Charlie Lotridge
.I'll certainly research it. Cool tool Misa. It unfortunately doesn't quite help me here since I don't actually have any menus that need converting (and was looking to introduce one mostly to leverage the hot key functionality), but I'm sure many will find something like this ver

Menu Bar in mid-tier (v8.1)

2014-03-19 Thread Charlie Lotridge
in the old User tool), is there another way I can affect this? Thanks, Charlie ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

Re: BMC should have made upgrades easier - Customers loosing interests

2014-03-11 Thread Charlie Lotridge
ywords=sql+server+2012> you can buy a developer license to MS SQL Server which is pretty much functionally equivalent to their enterprise edition. Both companies provide tons of online documentation, tutorials, WBT, etc. *for free*. Why can't BMC adopt such a model? I have to believe that

Re: Get Entry filter trigger - request for opinions

2014-02-22 Thread Charlie Lotridge
that data were > fired > > directly in the user's browser, so there would be three legs: browser to > > mid-tier, mid-tier to ARS, and ARS to DB. Are you saying that those AL's > > are actually executed by the mid-tier? I really don't yet know enough >

Re: Get Entry filter trigger - request for opinions

2014-02-21 Thread Charlie Lotridge
don't yet know enough about the division of labor between the mid-tier and the browser. The $CLIENT-TYPE$ idea is excellent. Thanks. -charlie On Fri, Feb 21, 2014 at 11:52 AM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > ** > > Yes we are using them here. >

Get Entry filter trigger - request for opinions

2014-02-21 Thread Charlie Lotridge
probably the exceptional situation and well worth the enhanced user experience. Well, after about an hour of writing this email and doing the research, at this point I'm pretty much convinced that Get Entry is the way to go for this. But I'll send this out anyway to maybe provoke some

Re: FYI...SQL in Set Fields MUST begin with "SELECT"

2014-02-20 Thread Charlie Lotridge
Yeah, things start to get funny when you surpass the varchar limit (typically 4000 chars) and head into LOB territory. Maybe it had something to do with that. I've never used such a large query in a Set Fields, so I don't think I've ever seen this issue. -charlie On Thu, Feb 2

Re: FYI...SQL in Set Fields MUST begin with "SELECT"

2014-02-20 Thread Charlie Lotridge
hat it's doing with thatto > see if it's executing it or notnot sure what would be found if you went > down that rabbit hole. > > > On Thu, Feb 20, 2014 at 1:25 PM, Charlie Lotridge wrote: > >> ** >> Interesting, thanks for this info. >> >>

Re: FYI...SQL in Set Fields MUST begin with "SELECT"

2014-02-20 Thread Charlie Lotridge
s, and at the end of lines, and it works correctly. -charlie On Thu, Feb 20, 2014 at 12:12 PM, Janie Sprenger wrote: > ** > I think there are security requirements for web applications and one of > the requirements is to prevent SQL injection. Not sure, but perhaps Remedy > is usin

FYI...SQL in Set Fields MUST begin with "SELECT"

2014-02-20 Thread Charlie Lotridge
the CTE, which is what I ultimately had to do. It's just a less convenient solution. Anyway, just something interesting I just discovered. -charlie ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

Why the 80 character name limit on workflow objects?

2014-02-19 Thread Charlie Lotridge
t is the Dev Studio (and the Admin tool before it). With either, though, selecting multiple objects then using the Edit->Rename mechanism is one way to expand the name beyond the limit. But this is an inconvenient and awkward way of doing it. So why the limit? Can anyone hazard a gue

Re: Why does the ARS Service take so long to start?

2014-02-19 Thread Charlie Lotridge
rt you could certainly sequester the ARS DD tables into their own filegroup. A reactive strategy (i.e. relieve existing fragmentation) would be to copy-restore the DB, or at least the ARS tables. -charlie On Wed, Feb 19, 2014 at 8:14 AM, Tauf Chowdhury wrote: > ** > I recall a while bac

Re: Friday Special, The First Post to the ARSList

2014-02-17 Thread Charlie Lotridge
on are you on? > > > > Joe > -- > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Charlie Lotridge > *Sent:* Monday, February 17, 2014 4:30 PM > > *To:* arslist@ARSLIST.ORG > *Su

Re: Friday Special, The First Post to the ARSList

2014-02-17 Thread Charlie Lotridge
rks. Or perhaps I'm misunderstanding the problem you're describing...? -charlie On Mon, Feb 17, 2014 at 1:20 PM, Joe D'Souza wrote: > ** > > I could not understand the benefit (still do not) of checkboxes over radio > buttons, at least the way they functionally wo

Re: Friday Special, The First Post to the ARSList

2014-02-14 Thread Charlie Lotridge
eld data types. And if I remember correctly, no trim fields either. There also was no shared workflow, but I've come to think that shared workflow was a mistake anyway. Yes, Fred, I also remain 100% custom, though I think I installed some of ITSM once a long time ago...this doesn't cou

Re: Remedy Form Archiving

2014-02-10 Thread Charlie Lotridge
k there for an indication of the problem. Finally, failing all else, turn on filter logging and try deleting the record manually...this may reveal the problem. I hope something here helps. Thanks, Charlie On Mon, Feb 10, 2014 at 3:54 AM, Nesma ElShal, Vodafone Egypt < nesma.els...@vodafone.com

Re: Table Column Data Alignment issue

2014-01-28 Thread Charlie Lotridge
s < 250KB, though I think that'll prove a challenge. Thanks, Charlie On Tue, Jan 28, 2014 at 9:05 AM, Joe D'Souza wrote: > ** > > I have not understood the problem you are trying to describe. > > > > Are you talking about data once exported to csv and viewed fr

Re: Table Column Data Alignment issue

2014-01-28 Thread Charlie Lotridge
There have been no responses to this, so I'm guessing that no one has seen this issue. Can anyone confirm that this does work for them? Or is it perhaps a little used feature? Thanks, Charlie On Sun, Jan 26, 2014 at 1:35 PM, Charlie Lotridge wrote: > Hi all, > > I have seve

Table Column Data Alignment issue

2014-01-26 Thread Charlie Lotridge
. On the other hand, changing the alignment of the headers seems to work just fine. Thanks, Charlie ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

Re: Using $GROUPS$ OR $GROUPIDS$ to hide fields for certain Groupid

2014-01-23 Thread Charlie Lotridge
used to be starting or ending semicolons, forcing you to use much more painful syntax: ($GROUPIDS$ LIKE "100000042;%) OR ($GROUPIDS$ LIKE "%;10042;%) OR ($GROUPIDS$ LIKE "%;10042")] -charlie On Thu, Jan 23, 2014 at 12:09 AM, SUBSCRIBE arslist Jabbie < jules

Re: Namesake Views

2014-01-22 Thread Charlie Lotridge
won't affect either the function or permissions of the MyHelpdeskView. Would this work? -charlie On Wed, Jan 22, 2014 at 11:38 AM, Brittain, Mark wrote: > ** > > HI All, > > > > The move from 6.3 (custom) to 7.6 & ITSM always seems to have more > surprises th

Re: CPU utilization sometimes goes up to 100%

2014-01-22 Thread Charlie Lotridge
atus' field, this will force a full table scan. If you do this, be sure that your DBA's are maintaining the statistics on the indexes (which they should be doing anyway), since this one could get very stale and cause bad DB optimizations. Anyway, I hope something here helps. Thanks

Re: Dev Studio error

2014-01-20 Thread Charlie Lotridge
I was at the .1 release with no patch, but just brought it up to patch 02. Hopefully that'll help...thanks for the info! -charlie On Sun, Jan 19, 2014 at 10:21 AM, Jason Miller wrote: > ** > What version of Dev Studio? The widget disposed error is a known issue. > Support ga

Re: Dev Studio error

2014-01-19 Thread Charlie Lotridge
No, I hadn't. I'm not a java guy, but a quick look and research suggests it'll be the -xmx option...is this correct? I've bumped it from 1024 to 4096 to see if it'll help. Thanks for the tip. -charlie On Sun, Jan 19, 2014 at 9:43 AM, LJ LongWing wrote: > *

Dev Studio error

2014-01-19 Thread Charlie Lotridge
troys any development context I had. I've only been working for about 1.5 hours this morning and it just happened for the third time. It's very annoying. Is this a known issue? Can anyone tell me how to fix or at

Re: Delta Data Migration for initial data migration.

2014-01-13 Thread Charlie Lotridge
ted it, I'd be happy to share more details about the strategy. Let me know. Thanks, Charlie On Mon, Jan 13, 2014 at 7:09 AM, Cecil, Ken wrote: > Misi, > > Will RRR|Chive work when moving from ITSM 7.6 to 8.1? Do I have to define > mapping to get from one version of the f

Re: Cleaning up forms before migration

2014-01-09 Thread Charlie Lotridge
nd the magnitude of the data, will certainly have impact on things like transaction logs. -charlie On Thu, Jan 9, 2014 at 1:02 PM, Grooms, Frederick W < frederick.w.gro...@xo.com> wrote: > ** > > We do it with a truncate table SQL command (since we want to delete > everything) &

Re: BMC Dev Studio - Windows 7

2014-01-08 Thread Charlie Lotridge
our done. If you DO discover it's a firewall issue (Windows firewall or an external box), your network guys should be able to help you poke a hole in it for this traffic. -charlie On Wed, Jan 8, 2014 at 2:04 PM, Jason Miller wrote: > ** > I wonder if that is organization specific?

Re: Multiple level join forms

2014-01-03 Thread Charlie Lotridge
n far more manageable. Anyway, my 2 cents. Hope something in here helps. -charlie On Fri, Jan 3, 2014 at 11:30 AM, Pierson, Shawn < shawn.pier...@energytransfer.com> wrote: > ** > > I’d work with the DBAs to run sql profiler or something while running > queries again

Re: Decrypt AR User password

2013-12-30 Thread Charlie Lotridge
turn), then use ARSetEntry to update the User record with the new password. Hope this helps. Charlie On Mon, Dec 30, 2013 at 12:51 PM, James Smith wrote: > I want to allow user to change the password from API coding. > > Before updating the new password, user should confirm his old password.

Create CI from Change form?

2012-09-04 Thread Charlie Wilson
Change Management 7.5, Change form, Relationships tabbed page, Request Type field. When we choose Configuration Item from the field then the Create button is disabled. We can only use the Search button. Can someone give me a tip on what is needed for the user to be able to use the Create button

Re: Must have Asset to add CI records?

2011-09-26 Thread Charlie Wilson
licenses of fixed and floating to users who need to use AM > functions such as contract management. > > ** ** > > For all other users you can give them the license type ‘None’ and they will > be able to create and update CIs using the AST forms. > > ** ** > &

Re: Must have Asset to add CI records?

2011-09-26 Thread Charlie Wilson
aintain CIs. > > > > > -Original Message- > From: Charlie Wilson > To: arslist > Sent: Mon, Sep 26, 2011 11:38 am > Subject: Must have Asset to add CI records? > > ** We have several ITSM 7.5 applications but not Asset Management. > Obviously, CMDB is required for

Must have Asset to add CI records?

2011-09-26 Thread Charlie Wilson
We have several ITSM 7.5 applications but not Asset Management. Obviously, CMDB is required for all of the apps. Is it impossible to add and modify CI data without having a Asset Management application and Asset Admin user license? We do not wish to purchase AM for we don't need any asset manageme

Update CI Class Mappings after CI edited

2011-04-01 Thread Charlie Wilson
ms, reopened them, logged out, logged back in. Does anyone have a tip on this? Should the new attributes show up immediately? Should any particular processes be restarted? Thanks, Charlie ___ UNSUBSCRIBE or access AR

  1   2   >