Re: Archiving SLM:Measurement

[William Rentfrow]

We are investigating some changes now - we've also done some tuning via
Oracle profiles (and by "we" I mean the dba's).



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Phil Murnane
Sent: Friday, December 19, 2008 1:35 PM
To: arslist@ARSLIST.ORG
Subject: Re: Archiving SLM:Measurement


** 
William:

At one customer site, we added some indexes to help those Push Fields If
conditions and avoid the table scans.  SLM benefits quite a bit from
some DB tuning.  So does the DSL, but that's another topic. :)

--Phil




From: Howard Richter 
To: arslist@ARSLIST.ORG
Sent: Friday, December 19, 2008 11:53:26 AM
Subject: Re: Archiving SLM:Measurement

** 
Bill,
 
On my past two systems (that had SLM) we trashed anything in the
SLM:Measurement, older then 30 days and that was not tied to active
ticket. I think we were able to report, but I don't remember from where.
 
hbr


On Fri, Dec 19, 2008 at 12:35 PM, William Rentfrow
 wrote:


** 
It's Friday and I have some other stuff to finish today so I
haven't gotten too far into researching this yet - so I thought I'd ask
if anyone else has a solution for this already.
 
Problem: SLM:Measurement is gigantic.  We have 240,000 requests
in HPD:Help Desk (IM 7.x) and 4,400,000+ SLM:Measurement records.
 
My gut feeling is to just archive off all of the records that
are closed and refer the reporting people to that table when they want
to run reports; however, I have not yet investigated the ramifications
of doing this.
 
Has anyone else?  
 

William Rentfrow

Principal Consultant, StrataCom Inc.

wrentf...@stratacominc.com

701-306-6157 C

952-432-0227 O

 
__Platinum Sponsor: www.rmsportal.com
  ARSlist: "Where the Answers Are" html___ 




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Some general Change Management questions

[Drake,Dave]

We just implemented the Change Management module and I have a few other 
questions that I'm hoping you may know the answer to.  Both questions are 
actually relating to approvals of change requests.
1.  How can you set up an approval rule to allow a specific number of 
approvers (say you have 5 approvers listed but only need 2 or 3 to approve in 
order to consider the request approved).  We received a document on the 
approval server that mentions how to set up a Signature Accumulator rule but 
the details in the guide didn't provide enough information.
2.  When we have approval mapping rules set up to assign multiple approvers 
simultaneously only the 1st approver is sent an email notification with a URL 
to the mid-tier approval form.  The other approvers are not notified.  Is this 
a configuration problem?  Is there a way to change this without creating a 
custom filter or escalation?

Thanks!

ARS 7.0.1 p007, CMDB 2.0.1, ITSM 7.0.3 p007

--
CONFIDENTIALITY NOTICE This message and any included attachments are from 
Cerner Corporation and are intended only for the addressee. The information 
contained in this message is confidential and may constitute inside or 
non-public information under international, federal, or state securities laws. 
Unauthorized forwarding, printing, copying, distribution, or use of such 
information is strictly prohibited and may be unlawful. If you are not the 
addressee, please promptly delete this message and notify the sender of the 
delivery error by e-mail or you may call Cerner's corporate offices in Kansas 
City, Missouri, U.S.A at (+1) (816)221-1024.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Archiving SLM:Measurement

[Phil Murnane]

William:

At one customer site, we added some indexes to help those Push Fields If 
conditions and avoid the table scans.  SLM benefits quite a bit from some DB 
tuning.  So does the DSL, but that's another topic. :)

--Phil





From: Howard Richter 
To: arslist@ARSLIST.ORG
Sent: Friday, December 19, 2008 11:53:26 AM
Subject: Re: Archiving SLM:Measurement

** 
Bill,
 
On my past two systems (that had SLM) we trashed anything in the 
SLM:Measurement, older then 30 days and that was not tied to active ticket. I 
think we were able to report, but I don't remember from where.
 
hbr


On Fri, Dec 19, 2008 at 12:35 PM, William Rentfrow  
wrote:

** 
It's Friday and I have some other stuff to finish today so I haven't gotten too 
far into researching this yet - so I thought I'd ask if anyone else has a 
solution for this already.
 
Problem: SLM:Measurement is gigantic.  We have 240,000 requests in HPD:Help 
Desk (IM 7.x) and 4,400,000+ SLM:Measurement records.
 
My gut feeling is to just archive off all of the records that are closed and 
refer the reporting people to that table when they want to run reports; 
however, I have not yet investigated the ramifications of doing this.
 
Has anyone else?  
 
William Rentfrow
Principal Consultant, StrataCom Inc.
wrentf...@stratacominc.com
701-306-6157 C
952-432-0227 O
 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 


-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
  

Re: Group/User Notifications.

[Brien Dieterle]

I didn't think about that too long, obviously :-).  You'll still have to
walk a table (if joined) or tableS (not joined), in any case, right?

Come to think of it, shouldn't the parent form already have a a table field
with the child incidents displayed?  And the Child incident probably already
has a table field listing the related tasks, right?  So, you just need two
Filter guides, and also add assigned to and assignee group to both table
fields (hidden?).  The Filter guide on the child incident form walks the
task table field and collects assigned_to and assignee group concatenated to
two fields on that form (which are then added to the Child Incident table
field on the Parent Incident form).  Another filter guide does the same
thing on the parent incident form, but also collects the two fields that are
the list of tasks.  The filter guides are triggered on modify and submit.
The button that adds children and tasks can also run process set-change-flag
1 to ensure the modify filter runs every time something is added.

I'm probably missing something but I think that is generally how I did
something similar.  Good luck!

Brien

On Fri, Dec 19, 2008 at 11:31 AM, Brien Dieterle <
brien.diete...@cgcmail.maricopa.edu> wrote:

> Couldn't the table fields be hidden or even on a separate view and then
> walked by AL Guides?  Or, another idea, create Join forms for the
> Parent/Child, include assigned to and assignee group for both forms (4
> fields) and the parent requestID.  Then join that to the task form, include
> assigned to and assignee  group (2 fields).  Then when you press that button
> do a set fields to lookup all 6 pieces of information from just the one
> master join form and set a display-only field to that to be included in the
> notify?  I think you would do a $assigned_to_parent$ + 
> $assignee_group_parent$ + etc.
>
> Brien
>
>
> On Fri, Dec 19, 2008 at 4:19 AM, Frex Popo  wrote:
>
>> ** Thanks Robert
>> The incident form we have is overloded with tones of fileds, field tables,
>> attachment tables and the rest of it, so I am trying to avoid using tables
>> and instead was thinking about an additional form ... anyway, I will think a
>> little bit about it and let you know if I manage to resolve it.
>>
>> Have a nice weekend
>> frex
>>
>>
>> --- En date de : *Jeu 18.12.08, Robert Halstead * a
>> écrit :
>>
>> De: Robert Halstead 
>> Objet: Re: Group/User Notifications.
>> À: arslist@ARSLIST.ORG
>> Date: Jeudi 18 Décembre 2008, 21h24
>>
>> ** This is just a thought, but you could build a table field on the
>> incident form of all the child tickets for that parent, and another for all
>> the tasks related.. I guess the problem would be getting all the tasks that
>> were related to the children and parent..   Essentially, you could walk a
>> table and build your recipients list that way.
>>
>> On Thu, Dec 18, 2008 at 7:49 AM, Frex Popo  wrote:
>>
>>> **   Hello everyone,
>>>
>>> I have a number of child Incidents linked to a parent Incident. Each
>>> child Incident has a number of tasks.
>>>
>>> What I need is, when a user presses a button on the Incident form, a
>>> notification is sent to the user whom THE PARENT INCIDENT has been assigned
>>> to, (or the group in case the incident has not been assigned to anyone yet).
>>>
>>>
>>> The notification should also be sent to the user to which THE CHILD
>>> INCIDENT t has been assigned to (or the group in case the child incident has
>>> not been assigned to anyone). The same for all the child Incidents of the
>>> parent Incident.
>>>
>>> The notification should also be sent to the user to which THE TASK of the
>>> child incident has been assigned to (or the group in case the task has not
>>> been assigned to anyone). The same should apply to all the tasks of each
>>> child Incident.
>>>
>>> What would the best way to approach this problem?
>>>
>>> Is it by creating a form and storing the ID of the parent incident, child
>>> incidents, and taks, along with all the group and users and then use a
>>> filter on submit to that form and send a notification?
>>>
>>> How about walking through the incident and taks form to find the relevant
>>> IDs?
>>>
>>> Anyone did before and want to share their thoughts.
>>>
>>> Thanks in advance
>>> frex.
>>>
>>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>>> html___
>>
>>
>>
>>
>> --
>> "A fool acts, regardless; knowing well that he is wrong. The ignoramus
>> acts on only what he knows, but all that he knows.
>> The ignoramus may be saved, but the fool knows that he is doomed."
>>
>> Robert Halstead
>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>> html___
>>
>>
>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>> html___
>>
>
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Archiving SLM:Measurement

[Howard Richter]

Bill,

On my past two systems (that had SLM) we trashed anything in the
SLM:Measurement, older then 30 days and that was not tied to active ticket.
I think we were able to report, but I don't remember from where.

hbr

On Fri, Dec 19, 2008 at 12:35 PM, William Rentfrow <
wrentf...@stratacominc.com> wrote:

> ** It's Friday and I have some other stuff to finish today so I haven't
> gotten too far into researching this yet - so I thought I'd ask if anyone
> else has a solution for this already.
>
> Problem: SLM:Measurement is gigantic.  We have 240,000 requests in HPD:Help
> Desk (IM 7.x) and 4,400,000+ SLM:Measurement records.
>
> My gut feeling is to just archive off all of the records that are closed
> and refer the reporting people to that table when they want to run reports;
> however, I have not yet investigated the ramifications of doing this.
>
> Has anyone else?
>
>
> William Rentfrow
>
> Principal Consultant, StrataCom Inc.
>
> wrentf...@stratacominc.com
>
> 701-306-6157 C
>
> 952-432-0227 O
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Archiving SLM:Measurement

[William Rentfrow]

There are some pretty severe Oracle performance problems we had to
address - the "Push fields if" filters that fire to populate the form
end up causing many, many table scans.



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Phil Murnane
Sent: Friday, December 19, 2008 12:44 PM
To: arslist@ARSLIST.ORG
Subject: Re: Archiving SLM:Measurement


** 
William:

Sounds like a pretty good solution to me.  Just out of curiosity, are
you seeing performance problems due to the 4.5M records in
SLM:Measurement?

--Phil




From: William Rentfrow 
To: arslist@ARSLIST.ORG
Sent: Friday, December 19, 2008 10:35:06 AM
Subject: Archiving SLM:Measurement

** 
It's Friday and I have some other stuff to finish today so I haven't
gotten too far into researching this yet - so I thought I'd ask if
anyone else has a solution for this already.
 
Problem: SLM:Measurement is gigantic.  We have 240,000 requests in
HPD:Help Desk (IM 7.x) and 4,400,000+ SLM:Measurement records.
 
My gut feeling is to just archive off all of the records that are closed
and refer the reporting people to that table when they want to run
reports; however, I have not yet investigated the ramifications of doing
this.
 
Has anyone else?  
 

William Rentfrow 

Principal Consultant, StrataCom Inc.

wrentf...@stratacominc.com

701-306-6157 C

952-432-0227 O

 
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Archiving SLM:Measurement

[Phil Murnane]

William:

Sounds like a pretty good solution to me.  Just out of curiosity, are you 
seeing performance problems due to the 4.5M records in SLM:Measurement?

--Phil





From: William Rentfrow 
To: arslist@ARSLIST.ORG
Sent: Friday, December 19, 2008 10:35:06 AM
Subject: Archiving SLM:Measurement

** 
It's Friday and I 
have some other stuff to finish today so I haven't gotten too far into 
researching this yet - so I thought I'd ask if anyone else has a solution for 
this already.
 
Problem: 
SLM:Measurement is gigantic.  We have 240,000 requests in HPD:Help Desk (IM 
7.x) and 4,400,000+ SLM:Measurement records.
 
My gut feeling is to 
just archive off all of the records that are closed and refer the reporting 
people to that table when they want to run reports; however, I have not yet 
investigated the ramifications of doing this.
 
Has anyone 
else?  
 
William Rentfrow 
Principal Consultant, StrataCom 
Inc.
wrentf...@stratacominc.com
701-306-6157 C
952-432-0227 
O
 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 



___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
  

Re: Group/User Notifications.

[Brien Dieterle]

Couldn't the table fields be hidden or even on a separate view and then
walked by AL Guides?  Or, another idea, create Join forms for the
Parent/Child, include assigned to and assignee group for both forms (4
fields) and the parent requestID.  Then join that to the task form, include
assigned to and assignee  group (2 fields).  Then when you press that button
do a set fields to lookup all 6 pieces of information from just the one
master join form and set a display-only field to that to be included in the
notify?  I think you would do a $assigned_to_parent$ + 
$assignee_group_parent$ + etc.

Brien

On Fri, Dec 19, 2008 at 4:19 AM, Frex Popo  wrote:

> ** Thanks Robert
> The incident form we have is overloded with tones of fileds, field tables,
> attachment tables and the rest of it, so I am trying to avoid using tables
> and instead was thinking about an additional form ... anyway, I will think a
> little bit about it and let you know if I manage to resolve it.
>
> Have a nice weekend
> frex
>
>
> --- En date de : *Jeu 18.12.08, Robert Halstead * a
> écrit :
>
> De: Robert Halstead 
> Objet: Re: Group/User Notifications.
> À: arslist@ARSLIST.ORG
> Date: Jeudi 18 Décembre 2008, 21h24
>
> ** This is just a thought, but you could build a table field on the
> incident form of all the child tickets for that parent, and another for all
> the tasks related.. I guess the problem would be getting all the tasks that
> were related to the children and parent..   Essentially, you could walk a
> table and build your recipients list that way.
>
> On Thu, Dec 18, 2008 at 7:49 AM, Frex Popo  wrote:
>
>> **   Hello everyone,
>>
>> I have a number of child Incidents linked to a parent Incident. Each child
>> Incident has a number of tasks.
>>
>> What I need is, when a user presses a button on the Incident form, a
>> notification is sent to the user whom THE PARENT INCIDENT has been assigned
>> to, (or the group in case the incident has not been assigned to anyone yet).
>>
>>
>> The notification should also be sent to the user to which THE CHILD
>> INCIDENT t has been assigned to (or the group in case the child incident has
>> not been assigned to anyone). The same for all the child Incidents of the
>> parent Incident.
>>
>> The notification should also be sent to the user to which THE TASK of the
>> child incident has been assigned to (or the group in case the task has not
>> been assigned to anyone). The same should apply to all the tasks of each
>> child Incident.
>>
>> What would the best way to approach this problem?
>>
>> Is it by creating a form and storing the ID of the parent incident, child
>> incidents, and taks, along with all the group and users and then use a
>> filter on submit to that form and send a notification?
>>
>> How about walking through the incident and taks form to find the relevant
>> IDs?
>>
>> Anyone did before and want to share their thoughts.
>>
>> Thanks in advance
>> frex.
>>
>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>> html___
>
>
>
>
> --
> "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts
> on only what he knows, but all that he knows.
> The ignoramus may be saved, but the fool knows that he is doomed."
>
> Robert Halstead
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Log File Question...

[Richard Copits]

Thank you - that  gives us a good starting place...

 

From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of William Rentfrow
Sent: Friday, December 19, 2008 12:30 PM
To: arslist@ARSLIST.ORG
Subject: Re: Log File Question...

 

** 

Can you defined "entered some service desk tickets..." a little more?
Did they enter them from the Support Console?  From the Requester
Console?

 

Typically I'd start this with user-side API/AL/Filter logs - you may
have to put them in the admin group (or change the client side logging
group) but since this is a test server I'll assume that's not an issue.

 

Once you get that look for all +CE entries in the log file - this is
where the create entry starts via the API.

 

Needless to say there are dozens of correct ways to go about
troubleshooting this.  My gut instinct says your user was using the
requester module and you are not configured to have those requests
create incidents automatically.

 



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Richard Copits
Sent: Friday, December 19, 2008 9:59 AM
To: arslist@ARSLIST.ORG
Subject: Log File Question...

** 

We just got our 7.1 system up and running in test mode. We have a user

who says that they entered some service desk tickets but now they don't

seem to be there. We'd like to use the log files to see if we can tell
what's

happening, but there are a ton of log files. Which ones might be of the
most

help to us to see/track what's happening with the tickets? We're
brand-new

to this so all help/suggestions are appreciated. Thank you!


Portions of this message may be confidential under an exemption to
Ohio's public records law or under a legal privilege. If you have
received this message in error or due to an unauthorized transmission or
interception, please delete all copies from your system without
disclosing, copying, or transmitting this message. __Platinum Sponsor:
www.rmsportal.com ARSlist: "Where the Answers Are" html___ 

__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 



Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Archiving SLM:Measurement

[William Rentfrow]

It's Friday and I have some other stuff to finish today so I haven't
gotten too far into researching this yet - so I thought I'd ask if
anyone else has a solution for this already.
 
Problem: SLM:Measurement is gigantic.  We have 240,000 requests in
HPD:Help Desk (IM 7.x) and 4,400,000+ SLM:Measurement records.
 
My gut feeling is to just archive off all of the records that are closed
and refer the reporting people to that table when they want to run
reports; however, I have not yet investigated the ramifications of doing
this.
 
Has anyone else?  
 

William Rentfrow

Principal Consultant, StrataCom Inc.

wrentf...@stratacominc.com

701-306-6157 C

952-432-0227 O

 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Log File Question...

[William Rentfrow]

Can you defined "entered some service desk tickets..." a little more?
Did they enter them from the Support Console?  From the Requester
Console?
 
Typically I'd start this with user-side API/AL/Filter logs - you may
have to put them in the admin group (or change the client side logging
group) but since this is a test server I'll assume that's not an issue.
 
Once you get that look for all +CE entries in the log file - this is
where the create entry starts via the API.
 
Needless to say there are dozens of correct ways to go about
troubleshooting this.  My gut instinct says your user was using the
requester module and you are not configured to have those requests
create incidents automatically.



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Richard Copits
Sent: Friday, December 19, 2008 9:59 AM
To: arslist@ARSLIST.ORG
Subject: Log File Question...


** 

We just got our 7.1 system up and running in test mode. We have a user

who says that they entered some service desk tickets but now they don't

seem to be there. We'd like to use the log files to see if we can tell
what's

happening, but there are a ton of log files. Which ones might be of the
most

help to us to see/track what's happening with the tickets? We're
brand-new

to this so all help/suggestions are appreciated. Thank you!


Portions of this message may be confidential under an exemption to
Ohio's public records law or under a legal privilege. If you have
received this message in error or due to an unauthorized transmission or
interception, please delete all copies from your system without
disclosing, copying, or transmitting this message. __Platinum Sponsor:
www.rmsportal.com ARSlist: "Where the Answers Are" html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: 6.3 archive forms

[William Rentfrow]

We just archived 1.2 million records :)  I feel your pain



