Re: Count CRQ related an INC in status=Completed

2015-06-22 Thread Misi Mladoniczky
Hi,

Why not do it without Direct SQL?

Action 1:
  Set-Fields: From: CHG:Association_ID02Join
('Request ID01'= $Incident Number$ AND 'RequestID02_Status = Completed)
Integer Field = $LASTCOUNT$ + LEFT($1$, 0)

If you have a lot of matches, and do the count often, using this method might
have a slight performance impact.

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.

 Hi Pamela,

 You need to replace the double quotes with single quotes for this to work.

 Regards,

 Chris


 -Original Message-
 From: Action Request System discussion list(ARSList)
 [mailto:arslist@ARSLIST.ORG] On Behalf Of Pamela Morales
 Sent: 19 June 2015 21:32
 To: arslist@ARSLIST.ORG
 Subject: Re: Count CRQ related an INC in status=Completed

 Hi Bruce,

 I tried what you recommend, but I got an error: Invalid column name
 'INC2014000903'. (SQL Server 207) (ARERR 552). I'm trying to do this SQL
 Sentence:


 SELECT COUNT (*) FROM dbo.CHG_Association_ID02Join WHERE (Request_ID01
 =$Incident Number$  AND RequestID02_Status=10)

 I will be grateful  with your help

 Thanks

 Pamela

 ___
 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


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


Re: People missing???

2015-06-22 Thread Joe D'Souza
I remember one of my customer had a similar problem where a people record
would loose its permissions - turned out that the customer had bad code
written on the automatic foundation  data feed where instead of finding
exact match and modifying its associated records, it modified multiple
records due to a bad search. Thus a bunch of people would be locked out as
their permission record would be updated with some other persons info,

 

Joe

 

  _  

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Tauf
Sent: Saturday, June 20, 2015 7:53 PM
To: arslist@ARSLIST.ORG
Subject: Re: People missing???

 

** 

I think you need to investigate any escalations/filters that do cleanups or
modifications to your people data. Maybe some AD feed or HR system feed into
Remedy and see if it is inadvertently deleting/changing records. I can see
how there maybe more User records than People records but cannot see a
working scenario where you have more People records than User records. 

As a test, if you find a People record that does not have a User record, can
you try to login and see what this account can/cannot do? 

Hopefully by now you've found the culprit! Good luck.


On Friday, June 19, 2015 at 9:03:08 AM UTC-4, richa...@bwc.state.oh.us
wrote:

** 

It looks like the core AR form is being created but apparently the
people/itsm record isn't. Also, looks like there are

many more itsm records than AR/user records. Doesn't seem like the two are
talking to each other.

 

 

From: Action Request System discussion list(ARSList)
[mailto:ars...@arslist.org javascript: ] On Behalf Of Tauf Chowdhury
Sent: Friday, June 19, 2015 8:39 AM
To: ars...@arslist.org javascript: 
Subject: Re: People missing???

 

** 

As the User form is a core AR form? There's no out of box workflow to create
a People record for it. However, if a People record is created, there is
ITSM out of box workflow to create the people record. 

Perhaps you have some integration that is doing this?

Sent from my iPhone


On Jun 19, 2015, at 8:17 AM, richa...@bwc.state.oh.us javascript:
richa...@bwc.state.oh.us javascript:  wrote:

** 

We are on a 7.6.04 system and are running into a very strange situation. If
I go into the System Admin screen and look under Applications/users

the person has a record shown. However, if I go into IT Service
Mgt/people/view there is no listing shown for that person. It looks like
there are

more records shown in the people screen than are shown in the system admin
users screen. Any thoughts? Thanks.

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. 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. _ARSlist: Where
the Answers Are and have been for 20 years_ 

_ARSlist: Where the Answers Are and have been for 20 years_ 

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. 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. 

_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


Accessing the Menu through Mid-Tier

2015-06-22 Thread Karthick S
Hi All,


How can i access the Menu through Mid-Tier? and i know it is not possible
to view the menu associated with the form using Mid-Tier.



Like I'm able to view the Menu through Think Client (User tool), is there
any other way or functionality to view Menu's.

Please advise.



Thanks.

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


updating ITSM support tickets on mobile devices

2015-06-22 Thread theReel
Hi Guys,

We currently have the ITSM 8.1 suite - could move to 9.0 later this year.  I am 
looking at possible solutions to allow our on site engineers to pick up and 
update their ITSM tickets while on the move i.e mobile devices.
Looking at SRM and MyIT they seem to be more suitable for end users reporting 
issues or managers getting an overview of the services rather than for support 
personnel.   I have only ever used MyIT via the BMC Demo website.
What does anyone else use to allow support staff to update tickets (i.e add 
work info notes, reassign, add time, resolve) on mobile devices?

Thanks
T

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


Re: updating ITSM support tickets on mobile devices

2015-06-22 Thread Tauf Chowdhury
You should look at SmartIT. While it comes by default with 9.0, it is backwards 
compatible up to version 7.6.04 sp2(?). 
SmartIT supports mobile natively. 


Sent from my iPhone

 On Jun 22, 2015, at 9:28 AM, theReel tony.r...@bt.com wrote:
 
 Hi Guys,
 
 We currently have the ITSM 8.1 suite - could move to 9.0 later this year.  I 
 am looking at possible solutions to allow our on site engineers to pick up 
 and update their ITSM tickets while on the move i.e mobile devices.
 Looking at SRM and MyIT they seem to be more suitable for end users reporting 
 issues or managers getting an overview of the services rather than for 
 support personnel.   I have only ever used MyIT via the BMC Demo website.
 What does anyone else use to allow support staff to update tickets (i.e add 
 work info notes, reassign, add time, resolve) on mobile devices?
 
 Thanks
 T
 
 ___
 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