Re: Limit Time Of Day a Filter Runs

2016-08-12 Thread Wallace, Kelvin
You could also create an integer field called Hour and, in the first If Action of your Filter, set the field to HOUR($TIMESTAMP$) - then do comparisons. The set fields action will set a value between 0 and 23 based on the 24-hour clock. -Original Message- From: Action Request System

Re: Limit Time Of Day a Filter Runs

2016-08-12 Thread Mueller, Doug
Todd, I see several folks have replied, but there are several questions that need to be answered first... When you say "current time is" According to WHO? And in what Timezone? Is it the server timezone you are talking about or the end user's timezone. For example, if the server is in

Re: Limit Time Of Day a Filter Runs

2016-08-12 Thread Grooms, Frederick W
I have used something like this in the past ( Substitute $TIMESTAMP$ or $SERVERTIMESTAMP$ for 'Create Date' ) Example of between 1 AM and 5 AM ('Create Date' - "1/1/70" ) % 86400) >= (1 * 3600)) AND ((('Create Date' - "1/1/70") % 86400) <= (5 * 3600 The Logic is

Smart Reporting Installation

2016-08-12 Thread Brian Pancia
Basic question here. In the documentation I only saw that is recommended not to install Smart Reporting on the same server as ARSystem. In addition to Smart Reporting we are using Analytics. We have a report server setup for Analytics already. Would you recommend loading Smart Reporting on

Re: Limit Time Of Day a Filter Runs

2016-08-12 Thread Brittain, Mark
Todd I use this one to limit the filter between Saturday, 9AM to Sunday, 9PM. ((($TIMESTAMP$ > ($DATE$ + ((60 * 60) * 9))) AND ($WEEKDAY$ = "Saturday")) OR (($TIMESTAMP$ < ($DATE$ + ((60 * 60) * 21))) AND ($WEEKDAY$ = "Sunday"))) Mark From: Action Request System discussion list(ARSList)

Re: Limit Time Of Day a Filter Runs

2016-08-12 Thread Misi Mladoniczky
Hi, I do not know if it works, but keywords are available. Run If: ($TIMESTAMP$ - $DATE$ >= 7*60*60 AND $TIMESTAMP$ - $DATE$ <= 18*60*60) 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): *

Limit Time Of Day a Filter Runs

2016-08-12 Thread Arner, Todd
We have a filter that is set up to send an email and need to limit it so that it only sends the email if the current time is between 7 AM and 6 PM. Does anyone know if there is a way to limit this maybe by adding a qualification to the run if statement? Any other ideas on how we may be able

Re: Remedy indexing at the DB level

2016-08-12 Thread Brittain, Mark
Granted I ran into this in 6.3 but after some db indexes were done, I could not manage indexing on the form at all. Couldn’ add, remove or update. So I would recommend avoiding it. Mark From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing

Re: Remedy indexing at the DB level

2016-08-12 Thread LJ LongWing
I don't think there has been a change in direction. The only possible conflict I know of is if you are creating them at the db level using a naming standard that is the same as the ones that Remedy does, and you come across a conflict. On Fri, Aug 12, 2016 at 9:47 AM, Rick Cook

Remedy indexing at the DB level

2016-08-12 Thread Rick Cook
Is anyone aware of a change in direction at BMC in terms of allowing indexes to be managed at the SQL level without affecting the ability to manage them in Remedy? ARS /ITSM 8.1.2 SQL 2012 Rick ___ UNSUBSCRIBE or access