From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Howard Richter
Sent: Friday, December 19, 2008 11:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: 6.3 archive forms


** 

Bill,

 

I always had issues using the archiving function on 6.3, maybe others
had better luck, but I stayed away from it. Now in 7. it did work and
worked very well.

 

Just an example in 6.3 I tried to use it for the e-mail messages form.
There appeared to be a record limit on the receiving form as well as one
on the main one. Needless to say with the help of support we re-imported
the mail messages form and used a little workflow to save off data.


On Fri, Dec 19, 2008 at 11:48 AM, William Rentfrow
 wrote:


** 
I am working on an old server on and off doing some archiving
for a customer.  I'm so used to 7 now I can't remember all the
differences between 6.3 and 7 when it comes to archive forms - and I
haven't worked with modifying them all that much anyway...
 
Case in point - we've archived the main issue form from CSS
(SPRT:Issue) and the system created a backup of the form.  Consequently
one of the tables that shows child records is broken because the ID
field needs to be re-directed to the archive form "Original Issue ID" -
not a bid deal there...
 
Howeverwhen I try to edit the table field and open the
properties to the "table properties" tab I just get a blank "Not
applicable" tab.  This also happens if I copy the control and try to
create a new one.
 
Was this a limitation in the 6.3 app?  You can't change anything
on the form?  Or is there a way around this?
 

