Yes.
I'll confess to not voting this year (for the first time) since my own Remedy
involvement has diminished substantially, but I don't think that should devalue
the efforts of those contributors who bring the list to life and keep it
breathing.
___
I'm heavily dependent upon it and expect to continue to use it indefinitely.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
If you are working in SQL Server (2000 or later), the following UDF will do the
trick:
ALTER FUNCTION [dbo].[fnGetRemedyDateOnly](@Days int)
RETURNS datetime
AS
BEGIN
DECLARE @BaseDate datetime
DECLARE @TargetDate datetime
SET @BaseDate='1900-01-01'
SET @TargetDate
No, unfortunately you do not. TEST1 and test1 are interpreted as being
equivalent from the point of view of whatever procedure is looking for
associated preference servers. So if you log in as TEST1 on ServerA, and
then test1 (which should default to ServerB) ServerA shows up in the
preferen
When logging in to the user tool, is it possible to associate a particular
user with a particular preference server?
By way of example, suppose I have two users, "testuser" and "TESTUSER".
testuser is supposed to use preference server "PreferenceServer1", and
TESTUSER is supposed to use prefer
Thanks, L.J. That works exactly as you described.
Unfortunately, the example I gave did not adequately define the nature of
my problem. My two users who require different preference servers are
actually called test1 and TEST1 (utilizing case sensitivity of user names,
which apparently does
Hello.
Is it possible to permanently associate a particular user name and a given
preference server?
For example, I have users TEST1 and TEST2, and preference servers ServerA
and ServerB. I want TEST1 to always use ServerA, and TEST2 to always use
ServerB when logging in with the Desktop Clie
Hi, Joe.
If I understand your problem correctly, I think you may need a UNION query.
Something similar to that below:
SELECT Col1, Col2
FROM Table1
UNION
SELECT Col1, Col2
FROM Table2
This assumes Col1 is a compatible data type in both Table1 and Table2, as
is Col2. This will give you the ent
Thanks to all for your suggestions re. this question. I overlooked the
inclusion of IP addresses in the API log when I was checking logs as an
option, which prompted the question initially. Hooking into the login
process and capturing additional data seems the most logical approach, and
I wil
Is it possible to determine the IP address of a client workstation logging
on to Remedy as a particular user?
I have a user which is reserved for special purposes, but is periodically
appearing as logged on when I don't expect it to be. I would like to
determine the source of these logons, whi
I would like to try and gain an understanding of the mechanics behind the
Cross Ref Blank Password Windows NT login validation feature. Please note
that I am not asking for an explanation of how to implement the feature
(we've been using it for some time) but rather how it actually works - what
Apologies to the list for resending this. I meant to send it solely to
myself as a reminder. It is a very useful product!
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
On Fri, 8 Dec 2006 07:47:44 -0500, [EMAIL PROTECTED] wrote:
>Hello everyone, Happy Holidays.
>
>ARUtilities Suite is now available for half price during the month of
December.
>The sale will end January 1, 2007.
>
>ARUtilities Suite includes:
>ARUtilities 7.0
>ARUtilities 6.5
>ARUtilities 5.6
>AR
Yet another option
The following T-SQL functions convert date/time to/from Remedy and account
for GMT and Daylight Savings Time (set up for Canada):
/* NOTES on this function:
Input parameters @GetUTCDate and @GetDate expect the results of the
GetUTCDate() and GetDate()
built-in functions
What if you try an active link that executes on After Modify instead?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
I think you may need one more set of brackets. It appears that the query
always returns 1 because Request_ID = '$Request ID$' is always true and at
least one of the OR conditions is true somewhere in the
IPVPN_IPACT_Overview table.
Put another set of brackets around everything following the AND
John,
I'm not familiar with Helpdesk application but I did create something
similar for Asset Management (I think, based on your description of the
problem). In Asset Management I have a button which allows a user to copy
a Purchase Requisition (AST:PurchaseRequisition), including the details
Leigh,
Try the following statement (I've substituted a SQL-based calculation of
epoch time for the $TIMESTAMP$ value):
SELECT count(*) FROM Issue
WHERE Customer_Abbreviation = '$Customer_Abbreviation$' AND
Create_Date > (ABS(DATEDIFF(ss,GetUTCDate(),'1970-01-01')) - ($Threshold
Days$ * 24 *
ARS Server version: 6.00.01 patch 1454
Windows Server version: Windows 2000 SP4
SQL: SQL Server 2000
I have successfully automated the Sync Search process as follows in the
above environment, and have been using this for several months.
-- synchronize search database
DELETE FROM arsystem.dbo.obj
Thank you, John. It was rather clueless of me to miss that piece of
functionality in the admin tool entirely.
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
o locate a field on a form.
Ideally, if it is not possible to locate this field, I would like to remove
it entirely and attempt to recreate it, but I haven't been able to find a
way to do this either.
Any
21 matches
Mail list logo