Web service
Hi all, I am trying to publish a web service using a get operation and my intention is to get the most recent record of my search. I have been trying a lot with the qualification field in the web service example: 'EMP ID' = XPATH(/ROOT/EMP_ID), but couldn't succeed in it. This particular qualification results in showing the first matching request rather than the recent request... Could some one please help me on this? One more question: How could we use this qualification in the webservie for any operation? Could you explain with some example? - This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Web service
Hi Saravanan, Get operation would return a single record depending on the qualification. You could probably add few more fields in the qualification to fetch the right record. Regards, Shweta From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Saravanan Palaniappan Sent: Tuesday, March 11, 2008 12:41 PM To: arslist@ARSLIST.ORG Subject: Web service Hi all, I am trying to publish a web service using a get operation and my intention is to get the most recent record of my search. I have been trying a lot with the qualification field in the web service example: 'EMP ID' = XPATH(/ROOT/EMP_ID), but couldn't succeed in it. This particular qualification results in showing the first matching request rather than the recent request... Could some one please help me on this? One more question: How could we use this qualification in the webservie for any operation? Could you explain with some example? - This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html";>http://www.techmahindra.com/Disclaimer.html externally and http://tim.techmahindra.com/Disclaimer.html";>http://tim.techmahindra.com/Disclaimer.html internally within Tech Mahindra. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Web service
Hi sweta, I tried that , but that doesn't seem to help us.. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shweta Dhaneshwar Sent: Tuesday, March 11, 2008 2:48 PM To: arslist@ARSLIST.ORG Subject: Re: Web service Hi Saravanan, Get operation would return a single record depending on the qualification. You could probably add few more fields in the qualification to fetch the right record. Regards, Shweta From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Saravanan Palaniappan Sent: Tuesday, March 11, 2008 12:41 PM To: arslist@ARSLIST.ORG Subject: Web service Hi all, I am trying to publish a web service using a get operation and my intention is to get the most recent record of my search. I have been trying a lot with the qualification field in the web service example: 'EMP ID' = XPATH(/ROOT/EMP_ID), but couldn't succeed in it. This particular qualification results in showing the first matching request rather than the recent request... Could some one please help me on this? One more question: How could we use this qualification in the webservie for any operation? Could you explain with some example? - This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Disclaimer: This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at http://www.techmahindra.com/Disclaimer.html externally and http://tim.techmahindra.com/Disclaimer.html internally within Tech Mahindra. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ - This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Quick update on AR System 7.5.00
Daniel, Extensions sound good. ( Which I will assume means Eclipse plugin development based on a published interface from the new Admin Tool. Er... "ARS Developers Studio"?) However what I think would be very, very cool for BMC to do is draw the thick line at the API layer and let us into the Client layer. They have to control and maintain the API. However it has always been possible for someone to use the API and write their own Admin Tool. ( And some people have done that in various forms/degrees. Look at what people like http://www.abydos-workflow.com/ have done with their Abydos Designer product. Look at what ARSDocs does for the community... and there are many other tools/companies that are in wide use in the community too.) If BMC was to adopt that approach then we just might see an "open sourced ARS IDE" some day. We could share in the full development/improvement of the clients (AdminTool, Mid-tier, Import Tool, Alert Tool) and BMC would be focused on the framework, in the form of the Server and the API. Maybe someday, but I really doubt 7.5 will be that day. (But here is to the future May it bring prosperity to all, and well defined business driven requirements too. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Mon, Mar 10, 2008 at 8:53 PM, Daniel Bloom <[EMAIL PROTECTED]> wrote: > The new admin tool is a very new beast if it is at all close to what we saw > at UserWorld, > > And a really slick one at that, I would give it an 11 out of 10. > > > > However, if they don't change their minds, > > you can also change the behaviour of the admin tool > > With your own extensions. > ... Daniel ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Email process hanging occasionally - no apparent cause
Hello ARSers, ARS 7.0.1 Patch 5 Email Engine 7.0.1 Patch 5 RedHat Linux Remote Oracle 10 DB We have the above configuration logging into an IMAP mailbox every two minutes to get and process inbound email. Every so often the process stops checking the inbox for messages and it requires a kill of the java process running the email jar file to start it up again. The logs do not appear to show any cause for this behavior. Has anyone run into this before and/or does anyone have any suggestions on how we can either detect this situation and prevent it or work around it? Thanks! --- J.T. Shyman ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Service Level Management
Frans,
I would be surprised if there is a max, however managing a large number of
them could be an issue.
hbr
On Tue, Mar 11, 2008 at 1:30 AM, Ferreira, Frans F <
[EMAIL PROTECTED]> wrote:
> **
>
> Hi All on List
>
>
>
> What is the maximum number of Service targets that can be created in the
> SLM Module?
>
>
>
> Regards
>
> Frans Ferreira
>
>
>
> __
> *Standard Bank Disclaimer and Confidentiality Note*
>
> This e-mail, its attachments and any rights attaching hereto are, unless
> the context clearly indicates otherwise, the property of Standard Bank Group
> Limited and/or its subsidiaries ("the Group"). It is confidential, private
> and intended for the addressee only.
>
> Should you not be the addressee and receive this e-mail by mistake, kindly
> notify the sender, and delete this e-mail, immediately and do not disclose
> or use same in any manner whatsoever. Views and opinions expressed in this
> e-mail are those of the sender unless clearly stated as those of the Group.
> The Group accepts no liability whatsoever for any loss or damages whatsoever
> and howsoever incurred, or suffered, resulting, or arising, from the use of
> this email or its attachments.
>
> The Group does not warrant the integrity of this e-mail nor that it is
> free of errors, viruses, interception or interference. Licensed divisions
> of the Standard Bank Group are authorised financial services providers in
> terms of the Financial Advisory and Intermediary Services Act, No 37 of 2002
> (FAIS).
>
> For information about the Standard Bank Group Limited visit our website
> http://www.standardbank.co.za
>
> __
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
--
Howard Richter
ITIL Foundation Certified
Red Hat Certified Technician
CompTIA Linux+ Certified
[EMAIL PROTECTED]
Resume = http://hotjobs.yahoo.com/resumes/hrichter_1/masterresume20(2)
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Web service
Saravanan, Basically, I think your solution can be found beyond what ARS web Services does. I think the problem that you have is the sort order of the form that your querying. If you can not change the sort order on the form directly (due to breaking existing functionality) then I think you can create a self Join (A join of the form with itself.) and set the sort order on the Join. Then point the Web Service to the Join to get the answer your after. Another option would be to "keep a high water mark" in one row in a special table that you would then query instead of the "source data" form. ( Like the way the arschema table is used for 'Request ID' values.) HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Mar 11, 2008 at 2:11 AM, Saravanan Palaniappan <[EMAIL PROTECTED]> wrote: > ** > > > > Hi all, > > I am trying to publish a web service using a get operation and my intention > is to get the most recent record of my search. > > I have been trying a lot with the qualification field in the web service > example: 'EMP ID' = XPATH(/ROOT/EMP_ID), but couldn't succeed in it. > > This particular qualification results in showing the first matching request > rather than the recent request… > > > > Could some one please help me on this? > > > > One more question: > > How could we use this qualification in the webservie for any operation? > Could you explain with some example? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Web service
Saravanan, You can create a new integer field (say recent_flag) on your form set a default value as 0. And then make a filter on submit and Modify(if change is possible in emp name) to check if Employee Name already exist in same form then increase the value of existing entries by 1 every time by using push field action with modify all option. So in this scenario you will always get recent_flag value 0 in your most recent entry. You can always use this recent_flag=0 in your web service qualification. Regards, Tarun Sharma -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Tuesday, March 11, 2008 7:13 PM To: arslist@ARSLIST.ORG Subject: Re: Web service Saravanan, Basically, I think your solution can be found beyond what ARS web Services does. I think the problem that you have is the sort order of the form that your querying. If you can not change the sort order on the form directly (due to breaking existing functionality) then I think you can create a self Join (A join of the form with itself.) and set the sort order on the Join. Then point the Web Service to the Join to get the answer your after. Another option would be to "keep a high water mark" in one row in a special table that you would then query instead of the "source data" form. ( Like the way the arschema table is used for 'Request ID' values.) HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Tue, Mar 11, 2008 at 2:11 AM, Saravanan Palaniappan <[EMAIL PROTECTED]> wrote: > ** > > > > Hi all, > > I am trying to publish a web service using a get operation and my intention > is to get the most recent record of my search. > > I have been trying a lot with the qualification field in the web service > example: 'EMP ID' = XPATH(/ROOT/EMP_ID), but couldn't succeed in it. > > This particular qualification results in showing the first matching request > rather than the recent request... > > > > Could some one please help me on this? > > > > One more question: > > How could we use this qualification in the webservie for any operation? > Could you explain with some example? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Guest users only get Read license
Hello Everyone, We have users without Remedy accounts (no record in the User form) who are nevertheless “Submitter” in certain call entries. We want them to be able to go in and modify these requests. I am pretty sure they used to be able to do it. But now I have a user who logs in but only gets a “read” license, so she can’t do what she needs to do. (It isn't just a temporary read. There are plenty of read licenses available.) I think that guest users used to get “Floating” licenses, but am not totally sure. We have “Allow Guest Users” checked in the configuration. The default value for license type in the User form is “License Type” default value is “Floating”. (That shouldn’t make any difference, but I am grasping at straws.) The user is logging in via Mid-Tier, which also shouldn’t make any difference. I gave her a Remedy account, and now she gets a Floating license when she logs in. But I don’t want to give all our potential users Remedy accounts. That defeats the whole purpose of the “Submitter” permission group. Any suggestions? (ARS and Mid-Tier 7.1, Mid-Tier Build 200708221849, RH Linux Server, Oracle 10..2 db) Dwayne Martin James Madison University
Re: Issue with OpGetList web service
I think you need to do something more like this sample.
BTW: It generally helps if you tell us what ARS version your using and
if your using any of the ITSM applications. (Your web service def file
by itself does not really help much.)
Basically you did not have a mapping to a list of elements in the
return ("Output Mapping..."). So the web serivce was only returning
the first record found.
As far as the startRecord and maxLimit ideas... they are not required
(and in fact new in 7.1 for ARS WebService objects) but they have
their uses. If you do not have them in the "Input Mapping..." then I
would suggest removing them from the ARS WebService definition object
too. ( I hope that would be less confusing for the system.)
HTH
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
On Fri, Mar 7, 2008 at 11:45 AM, Ibrahim Akar <[EMAIL PROTECTED]> wrote:
> ** I have created three web services against CTM:People. OpCreate, OpGet and
> OpGetList.
>
> The web services work fine with the exception of OpGetList. It partially
> works in that it only returns one record instead of the dozens that I am
> expecting. I am thinking it might have to do with
>
>
> XPATH(/ROOT/maxLimit) &
> XPATH(/ROOT/startRecord)Do I need to do anything with these? If so, what?
> What I noticed is that the web service only returns the first record. I am
> attaching the def file.
>
> Any help will be appreciated.
>
> --
> -Ibrahim Akar
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
QTSFetchPeopleRecordARSList.def
Description: Binary data
Re: Guest users only get Read license
Do you have your Submitter Mode set to Locked? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, March 11, 2008 9:19 AM To: arslist@ARSLIST.ORG Subject: Guest users only get Read license Hello Everyone, We have users without Remedy accounts (no record in the User form) who are nevertheless "Submitter" in certain call entries. We want them to be able to go in and modify these requests. I am pretty sure they used to be able to do it. But now I have a user who logs in but only gets a "read" license, so she can't do what she needs to do. (It isn't just a temporary read. There are plenty of read licenses available.) I think that guest users used to get "Floating" licenses, but am not totally sure. We have "Allow Guest Users" checked in the configuration. The default value for license type in the User form is "License Type" default value is "Floating". (That shouldn't make any difference, but I am grasping at straws.) The user is logging in via Mid-Tier, which also shouldn't make any difference. I gave her a Remedy account, and now she gets a Floating license when she logs in. But I don't want to give all our potential users Remedy accounts. That defeats the whole purpose of the "Submitter" permission group. Any suggestions? (ARS and Mid-Tier 7.1, Mid-Tier Build 200708221849, RH Linux Server, Oracle 10..2 db) Dwayne Martin James Madison University ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SQL Form?
It was a little DEF file that contained a form called "SQL form" and some active links. It just let you do simple SQL from a Remedy display-only window. I don't know who developed it but it was a nice end-run around environments where you don't have direct access to database and want to do some queries (like checking what form the "T" number was in SQL logs) On my "to do" list was to write an updated version of itmight have to bump that up a few notches... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 10, 2008 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** What's the SQL form? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Monday, March 10, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: SQL Form? ** I used to be able to find the SQL form whenever I needed/wanted it on the old website (before the BMC Dev Network site). Does anyone know where it lives? I can't find itwhich could just be a case of the Mondays William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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: Guest users only get Read license
Yes! Dwayne Original message >Date: Tue, 11 Mar 2008 09:26:54 -0500 >From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >Subject: Re: Guest users only get Read license >To: arslist@ARSLIST.ORG > >Do you have your Submitter Mode set to Locked? > >Fred > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Tuesday, March 11, 2008 9:19 AM >To: arslist@ARSLIST.ORG >Subject: Guest users only get Read license > >Hello Everyone, > >We have users without Remedy accounts (no record in the User form) who >are nevertheless "Submitter" in certain call entries. We want them to >be able to go in and modify these requests. I am pretty sure they used >to be able to do it. But now I have a user who logs in but only gets a >"read" license, so she can't do what she needs to do. (It isn't just a >temporary read. There are plenty of read licenses available.) > >I think that guest users used to get "Floating" licenses, but am not >totally sure. We have "Allow Guest Users" checked in the configuration. >The default value for license type in the User form is "License Type" >default value is "Floating". (That shouldn't make any difference, but I >am grasping at straws.) > >The user is logging in via Mid-Tier, which also shouldn't make any >difference. I gave her a Remedy account, and now she gets a Floating >license when she logs in. But I don't want to give all our potential >users Remedy accounts. That defeats the whole purpose of the >"Submitter" permission group. > >Any suggestions? > >(ARS and Mid-Tier 7.1, Mid-Tier Build 200708221849, RH Linux Server, >Oracle 10..2 db) > >Dwayne Martin >James Madison University > >___ >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: SQL Form?
I never knew they provided this. I always wrote one myself. Just do a display only form, two unlimited length character fields. The first field is where you put your query. Add a button that does a set fields on the second field from SQL. Viola! Also, put a view form out on top of arschema to save you from constructing a select name, schemaid from arschema where name = "blah" all the time. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** It was a little DEF file that contained a form called "SQL form" and some active links. It just let you do simple SQL from a Remedy display-only window. I don't know who developed it but it was a nice end-run around environments where you don't have direct access to database and want to do some queries (like checking what form the "T" number was in SQL logs) On my "to do" list was to write an updated version of itmight have to bump that up a few notches... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 10, 2008 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** What's the SQL form? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Monday, March 10, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: SQL Form? ** I used to be able to find the SQL form whenever I needed/wanted it on the old website (before the BMC Dev Network site). Does anyone know where it lives? I can't find itwhich could just be a case of the Mondays William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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: SQL Form?
It's not a BMC/Remedy product - someone wrote it and posted it to the old Remedy Community site - it was there for a very long time. Granted - it is pretty easy to write one. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? I never knew they provided this. I always wrote one myself. Just do a display only form, two unlimited length character fields. The first field is where you put your query. Add a button that does a set fields on the second field from SQL. Viola! Also, put a view form out on top of arschema to save you from constructing a select name, schemaid from arschema where name = "blah" all the time. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** It was a little DEF file that contained a form called "SQL form" and some active links. It just let you do simple SQL from a Remedy display-only window. I don't know who developed it but it was a nice end-run around environments where you don't have direct access to database and want to do some queries (like checking what form the "T" number was in SQL logs) On my "to do" list was to write an updated version of itmight have to bump that up a few notches... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 10, 2008 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** What's the SQL form? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Monday, March 10, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: SQL Form? ** I used to be able to find the SQL form whenever I needed/wanted it on the old website (before the BMC Dev Network site). Does anyone know where it lives? I can't find itwhich could just be a case of the Mondays William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Guest users only get Read license
Since you're grasping at straws, I'll do the same. 1) Is this only happening to one user? 2) If yes, how is the user logging in? Since you allow guest users, they can log in as "Jane Smith", JSmith, etc. Or maybe you have a company policy that says you log in using your corporate ID which might be something like CompanyInitialsLastnameFirstinitial; "XYZCorpSmithJ". I noticed that you mentioned "she". Did she recently have a name change (marriage/divorce) so that now her login might be "XYZCorpJonesJ"? So, have you verified that the user name she is logging in with exactly matches the value in the Submitter field for the ticket she is trying to modify? TP -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, March 11, 2008 10:51 AM To: arslist@ARSLIST.ORG Subject: Re: Guest users only get Read license Yes! Dwayne Original message >Date: Tue, 11 Mar 2008 09:26:54 -0500 >From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >Subject: Re: Guest users only get Read license >To: arslist@ARSLIST.ORG > >Do you have your Submitter Mode set to Locked? > >Fred > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Tuesday, March 11, 2008 9:19 AM >To: arslist@ARSLIST.ORG >Subject: Guest users only get Read license > >Hello Everyone, > >We have users without Remedy accounts (no record in the User form) who >are nevertheless "Submitter" in certain call entries. We want them to >be able to go in and modify these requests. I am pretty sure they used >to be able to do it. But now I have a user who logs in but only gets a >"read" license, so she can't do what she needs to do. (It isn't just a >temporary read. There are plenty of read licenses available.) > >I think that guest users used to get "Floating" licenses, but am not >totally sure. We have "Allow Guest Users" checked in the configuration. >The default value for license type in the User form is "License Type" >default value is "Floating". (That shouldn't make any difference, but I >am grasping at straws.) > >The user is logging in via Mid-Tier, which also shouldn't make any >difference. I gave her a Remedy account, and now she gets a Floating >license when she logs in. But I don't want to give all our potential >users Remedy accounts. That defeats the whole purpose of the >"Submitter" permission group. > >Any suggestions? > >(ARS and Mid-Tier 7.1, Mid-Tier Build 200708221849, RH Linux Server, >Oracle 10..2 db) > >Dwayne Martin >James Madison University > >___ >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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SQL Form?
Here is the one I use. It's pretty basic. It checks for DROP, Drop, or drop in the sql statement. I've also added clear buttons for the sql query field, and for the result field. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 10:01 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? It's not a BMC/Remedy product - someone wrote it and posted it to the old Remedy Community site - it was there for a very long time. Granted - it is pretty easy to write one. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? I never knew they provided this. I always wrote one myself. Just do a display only form, two unlimited length character fields. The first field is where you put your query. Add a button that does a set fields on the second field from SQL. Viola! Also, put a view form out on top of arschema to save you from constructing a select name, schemaid from arschema where name = "blah" all the time. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** It was a little DEF file that contained a form called "SQL form" and some active links. It just let you do simple SQL from a Remedy display-only window. I don't know who developed it but it was a nice end-run around environments where you don't have direct access to database and want to do some queries (like checking what form the "T" number was in SQL logs) On my "to do" list was to write an updated version of itmight have to bump that up a few notches... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 10, 2008 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** What's the SQL form? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Monday, March 10, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: SQL Form? ** I used to be able to find the SQL form whenever I needed/wanted it on the old website (before the BMC Dev Network site). Does anyone know where it lives? I can't find itwhich could just be a case of the Mondays William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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" ___ 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" sql_query.def Description: sql_query.def
Re: SQL Form?
Sorry, here is the export with the accompanying active links. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. -Original Message- From: Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 10:08 AM To: 'arslist@ARSLIST.ORG' Subject: RE: SQL Form? Here is the one I use. It's pretty basic. It checks for DROP, Drop, or drop in the sql statement. I've also added clear buttons for the sql query field, and for the result field. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 10:01 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? It's not a BMC/Remedy product - someone wrote it and posted it to the old Remedy Community site - it was there for a very long time. Granted - it is pretty easy to write one. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? I never knew they provided this. I always wrote one myself. Just do a display only form, two unlimited length character fields. The first field is where you put your query. Add a button that does a set fields on the second field from SQL. Viola! Also, put a view form out on top of arschema to save you from constructing a select name, schemaid from arschema where name = "blah" all the time. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** It was a little DEF file that contained a form called "SQL form" and some active links. It just let you do simple SQL from a Remedy display-only window. I don't know who developed it but it was a nice end-run around environments where you don't have direct access to database and want to do some queries (like checking what form the "T" number was in SQL logs) On my "to do" list was to write an updated version of itmight have to bump that up a few notches... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 10, 2008 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** What's the SQL form? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Monday, March 10, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: SQL Form? ** I used to be able to find the SQL form whenever I needed/wanted it on the old website (before the BMC Dev Network site). Does anyone know where it lives? I can't find itwhich could just be a case of the Mondays William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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" ___ 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" sql_query.def Description: sql_query.def
Re: Service Level Management
I can tell you from experience you want to be very careful with this and
try to consolidate service targets and then use reporting to quantify
the results.
For example - if you have a 8-hour resolution time for email inbound
Incidents for one group and a 8-hour resolution time for phone call for
another group you're best off doing 1 Service Target and then doing
reporting on the results based on the incoming contact medium.
That is of course a simplistic example but you would want to do this as
much as possible - keep the service targets broad and the results
reportable.
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter
Sent: Tuesday, March 11, 2008 8:32 AM
To: arslist@ARSLIST.ORG
Subject: Re: Service Level Management
**
Frans,
I would be surprised if there is a max, however managing a large number
of them could be an issue.
hbr
On Tue, Mar 11, 2008 at 1:30 AM, Ferreira, Frans F
<[EMAIL PROTECTED]> wrote:
**
Hi All on List
What is the maximum number of Service targets that can be
created in the SLM Module?
Regards
Frans Ferreira
__
Standard Bank Disclaimer and Confidentiality Note
This e-mail, its attachments and any rights attaching hereto
are, unless the context clearly indicates otherwise, the property of
Standard Bank Group Limited and/or its subsidiaries ("the Group"). It is
confidential, private and intended for the addressee only.
Should you not be the addressee and receive this e-mail by
mistake, kindly notify the sender, and delete this e-mail, immediately
and do not disclose or use same in any manner whatsoever. Views and
opinions expressed in this e-mail are those of the sender unless clearly
stated as those of the Group. The Group accepts no liability whatsoever
for any loss or damages whatsoever and howsoever incurred, or suffered,
resulting, or arising, from the use of this email or its attachments.
The Group does not warrant the integrity of this e-mail nor that
it is free of errors, viruses, interception or interference. Licensed
divisions of the Standard Bank Group are authorised financial services
providers in terms of the Financial Advisory and Intermediary Services
Act, No 37 of 2002 (FAIS).
For information about the Standard Bank Group Limited visit our
website http://www.standardbank.co.za
Re: SQL Form?
Thanks for all the responses. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 10:12 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? Sorry, here is the export with the accompanying active links. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. -Original Message- From: Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 10:08 AM To: 'arslist@ARSLIST.ORG' Subject: RE: SQL Form? Here is the one I use. It's pretty basic. It checks for DROP, Drop, or drop in the sql statement. I've also added clear buttons for the sql query field, and for the result field. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 10:01 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? It's not a BMC/Remedy product - someone wrote it and posted it to the old Remedy Community site - it was there for a very long time. Granted - it is pretty easy to write one. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? I never knew they provided this. I always wrote one myself. Just do a display only form, two unlimited length character fields. The first field is where you put your query. Add a button that does a set fields on the second field from SQL. Viola! Also, put a view form out on top of arschema to save you from constructing a select name, schemaid from arschema where name = "blah" all the time. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** It was a little DEF file that contained a form called "SQL form" and some active links. It just let you do simple SQL from a Remedy display-only window. I don't know who developed it but it was a nice end-run around environments where you don't have direct access to database and want to do some queries (like checking what form the "T" number was in SQL logs) On my "to do" list was to write an updated version of itmight have to bump that up a few notches... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 10, 2008 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** What's the SQL form? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Monday, March 10, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: SQL Form? ** I used to be able to find the SQL form whenever I needed/wanted it on the old website (before the BMC Dev Network site). Does anyone know where it lives? I can't find itwhich could just be a case of the Mondays William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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" ___ 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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SQL Form?
Bill, Here is the path on BMCDN for this utility. BMCDN Home > Resource Center> Downloads> BMC Atrium & Foundation Technologies> Remedy AR System > Applications > Document 1082 The URL is: http://developer.bmc.com/jiveProd/entry.jspa?externalID=1082&categoryID=503 Remember the two rules for finding any AR System related utilities on BMCDN. 1. You must log in. 2. All of the AR System stuff is under BMC Atrium & Foundation Technologies. HTH Roger Medsker Remedy Consultant Bluestem Consulting Group, LLC [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 10:24 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? Thanks for all the responses. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 10:12 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? Sorry, here is the export with the accompanying active links. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. -Original Message- From: Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 10:08 AM To: 'arslist@ARSLIST.ORG' Subject: RE: SQL Form? Here is the one I use. It's pretty basic. It checks for DROP, Drop, or drop in the sql statement. I've also added clear buttons for the sql query field, and for the result field. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 10:01 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? It's not a BMC/Remedy product - someone wrote it and posted it to the old Remedy Community site - it was there for a very long time. Granted - it is pretty easy to write one. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 9:57 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? I never knew they provided this. I always wrote one myself. Just do a display only form, two unlimited length character fields. The first field is where you put your query. Add a button that does a set fields on the second field from SQL. Viola! Also, put a view form out on top of arschema to save you from constructing a select name, schemaid from arschema where name = "blah" all the time. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 9:47 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** It was a little DEF file that contained a form called "SQL form" and some active links. It just let you do simple SQL from a Remedy display-only window. I don't know who developed it but it was a nice end-run around environments where you don't have direct access to database and want to do some queries (like checking what form the "T" number was in SQL logs) On my "to do" list was to write an updated version of itmight have to bump that up a few notches... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 10, 2008 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** What's the SQL form? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Monday, March 10, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: SQL Form? ** I used to be able to find the SQL form whenever I needed/wanted it on the old website (before the BMC Dev Network site). Does anyone know where it lives? I can't find itwhich could just be a case of the Mondays William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access A
Re: Service Level Management
The only issue you will face when you create a lot of service targets
The main table for the service target there is limit to display the entry as
I remember 55 or something like that
Open the form in Administrator tools then increases the rows of that
table... Then no problem you can add infinite numbers of Service Targets.
Regards,
Ramy
On Tue, Mar 11, 2008 at 5:19 PM, William Rentfrow <
[EMAIL PROTECTED]> wrote:
> ** I can tell you from experience you want to be very careful with this
> and try to consolidate service targets and then use reporting to quantify
> the results.
>
> For example - if you have a 8-hour resolution time for email inbound
> Incidents for one group and a 8-hour resolution time for phone call for
> another group you're best off doing 1 Service Target and then doing
> reporting on the results based on the incoming contact medium.
>
> That is of course a simplistic example but you would want to do this as
> much as possible - keep the service targets broad and the results
> reportable.
>
> --
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Howard Richter
> *Sent:* Tuesday, March 11, 2008 8:32 AM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: Service Level Management
>
> **
>
> Frans,
>
>
>
> I would be surprised if there is a max, however managing a large number of
> them could be an issue.
>
>
>
> hbr
>
>
> On Tue, Mar 11, 2008 at 1:30 AM, Ferreira, Frans F <
> [EMAIL PROTECTED]> wrote:
>
> > **
> >
> > Hi All on List
> >
> >
> >
> > What is the maximum number of Service targets that can be created in the
> > SLM Module?
> >
> >
> >
> > Regards
> >
> > Frans Ferreira
> >
> >
> >
> > __
> > *Standard Bank Disclaimer and Confidentiality Note*
> >
> > This e-mail, its attachments and any rights attaching hereto are, unless
> > the context clearly indicates otherwise, the property of Standard Bank Group
> > Limited and/or its subsidiaries ("the Group"). It is confidential,
> > private and intended for the addressee only.
> >
> > Should you not be the addressee and receive this e-mail by mistake,
> > kindly notify the sender, and delete this e-mail, immediately and do not
> > disclose or use same in any manner whatsoever. Views and opinions
> > expressed in this e-mail are those of the sender unless clearly stated
> > as those of the Group. The Group accepts no liability whatsoever for any
> > loss or damages whatsoever and howsoever incurred, or suffered,
> > resulting, or arising, from the use of this email or its attachments.
> >
> > The Group does not warrant the integrity of this e-mail nor that it is
> > free of errors, viruses, interception or interference. Licensed
> > divisions of the Standard Bank Group are authorised financial services
> > providers in terms of the Financial Advisory and Intermediary Services Act,
> > No 37 of 2002 (FAIS).
> >
> > For information about the Standard Bank Group Limited visit our website
> > http://www.standardbank.co.za
> >
> > __
> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> > html___
>
>
>
>
> --
> Howard Richter
> ITIL Foundation Certified
> Red Hat Certified Technician
> CompTIA Linux+ Certified
> [EMAIL PROTECTED]
> Resume =
> http://hotjobs.yahoo.com/resumes/hrichter_1/masterresume20(2)__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"
SQL Server 2005 Dbase Error
Hello All, ITSM 7.0.01 SQL Server 2005 We are getting the strangest error in the sql logs, trying to reference the table "spt_server_info". I have spoken with our DBA and he said this table only existed in SQL Server 2000 and not in 2005. Has anyone seen anything like this? I don't know how to proceed. Any and all comments/questions are appreciated. Thanks, Jase Brandon ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Track time on how long the ticket was on a group's queue
I followed your instructions and I was able to get the value of the Total Queue Time but the Que Time Minutes always gets a value of "0" and the Character field for days/hours/mins gets 00/00/00. I don't know what I'm missing. I set the values exactly as you did: Queue Time Days = TRUNC($Total Queue Time$ / 86400) Queue Time Hours = TRUNC((($Total Queue Time$ / 86400) - $Queue Time Days$) * 24) Queue Time Minutes = $Total Queue Time$ / 86400) - $Queue Time Days$) * 24) - $Queue Time Hours$) * 60 Thanks for your help! Kaiser Norm E CIV USAF 96 CS/SCCE wrote: > > Creating a separate form is the right idea. > > Put two date/time fields on it--call them what you want...maybe Time in > Queue and Time Out of Queue or something similar. Create two > filters--one that sets the "in" time and one that sets the "out" time. > The one that does that "out" time can also do the calculations I > describe below. > > Have a third field on your form capture the difference between "in" time > and "out" time, and that's simply "out" - "in". That will give you a > number of seconds, so that field should be an integer field. Let's call > that field Total Queue Time. > > Now we need to convert the total number of seconds to the corresponding > days/hours/mins format. Throw three more integer fields onto your form. > Let's call them Queue Time Hours, Queue Time Minutes, and Queue Time > Seconds. You'll use these to calculate the time part of the desired > days/hours/mins format. Set them with these values: > > > OK, so now you have a field holding your days, a field holding your > hours, and a field holding your minutes. All you need to do now is > concatenate them into a character field by doing some string functions: > > (((LPAD($Queue Time Days$, 2, "00") + "/") + LPAD($Queue Time Hours$, > 2, "00")) + "/") + LPAD($Queue Time Minutes$, 2, "00") > > In the above I'm doing a series of LPAD functions so the system will > fill in a zero if the value is less than ten. For example, 1 day, 1 > hour, and 1 second would be: 01/01/01. > > HTH, > Norm > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Rocky - > Sent: Monday, March 10, 2008 10:29 AM > To: arslist@ARSLIST.ORG > Subject: Track time on how long the ticket was on a group's queue > > Please help... This is for a custom application and I need to be able to > track how long the ticket is sitting on a groups queue in > days:hours:mins > before it gets re-assigned or resolved. I tried creating a new form > that > supposedly will track the assigned time and reassigned time and I just > can't > get it to work. > > Thanks, > Rocky > -- > View this message in context: > http://www.nabble.com/Track-time-on-how-long-the-ticket-was-on-a-group%2 > 7s-queue-tp15950817p15950817.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" > > -- View this message in context: http://www.nabble.com/Track-time-on-how-long-the-ticket-was-on-a-group%27s-queue-tp15950817p15976700.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"
Re: Track time on how long the ticket was on a group's queue
I got it! I was doing the set the fields all at the same time. I set the 1st action to set field for the Total Que Time then another action to set the fields of the rest. Thanks for your help! It works now Rocky - wrote: > > I followed your instructions and I was able to get the value of the Total > Queue Time but the Que Time Minutes always gets a value of "0" and the > Character field for days/hours/mins gets 00/00/00. I don't know what I'm > missing. > > I set the values exactly as you did: > Queue Time Days = TRUNC($Total Queue Time$ / 86400) > Queue Time Hours = TRUNC((($Total Queue Time$ / 86400) - $Queue Time > Days$) * 24) > Queue Time Minutes = $Total Queue Time$ / 86400) - $Queue Time > Days$) * 24) - $Queue Time Hours$) * 60 > > Thanks for your help! > > > Kaiser Norm E CIV USAF 96 CS/SCCE wrote: >> >> Creating a separate form is the right idea. >> >> Put two date/time fields on it--call them what you want...maybe Time in >> Queue and Time Out of Queue or something similar. Create two >> filters--one that sets the "in" time and one that sets the "out" time. >> The one that does that "out" time can also do the calculations I >> describe below. >> >> Have a third field on your form capture the difference between "in" time >> and "out" time, and that's simply "out" - "in". That will give you a >> number of seconds, so that field should be an integer field. Let's call >> that field Total Queue Time. >> >> Now we need to convert the total number of seconds to the corresponding >> days/hours/mins format. Throw three more integer fields onto your form. >> Let's call them Queue Time Hours, Queue Time Minutes, and Queue Time >> Seconds. You'll use these to calculate the time part of the desired >> days/hours/mins format. Set them with these values: >> >> >> OK, so now you have a field holding your days, a field holding your >> hours, and a field holding your minutes. All you need to do now is >> concatenate them into a character field by doing some string functions: >> >> (((LPAD($Queue Time Days$, 2, "00") + "/") + LPAD($Queue Time Hours$, >> 2, "00")) + "/") + LPAD($Queue Time Minutes$, 2, "00") >> >> In the above I'm doing a series of LPAD functions so the system will >> fill in a zero if the value is less than ten. For example, 1 day, 1 >> hour, and 1 second would be: 01/01/01. >> >> HTH, >> Norm >> >> >> >> -Original Message- >> From: Action Request System discussion list(ARSList) >> [mailto:[EMAIL PROTECTED] On Behalf Of Rocky - >> Sent: Monday, March 10, 2008 10:29 AM >> To: arslist@ARSLIST.ORG >> Subject: Track time on how long the ticket was on a group's queue >> >> Please help... This is for a custom application and I need to be able to >> track how long the ticket is sitting on a groups queue in >> days:hours:mins >> before it gets re-assigned or resolved. I tried creating a new form >> that >> supposedly will track the assigned time and reassigned time and I just >> can't >> get it to work. >> >> Thanks, >> Rocky >> -- >> View this message in context: >> http://www.nabble.com/Track-time-on-how-long-the-ticket-was-on-a-group%2 >> 7s-queue-tp15950817p15950817.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" >> >> > > -- View this message in context: http://www.nabble.com/Track-time-on-how-long-the-ticket-was-on-a-group%27s-queue-tp15950817p15976737.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"
Re: Guest users only get Read license
Tim, I am looking at the "Manage User License" panel, and I see that when the user logs in she gets a "Read" license (or did before I gave her an account.) That is set before she tries to make any changes. Even if somebody logs in as "wxyz" they should get a "Floating" license. After that they would only be able to modify forms in which they are "Submitter". But they can't do anything if they only get a "Read" license. Dwayne Martin Original message >Date: Tue, 11 Mar 2008 11:04:35 -0400 >From: Timothy Powell <[EMAIL PROTECTED]> >Subject: Re: Guest users only get Read license >To: arslist@ARSLIST.ORG > >Since you're grasping at straws, I'll do the same. > >1) Is this only happening to one user? >2) If yes, how is the user logging in? Since you allow guest users, they can >log in as "Jane Smith", JSmith, etc. Or maybe you have a company policy that >says you log in using your corporate ID which might be something like >CompanyInitialsLastnameFirstinitial; "XYZCorpSmithJ". I noticed that you >mentioned "she". Did she recently have a name change (marriage/divorce) so >that now her login might be "XYZCorpJonesJ"? So, have you verified that the >user name she is logging in with exactly matches the value in the Submitter >field for the ticket she is trying to modify? > >TP > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Tuesday, March 11, 2008 10:51 AM >To: arslist@ARSLIST.ORG >Subject: Re: Guest users only get Read license > >Yes! > >Dwayne > > Original message >>Date: Tue, 11 Mar 2008 09:26:54 -0500 >>From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >>Subject: Re: Guest users only get Read license >>To: arslist@ARSLIST.ORG >> >>Do you have your Submitter Mode set to Locked? >> >>Fred >> >>-Original Message- >>From: Action Request System discussion list(ARSList) >>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >>Sent: Tuesday, March 11, 2008 9:19 AM >>To: arslist@ARSLIST.ORG >>Subject: Guest users only get Read license >> >>Hello Everyone, >> >>We have users without Remedy accounts (no record in the User form) who >>are nevertheless "Submitter" in certain call entries. We want them to >>be able to go in and modify these requests. I am pretty sure they used >>to be able to do it. But now I have a user who logs in but only gets a >>"read" license, so she can't do what she needs to do. (It isn't just a >>temporary read. There are plenty of read licenses available.) >> >>I think that guest users used to get "Floating" licenses, but am not >>totally sure. We have "Allow Guest Users" checked in the configuration. >>The default value for license type in the User form is "License Type" >>default value is "Floating". (That shouldn't make any difference, but I >>am grasping at straws.) >> >>The user is logging in via Mid-Tier, which also shouldn't make any >>difference. I gave her a Remedy account, and now she gets a Floating >>license when she logs in. But I don't want to give all our potential >>users Remedy accounts. That defeats the whole purpose of the >>"Submitter" permission group. >> >>Any suggestions? >> >>(ARS and Mid-Tier 7.1, Mid-Tier Build 200708221849, RH Linux Server, >>Oracle 10..2 db) >> >>Dwayne Martin >>James Madison University >> >>___ > >>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" > >___ >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"
newScale and Remedy
All: The archives are pretty thin so I will ask it again (in case anyone has new information) Is anyone doing anything with newScale and it's Remedy integration? How does it compare to Remedy's SRM? Does anyone recommend one over the other? If anyone has any knowledge they want to impart, please let me know. -scott ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Question: Overview Console - Assignee
I have added a couple of new fields to the Overview Console with no problems. However, the users want to see "Assignee" on the Overview Console. The problem is the Database ID for Change, Help Desk and Task is not the same. Has anyone added Assignee to their Overview Console? Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Guest users only get Read license (U)
UNCLASSIFIED "Allow Guest Users" means that every login is accepted; the login doesn't have to match a Remedy login name. Submitter Lock Mode means no change can be made to the original submitter. Remedy allows the submitter to modify tickets submitted by him/her but cannot modify other tickets without being assigned a Fixed or Floating license. A current user, with a Read license, can modify tickets where he/she is the submitter. Just because you can successfully log in, doesn't mean that you can modify. When your user logged in originally (before you assigned her a Floating License), and could not modify a ticket, was her Remedy login name being used and did it match the submitter name on the tickets she was trying to modify? Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-602-2525 x248 Apparently, there is nothing that cannot happen today. Mark Twain -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, March 11, 2008 12:01 PM To: arslist@ARSLIST.ORG Subject: Re: Guest users only get Read license Tim, I am looking at the "Manage User License" panel, and I see that when the user logs in she gets a "Read" license (or did before I gave her an account.) That is set before she tries to make any changes. Even if somebody logs in as "wxyz" they should get a "Floating" license. After that they would only be able to modify forms in which they are "Submitter". But they can't do anything if they only get a "Read" license. Dwayne Martin Original message >Date: Tue, 11 Mar 2008 11:04:35 -0400 >From: Timothy Powell <[EMAIL PROTECTED]> >Subject: Re: Guest users only get Read license >To: arslist@ARSLIST.ORG > >Since you're grasping at straws, I'll do the same. > >1) Is this only happening to one user? >2) If yes, how is the user logging in? Since you allow guest users, >they can log in as "Jane Smith", JSmith, etc. Or maybe you have a >company policy that says you log in using your corporate ID which might >be something like CompanyInitialsLastnameFirstinitial; "XYZCorpSmithJ". >I noticed that you mentioned "she". Did she recently have a name change >(marriage/divorce) so that now her login might be "XYZCorpJonesJ"? So, >have you verified that the user name she is logging in with exactly >matches the value in the Submitter field for the ticket she is trying >to modify? > >TP > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Tuesday, March 11, 2008 10:51 AM >To: arslist@ARSLIST.ORG >Subject: Re: Guest users only get Read license > >Yes! > >Dwayne > > Original message >>Date: Tue, 11 Mar 2008 09:26:54 -0500 >>From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >>Subject: Re: Guest users only get Read license >>To: arslist@ARSLIST.ORG >> >>Do you have your Submitter Mode set to Locked? >> >>Fred >> >>-Original Message- >>From: Action Request System discussion list(ARSList) >>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >>Sent: Tuesday, March 11, 2008 9:19 AM >>To: arslist@ARSLIST.ORG >>Subject: Guest users only get Read license >> >>Hello Everyone, >> >>We have users without Remedy accounts (no record in the User form) who >>are nevertheless "Submitter" in certain call entries. We want them to >>be able to go in and modify these requests. I am pretty sure they >>used to be able to do it. But now I have a user who logs in but only >>gets a "read" license, so she can't do what she needs to do. (It >>isn't just a temporary read. There are plenty of read licenses >>available.) >> >>I think that guest users used to get "Floating" licenses, but am not >>totally sure. We have "Allow Guest Users" checked in the >>configuration. The default value for license type in the User form is >>"License Type" default value is "Floating". (That shouldn't make any >>difference, but I am grasping at straws.) >> >>The user is logging in via Mid-Tier, which also shouldn't make any >>difference. I gave her a Remedy account, and now she gets a Floating >>license when she logs in. But I don't want to give all our potential >>users Remedy accounts. That defeats the whole purpose of the >>"Submitter" permission group. >> >>Any suggestions? >> >>(ARS and Mid-Tier 7.1, Mid-Tier Build 200708221849, RH Linux Server, >>Oracle 10..2 db) >> >>Dwayne Martin >>James Madison University >> >>__ >>_ > >>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" > >___
Convert string to Date/Time
Hi dear listers I have a string field with a Date but I need copy this date to a Date/Time field, the format date on the string field is mm/dd/ hh:mm:ss a.m./p.m. When I use a Set Field action for copy the string value to the date/time field appear the next in this field 12/31/69 18:00:11 How can I convert string to the date/time value? Thanks in advance Greetings from Mexico City __ Atentamente Guillermo Alfredo Torres Barrón Proyectos ARS Remedy Grupo Financiero Banorte Calzada de Tlalpan #2980, Col. Ejidos de Santa Ursula Coapa, C.P. 04850 México, D.F. Tel Directo: 51746520, ext: 8505-2520 ... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Guest users only get Read license (U)
Hi Sandra, Re:"A current user, with a Read license, can modify tickets where he/she is the submitter." I made one our "test" logins the submitter to a form, and gave her a "Read" license. Then I logged in as the "test" person- and was able to modify the form! So you are right! I've learned something. Mainly that giving my user a Remedy account was a waste of effort. Something else must have gone wrong. She couldn't have logged in as someone else. People without Remedy accounts have to LDAP authenticate. So maybe this issue will have to remain one of life's mysteries. Thanks to all who replied. Dwayne Martin Original message >Date: Tue, 11 Mar 2008 12:24:19 -0400 >From: "Hennigan, Sandra H CTR OSD-CIO" <[EMAIL PROTECTED]> >Subject: Re: Guest users only get Read license (U) >To: arslist@ARSLIST.ORG > >UNCLASSIFIED > >"Allow Guest Users" means that every login is accepted; the login >doesn't have to match a Remedy login name. > >Submitter Lock Mode means no change can be made to the original >submitter. Remedy allows the submitter to modify tickets submitted by >him/her but cannot modify other tickets without being assigned a Fixed >or Floating license. > >A current user, with a Read license, can modify tickets where he/she is >the submitter. Just because you can successfully log in, doesn't mean >that you can modify. > >When your user logged in originally (before you assigned her a Floating >License), and could not modify a ticket, was her Remedy login name being >used and did it match the submitter name on the tickets she was trying >to modify? > >Sandra Hennigan > >OSD Enterprise Remedy Administrator >Office # 703-602-2525 x248 > >Apparently, there is nothing that cannot happen today. Mark Twain > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Tuesday, March 11, 2008 12:01 PM >To: arslist@ARSLIST.ORG >Subject: Re: Guest users only get Read license > > >Tim, > >I am looking at the "Manage User License" panel, and I see that when the >user logs in she gets a "Read" license (or did before I gave her an >account.) That is set before she tries to make any changes. > >Even if somebody logs in as "wxyz" they should get a "Floating" license. >After that they would only be able to modify forms in which they are >"Submitter". But they can't do anything if they only get a "Read" >license. > >Dwayne Martin > > Original message >>Date: Tue, 11 Mar 2008 11:04:35 -0400 >>From: Timothy Powell <[EMAIL PROTECTED]> >>Subject: Re: Guest users only get Read license >>To: arslist@ARSLIST.ORG >> >>Since you're grasping at straws, I'll do the same. >> >>1) Is this only happening to one user? >>2) If yes, how is the user logging in? Since you allow guest users, >>they can log in as "Jane Smith", JSmith, etc. Or maybe you have a >>company policy that says you log in using your corporate ID which might > >>be something like CompanyInitialsLastnameFirstinitial; "XYZCorpSmithJ". > >>I noticed that you mentioned "she". Did she recently have a name change > >>(marriage/divorce) so that now her login might be "XYZCorpJonesJ"? So, >>have you verified that the user name she is logging in with exactly >>matches the value in the Submitter field for the ticket she is trying >>to modify? >> >>TP >> >>-Original Message- >>From: Action Request System discussion list(ARSList) >>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >>Sent: Tuesday, March 11, 2008 10:51 AM >>To: arslist@ARSLIST.ORG >>Subject: Re: Guest users only get Read license >> >>Yes! >> >>Dwayne >> >> Original message >>>Date: Tue, 11 Mar 2008 09:26:54 -0500 >>>From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >>>Subject: Re: Guest users only get Read license >>>To: arslist@ARSLIST.ORG >>> >>>Do you have your Submitter Mode set to Locked? >>> >>>Fred >>> >>>-Original Message- >>>From: Action Request System discussion list(ARSList) >>>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >>>Sent: Tuesday, March 11, 2008 9:19 AM >>>To: arslist@ARSLIST.ORG >>>Subject: Guest users only get Read license >>> >>>Hello Everyone, >>> >>>We have users without Remedy accounts (no record in the User form) who > >>>are nevertheless "Submitter" in certain call entries. We want them to > >>>be able to go in and modify these requests. I am pretty sure they >>>used to be able to do it. But now I have a user who logs in but only >>>gets a "read" license, so she can't do what she needs to do. (It >>>isn't just a temporary read. There are plenty of read licenses >>>available.) >>> >>>I think that guest users used to get "Floating" licenses, but am not >>>totally sure. We have "Allow Guest Users" checked in the >>>configuration. The default value for license type in the User form is >>>"License Type" default value is "Floating". (That shouldn't make any >>>difference, but I am grasping at straws.) >>> >>>The user
Re: Guest users only get Read license
Incorrect. With Submitter Mode set to Locked, a person with a "Read" license can submit AND modify their tickets (where the login name they are logged in as = the value in the Submitter field). The error comes when they have a "read" license and they try to modify a ticket where their login name is not in the Submitter field. Floating licenses are not automatically issued to guest users, read licenses are. Floating licenses are specifically issued to defined user accounts by an administrator. So if somebody logged in as wxyz will not get a floating license unless an administrator has created a specific user record with a login name of wxyz and issued them a floating license. As a general rule, a floating license will allow a user to modify any ticket, or course provided that they aren't restricted by administrator defined permission groups or custom workflow. TP -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, March 11, 2008 12:01 PM To: arslist@ARSLIST.ORG Subject: Re: Guest users only get Read license Tim, I am looking at the "Manage User License" panel, and I see that when the user logs in she gets a "Read" license (or did before I gave her an account.) That is set before she tries to make any changes. Even if somebody logs in as "wxyz" they should get a "Floating" license. After that they would only be able to modify forms in which they are "Submitter". But they can't do anything if they only get a "Read" license. Dwayne Martin Original message >Date: Tue, 11 Mar 2008 11:04:35 -0400 >From: Timothy Powell <[EMAIL PROTECTED]> >Subject: Re: Guest users only get Read license >To: arslist@ARSLIST.ORG > >Since you're grasping at straws, I'll do the same. > >1) Is this only happening to one user? >2) If yes, how is the user logging in? Since you allow guest users, they can >log in as "Jane Smith", JSmith, etc. Or maybe you have a company policy that >says you log in using your corporate ID which might be something like >CompanyInitialsLastnameFirstinitial; "XYZCorpSmithJ". I noticed that you >mentioned "she". Did she recently have a name change (marriage/divorce) so >that now her login might be "XYZCorpJonesJ"? So, have you verified that the >user name she is logging in with exactly matches the value in the Submitter >field for the ticket she is trying to modify? > >TP > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Tuesday, March 11, 2008 10:51 AM >To: arslist@ARSLIST.ORG >Subject: Re: Guest users only get Read license > >Yes! > >Dwayne > > Original message >>Date: Tue, 11 Mar 2008 09:26:54 -0500 >>From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >>Subject: Re: Guest users only get Read license >>To: arslist@ARSLIST.ORG >> >>Do you have your Submitter Mode set to Locked? >> >>Fred >> >>-Original Message- >>From: Action Request System discussion list(ARSList) >>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >>Sent: Tuesday, March 11, 2008 9:19 AM >>To: arslist@ARSLIST.ORG >>Subject: Guest users only get Read license >> >>Hello Everyone, >> >>We have users without Remedy accounts (no record in the User form) who >>are nevertheless "Submitter" in certain call entries. We want them to >>be able to go in and modify these requests. I am pretty sure they used >>to be able to do it. But now I have a user who logs in but only gets a >>"read" license, so she can't do what she needs to do. (It isn't just a >>temporary read. There are plenty of read licenses available.) >> >>I think that guest users used to get "Floating" licenses, but am not >>totally sure. We have "Allow Guest Users" checked in the configuration. >>The default value for license type in the User form is "License Type" >>default value is "Floating". (That shouldn't make any difference, but I >>am grasping at straws.) >> >>The user is logging in via Mid-Tier, which also shouldn't make any >>difference. I gave her a Remedy account, and now she gets a Floating >>license when she logs in. But I don't want to give all our potential >>users Remedy accounts. That defeats the whole purpose of the >>"Submitter" permission group. >> >>Any suggestions? >> >>(ARS and Mid-Tier 7.1, Mid-Tier Build 200708221849, RH Linux Server, >>Oracle 10..2 db) >> >>Dwayne Martin >>James Madison University >> >>__ _ > >>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" > >___ >UNSUBSCRIBE
Re: Guest users only get Read license (U)
LDAP...so they have a specified, company defined login. This takes me right back to my 2nd question. Did the person's LDAP login change due to name change, location change, etc? TP -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, March 11, 2008 12:50 PM To: arslist@ARSLIST.ORG Subject: Re: Guest users only get Read license (U) Hi Sandra, Re:"A current user, with a Read license, can modify tickets where he/she is the submitter." I made one our "test" logins the submitter to a form, and gave her a "Read" license. Then I logged in as the "test" person- and was able to modify the form! So you are right! I've learned something. Mainly that giving my user a Remedy account was a waste of effort. Something else must have gone wrong. She couldn't have logged in as someone else. People without Remedy accounts have to LDAP authenticate. So maybe this issue will have to remain one of life's mysteries. Thanks to all who replied. Dwayne Martin Original message >Date: Tue, 11 Mar 2008 12:24:19 -0400 >From: "Hennigan, Sandra H CTR OSD-CIO" <[EMAIL PROTECTED]> >Subject: Re: Guest users only get Read license (U) >To: arslist@ARSLIST.ORG > >UNCLASSIFIED > >"Allow Guest Users" means that every login is accepted; the login >doesn't have to match a Remedy login name. > >Submitter Lock Mode means no change can be made to the original >submitter. Remedy allows the submitter to modify tickets submitted by >him/her but cannot modify other tickets without being assigned a Fixed >or Floating license. > >A current user, with a Read license, can modify tickets where he/she is >the submitter. Just because you can successfully log in, doesn't mean >that you can modify. > >When your user logged in originally (before you assigned her a Floating >License), and could not modify a ticket, was her Remedy login name being >used and did it match the submitter name on the tickets she was trying >to modify? > >Sandra Hennigan > >OSD Enterprise Remedy Administrator >Office # 703-602-2525 x248 > >Apparently, there is nothing that cannot happen today. Mark Twain > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Tuesday, March 11, 2008 12:01 PM >To: arslist@ARSLIST.ORG >Subject: Re: Guest users only get Read license > > >Tim, > >I am looking at the "Manage User License" panel, and I see that when the >user logs in she gets a "Read" license (or did before I gave her an >account.) That is set before she tries to make any changes. > >Even if somebody logs in as "wxyz" they should get a "Floating" license. >After that they would only be able to modify forms in which they are >"Submitter". But they can't do anything if they only get a "Read" >license. > >Dwayne Martin > > Original message >>Date: Tue, 11 Mar 2008 11:04:35 -0400 >>From: Timothy Powell <[EMAIL PROTECTED]> >>Subject: Re: Guest users only get Read license >>To: arslist@ARSLIST.ORG >> >>Since you're grasping at straws, I'll do the same. >> >>1) Is this only happening to one user? >>2) If yes, how is the user logging in? Since you allow guest users, >>they can log in as "Jane Smith", JSmith, etc. Or maybe you have a >>company policy that says you log in using your corporate ID which might > >>be something like CompanyInitialsLastnameFirstinitial; "XYZCorpSmithJ". > >>I noticed that you mentioned "she". Did she recently have a name change > >>(marriage/divorce) so that now her login might be "XYZCorpJonesJ"? So, >>have you verified that the user name she is logging in with exactly >>matches the value in the Submitter field for the ticket she is trying >>to modify? >> >>TP >> >>-Original Message- >>From: Action Request System discussion list(ARSList) >>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >>Sent: Tuesday, March 11, 2008 10:51 AM >>To: arslist@ARSLIST.ORG >>Subject: Re: Guest users only get Read license >> >>Yes! >> >>Dwayne >> >> Original message >>>Date: Tue, 11 Mar 2008 09:26:54 -0500 >>>From: "Grooms, Frederick W" <[EMAIL PROTECTED]> >>>Subject: Re: Guest users only get Read license >>>To: arslist@ARSLIST.ORG >>> >>>Do you have your Submitter Mode set to Locked? >>> >>>Fred >>> >>>-Original Message- >>>From: Action Request System discussion list(ARSList) >>>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >>>Sent: Tuesday, March 11, 2008 9:19 AM >>>To: arslist@ARSLIST.ORG >>>Subject: Guest users only get Read license >>> >>>Hello Everyone, >>> >>>We have users without Remedy accounts (no record in the User form) who > >>>are nevertheless "Submitter" in certain call entries. We want them to > >>>be able to go in and modify these requests. I am pretty sure they >>>used to be able to do it. But now I have a user who logs in but only >>>gets a "read" license, so she can't do what she needs to do. (It >>>i
Re: Convert string to Date/Time
If you are trying to see the database, or epoch value, then do a set fields into an integer field. Remedy will then convert the date into integer format. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Guillermo Alfredo Torres Barron Sent: Tuesday, March 11, 2008 11:36 AM To: arslist@ARSLIST.ORG Subject: Convert string to Date/Time Hi dear listers I have a string field with a Date but I need copy this date to a Date/Time field, the format date on the string field is mm/dd/ hh:mm:ss a.m./p.m. When I use a Set Field action for copy the string value to the date/time field appear the next in this field 12/31/69 18:00:11 How can I convert string to the date/time value? Thanks in advance Greetings from Mexico City __ Atentamente Guillermo Alfredo Torres Barrón Proyectos ARS Remedy Grupo Financiero Banorte Calzada de Tlalpan #2980, Col. Ejidos de Santa Ursula Coapa, C.P. 04850 México, D.F. Tel Directo: 51746520, ext: 8505-2520 ... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ... ___ 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: Guest users only get Read license (U)
Oh, I see what you are getting at. No, in looking in the license tool I verified that the person logged in with the same name as what was in the "Submitter" field. Thanks, Dwayne Original message >Date: Tue, 11 Mar 2008 13:00:19 -0400 >From: Timothy Powell <[EMAIL PROTECTED]> >Subject: Re: Guest users only get Read license (U) >To: arslist@ARSLIST.ORG > >LDAP...so they have a specified, company defined login. This takes me right >back to my 2nd question. Did the person's LDAP login change due to name >change, location change, etc? > >TP > >-Original Message- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Tuesday, March 11, 2008 12:50 PM >To: arslist@ARSLIST.ORG >Subject: Re: Guest users only get Read license (U) > >Hi Sandra, > >Re:"A current user, with a Read license, can modify tickets where he/she is >the submitter." > >I made one our "test" logins the submitter to a form, and gave her a "Read" >license. Then I logged in as the "test" person- and was able to modify the >form! So you are right! I've learned something. Mainly that giving my >user a Remedy account was a waste of effort. Something else must have gone >wrong. > >She couldn't have logged in as someone else. People without Remedy accounts >have to LDAP authenticate. So maybe this issue will have to remain one of >life's mysteries. > >Thanks to all who replied. > >Dwayne Martin > > Original message >>Date: Tue, 11 Mar 2008 12:24:19 -0400 >>From: "Hennigan, Sandra H CTR OSD-CIO" <[EMAIL PROTECTED]> >>Subject: Re: Guest users only get Read license (U) >>To: arslist@ARSLIST.ORG >> >>UNCLASSIFIED >> >>"Allow Guest Users" means that every login is accepted; the login >>doesn't have to match a Remedy login name. >> >>Submitter Lock Mode means no change can be made to the original >>submitter. Remedy allows the submitter to modify tickets submitted by >>him/her but cannot modify other tickets without being assigned a Fixed >>or Floating license. >> >>A current user, with a Read license, can modify tickets where he/she is >>the submitter. Just because you can successfully log in, doesn't mean >>that you can modify. >> >>When your user logged in originally (before you assigned her a Floating >>License), and could not modify a ticket, was her Remedy login name being >>used and did it match the submitter name on the tickets she was trying >>to modify? >> >>Sandra Hennigan >> >>OSD Enterprise Remedy Administrator >>Office # 703-602-2525 x248 >> >>Apparently, there is nothing that cannot happen today. Mark Twain >> >>-Original Message- >>From: Action Request System discussion list(ARSList) >>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >>Sent: Tuesday, March 11, 2008 12:01 PM >>To: arslist@ARSLIST.ORG >>Subject: Re: Guest users only get Read license >> >> >>Tim, >> >>I am looking at the "Manage User License" panel, and I see that when the >>user logs in she gets a "Read" license (or did before I gave her an >>account.) That is set before she tries to make any changes. >> >>Even if somebody logs in as "wxyz" they should get a "Floating" license. >>After that they would only be able to modify forms in which they are >>"Submitter". But they can't do anything if they only get a "Read" >>license. >> >>Dwayne Martin >> >> Original message >>>Date: Tue, 11 Mar 2008 11:04:35 -0400 >>>From: Timothy Powell <[EMAIL PROTECTED]> >>>Subject: Re: Guest users only get Read license >>>To: arslist@ARSLIST.ORG >>> >>>Since you're grasping at straws, I'll do the same. >>> >>>1) Is this only happening to one user? >>>2) If yes, how is the user logging in? Since you allow guest users, >>>they can log in as "Jane Smith", JSmith, etc. Or maybe you have a >>>company policy that says you log in using your corporate ID which might >> >>>be something like CompanyInitialsLastnameFirstinitial; "XYZCorpSmithJ". >> >>>I noticed that you mentioned "she". Did she recently have a name change >> >>>(marriage/divorce) so that now her login might be "XYZCorpJonesJ"? So, >>>have you verified that the user name she is logging in with exactly >>>matches the value in the Submitter field for the ticket she is trying >>>to modify? >>> >>>TP >>> >>>-Original Message- >>>From: Action Request System discussion list(ARSList) >>>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >>>Sent: Tuesday, March 11, 2008 10:51 AM >>>To: arslist@ARSLIST.ORG >>>Subject: Re: Guest users only get Read license >>> >>>Yes! >>> >>>Dwayne >>> >>> Original message Date: Tue, 11 Mar 2008 09:26:54 -0500 From: "Grooms, Frederick W" <[EMAIL PROTECTED]> Subject: Re: Guest users only get Read license To: arslist@ARSLIST.ORG Do you have your Submitter Mode set to Locked? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin S
Re: SQL Server 2005 Dbase Error
Jase, What was the exact error? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Jase Brandon Sent: Tuesday, March 11, 2008 11:48 AM To: arslist@ARSLIST.ORG Subject: SQL Server 2005 Dbase Error ** Hello All, ITSM 7.0.01 SQL Server 2005 We are getting the strangest error in the sql logs, trying to reference the table "spt_server_info". I have spoken with our DBA and he said this table only existed in SQL Server 2000 and not in 2005. Has anyone seen anything like this? I don't know how to proceed. Any and all comments/questions are appreciated. Thanks, Jase Brandon No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1325 - Release Date: 3/11/2008 1:41 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SQL Form?
Oh, I had actually built something like that myself years ago, but never really published it.. It isn't all that difficult to build it. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** It was a little DEF file that contained a form called "SQL form" and some active links. It just let you do simple SQL from a Remedy display-only window. I don't know who developed it but it was a nice end-run around environments where you don't have direct access to database and want to do some queries (like checking what form the "T" number was in SQL logs) On my "to do" list was to write an updated version of itmight have to bump that up a few notches... -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 10, 2008 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** What's the SQL form? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Monday, March 10, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: SQL Form? ** I used to be able to find the SQL form whenever I needed/wanted it on the old website (before the BMC Dev Network site). Does anyone know where it lives? I can't find itwhich could just be a case of the Mondays William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1325 - Release Date: 3/11/2008 1:41 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Guest users only get Read license (U)
Is this user found in LDAP? Look at your LDAP form settings. The default write license must have been set to "Read" . In such a case if the user is not found in ldap, Read license is assigned to that user. Thanks, Mohan --- Dwayne Martin <[EMAIL PROTECTED]> wrote: > Oh, I see what you are getting at. No, in looking in > the license tool I verified that the person logged > in with the same name as what was in the "Submitter" > field. > > Thanks, > Dwayne > > Original message > >Date: Tue, 11 Mar 2008 13:00:19 -0400 > >From: Timothy Powell > <[EMAIL PROTECTED]> > >Subject: Re: Guest users only get Read license (U) > > >To: arslist@ARSLIST.ORG > > > >LDAP...so they have a specified, company defined > login. This takes me right > >back to my 2nd question. Did the person's LDAP > login change due to name > >change, location change, etc? > > > >TP > > > >-Original Message- > >From: Action Request System discussion > list(ARSList) > >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne > Martin > >Sent: Tuesday, March 11, 2008 12:50 PM > >To: arslist@ARSLIST.ORG > >Subject: Re: Guest users only get Read license (U) > > > >Hi Sandra, > > > >Re:"A current user, with a Read license, can modify > tickets where he/she is > >the submitter." > > > >I made one our "test" logins the submitter to a > form, and gave her a "Read" > >license. Then I logged in as the "test" person- > and was able to modify the > >form! So you are right! I've learned something. > Mainly that giving my > >user a Remedy account was a waste of effort. > Something else must have gone > >wrong. > > > >She couldn't have logged in as someone else. > People without Remedy accounts > >have to LDAP authenticate. So maybe this issue > will have to remain one of > >life's mysteries. > > > >Thanks to all who replied. > > > >Dwayne Martin > > > > Original message > >>Date: Tue, 11 Mar 2008 12:24:19 -0400 > >>From: "Hennigan, Sandra H CTR OSD-CIO" > <[EMAIL PROTECTED]> > >>Subject: Re: Guest users only get Read license (U) > > >>To: arslist@ARSLIST.ORG > >> > >>UNCLASSIFIED > >> > >>"Allow Guest Users" means that every login is > accepted; the login > >>doesn't have to match a Remedy login name. > >> > >>Submitter Lock Mode means no change can be made to > the original > >>submitter. Remedy allows the submitter to modify > tickets submitted by > >>him/her but cannot modify other tickets without > being assigned a Fixed > >>or Floating license. > >> > >>A current user, with a Read license, can modify > tickets where he/she is > >>the submitter. Just because you can successfully > log in, doesn't mean > >>that you can modify. > >> > >>When your user logged in originally (before you > assigned her a Floating > >>License), and could not modify a ticket, was her > Remedy login name being > >>used and did it match the submitter name on the > tickets she was trying > >>to modify? > >> > >>Sandra Hennigan > >> > >>OSD Enterprise Remedy Administrator > >>Office # 703-602-2525 x248 > >> > >>Apparently, there is nothing that cannot happen > today. Mark Twain > >> > >>-Original Message- > >>From: Action Request System discussion > list(ARSList) > >>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne > Martin > >>Sent: Tuesday, March 11, 2008 12:01 PM > >>To: arslist@ARSLIST.ORG > >>Subject: Re: Guest users only get Read license > >> > >> > >>Tim, > >> > >>I am looking at the "Manage User License" panel, > and I see that when the > >>user logs in she gets a "Read" license (or did > before I gave her an > >>account.) That is set before she tries to make > any changes. > >> > >>Even if somebody logs in as "wxyz" they should get > a "Floating" license. > >>After that they would only be able to modify forms > in which they are > >>"Submitter". But they can't do anything if they > only get a "Read" > >>license. > >> > >>Dwayne Martin > >> > >> Original message > >>>Date: Tue, 11 Mar 2008 11:04:35 -0400 > >>>From: Timothy Powell > <[EMAIL PROTECTED]> > >>>Subject: Re: Guest users only get Read license > >>>To: arslist@ARSLIST.ORG > >>> > >>>Since you're grasping at straws, I'll do the > same. > >>> > >>>1) Is this only happening to one user? > >>>2) If yes, how is the user logging in? Since you > allow guest users, > >>>they can log in as "Jane Smith", JSmith, etc. Or > maybe you have a > >>>company policy that says you log in using your > corporate ID which might > >> > >>>be something like > CompanyInitialsLastnameFirstinitial; > "XYZCorpSmithJ". > >> > >>>I noticed that you mentioned "she". Did she > recently have a name change > >> > >>>(marriage/divorce) so that now her login might be > "XYZCorpJonesJ"? So, > >>>have you verified that the user name she is > logging in with exactly > >>>matches the value in the Submitter field for the > ticket she is trying > >>>to modify? > >>> > >>>TP > >>> > >>>-Original Message- > >>>From: Action Request System discussion > list(ARSList) > >>>[mailto:[EMAIL PROTECTE
Re: SQL Form?
Agreed! Super easy to build. But even EASIER to download and import :) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, March 11, 2008 12:38 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** Oh, I had actually built something like that myself years ago, but never really published it.. It isn't all that difficult to build it. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Tuesday, March 11, 2008 10:47 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** It was a little DEF file that contained a form called "SQL form" and some active links. It just let you do simple SQL from a Remedy display-only window. I don't know who developed it but it was a nice end-run around environments where you don't have direct access to database and want to do some queries (like checking what form the "T" number was in SQL logs) On my "to do" list was to write an updated version of itmight have to bump that up a few notches... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Monday, March 10, 2008 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Form? ** What's the SQL form? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow Sent: Monday, March 10, 2008 4:50 PM To: arslist@ARSLIST.ORG Subject: SQL Form? ** I used to be able to find the SQL form whenever I needed/wanted it on the old website (before the BMC Dev Network site). Does anyone know where it lives? I can't find itwhich could just be a case of the Mondays William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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: newScale and Remedy
Pretty new to newScale here too, but one of the things we have observed here in your environment is that it tends to leave open database connections. Everytime it polls it opens a new connection and leaves it open at the end and does not re-use it. Reminds me of what EIE did, I hear AIE has been fixed as far as that is concerned. But at least in case of EIE, there was a service we use a batch file to turn off when not needed which used to kill the database connection. In case of newScale that is not really an option as the ideal thing to do is leave it running so the Remedy database and the newScale database is most current at all times.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Scott Philben Sent: Tuesday, March 11, 2008 12:11 PM To: arslist@ARSLIST.ORG Subject: newScale and Remedy All: The archives are pretty thin so I will ask it again (in case anyone has new information) Is anyone doing anything with newScale and it's Remedy integration? How does it compare to Remedy's SRM? Does anyone recommend one over the other? If anyone has any knowledge they want to impart, please let me know. -scott No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1325 - Release Date: 3/11/2008 1:41 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SQL Server 2005 Dbase Error
Hi Joe, My Apologies for not being precise. The exact error is shown below. In my humble opinion, it appears that the server is trying to referenece a dbase object that doesn't exist. Any input is greatly appreciated Thanks, :) /* Fri Jan 25 2008 12:21:18.1240 */*** ERROR *** Invalid object name 'master..spt_server_info'. (SQL Server 208) On 3/11/08, Joe D'Souza <[EMAIL PROTECTED]> wrote: > > ** Jase, > > What was the exact error? > > Joe > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] Behalf Of *Jase Brandon > *Sent:* Tuesday, March 11, 2008 11:48 AM > *To:* arslist@ARSLIST.ORG > *Subject:* SQL Server 2005 Dbase Error > > ** Hello All, > ITSM 7.0.01 > SQL Server 2005 > > We are getting the strangest error in the sql logs, trying to reference > the table "spt_server_info". > I have spoken with our DBA and he said this table only existed in SQL > Server 2000 and not in 2005. > Has anyone seen anything like this? I don't know how to proceed. Any and > all comments/questions are appreciated. > > Thanks, > > Jase Brandon > > __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"
Guest Access for Email submission in ARS 7.1
I've just upgraded my dev server to 7.1, and the email submissions have stopped working. My production box is 7.0.1, and it's working there. We have users fill out a form on our Domino-based intranet site, and Domino generates an email message to ARS. The login is a generic login that doesn't have a People or User record. According to the doc, this shouldn't work, but it does on my prod 7.0.1 box. In dev, when ARS processes the incoming message, I get error 8932 'You do not have write license' and 332 'You do not have write access (at create time) to field 1'. This makes sense according to the doc. When I create a person and user record for the generic login, though, I still get error 332. I've given Mr. Generic a read license, then a floating license, then added him to the group 'APP-Support', and I still get error 332. As I write this, I realize that in all of these attempts, Mr. Generic has not had a password. Could this be the problem? Is 7.1 pickier about passwords than 7.0.1? Both systems are running HelpDesk 6.0 if that matters. Thanks, Ron Legters Tools Administrator Data & Systems Services Univar USA Inc. 425.889.3952 Office 425.889.4111 Fax www.univarusa.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Cisco CSS load balancer config?
Hello ARSList, One of my colleagues has the delightful opportunity to configure a Cisco Content Services Switch (CSS) load balancer in front of two ARS servers. He is looking at the initial part of the CSS config script which appears as follows. !*** GLOBAL *** username admin1 des-password superuser username admin2 des-password superuser username admin3 des-password superuser What he cannot find in either the BMC or Cisco documentation is what those three lines of the script mean. Are admin1, admin2, admin3 ARS account names? If so, how ought they to be configured? If not, what are they? What needs to be done about them? Cisco support suggests that part of the script is specific to BMC's ARS, so Cisco cannot help interpret them. BMC's support has so far been responsive in that he has received replies but unresponsive in that the replies did not meaningfully address his inquiry. His environment is ARS 7.1 on Windows OS & MS SQL. It's a Cisco CSS11503. If you have already solved this puzzle, perhaps you could share the secrets? Many thanks, Doug Anderson Mayo Clinic ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
runmacro.exe
I have a customer that uses runmacro.exe to submit tickets. Part of what he's sending me is short description. Randomly, he will receive an error saying short description is required, and that he left it blank. However, he is clearly putting data in it. This particular ticket we're looking at, the user has put => a bunch in the short description. We are wondering if this is what would have caused the issue. Does anyone have any feedback on characters you cannot put in the value of a field for runmacro.exe? Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
This is the end...
I start working for a new company next month, moving over to a technical architech role with focus on integrations and middleware (yes, SOA). Just what I've done the last years :-) Keep up the good work, and remember with version 7.5 all your dreams will come trough :-) No one mentioned, no one forgotten Regards, Jarl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: This is the end...
We wish you well, Jarl. I'm sure you'll be as valuable to that community as you have been to ours. I will miss your professional wisdom as well as your company at RUGs. Rick On Tue, Mar 11, 2008 at 11:04 AM, Jarl Grøneng <[EMAIL PROTECTED]> wrote: > I start working for a new company next month, moving over to a > technical architech role with focus on integrations and middleware > (yes, SOA). Just what I've done the last years :-) > > Keep up the good work, and remember with version 7.5 all your dreams > will come trough :-) > > > > No one mentioned, no one forgotten > > Regards, > Jarl > > > ___ > 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: This is the end...
Ok...so now I have this Doors song playing in my head (seriously, good luck to you, Jarl!) Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] Jarl Grøneng <[EMAIL PROTECTED]To: arslist@ARSLIST.ORG IL.COM> cc: Sent by: "Action Subject: This is the end... Request System discussion list(ARSList)" <[EMAIL PROTECTED] ORG> 03/11/2008 14:04 Please respond to arslist I start working for a new company next month, moving over to a technical architech role with focus on integrations and middleware (yes, SOA). Just what I've done the last years :-) Keep up the good work, and remember with version 7.5 all your dreams will come trough :-) No one mentioned, no one forgotten Regards, Jarl ___ 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: This is the end...
Good luck Jarl. Thank you for all your contributions to this community. Who knows, sometimes things take a u-turn and you may end-up back here! Susan On Tue, Mar 11, 2008 at 1:04 PM, Jarl Grøneng <[EMAIL PROTECTED]> wrote: > I start working for a new company next month, moving over to a > technical architech role with focus on integrations and middleware > (yes, SOA). Just what I've done the last years :-) > > Keep up the good work, and remember with version 7.5 all your dreams > will come trough :-) > > > > No one mentioned, no one forgotten > > Regards, > Jarl > > > ___ > 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: Guest users only get Read license (U)
Thanks, Mohan, If the user weren't in LDAP she would have gotten "Unable to log into any server." Dwayne Original message >Date: Tue, 11 Mar 2008 10:38:18 -0700 >From: Mohan Panchangmath <[EMAIL PROTECTED]> >Subject: Re: Guest users only get Read license (U) >To: arslist@ARSLIST.ORG > >Is this user found in LDAP? > >Look at your LDAP form settings. The default write >license must have been set to "Read" . >In such a case if the user is not found in ldap, Read >license is assigned to that user. > >Thanks, >Mohan > > >--- Dwayne Martin <[EMAIL PROTECTED]> wrote: > >> Oh, I see what you are getting at. No, in looking in >> the license tool I verified that the person logged >> in with the same name as what was in the "Submitter" >> field. >> >> Thanks, >> Dwayne >> >> Original message >> >Date: Tue, 11 Mar 2008 13:00:19 -0400 >> >From: Timothy Powell >> <[EMAIL PROTECTED]> >> >Subject: Re: Guest users only get Read license (U) >> >> >To: arslist@ARSLIST.ORG >> > >> >LDAP...so they have a specified, company defined >> login. This takes me right >> >back to my 2nd question. Did the person's LDAP >> login change due to name >> >change, location change, etc? >> > >> >TP >> > >> >-Original Message- >> >From: Action Request System discussion >> list(ARSList) >> >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne >> Martin >> >Sent: Tuesday, March 11, 2008 12:50 PM >> >To: arslist@ARSLIST.ORG >> >Subject: Re: Guest users only get Read license (U) >> > >> >Hi Sandra, >> > >> >Re:"A current user, with a Read license, can modify >> tickets where he/she is >> >the submitter." >> > >> >I made one our "test" logins the submitter to a >> form, and gave her a "Read" >> >license. Then I logged in as the "test" person- >> and was able to modify the >> >form! So you are right! I've learned something. >> Mainly that giving my >> >user a Remedy account was a waste of effort. >> Something else must have gone >> >wrong. >> > >> >She couldn't have logged in as someone else. >> People without Remedy accounts >> >have to LDAP authenticate. So maybe this issue >> will have to remain one of >> >life's mysteries. >> > >> >Thanks to all who replied. >> > >> >Dwayne Martin >> > >> > Original message >> >>Date: Tue, 11 Mar 2008 12:24:19 -0400 >> >>From: "Hennigan, Sandra H CTR OSD-CIO" >> <[EMAIL PROTECTED]> >> >>Subject: Re: Guest users only get Read license (U) >> >> >>To: arslist@ARSLIST.ORG >> >> >> >>UNCLASSIFIED >> >> >> >>"Allow Guest Users" means that every login is >> accepted; the login >> >>doesn't have to match a Remedy login name. >> >> >> >>Submitter Lock Mode means no change can be made to >> the original >> >>submitter. Remedy allows the submitter to modify >> tickets submitted by >> >>him/her but cannot modify other tickets without >> being assigned a Fixed >> >>or Floating license. >> >> >> >>A current user, with a Read license, can modify >> tickets where he/she is >> >>the submitter. Just because you can successfully >> log in, doesn't mean >> >>that you can modify. >> >> >> >>When your user logged in originally (before you >> assigned her a Floating >> >>License), and could not modify a ticket, was her >> Remedy login name being >> >>used and did it match the submitter name on the >> tickets she was trying >> >>to modify? >> >> >> >>Sandra Hennigan >> >> >> >>OSD Enterprise Remedy Administrator >> >>Office # 703-602-2525 x248 >> >> >> >>Apparently, there is nothing that cannot happen >> today. Mark Twain >> >> >> >>-Original Message- >> >>From: Action Request System discussion >> list(ARSList) >> >>[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne >> Martin >> >>Sent: Tuesday, March 11, 2008 12:01 PM >> >>To: arslist@ARSLIST.ORG >> >>Subject: Re: Guest users only get Read license >> >> >> >> >> >>Tim, >> >> >> >>I am looking at the "Manage User License" panel, >> and I see that when the >> >>user logs in she gets a "Read" license (or did >> before I gave her an >> >>account.) That is set before she tries to make >> any changes. >> >> >> >>Even if somebody logs in as "wxyz" they should get >> a "Floating" license. >> >>After that they would only be able to modify forms >> in which they are >> >>"Submitter". But they can't do anything if they >> only get a "Read" >> >>license. >> >> >> >>Dwayne Martin >> >> >> >> Original message >> >>>Date: Tue, 11 Mar 2008 11:04:35 -0400 >> >>>From: Timothy Powell >> <[EMAIL PROTECTED]> >> >>>Subject: Re: Guest users only get Read license >> >>>To: arslist@ARSLIST.ORG >> >>> >> >>>Since you're grasping at straws, I'll do the >> same. >> >>> >> >>>1) Is this only happening to one user? >> >>>2) If yes, how is the user logging in? Since you >> allow guest users, >> >>>they can log in as "Jane Smith", JSmith, etc. Or >> maybe you have a >> >>>company policy that says you log in using your >> corporate ID which might >> >> >> >>>be something like >> CompanyInitialsLastnameFirstinitial; >> "XYZCorpSmithJ". >> >> >>
Re: SQL Server 2005 Dbase Error
The object doesn't exist or the ARSystem dbo (ARAdmin) doesn't have access to the object. From: Jase Brandon Sent: Tuesday, March 11, 2008 10:54 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: SQL Server 2005 Dbase Error ** Hi Joe, My Apologies for not being precise. The exact error is shown below. In my humble opinion, it appears that the server is trying to referenece a dbase object that doesn't exist. Any input is greatly appreciated Thanks, :) /* Fri Jan 25 2008 12:21:18.1240 */*** ERROR *** Invalid object name 'master..spt_server_info'. (SQL Server 208) On 3/11/08, Joe D'Souza <[EMAIL PROTECTED]> wrote: ** Jase, What was the exact error? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Jase Brandon Sent: Tuesday, March 11, 2008 11:48 AM To: arslist@ARSLIST.ORG Subject: SQL Server 2005 Dbase Error ** Hello All, ITSM 7.0.01 SQL Server 2005 We are getting the strangest error in the sql logs, trying to reference the table "spt_server_info". I have spoken with our DBA and he said this table only existed in SQL Server 2000 and not in 2005. Has anyone seen anything like this? I don't know how to proceed. Any and all comments/questions are appreciated. Thanks, Jase Brandon __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: Question: Overview Console - Assignee
You must add the entries to the SHR:ARDBCFields form for each field of the 3 forms and map them to the same field. So you will have 3 different entries for the Assignee field. One for each form. Once you do that you add the Assignee field to the table in the Overview Console with public permissions then restart the plugin. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Tuesday, March 11, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Question: Overview Console - Assignee I have added a couple of new fields to the Overview Console with no problems. However, the users want to see "Assignee" on the Overview Console. The problem is the Database ID for Change, Help Desk and Task is not the same. Has anyone added Assignee to their Overview Console? Thanks! ___ 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: This is the end...
Mike you got me thinking the same thing too! Good luck to you Jarl and thank you for being an active member of this list through these years! Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mike White Sent: Tuesday, March 11, 2008 2:13 PM To: arslist@ARSLIST.ORG Subject: Re: This is the end... ** Ok...so now I have this Doors song playing in my head (seriously, good luck to you, Jarl!) Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] Jarl Grøneng <[EMAIL PROTECTED]> Jarl Grøneng <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" 03/11/2008 14:04 Please respond to arslist To: arslist@ARSLIST.ORG cc: Subject: This is the end... I start working for a new company next month, moving over to a technical architech role with focus on integrations and middleware (yes, SOA). Just what I've done the last years :-) Keep up the good work, and remember with version 7.5 all your dreams will come trough :-) No one mentioned, no one forgotten Regards, Jarl No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1325 - Release Date: 3/11/2008 1:41 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" <><>
Re: SQL Server 2005 Dbase Error
I remember getting that error too and I think the reason for it was the MS SQL server was being accessed through the 2000 libraries.. What version of the MS SQL client have you got installed.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Bill H. Sent: Tuesday, March 11, 2008 2:32 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Server 2005 Dbase Error ** The object doesn't exist or the ARSystem dbo (ARAdmin) doesn't have access to the object. From: Jase Brandon Sent: Tuesday, March 11, 2008 10:54 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: SQL Server 2005 Dbase Error ** Hi Joe, My Apologies for not being precise. The exact error is shown below. In my humble opinion, it appears that the server is trying to referenece a dbase object that doesn't exist. Any input is greatly appreciated Thanks, :) /* Fri Jan 25 2008 12:21:18.1240 */*** ERROR *** Invalid object name 'master..spt_server_info'. (SQL Server 208) On 3/11/08, Joe D'Souza <[EMAIL PROTECTED]> wrote: ** Jase, What was the exact error? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Jase Brandon Sent: Tuesday, March 11, 2008 11:48 AM To: arslist@ARSLIST.ORG Subject: SQL Server 2005 Dbase Error ** Hello All, ITSM 7.0.01 SQL Server 2005 We are getting the strangest error in the sql logs, trying to reference the table "spt_server_info". I have spoken with our DBA and he said this table only existed in SQL Server 2000 and not in 2005. Has anyone seen anything like this? I don't know how to proceed. Any and all comments/questions are appreciated. Thanks, Jase Brandon No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1325 - Release Date: 3/11/2008 1:41 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Remedy Reporting
Hi All, I have an active link that opens the window on "Report". Lets say on the IF action, the Form Name field has "$z2B Report Form$. There is no Report Form on our server with this name so how is this workflow derived? Then lets say the view is "$z2B Report View$. Usually I specify a form, however in this case I am leveraging pre-existing workflow. What does this mean? **It's Tax Time! Get tips, forms, and advice on AOL Money & Finance. (http://money.aol.com/tax?NCID=aolprf000301) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
ITSM7/BMC Data Loader--Extra Precaution
We have just determined another 'feature' in subject tool. Details: Column BG of '02 CTM-People', located in People.xls, designates 'Unrestricted Access'. Column is NOT color-coded, and specifically labelled optional; further instructions declare, it must be entered as "0" or "Yes" if used. We imported ca 250 users to various companies/organizations in a multi-tenancy environment, leaving this column blank (and re-checking the *.csv to make certain it was, indeed, blank!). To our surprise, these users were created with Unrestricted Access in their USER record, even though CTM:People displayed the related box as unchecked-- in fact, CTM:People showing no groups at all. Further, the import/promote scheme did NOT assign the expected 'Global Access' group--with its attendant 'modify field' disconnects. I do realize that our importation of people intending to make them support staff, without creating templates first, is inconsistent with instructions for this product. On prolonged usage, this product reminds me of a frequent note I've heard, as aircrew, from air traffic controllers: "Aircraft ZZ, cleared for takeoff. Caution, wake turbulence from departing , parallel runway, one mile in lead". Aircrew is legal for takeoff, all right, but CRAZY to actually use that clearance without waiting at least three minutes for the wake turbulence to settle! Don W. McClure, P.E. Data Administrator & System Engineer University of North Texas Computing & IT Center dwmac_at_unt.edu 940.565.3287 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Remedy Reporting
Kathy, I believe that means it is pulling the form/view names from a character field reference on the current form that the active link is attached to. These are most likely display-only character fields. --Thomas - Original Message - From: Kathy Morris Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Tuesday, March 11, 2008 3:23 PM Subject: Remedy Reporting ** Hi All, I have an active link that opens the window on "Report". Lets say on the IF action, the Form Name field has "$z2B Report Form$. There is no Report Form on our server with this name so how is this workflow derived? Then lets say the view is "$z2B Report View$. Usually I specify a form, however in this case I am leveraging pre-existing workflow. What does this mean? -- It's Tax Time! Get tips, forms and advice on AOL Money & Finance. __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: Guest users only get Read license (U)
NO. She wont get that message. If she is not in LDAP and if you have default permission set up in LDAP configuration for users not found in LDAP with "authorizing unregistered users" turned ON then they will get into Remedy with that default permission and they wont see the error message "Unable to log into any server." Besides that, is she a guest user?? If users are NOT assigned a fixed or floating license, they will automatically use a read license by default. Guest users will automatically use a read license. Thanks, Mohan Thanks, Mohan --- Dwayne Martin <[EMAIL PROTECTED]> wrote: > Thanks, Mohan, > > If the user weren't in LDAP she would have gotten > "Unable to log into any server." > > Dwayne > > Original message > >Date: Tue, 11 Mar 2008 10:38:18 -0700 > >From: Mohan Panchangmath <[EMAIL PROTECTED]> > >Subject: Re: Guest users only get Read license (U) > > >To: arslist@ARSLIST.ORG > > > >Is this user found in LDAP? > > > >Look at your LDAP form settings. The default write > >license must have been set to "Read" . > >In such a case if the user is not found in ldap, > Read > >license is assigned to that user. > > > >Thanks, > >Mohan > > > > > >--- Dwayne Martin <[EMAIL PROTECTED]> wrote: > > > >> Oh, I see what you are getting at. No, in looking > in > >> the license tool I verified that the person > logged > >> in with the same name as what was in the > "Submitter" > >> field. > >> > >> Thanks, > >> Dwayne > >> > >> Original message > >> >Date: Tue, 11 Mar 2008 13:00:19 -0400 > >> >From: Timothy Powell > >> <[EMAIL PROTECTED]> > >> >Subject: Re: Guest users only get Read license > (U) > >> > >> >To: arslist@ARSLIST.ORG > >> > > >> >LDAP...so they have a specified, company defined > >> login. This takes me right > >> >back to my 2nd question. Did the person's LDAP > >> login change due to name > >> >change, location change, etc? > >> > > >> >TP > >> > > >> >-Original Message- > >> >From: Action Request System discussion > >> list(ARSList) > >> >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne > >> Martin > >> >Sent: Tuesday, March 11, 2008 12:50 PM > >> >To: arslist@ARSLIST.ORG > >> >Subject: Re: Guest users only get Read license > (U) > >> > > >> >Hi Sandra, > >> > > >> >Re:"A current user, with a Read license, can > modify > >> tickets where he/she is > >> >the submitter." > >> > > >> >I made one our "test" logins the submitter to a > >> form, and gave her a "Read" > >> >license. Then I logged in as the "test" person- > >> and was able to modify the > >> >form! So you are right! I've learned > something. > >> Mainly that giving my > >> >user a Remedy account was a waste of effort. > >> Something else must have gone > >> >wrong. > >> > > >> >She couldn't have logged in as someone else. > >> People without Remedy accounts > >> >have to LDAP authenticate. So maybe this issue > >> will have to remain one of > >> >life's mysteries. > >> > > >> >Thanks to all who replied. > >> > > >> >Dwayne Martin > >> > > >> > Original message > >> >>Date: Tue, 11 Mar 2008 12:24:19 -0400 > >> >>From: "Hennigan, Sandra H CTR OSD-CIO" > >> <[EMAIL PROTECTED]> > >> >>Subject: Re: Guest users only get Read license > (U) > >> > >> >>To: arslist@ARSLIST.ORG > >> >> > >> >>UNCLASSIFIED > >> >> > >> >>"Allow Guest Users" means that every login is > >> accepted; the login > >> >>doesn't have to match a Remedy login name. > >> >> > >> >>Submitter Lock Mode means no change can be made > to > >> the original > >> >>submitter. Remedy allows the submitter to > modify > >> tickets submitted by > >> >>him/her but cannot modify other tickets without > >> being assigned a Fixed > >> >>or Floating license. > >> >> > >> >>A current user, with a Read license, can modify > >> tickets where he/she is > >> >>the submitter. Just because you can > successfully > >> log in, doesn't mean > >> >>that you can modify. > >> >> > >> >>When your user logged in originally (before you > >> assigned her a Floating > >> >>License), and could not modify a ticket, was > her > >> Remedy login name being > >> >>used and did it match the submitter name on the > >> tickets she was trying > >> >>to modify? > >> >> > >> >>Sandra Hennigan > >> >> > >> >>OSD Enterprise Remedy Administrator > >> >>Office # 703-602-2525 x248 > >> >> > >> >>Apparently, there is nothing that cannot happen > >> today. Mark Twain > >> >> > >> >>-Original Message- > >> >>From: Action Request System discussion > >> list(ARSList) > >> >>[mailto:[EMAIL PROTECTED] On Behalf Of > Dwayne > >> Martin > >> >>Sent: Tuesday, March 11, 2008 12:01 PM > >> >>To: arslist@ARSLIST.ORG > >> >>Subject: Re: Guest users only get Read license > >> >> > >> >> > >> >>Tim, > >> >> > >> >>I am looking at the "Manage User License" > panel, > >> and I see that when the > >> >>user logs in she gets a "Read" license (or did > >> before I gave her an > >> >>account.) That is set before she tries to make > >> any changes. > >> >> > >> >>Even
Re: Convert string to Date/Time
Hi Guillermo, In order for the date to be converted correctly from the character field to the date/time field, the format of the date string probably needs to match the format you are seeing in the date/time field. So, if the date/time is showing up under this format: 12/31/69 18:00:11 Then your original date string probably needs to be in this format to be converted correctly: MM/DD/YY HH:MM:SS (24-hour format *without* am/pm) --Thomas - Original Message - From: "Guillermo Alfredo Torres Barron" <[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: Sent: Tuesday, March 11, 2008 11:35 AM Subject: Convert string to Date/Time Hi dear listers I have a string field with a Date but I need copy this date to a Date/Time field, the format date on the string field is mm/dd/ hh:mm:ss a.m./p.m. When I use a Set Field action for copy the string value to the date/time field appear the next in this field 12/31/69 18:00:11 How can I convert string to the date/time value? Thanks in advance Greetings from Mexico City __ Atentamente Guillermo Alfredo Torres Barrón Proyectos ARS Remedy Grupo Financiero Banorte Calzada de Tlalpan #2980, Col. Ejidos de Santa Ursula Coapa, C.P. 04850 México, D.F. Tel Directo: 51746520, ext: 8505-2520 ... Este correo electronico es confidencial y/o puede contener informacion privilegiada. Si usted no es su destinatario o no es alguna persona autorizada por este para recibir sus correos electronicos, NO debera usted utilizar, copiar, revelar, o tomar ninguna accion basada en este correo electronico o cualquier otra informacion incluida en el, favor de notificar al remitente de inmediato mediante el reenvio de este correo electronico y borrar a continuacion totalmente este correo electronico y sus anexos. Nota: Los acentos y caracteres especiales fueron omitidos para su correcta lectura en cualquier medio electronico. This e-mail is confidential and/or may contain privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any other information herein, please advise the sender immediately by reply this e-mail and delete this e-mail and its attachments. ... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: runmacro.exe
Have you checked the field length of the Short Description field? Maybe he is violating that and the system is reporting a wrong error? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 2:03 PM To: arslist@ARSLIST.ORG Subject: runmacro.exe ** I have a customer that uses runmacro.exe to submit tickets. Part of what he’s sending me is short description. Randomly, he will receive an error saying short description is required, and that he left it blank. However, he is clearly putting data in it. This particular ticket we’re looking at, the user has put => a bunch in the short description. We are wondering if this is what would have caused the issue. Does anyone have any feedback on characters you cannot put in the value of a field for runmacro.exe? Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1325 - Release Date: 3/11/2008 1:41 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SQL Server 2005 Dbase Error
Yes it is, this object has been removed in MS-SQL 2005. https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=229015&SiteID=1 It is looking for this perhaps because the AR System server was installed on MS-SQL 2000, and the database was later upgraded. Two things you can do to resolve this.. Install the MS-SQL 2005 client. If this doesn't resolve your problem, run the upgrade the AR Server and this would install any 2005 specific libraries if that is missing.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Jase Brandon Sent: Tuesday, March 11, 2008 1:55 PM To: arslist@ARSLIST.ORG Subject: Re: SQL Server 2005 Dbase Error ** Hi Joe, My Apologies for not being precise. The exact error is shown below. In my humble opinion, it appears that the server is trying to referenece a dbase object that doesn't exist. Any input is greatly appreciated Thanks, :) /* Fri Jan 25 2008 12:21:18.1240 */*** ERROR *** Invalid object name 'master..spt_server_info'. (SQL Server 208) On 3/11/08, Joe D'Souza <[EMAIL PROTECTED]> wrote: ** Jase, What was the exact error? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Jase Brandon Sent: Tuesday, March 11, 2008 11:48 AM To: arslist@ARSLIST.ORG Subject: SQL Server 2005 Dbase Error ** Hello All, ITSM 7.0.01 SQL Server 2005 We are getting the strangest error in the sql logs, trying to reference the table "spt_server_info". I have spoken with our DBA and he said this table only existed in SQL Server 2000 and not in 2005. Has anyone seen anything like this? I don't know how to proceed. Any and all comments/questions are appreciated. Thanks, Jase Brandon __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1325 - Release Date: 3/11/2008 1:41 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: runmacro.exe
No, but that is a good idea. I'll have him check that. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, March 11, 2008 3:54 PM To: arslist@ARSLIST.ORG Subject: Re: runmacro.exe ** Have you checked the field length of the Short Description field? Maybe he is violating that and the system is reporting a wrong error? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 2:03 PM To: arslist@ARSLIST.ORG Subject: runmacro.exe ** I have a customer that uses runmacro.exe to submit tickets. Part of what he's sending me is short description. Randomly, he will receive an error saying short description is required, and that he left it blank. However, he is clearly putting data in it. This particular ticket we're looking at, the user has put => a bunch in the short description. We are wondering if this is what would have caused the issue. Does anyone have any feedback on characters you cannot put in the value of a field for runmacro.exe? Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. __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: runmacro.exe
I forgot, we had already ruled that out. Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. 405 736 3211 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Tuesday, March 11, 2008 3:54 PM To: arslist@ARSLIST.ORG Subject: Re: runmacro.exe ** Have you checked the field length of the Short Description field? Maybe he is violating that and the system is reporting a wrong error? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Opela, Gary L Contr OC-ALC/ITMA Sent: Tuesday, March 11, 2008 2:03 PM To: arslist@ARSLIST.ORG Subject: runmacro.exe ** I have a customer that uses runmacro.exe to submit tickets. Part of what he's sending me is short description. Randomly, he will receive an error saying short description is required, and that he left it blank. However, he is clearly putting data in it. This particular ticket we're looking at, the user has put => a bunch in the short description. We are wondering if this is what would have caused the issue. Does anyone have any feedback on characters you cannot put in the value of a field for runmacro.exe? Thanks, Gary Opela, Jr Sr. Remedy Developer Leader Communications, Inc. __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: Track time on how long the ticket was on a group's queue
What qualifications should I use for the filter that sets the time in and time out? I can get it to work just fine up until if the ticket gets resolved and when it gets reassigned it doesn't track the time in and time out properly. Kaiser Norm E CIV USAF 96 CS/SCCE wrote: > > Creating a separate form is the right idea. > > Put two date/time fields on it--call them what you want...maybe Time in > Queue and Time Out of Queue or something similar. Create two > filters--one that sets the "in" time and one that sets the "out" time. > The one that does that "out" time can also do the calculations I > describe below. > > Have a third field on your form capture the difference between "in" time > and "out" time, and that's simply "out" - "in". That will give you a > number of seconds, so that field should be an integer field. Let's call > that field Total Queue Time. > > Now we need to convert the total number of seconds to the corresponding > days/hours/mins format. Throw three more integer fields onto your form. > Let's call them Queue Time Hours, Queue Time Minutes, and Queue Time > Seconds. You'll use these to calculate the time part of the desired > days/hours/mins format. Set them with these values: > > Queue Time Days = TRUNC($Total Queue Time$ / 86400) > Queue Time Hours = TRUNC((($Total Queue Time$ / 86400) - $Queue Time > Days$) * 24) > Queue Time Minutes = $Total Queue Time$ / 86400) - $Queue Time > Days$) * 24) - $Queue Time Hours$) * 60 > > OK, so now you have a field holding your days, a field holding your > hours, and a field holding your minutes. All you need to do now is > concatenate them into a character field by doing some string functions: > > (((LPAD($Queue Time Days$, 2, "00") + "/") + LPAD($Queue Time Hours$, > 2, "00")) + "/") + LPAD($Queue Time Minutes$, 2, "00") > > In the above I'm doing a series of LPAD functions so the system will > fill in a zero if the value is less than ten. For example, 1 day, 1 > hour, and 1 second would be: 01/01/01. > > HTH, > Norm > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Rocky - > Sent: Monday, March 10, 2008 10:29 AM > To: arslist@ARSLIST.ORG > Subject: Track time on how long the ticket was on a group's queue > > Please help... This is for a custom application and I need to be able to > track how long the ticket is sitting on a groups queue in > days:hours:mins > before it gets re-assigned or resolved. I tried creating a new form > that > supposedly will track the assigned time and reassigned time and I just > can't > get it to work. > > Thanks, > Rocky > -- > View this message in context: > http://www.nabble.com/Track-time-on-how-long-the-ticket-was-on-a-group%2 > 7s-queue-tp15950817p15950817.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" > > -- View this message in context: http://www.nabble.com/Track-time-on-how-long-the-ticket-was-on-a-group%27s-queue-tp15950817p15989839.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"
Re: newScale and Remedy
Actually, I haven't checked SRM 2.1. They may have added the integration. I am sure it was not there in SRM 2.0. Carolyn -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Scott Philben Sent: Tuesday, March 11, 2008 9:11 AM To: arslist@ARSLIST.ORG Subject: newScale and Remedy All: The archives are pretty thin so I will ask it again (in case anyone has new information) Is anyone doing anything with newScale and it's Remedy integration? How does it compare to Remedy's SRM? Does anyone recommend one over the other? If anyone has any knowledge they want to impart, please let me know. -scott ___ 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: SQL Server 2005 Dbase Error = SOLVED
Thanks to All who replied. WeI just upgraded from 7.0.01 Unpatched to Patch 002, and believe it or not, the sql error just stopped. I suspect that it was using 2000 libraries and Patch 002 resolved. Thanks Joe and Bill for your help! Jase Brandon On 3/11/08, Joe D'Souza <[EMAIL PROTECTED]> wrote: > > ** Yes it is, this object has been removed in MS-SQL 2005. > > https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=229015&SiteID=1 > > It is looking for this perhaps because the AR System server was installed > on MS-SQL 2000, and the database was later upgraded. Two things you can do > to resolve this.. Install the MS-SQL 2005 client. If this doesn't resolve > your problem, run the upgrade the AR Server and this would install any 2005 > specific libraries if that is missing.. > > Joe > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] Behalf Of *Jase Brandon > *Sent:* Tuesday, March 11, 2008 1:55 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: SQL Server 2005 Dbase Error > > ** Hi Joe, > My Apologies for not being precise. > > The exact error is shown below. In my humble opinion, it appears that the > server is trying to referenece a dbase object that doesn't exist. > Any input is greatly appreciated > Thanks, :) > > > > /* Fri Jan 25 2008 12:21:18.1240 */*** ERROR *** Invalid object name > 'master..spt_server_info'. (SQL Server 208) > > > > On 3/11/08, Joe D'Souza <[EMAIL PROTECTED]> wrote: > > > > ** Jase, > > > > What was the exact error? > > > > Joe > > > > -Original Message- > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] Behalf Of *Jase Brandon > > *Sent:* Tuesday, March 11, 2008 11:48 AM > > *To:* arslist@ARSLIST.ORG > > *Subject:* SQL Server 2005 Dbase Error > > > > ** Hello All, > > ITSM 7.0.01 > > SQL Server 2005 > > > > We are getting the strangest error in the sql logs, trying to reference > > the table "spt_server_info". > > I have spoken with our DBA and he said this table only existed in SQL > > Server 2000 and not in 2005. > > Has anyone seen anything like this? I don't know how to proceed. Any and > > all comments/questions are appreciated. > > > > Thanks, > > > > Jase Brandon > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > __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: Escalations
In my case, i realized similar situation when my database was busy. Escalations just stopped working, after a while they started again normally... Hugs - Original Message - From: Michiel Beijen Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Thursday, March 06, 2008 11:02 AM Subject: Re: Escalations ** And if you want to know exactly what is happening I would recommend turning on and examining the Escalation log file. -- Met vriendelijke groet / Kind regards Michiel Beijen __ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl On Thu, Mar 6, 2008 at 2:04 PM, Frank Caruso <[EMAIL PROTECTED]> wrote: ** In the admin tool, server config, confg tab. Disable then enable escalations. That should restart escalations On Mar 6, 2008, at 6:54 AM, "Brittain, Mark" <[EMAIL PROTECTED]> wrote: ** Good Morning All, This morning all escalations appear to have stopped working. Escalations fire for different forms at different times to do set fields, push fields, and notifications. Has anyone run into this? ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2 Thanks Mark Mark Brittain ESM Remedy Developer NaviSite Inc. 315-453-2912 x5418 (office) 315-317-2897 (cell) This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __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: Check ARS services from Unix shell script
Hi Joe, I want to a command or a script to check if the arsystem processes are hung for some reason. Processes wise everything is up. However, I want to check if the process is hung in some way since from the Unix side, it seems the arserverd is taking having resources at certain times. Please let me know how to check this. Thanks, Conrad On Tue, Feb 12, 2008 at 10:21 AM, Joe D'Souza <[EMAIL PROTECTED]> wrote: > ** Or you could even try running arsignal -g : from the > AR Server installation directory and if this command doesn't return anything > the services are up.. If it returns a message of any kind, it means the AR > Server is not yet up.. > > Joe > > -Original Message- > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] Behalf Of *Prashant Patil > *Sent:* Tuesday, February 12, 2008 2:04 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Check ARS services from Unix shell script > > ** Hi All, > > > Thanks alot for on all the inputs. > > Prashant > > > > > On Feb 4, 2008 11:55 PM, Wallace, Kelvin <[EMAIL PROTECTED]> > wrote: > > > ** > > > > Prashant, > > > > > > > > I have a script I call "remstat" which is shown below. It allows you to > > quickly see all of the Remedy processes you wish to monitor. You may need > > to tweak it for your needs… > > > > > > > > echo Tomcat - Remedy Mid-Tier - Web > > > > ps -ef | grep tomcat > > > > echo > > > > echo AR Server Daemon -- > > > > ps -ef | grep arserverd > > > > echo > > > > echo AR Monitor > > > > ps -ef | grep armonitor > > > > echo > > > > echo AR Plug-in Server - > > > > ps -ef | grep arplugin > > > > echo > > > > echo AR Assignment Engine -- > > > > ps -ef | grep apsvcae > > > > echo > > > > echo AR Application Dispatcher - > > > > ps -ef | grep arsvcdsp > > > > echo > > > > echo AR Fork Daemon > > > > ps -ef | grep arforkd > > > > echo > > > > echo CMDB Engine --- > > > > ps -ef | grep cmdbd > > > > echo > > > > echo Reconciliation Engine - > > > > ps -ef | grep arrecond > > > > echo > > > > echo AR Flashboards > > > > ps -ef | grep flashboard > > > > echo > > > > echo AR E-mail Engine -- > > > > ps -ef | grep AREmail > > > > echo > > > > > > > > Hope this is helpful. > > > > > > > > Kelvin > > > > > > -- > > > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] *On Behalf Of *Prashant Patil > > *Sent:* Sunday, February 03, 2008 1:48 AM > > *To:* arslist@ARSLIST.ORG > > *Subject:* Check ARS services from Unix shell script > > > > > > > > ** > > > > Dear All, > > > > I have a query regarding ARSystem services on a unix server. > > > > I have a requirement wherein the remedy database needs to be shutdown > > for a particular task. I have a shell script in place for this. It does the > > following: > > > > 1) The shell script shuts down ARS services, checks for the message: > > "Action Request System shutdown process complete" > > > > 2) Shuts down the DB, performs the task and restarts the DB. > > > > 3) Once the DB is up, ARS services is started and checks the message: > > "Action Request System initialization is complete." > > > > I am not sure if the above steps are an efficient way to detect ARS > > services. Is there a better way of checking ARS services from within a shell > > script? > > > > Thanks, > > > > Prashant > > > __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"
Can't delete a user from CTM:People
Hi All, I'm trying to delete some users out of the CTM:People form however I keep getting the error ARERR (382) The value(s) for this entry violate a unique index that has been identified for this form. I ran logs but can't find what it's talking about... I even tried adding a new record and deleting it (which works). The records I can't seem to delete were restored from another server. Setting the status to Delete saved okay... it's just when I try to delete it. I checked the "CTM:SupportGroupFunctionalRole", "CTM:Support Group Association" and there are no entries for the users. They do have entries in CTM:People, CTM:People Permission Groups, and User. If I try to delete the user from any of these forms, I get the unique index error... :( Has anyone encountered this? If so, is there a way to resolve it? I have over 7k records I need to dump and reload... but I have to delete them first. Thanks!!! Mary Dollus ARS 7.0.01 patch 005 SQL server 2005 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Adding fields to the Incident Process Flow Wizard
Hello Listers Has anyone added fields to the Incident flow Process Flow Wizard (Investigation & Diagnosis Form)? If anyone has can someone provided me some insight :-) I have added several fields to the form but the information that is available in the fields do not push the values back to the HPD:HelpDesk form when the request is saved. Thanks in advance Abdul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Can't delete a user from CTM:People
Could I be the licenses or permissions they belong to? Try removing their groups / permissions and try again. On Tue, Mar 11, 2008 at 7:43 PM, Mary Dollus <[EMAIL PROTECTED]> wrote: > ** > > > Hi All, > > > > I'm trying to delete some users out of the CTM:People form however I keep > getting the error ARERR (382) The value(s) for this entry violate a unique > index that has been identified for this form. I ran logs but can't find > what it's talking about… I even tried adding a new record and deleting it > (which works). The records I can't seem to delete were restored from > another server. > > > > Setting the status to Delete saved okay… it's just when I try to delete it. > > > > I checked the "CTM:SupportGroupFunctionalRole", "CTM:Support Group > Association" and there are no entries for the users. > > > > They do have entries in CTM:People, CTM:People Permission Groups, and User. > If I try to delete the user from any of these forms, I get the unique index > error… L > > > > Has anyone encountered this? If so, is there a way to resolve it? I have > over 7k records I need to dump and reload… but I have to delete them first. > > > > Thanks!!! > > Mary Dollus > > > > ARS 7.0.01 patch 005 > > SQL server 2005__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: Question: Overview Console - Assignee
Thank you - I have added fields before. The problem is the Assignee field is not the same on Task, Change and Incident. But I see the Assignee field in SHR:ARDBC. On Tue, Mar 11, 2008 at 2:48 PM, Brandi Barbour <[EMAIL PROTECTED]> wrote: > You must add the entries to the SHR:ARDBCFields form for each field of > the 3 forms and map them to the same field. So you will have 3 > different entries for the Assignee field. One for each form. Once you > do that you add the Assignee field to the table in the Overview Console > with public permissions then restart the plugin. > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee > Sent: Tuesday, March 11, 2008 12:19 PM > To: arslist@ARSLIST.ORG > Subject: Question: Overview Console - Assignee > > I have added a couple of new fields to the Overview Console with no > problems. > > However, the users want to see "Assignee" on the Overview Console. > The problem is the Database ID for Change, Help Desk and Task is not the > same. > > Has anyone added Assignee to their Overview Console? > > Thanks! > > > ___ > 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" > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Can't delete a user from CTM:People
Logs? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mary Dollus Sent: Tuesday, March 11, 2008 7:44 PM To: arslist@ARSLIST.ORG Subject: Can't delete a user from CTM:People ** Hi All, I'm trying to delete some users out of the CTM:People form however I keep getting the error ARERR (382) The value(s) for this entry violate a unique index that has been identified for this form. I ran logs but can’t find what it’s talking about… I even tried adding a new record and deleting it (which works). The records I can’t seem to delete were restored from another server. Setting the status to Delete saved okay… it’s just when I try to delete it. I checked the “CTM:SupportGroupFunctionalRole”, “CTM:Support Group Association” and there are no entries for the users. They do have entries in CTM:People, CTM:People Permission Groups, and User. If I try to delete the user from any of these forms, I get the unique index error… L Has anyone encountered this? If so, is there a way to resolve it? I have over 7k records I need to dump and reload… but I have to delete them first. Thanks!!! Mary Dollus ARS 7.0.01 patch 005 SQL server 2005 No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1325 - Release Date: 3/11/2008 1:41 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: SQL Form?
I found this on the developer network: http://developer.bmc.com/jiveProd/entry.jspa?externalID=1082&categoryID=503 On Tue, Mar 11, 2008 at 1:43 PM, William Rentfrow <[EMAIL PROTECTED]> wrote: > ** > > Agreed! Super easy to build. > > But even EASIER to download and import :) > > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza > Sent: Tuesday, March 11, 2008 12:38 PM > > > To: arslist@ARSLIST.ORG > Subject: Re: SQL Form? > > > > ** > Oh, I had actually built something like that myself years ago, but never > really published it.. It isn't all that difficult to build it. > > Joe > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow > Sent: Tuesday, March 11, 2008 10:47 AM > To: arslist@ARSLIST.ORG > Subject: Re: SQL Form? > > ** > It was a little DEF file that contained a form called "SQL form" and some > active links. It just let you do simple SQL from a Remedy display-only > window. I don't know who developed it but it was a nice end-run around > environments where you don't have direct access to database and want to do > some queries (like checking what form the "T" number was in SQL logs) > > On my "to do" list was to write an updated version of itmight have to > bump that up a few notches... > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza > Sent: Monday, March 10, 2008 4:18 PM > To: arslist@ARSLIST.ORG > Subject: Re: SQL Form? > > > ** > What's the SQL form? > > Joe > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] Behalf Of William Rentfrow > Sent: Monday, March 10, 2008 4:50 PM > To: arslist@ARSLIST.ORG > Subject: SQL Form? > > ** > I used to be able to find the SQL form whenever I needed/wanted it on the > old website (before the BMC Dev Network site). > > Does anyone know where it lives? I can't find itwhich could just be a > case of the Mondays > > William Rentfrow, Principal Consultant > [EMAIL PROTECTED] > C 701-306-6157 > O 952-432-0227__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: Adding fields to the Incident Process Flow Wizard
Are you talking about adding fields to the Dialog windows that pop-up when using the Process Flow Wizard? On Tue, Mar 11, 2008 at 9:43 PM, Abdul Baytops <[EMAIL PROTECTED]> wrote: > ** > > > Hello Listers > > > > Has anyone added fields to the Incident flow Process Flow Wizard > (Investigation & Diagnosis Form)? If anyone has can someone provided me > some insight J I have added several fields to the form but the information > that is available in the fields do not push the values back to the > HPD:HelpDesk form when the request is saved. > > > > Thanks in advance > > Abdul > > __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: Check ARS services from Unix shell script
Conrad, Whenever the arserverd has consumed more resources than average it doesn't always mean it has hung. Try turning on the API/SQL combined logs during such times. It could mean that the arserverd is waiting for available queues for processing but there are no available queues. It could mean you are falling short of fast or list threads.. A combined API/SQL logs would tell you if this is the case from the time that it takes for the execution cycle of an API from the time it is sent to the time a response is received. What are your fast and list threads set to and what is the usage (number of concurrent submits/modify operation, number of concurrent searches either user induced searches or workflow induced) of your AR System? To answer your question on a command or script to check if a AR System process is hung, how would you do that? A process that has hung is still a process. It is still running, and usually ends up hogging more server resources (CPU utilization). However the same process may not be hung but could utilize more than average resources when doing some DB intensive tasks. Does your AR System server terminate when you think it has hung??? Does the armonitor service fail to restart it automatically after such a termination?? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Conrad Pereira Sent: Tuesday, March 11, 2008 6:30 PM To: arslist@ARSLIST.ORG Subject: Re: Check ARS services from Unix shell script ** Hi Joe, I want to a command or a script to check if the arsystem processes are hung for some reason. Processes wise everything is up. However, I want to check if the process is hung in some way since from the Unix side, it seems the arserverd is taking having resources at certain times. Please let me know how to check this. Thanks, Conrad On Tue, Feb 12, 2008 at 10:21 AM, Joe D'Souza <[EMAIL PROTECTED]> wrote: ** Or you could even try running arsignal -g : from the AR Server installation directory and if this command doesn't return anything the services are up.. If it returns a message of any kind, it means the AR Server is not yet up.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Prashant Patil Sent: Tuesday, February 12, 2008 2:04 AM To: arslist@ARSLIST.ORG Subject: Re: Check ARS services from Unix shell script ** Hi All, Thanks alot for on all the inputs. Prashant On Feb 4, 2008 11:55 PM, Wallace, Kelvin <[EMAIL PROTECTED]> wrote: ** Prashant, I have a script I call "remstat" which is shown below. It allows you to quickly see all of the Remedy processes you wish to monitor. You may need to tweak it for your needs… echo Tomcat - Remedy Mid-Tier - Web ps -ef | grep tomcat echo echo AR Server Daemon -- ps -ef | grep arserverd echo echo AR Monitor ps -ef | grep armonitor echo echo AR Plug-in Server - ps -ef | grep arplugin echo echo AR Assignment Engine -- ps -ef | grep apsvcae echo echo AR Application Dispatcher - ps -ef | grep arsvcdsp echo echo AR Fork Daemon ps -ef | grep arforkd echo echo CMDB Engine --- ps -ef | grep cmdbd echo echo Reconciliation Engine - ps -ef | grep arrecond echo echo AR Flashboards ps -ef | grep flashboard echo echo AR E-mail Engine -- ps -ef | grep AREmail echo Hope this is helpful. Kelvin From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Prashant Patil Sent: Sunday, February 03, 2008 1:48 AM To: arslist@ARSLIST.ORG Subject: Check ARS services from Unix shell script ** Dear All, I have a query regarding ARSystem services on a unix server. I have a requirement wherein the remedy database needs to be shutdown for a particular task. I have a shell script in place for this. It does the following: 1) The shell script shuts down ARS services, checks for the message: "Action Request System shutdown process complete" 2) Shuts down the DB, performs the task and restarts the DB. 3) Once the DB is up, ARS services is sta
Re: Can't delete a user from CTM:People
Please send me the log files I can help you on this!!! From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, March 12, 2008 7:41 AM To: arslist@ARSLIST.ORG Subject: Re: Can't delete a user from CTM:People Logs? Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mary Dollus Sent: Tuesday, March 11, 2008 7:44 PM To: arslist@ARSLIST.ORG Subject: Can't delete a user from CTM:People ** Hi All, I'm trying to delete some users out of the CTM:People form however I keep getting the error ARERR (382) The value(s) for this entry violate a unique index that has been identified for this form. I ran logs but can't find what it's talking about... I even tried adding a new record and deleting it (which works). The records I can't seem to delete were restored from another server. Setting the status to Delete saved okay... it's just when I try to delete it. I checked the "CTM:SupportGroupFunctionalRole", "CTM:Support Group Association" and there are no entries for the users. They do have entries in CTM:People, CTM:People Permission Groups, and User. If I try to delete the user from any of these forms, I get the unique index error... :-( Has anyone encountered this? If so, is there a way to resolve it? I have over 7k records I need to dump and reload... but I have to delete them first. Thanks!!! Mary Dollus ARS 7.0.01 patch 005 SQL server 2005 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ - This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