William Rentfrow

Principal Consultant, StrataCom Inc.

wrentf...@stratacominc.com

701-306-6157 C

952-432-0227 O

 
__Platinum Sponsor: www.rmsportal.com
  ARSlist: "Where the Answers Are" html___ 




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified 
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___ 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: 6.3 archive forms

[Howard Richter]

Bill,



I always had issues using the archiving function on 6.3, maybe others had
better luck, but I stayed away from it. Now in 7. it did work and worked
very well.



Just an example in 6.3 I tried to use it for the e-mail messages form. There
appeared to be a record limit on the receiving form as well as one on the
main one. Needless to say with the help of support we re-imported the mail
messages form and used a little workflow to save off data.

On Fri, Dec 19, 2008 at 11:48 AM, William Rentfrow <
wrentf...@stratacominc.com> wrote:

> ** I am working on an old server on and off doing some archiving for a
> customer.  I'm so used to 7 now I can't remember all the differences between
> 6.3 and 7 when it comes to archive forms - and I haven't worked with
> modifying them all that much anyway...
>
> Case in point - we've archived the main issue form from CSS (SPRT:Issue)
> and the system created a backup of the form.  Consequently one of the tables
> that shows child records is broken because the ID field needs to be
> re-directed to the archive form "Original Issue ID" - not a bid deal
> there...
>
> Howeverwhen I try to edit the table field and open the properties to
> the "table properties" tab I just get a blank "Not applicable" tab.  This
> also happens if I copy the control and try to create a new one.
>
> Was this a limitation in the 6.3 app?  You can't change anything on the
> form?  Or is there a way around this?
>
>
> William Rentfrow
>
> Principal Consultant, StrataCom Inc.
>
> wrentf...@stratacominc.com
>
> 701-306-6157 C
>
> 952-432-0227 O
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

