Re: Limit Time Of Day a Filter Runs

[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 discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Friday, August 12, 2016 3:25 PM
To: arslist@ARSLIST.ORG
Subject: Re: Limit Time Of Day a Filter Runs

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 as follows   
Take the date/time and subtract the constant of the first date allowed.   This 
converts the date/time to an integer internally in seconds.   
MOD the date by the number of seconds in a day (This gives you the time of day) 
  

You can then do your comparisons 

Fred

 Original Message 
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd
Sent: Friday, August 12, 2016 12:51 PM
To: arslist@ARSLIST.ORG
Subject: Limit Time Of Day a Filter Runs

**
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 to limit the time 
of day the filter fires?

We are on ARS 8.1, and SQL 2008

Thanks in advance for any help

Todd Arner
Great Lakes

___
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: Limit Time Of Day a Filter Runs

[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 New York and the user is in Hawaii (5 hour 
time difference) and the ticket is submitted at 4:32 PM Hawaii time by the user 
in Hawaii, do you want the filter to fire? (remember, it is now 9:32 PM in New 
York where the server sits)

Is the filter tied to the submitter time?   The server time?   The assignee 
time?   Something else?

Once you address this question, you can then determine how to approach the 
problem as you have to be aware that time is not a fixed value, it is relative.

THEN, you may be able to take advantage of the $TIME$ keyword if it is relative 
to the server in some way to have a nice simple qualifier.  If something that 
depends on the submitter or the assignee, then there are lookups and 
calculations to do and then the qualifier can be on the result.

Doug Mueller

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd
Sent: Friday, August 12, 2016 10:51 AM
To: arslist@ARSLIST.ORG
Subject: Limit Time Of Day a Filter Runs

**
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 to limit the time 
of day the filter fires?

We are on ARS 8.1, and SQL 2008

Thanks in advance for any help

Todd Arner
Great Lakes

The information contained in this communication may be confidential, is 
intended only for the use of the recipient(s) named above, and may be protected 
under state or federal law. If the reader of this message is not the intended 
recipient, you are hereby notified that any dissemination, distribution, or 
copying of this communication, or any of its contents, is strictly prohibited. 
If you have received this communication in error, please forward the 
communication to no...@glhec.org immediately and 
destroy or delete the original message and any copy of it from your computer 
system. If you have any questions concerning this message, please contact the 
sender.
_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: Limit Time Of Day a Filter Runs

[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 as follows   
Take the date/time and subtract the constant of the first date allowed.   This 
converts the date/time to an integer internally in seconds.   
MOD the date by the number of seconds in a day (This gives you the time of day) 
  

You can then do your comparisons 

Fred

 Original Message 
From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd
Sent: Friday, August 12, 2016 12:51 PM
To: arslist@ARSLIST.ORG
Subject: Limit Time Of Day a Filter Runs

** 
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 to limit the time 
of day the filter fires?

We are on ARS 8.1, and SQL 2008

Thanks in advance for any help

Todd Arner
Great Lakes

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Smart Reporting Installation

[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 the 
Analytics servers, on the mid-tier server(s), or on it's own server?  If we 
have customers both inside and outside the DMZ I'm assuming we would need a 
Smart Reporting installation on both sides.


So I guess the options would be:


- Install Smart Reporting on all the Mid-Tier servers

- Install Smart Reporting on the Report servers with Analytics

- Install Smart Reporting on their own servers

- Some other recommendation


Which ever option is used we need to take the DMZ into consideration.


Thanks,


Brian


DISCLAIMER: The information contained in this e-mail and its attachments 
contain confidential information belonging to the sender, which is legally 
privileged. The information is intended only for the use of the recipient(s) 
named above. If you are not the intended recipient, you are notified that any 
disclosure, copying, distribution or action in reliance upon the contents of 
the information transmitted is strictly prohibited. If you have received this 
information in error, please delete it immediately.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Limit Time Of Day a Filter Runs

[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) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd
Sent: Friday, August 12, 2016 1:51 PM
To: arslist@ARSLIST.ORG
Subject: Limit Time Of Day a Filter Runs

**
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 to limit the time 
of day the filter fires?

We are on ARS 8.1, and SQL 2008

Thanks in advance for any help

Todd Arner
Great Lakes

The information contained in this communication may be confidential, is 
intended only for the use of the recipient(s) named above, and may be protected 
under state or federal law. If the reader of this message is not the intended 
recipient, you are hereby notified that any dissemination, distribution, or 
copying of this communication, or any of its contents, is strictly prohibited. 
If you have received this communication in error, please forward the 
communication to no...@glhec.org immediately and 
destroy or delete the original message and any copy of it from your computer 
system. If you have any questions concerning this message, please contact the 
sender.
_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: Limit Time Of Day a Filter Runs

[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):
* 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.

> 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 to limit the time
> of day the filter fires?
>
> We are on ARS 8.1, and SQL 2008
>
> Thanks in advance for any help
>
> Todd Arner
> Great Lakes
>
> --
> The information contained in this communication may be confidential, is
> intended only for the use of the recipient(s) named above, and may be
> protected under state or federal law. If the reader of this message is not the
> intended recipient, you are hereby notified that any dissemination,
> distribution, or copying of this communication, or any of its contents, is
> strictly prohibited. If you have received this communication in error, please
> forward the communication to no...@glhec.org immediately and destroy or delete
> the original message and any copy of it from your computer system. If you have
> any questions concerning this message, please contact the sender.
>
> ___
> 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"

Limit Time Of Day a Filter Runs

[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 to limit the time 
of day the filter fires?

We are on ARS 8.1, and SQL 2008

Thanks in advance for any help

Todd Arner
Great Lakes

--
The information contained in this communication may be confidential, is 
intended only for the use of the recipient(s) named above, and may be protected 
under state or federal law. If the reader of this message is not the intended 
recipient, you are hereby notified that any dissemination, distribution, or 
copying of this communication, or any of its contents, is strictly prohibited. 
If you have received this communication in error, please forward the 
communication to no...@glhec.org immediately and destroy or delete the original 
message and any copy of it from your computer system. If you have any questions 
concerning this message, please contact the sender.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Re: Remedy indexing at the DB level

[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
Sent: Friday, August 12, 2016 12:45 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy indexing at the DB level

**
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 
> wrote:
**

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
_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: Remedy indexing at the DB level

[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  wrote:

> **
>
> 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
> _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 indexing at the DB level

[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 ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"