I am trying to schedule a web report to run monthly that will pull in all
records that were created in the previous month and not sure how to format the
query. Is there a way to set up a query in Remedy that will pull all the
records created in the previous month? I appreciate any help you
If it is happening for valid values, I would suggest turn on SQL logging and
see what's going on in the backend.
Joe
_
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Abhi$hek
Sent: Wednesday, August 12, 2015 1:05 PM
To:
Hi Experts,
We are getting warning messages whenever trying out the search by filters in
change management console (version 8.1).
The Filter By menu may not be cleared, please only select valid search filters
(ARWARN 48440).
Also sometime its even not retaining the selected values from
Hi all -
System = ARS/ITSM 8.1.02 with the FTS fortifications and hotfixes in place.
We have a bizarre issue. I added a FTS index to CTM:People on the Corporate ID
field. It is indexed for both FTS and MFS.
We have incident management configured so that Customer ID is searching using
the
Thanks Chike and John for your responses. Unfortunately, I need to be exact
for the number of days In each month and was hoping there is a query that would
do that calculation rather than having to write a separate query for each month.
Thanks,
Todd
From: Action Request System discussion
You could do $TIMESTAMP$ - 2629743 to get all records for roughly the last
month. This doesn't take into account the fluctuation in days between
months though.
On Wed, Aug 12, 2015, 10:54 AM Arner, Todd tar...@glhec.org wrote:
**
I am trying to schedule a web report to run monthly that will
Hi Todd,
Try this:
'Create Date' = ($TIMESTAMP$ - 2678400)
2678400 is in seconds ( 3600 seconds * 24 hours * 31 day in a month)
Regards,
Chike
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Arner, Todd
Sent: Wednesday, August 12, 2015 10:54 AM
The (clear) option is to clear a value previously set in that field during
a submit or modify transaction - not for use during a search transaction to
search for NULL values. If you want to search for a null value, you would be
better off using the Advanced Query Bar and specify 'Field' = $NULL$
I was thinking the same thing. The increased challenge of exporting to xml
vs how many people export to xml probably wasn't worth the effort.
On Wed, Aug 12, 2015 at 9:16 AM, LJ LongWing lj.longw...@gmail.com wrote:
**
Joe,
Consider it a feature :)
First line of an XML def export is
It's happening not only for clear option but for any option
On 12 Aug 2015 21:45, Joe D'Souza jdso...@shyle.net wrote:
**
The (clear) option is to clear a value previously set in that field
during a submit or modify transaction – not for use during a search
transaction to search for NULL
If a feature I wonder what the benefit of it might be as I do not see one.
Which makes me think it's a bug.
If you select workflow objects to export, and select the export type as
.DEF, all is good. You can export your objects create the export file and
then if you missed exporting some just
Joe,
Consider it a feature :)
First line of an XML def export is
?xml version=1.0 encoding=utf-8?root
If appending more to the end, you can't add another ?xml in the middle
because you feel like it, so you can't just 'append' the same way to an XML
as you do to a defto append to an XML
Dear all,
Have some requirements for a couple of reports, one to identify all the CI
which have been created​ via ADDM/CMDB sync and a second to identify those
CIs which have been modified through reconciliation with data from a
specific source data set, ADDM to be precise and also what
Abhi - that error occurs if you inadvertently select the (clear) option
from the Filter By dropdown menu. All it means is that you must select a
real value from the Defined Searches - By Status area. There is also a
(clear) option under both the Show and the Roles menus, but they also
cannot be
Hi Stan,
Please let me know more about this opportunity. Location, permanent, etc?
I reside in Culver City, CA.
Thanks,
Jon
On Fri, Aug 7, 2015 at 12:18 PM, Stanley Feinstein
st...@projectremedies.com wrote:
**
Hi All You Senior Remedy Developers,
If you are a US citizen, have a
DEF is great for purely importing and exporting - XML is better for editing
content manually. Personally I use XML on occasions I need to edit the
definitions and DEF only if I intend to use it as is for import later
without having to edit anything.
Cheers
Joe
-Original Message-
From:
How big will an XML-export of ITSM get?
Huge. Around 800mb or so. But I wouldn't recommend exporting it all to the
same file :-)
For those purposes, I just use a separate script that queries all the
objects from the server and exports them to individual files.
Once you build a workflow cache
Todd,
I suppose that would require a little more work. After re-reading your
question, it seems you're just interested in generating the previous month's
records i.e. if you run the report on the 5th of March, you only want to get
the report for the month of February that has 28 or 29 days. Is
That's what I generally do when I want to export to XML for the purpose of
quick edits.
Examples of when this was useful to me was as Andrew pointed out when the
release version of the ARS like 7.6.3 and the earliest release of 7.6.4 was
so full of bugs that even simple workflow where menus
Hi Chike,
You are correct that I want to run the report on the 1st day of the month and
capture all the records created from the previous month, so if run on 7/1/15,
we want to see everything created 6/1/15 - 6/30/15. We are using the reporting
tool built into ARS and creating a report type of
Why use XML definition files?
It just adds a tremendous amount of tags
resulting in enormous files...
Because it's awesome, that's why!
I can extract (nearly all) the workflow and forms from an entire server and
I can parse them with xpath.
That is a HUGE capability. I've found and fixed some
Please do not respond to ARSList. Contact the job offerer directly
-Original Message-
From: Jon Chau jonl.c...@gmail.com
To: arslist arslist@ARSLIST.ORG
Sent: Wed, Aug 12, 2015 1:34 pm
Subject: Re: Good opportunity.
**
Hi Stan,
Please let me know more about this
Hi Andrew,
You are right, there are uses for the XML format.
I have written perl parsers for the DEF format instead, as the XML format gave
files that was too big. I am talking about complete exports of a whole system.
How big will an XML-export of ITSM get?
Best Regards - Misi, RRR AB,
Hi,
Updating XML is much more complicated. On DEF files you can just append
additional objects at the end.
To update XML in a correct way you should parse and validate the complete
XML-file before you add the extra content and save it to disc again. This
would be a client exercise, and it would
I was thinking that too but then it could as you have pointed out still be
possible by stripping the body of the XM, appending additional content and
then sticking it in there.
Joe
_
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ
I have since some time relied more on XML than DEF in the event I wanted to
modify the content using Notepad++ or a text editor. It's so much easier to
do such edits on XML than a DEF file.
Joe
_
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On
Todd,
With that in mind.you can take a MONTH($DATE$) to capture today's month
value, then from that you can build a query of 'DateField' month-1/1/year
AND 'DateField month/1/year and then pass that as the qualification to
the report...it'll take a bit (truly not much) workflow to grab the
Looks like LJs nailed it.
Regards,
Chike
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing
Sent: Wednesday, August 12, 2015 3:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Query question
**
Todd,
With that in mind.you can take a
28 matches
Mail list logo