6.3 archive forms

[William Rentfrow]

I am working on an old server on and off doing some archiving for a
customer.  I'm so used to 7 now I can't remember all the differences
between 6.3 and 7 when it comes to archive forms - and I haven't worked
with modifying them all that much anyway...
 
Case in point - we've archived the main issue form from CSS (SPRT:Issue)
and the system created a backup of the form.  Consequently one of the
tables that shows child records is broken because the ID field needs to
be re-directed to the archive form "Original Issue ID" - not a bid deal
there...
 
Howeverwhen I try to edit the table field and open the properties to
the "table properties" tab I just get a blank "Not applicable" tab.
This also happens if I copy the control and try to create a new one.
 
Was this a limitation in the 6.3 app?  You can't change anything on the
form?  Or is there a way around this?
 

William Rentfrow

Principal Consultant, StrataCom Inc.

wrentf...@stratacominc.com

701-306-6157 C

952-432-0227 O

 

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Log File Question...

[Richard Copits]

We just got our 7.1 system up and running in test mode. We have a user

who says that they entered some service desk tickets but now they don't

seem to be there. We'd like to use the log files to see if we can tell
what's

happening, but there are a ton of log files. Which ones might be of the
most

help to us to see/track what's happening with the tickets? We're
brand-new

to this so all help/suggestions are appreciated. Thank you!


