Re: Use of Modulus in Queries

2014-06-05 Thread Arner, Todd
Thanks everyone for your input. I guess I need to go have my bifocals checked. I didn't see the extra space in my original query. Todd From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Thursday, June 05, 2014 2:00 PM To: arslis

Re: Use of Modulus in Queries

2014-06-05 Thread Pierson, Shawn
So if I combine everyone's queries, I can use something like this to generate a list of all Incidents created outside of normal business hours in the month of May. That's really cool. (('Submit Date'>= "05/01/2014") AND ('Submit Date'< "06/01/2014")) AND (('Submit Date' - "1/1/70") % 86400

Re: Use of Modulus in Queries

2014-06-05 Thread Hennigan, Sandra
Try this one, starts after hours Incidents at 1800: (('Submit Date'>= "05/01/2014") AND ('Submit Date'< "06/01/2014")) AND (('Submit Date' - "1/1/70") % 86400) >= 17 * 3600) AND ((('Submit Date' - "1/1/70" ) % 86400) <= 24 * 3600 Change the month/day in (('Submit Date'>= "05/01/2014") A

Re: Use of Modulus in Queries

2014-06-05 Thread Lucero, Michelle
Hi, Todd: We're on ARS 8.1.xx. I tried the query below in Work Order and worked. You do have a space between the single quote and the "C" in 'Create Date' This happens to be a "find records reported on a particular day of the week" 'Status*' <= 3 AND '3'- "01/01/70") % (7*86400)) >= (2*86

Re: Remedy Developer Performance Metrics

2014-06-05 Thread JD Hood
Hmmm... If the bugs could be traced to a given developers competency rather than due to conflicting or poor reqs and/or otherwise "unintended consequences of the reqs", you are likely on to something... But shouldn't we already be capturing something along those lines from the root causes identifi

Re: Remedy Developer Performance Metrics

2014-06-05 Thread Rick Cook
Totally with you, JD! Rick On Thu, Jun 5, 2014 at 6:50 AM, JD Hood wrote: > ** > The thought of trying to measure something as fungible as development -- > given that there is usually more than "nine way to skin a cat" in Remedy -- > tends to make me believe the idea stems from a manager with

Use of Modulus in Queries

2014-06-05 Thread Arner, Todd
Hello Everyone, In the past, we have used the modulus to run queries to see all Incidents that were created during a specific timeframe, for instance any incident created between 7:00 and 9:00 PM. Below is the query we used: (('Create Date'-"01/01/1970")%86400) > 68400 AND (('Create Date'-"01/

Re: Remedy Developer Performance Metrics

2014-06-05 Thread Roney Samuel Varghese.
A good start for metrics could be the number of bugs/issues raised against a development effort and the number of occurrences of the same behavior over a period of time. Regards, Roney Samuel Varghese. Sent from my iPhone > On Jun 5, 2014, at 8:50 AM, JD Hood wrote: > > ** > The thought of

Re: Installing Additional Language Pack for ARS 7.6.04

2014-06-05 Thread Ben Cantatore
Rajiv, The language packs will mostly help you with the out of the box forms. Essentially they create multiple views of the form in the language installed. Also, your database will need unicode set prior to installing the language packs. So if you have a mostly custom system, you'll not bene

Re: Remedy Developer Performance Metrics

2014-06-05 Thread JD Hood
The thought of trying to measure something as fungible as development -- given that there is usually more than "nine way to skin a cat" in Remedy -- tends to make me believe the idea stems from a manager with far too much time on their hands. And as far as measuring development, I would think you

Re: Service Action to Push data

2014-06-05 Thread LJ LongWing
Vikrant, Unfortunately (or fortunately, depending on your stance on the subject), I don't have access to an ITSM install at the moment, so my ability to answer that question is limited. On Thu, Jun 5, 2014 at 2:05 AM, Vikrant Kulkarni wrote: > ** > > Thanks LJ for the input... I finally got it

Tomcat is creating 2 extra sessions when user logs out

2014-06-05 Thread John Baker
Hello Well that's a lovely little bug. I guess they must be trying to copy the contents of an old session to a new one or something? Why don't you start by reviewing a Fiddler trace to see if the new JSESSIONID appears in the trace, and look at how the browser may be affecting it? John ___

Re: Remedy Developer Performance Metrics

2014-06-05 Thread Ken Pritchard
This discussion / argument is no different than what we dealt with in the 1980's. How do you measure Quality. During that time I headed up a software testing group that was working on automated testing (we actually built our own tool back in the days of (dare I mention it) DOS. We tried to measu

Tomcat is creating 2 extra sessions when user logs out

2014-06-05 Thread MOHAMMED FAROOQ BABA
Hi, Tomcat is creating 2 extra sessions when user logs out. we are using Tomcat 7 with MT 8.1.01 with ARS 8.1. Issue and scenario: When user login in to ITSM through Mid-Tier, one session will be created for one user. Once user clicks on log-out button, we are able to see created session is

Re: Remedy Developer Performance Metrics

2014-06-05 Thread Theo Fondse
" . Fast, Accurate, Cheap Pick two.." - Matt Black On Thu, Jun 5, 2014 at 10:55 AM, Danny Kellett < dkell...@javasystemsolutions.com> wrote: > ** > Quantity != Quality > > -- > Danny Kellett > dkell...@javasystemsolutions.com > > > > On Thu, Jun 5, 2014, at 09:31 AM, Theo Fondse wrot

Re: Remedy Developer Performance Metrics

2014-06-05 Thread Danny Kellett
Quantity != Quality -- Danny Kellett dkell...@javasystemsolutions.com On Thu, Jun 5, 2014, at 09:31 AM, Theo Fondse wrote: ** Hi Charlie! Although I have grown over the past few years to fully agree with LJ on this subject, I can also understand the need for metrics to have something to

Re: Remedy Developer Performance Metrics

2014-06-05 Thread Theo Fondse
Hi Charlie! Although I have grown over the past few years to fully agree with LJ on this subject, I can also understand the need for metrics to have something to go by to know if our performance is on-par or not. Sadly, measurements in the LOC style no longer give a true picture of actual performa

Re: Service Action to Push data

2014-06-05 Thread Vikrant Kulkarni
Thanks LJ for the input... I finally got it to work.. But still can you help me understand the logic of Asset user not being able to relate a Computer System CI and a role. Both the records that I need to relate do exist so no new CI is created just a relationship is established by the asset user