Portions of this message may be confidential under an exemption to Ohio's 
public records law or under a legal privilege. If you have received this 
message in error or due to an unauthorized transmission or interception, please 
delete all copies from your system without disclosing, copying, or transmitting 
this message.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Getting the Current Form Name

[LJ Longwing]

In 7.x the form's view is stored in the arschema table for any form
created/modified since the upgrade to 7.x 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of RFrench
Sent: Friday, December 19, 2008 6:40 AM
To: arslist@ARSLIST.ORG
Subject: Re: Getting the Current Form Name

If you have a look at this thread it will give you some more information
http://n2.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-st
ructure-tt1562658.html#none
http://n2.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-st
ructure-tt1562658.html#none 

I am not sure if it is possible to take the name of a form and create a
query to list the view name.  However the form name is very close to the
view that the data is stored in.  This is what the database reference says
about form and view names

SQL views
For each table that is built in the system (except for the attachment
tables), an SQL view is automatically created. This view uses the form name
as the view name and the field names (not a display label in one of the
views) as the column names. The names are created by using the following
rules:

 All alphabetic and numeric characters remain as defined.

 All other characters are converted to an underscore (_).

 If the first character is not alphanumeric, a leading A is added to the
name.

 If the name of a field is blank, a field name with a leading A followed by
the fieldId is used.

 If the name is one of the reserved words for the database, the string _x
is appended. 

--
View this message in context:
http://www.nabble.com/Getting-the-Current-Form-Name-tp21037113p21091452.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:
www.rmsportal.com ARSlist: "Where the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: JOBAIDS?

[Howard Richter]

Maybe its a tool kit built by one of the partners (docs and some example
code).

Howard

On Fri, Dec 19, 2008 at 8:59 AM, Warren Baltimore  wrote:

> ** I just spoke with my Remedy Admin - Cindy Hegge.  She worked as a Remedy
> Instructor for some years.  She's never heard of it
>
> On Thu, Dec 18, 2008 at 3:28 PM, Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE <
> norm.kai...@eglin.af.mil> wrote:
>
>> That's what I suspected, too, but this admin insists it's some
>> executables she used in a Remedy class.
>>
>> -Original Message-
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
>> Sent: Thursday, December 18, 2008 1:49 PM
>> To: arslist@ARSLIST.ORG
>> Subject: Re: JOBAIDS?
>>
>> **
>>
>> I'm pretty sure that jobs aids are just a fancy term for documentation.
>>
>>
>>
>> From: Action Request System discussion list(ARSList)
>> [mailto:arsl...@arslist.org] On Behalf Of Kaiser, Norm E CIV USAF AFMC
>> 96 CS/SCCE
>> Sent: Thursday, December 18, 2008 1:42 PM
>> To: arslist@ARSLIST.ORG
>> Subject: JOBAIDS?
>>
>>
>>
>> **
>>
>> Is anyone here familiar with a bundle of resources called JOBAIDS?
>> Another developer I work with says she needs it...I'm not familiar with
>> it.
>>
>>
>>
>> Anyone know about it and where I might get it?
>>
>>
>>
>> Thanks,
>>
>> Norm
>>
>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>> html___
>>
>> Private and confidential as detailed here
>>  . If you cannot access
>> hyperlink, please e-mail sender.
>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>> html___
>>
>>
>> ___
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>>  Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>>
>
>
>
> --
> Warren R. Baltimore II
> Remedy Developer
> 410-533-5367
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___




-- 
Howard Richter
Red Hat Certified Technician
CompTIA Linux+ Certified
ITIL Foundation Certified
E-Mail = hbr4...@gmail.com
LinkedIn Profile = http://www.linkedin.com/in/hbr4270

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: JOBAIDS?

[Warren Baltimore]

I just spoke with my Remedy Admin - Cindy Hegge.  She worked as a Remedy
Instructor for some years.  She's never heard of it

On Thu, Dec 18, 2008 at 3:28 PM, Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE <
norm.kai...@eglin.af.mil> wrote:

> That's what I suspected, too, but this admin insists it's some
> executables she used in a Remedy class.
>
> -Original Message-
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn
> Sent: Thursday, December 18, 2008 1:49 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: JOBAIDS?
>
> **
>
> I'm pretty sure that jobs aids are just a fancy term for documentation.
>
>
>
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Kaiser, Norm E CIV USAF AFMC
> 96 CS/SCCE
> Sent: Thursday, December 18, 2008 1:42 PM
> To: arslist@ARSLIST.ORG
> Subject: JOBAIDS?
>
>
>
> **
>
> Is anyone here familiar with a bundle of resources called JOBAIDS?
> Another developer I work with says she needs it...I'm not familiar with
> it.
>
>
>
> Anyone know about it and where I might get it?
>
>
>
> Thanks,
>
> Norm
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
> Private and confidential as detailed here
>  . If you cannot access
> hyperlink, please e-mail sender.
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
>
> ___
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>  Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>



-- 
Warren R. Baltimore II
Remedy Developer
410-533-5367

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Getting the Current Form Name

[RFrench]

If you have a look at this thread it will give you some more information
http://n2.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tt1562658.html#none
http://n2.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tt1562658.html#none
 

I am not sure if it is possible to take the name of a form and create a
query to list the view name.  However the form name is very close to the
view that the data is stored in.  This is what the database reference says
about form and view names

SQL views
For each table that is built in the system (except for the attachment
tables),
an SQL view is automatically created. This view uses the form name as the
view name and the field names (not a display label in one of the views) as
the
column names. The names are created by using the following rules:

 All alphabetic and numeric characters remain as defined.

 All other characters are converted to an underscore (_).

 If the first character is not alphanumeric, a leading A is added to the
name.

 If the name of a field is blank, a field name with a leading A followed by
the
fieldId is used.

 If the name is one of the reserved words for the database, the string _x
is
appended. 

-- 
View this message in context: 
http://www.nabble.com/Getting-the-Current-Form-Name-tp21037113p21091452.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Hornsby, Tambre L is out of the office.

[Tambre L Hornsby/AC/VCU]

I will be out of the office starting  12/19/2008 and will not return until
01/05/2009.

VCU Offices are Closed for Winter Break.  If you need immediate attention
please call the VCU Help Desk at 804-828-2227.  I will respond to your
message when I return.

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Re: Group/User Notifications.

[Frex Popo]

Thanks Robert

The incident form we have is overloded with tones of fileds, field tables, 
attachment tables and the rest of it, so I am trying to avoid using tables and 
instead was thinking about an additional form ... anyway, I will think a little 
bit about it and let you know if I manage to resolve it.
 
Have a nice weekend
frex
 

--- En date de : Jeu 18.12.08, Robert Halstead  a écrit :

De: Robert Halstead 
Objet: Re: Group/User Notifications.
À: arslist@ARSLIST.ORG
Date: Jeudi 18 Décembre 2008, 21h24


** This is just a thought, but you could build a table field on the incident 
form of all the child tickets for that parent, and another for all the tasks 
related.. I guess the problem would be getting all the tasks that were related 
to the children and parent..   Essentially, you could walk a table and build 
your recipients list that way.  


On Thu, Dec 18, 2008 at 7:49 AM, Frex Popo  wrote:

** 




Hello everyone,
 
I have a number of child Incidents linked to a parent Incident. Each child 
Incident has a number of tasks.
 
What I need is, when a user presses a button on the Incident form, a 
notification is sent to the user whom THE PARENT INCIDENT has been assigned to, 
(or the group in case the incident has not been assigned to anyone yet). 
 
The notification should also be sent to the user to which THE CHILD INCIDENT t 
has been assigned to (or the group in case the child incident has not been 
assigned to anyone). The same for all the child Incidents of the parent 
Incident.
 
The notification should also be sent to the user to which THE TASK of the child 
incident has been assigned to (or the group in case the task has not been 
assigned to anyone). The same should apply to all the tasks of each child 
Incident.
 
What would the best way to approach this problem? 
 
Is it by creating a form and storing the ID of the parent incident, child 
incidents, and taks, along with all the group and users and then use a filter 
on submit to that form and send a notification?
 
How about walking through the incident and taks form to find the relevant IDs?
 
Anyone did before and want to share their thoughts.
 
Thanks in advance

frex.
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___


-- 
"A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on 
only what he knows, but all that he knows.
The ignoramus may be saved, but the fool knows that he is doomed."

Robert Halstead
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ 




___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"