Question about labels
Hi all!, Anybody knows if the labels of a regular form are stored in any place of the server, or on a particular table (of the Database)?. Thank you very much!. Alberto ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question about labels
Of course, it must be stored in the db. Else how would the ARS server know them? Labels are view based. That is: each view can have a different label for the same field. When a form is saved, if the default view changes, the labels are subject to change. This makes queries (which accept labels and field ids - but NOT field names) ugly to read in multi-language shops. Meta-Update queries can use field ids, labels, or names. Check out the Database Reference Guide manual for where field labels are stored. Sorry, I don't know the view tables off the top of my head as I use the API for that type of info and I've never had to adjust views tables for problems I've had to fix. What is it you are trying to do? Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email:mailto:ben.cher...@softwaretoolhouse.com ben.cher...@softwaretoolhouse.com Web: http://www.softwaretoolhouse.com/ www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Alberto Mel. Sent: May 12, 2010 9:27 AM To: arslist@ARSLIST.ORG Subject: Question about labels ** Hi all!, Anybody knows if the labels of a regular form are stored in any place of the server, or on a particular table (of the Database)?. Thank you very much!. Alberto _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question about labels
Hi Ben!. First, thanks a lot for your answer. I realized not to take a look to the document DB reference guide. The question is for making reports with a tool that takes the data directly to the Remedy Data Base. It's for a collegue, but your information is very useful!. Thank you very much again! Albertp 2010/5/12 Ben Chernys ben.cher...@softwaretoolhouse.com ** Of course, it must be stored in the db. Else how would the ARS server know them? Labels are view based. That is: each view can have a different label for the same field. When a form is saved, if the default view changes, the labels are subject to change. This makes queries (which accept labels and field ids - but NOT field names) ugly to read in multi-language shops. Meta-Update queries can use field ids, labels, or names. Check out the Database Reference Guide manual for where field labels are stored. Sorry, I don't know the view tables off the top of my head as I use the API for that type of info and I've never had to adjust views tables for problems I've had to fix. What is it you are trying to do? Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. *Meta-Update,* our premium ARS Data tool, lets you automate your imports, migrations, *in no time at all*, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/http://www.softwaretoolhouse.com/ -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Alberto Mel. *Sent:* May 12, 2010 9:27 AM *To:* arslist@ARSLIST.ORG *Subject:* Question about labels ** Hi all!, Anybody knows if the labels of a regular form are stored in any place of the server, or on a particular table (of the Database)?. Thank you very much!. Alberto _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question about labels
Hi Ben, when I told to my collegue your explanatiom, he told me that he need the value of the Incident and Change impact.so, it's in a form (SYS:Menu items). I misunderstood the question of my collegue. But, thank for your help!. Alberto 2010/5/12 Alberto Mel. alberto.rem...@gmail.com Hi Ben!. First, thanks a lot for your answer. I realized not to take a look to the document DB reference guide. The question is for making reports with a tool that takes the data directly to the Remedy Data Base. It's for a collegue, but your information is very useful!. Thank you very much again! Albertp 2010/5/12 Ben Chernys ben.cher...@softwaretoolhouse.com ** Of course, it must be stored in the db. Else how would the ARS server know them? Labels are view based. That is: each view can have a different label for the same field. When a form is saved, if the default view changes, the labels are subject to change. This makes queries (which accept labels and field ids - but NOT field names) ugly to read in multi-language shops. Meta-Update queries can use field ids, labels, or names. Check out the Database Reference Guide manual for where field labels are stored. Sorry, I don't know the view tables off the top of my head as I use the API for that type of info and I've never had to adjust views tables for problems I've had to fix. What is it you are trying to do? Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. *Meta-Update,* our premium ARS Data tool, lets you automate your imports, migrations, *in no time at all*, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/http://www.softwaretoolhouse.com/ -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Alberto Mel. *Sent:* May 12, 2010 9:27 AM *To:* arslist@ARSLIST.ORG *Subject:* Question about labels ** Hi all!, Anybody knows if the labels of a regular form are stored in any place of the server, or on a particular table (of the Database)?. Thank you very much!. Alberto _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Start AR Server With Erro Messages
Thanks for replying ,the problem seems caused by the database and I 'm working on it ,The file has been deleted by the Nabble. Joe DeSouza wrote: We couldn't see your text content of the error and I do not want to download a txt file from an unidentified source.. So could you print the content of the text in the email body? Joe From: honormine honorm...@gmail.com To: arslist@ARSLIST.ORG Sent: Tue, May 11, 2010 3:56:01 AM Subject: Start AR Server With Erro Messages I restarted the AR Server ,there is so many error messages, http://old.nabble.com/file/p28521044/Errors.txt Errors.txt -- View this message in context: http://old.nabble.com/Start-AR-Server-With-Erro-Messages-tp28521044p28521044.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are :-(( -- View this message in context: http://old.nabble.com/Re%3A-Start-AR-Server-With-Erro-Messages-tp28525909p28533655.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question about labels
Hi, You can allways have a look at the free utility RRR|DefFieldList: https://www.rrr.se/cgi/tools/main#rrrDefFieldList It will give you a TXT, SKV or XLS file with the following info: Form Id Name Label Type Option Length Enum-values Default Pattern and Menu As input, it takes a def-file-export of the forms you want to report on. Best Regards - Misi, RRR AB, http://rrr.se Hi Ben, when I told to my collegue your explanatiom, he told me that he need the value of the Incident and Change impact.so, it's in a form (SYS:Menu items). I misunderstood the question of my collegue. But, thank for your help!. Alberto 2010/5/12 Alberto Mel. alberto.rem...@gmail.com Hi Ben!. First, thanks a lot for your answer. I realized not to take a look to the document DB reference guide. The question is for making reports with a tool that takes the data directly to the Remedy Data Base. It's for a collegue, but your information is very useful!. Thank you very much again! Albertp 2010/5/12 Ben Chernys ben.cher...@softwaretoolhouse.com ** Of course, it must be stored in the db. Else how would the ARS server know them? Labels are view based. That is: each view can have a different label for the same field. When a form is saved, if the default view changes, the labels are subject to change. This makes queries (which accept labels and field ids - but NOT field names) ugly to read in multi-language shops. Meta-Update queries can use field ids, labels, or names. Check out the Database Reference Guide manual for where field labels are stored. Sorry, I don't know the view tables off the top of my head as I use the API for that type of info and I've never had to adjust views tables for problems I've had to fix. What is it you are trying to do? Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email: ben.cher...@softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. *Meta-Update,* our premium ARS Data tool, lets you automate your imports, migrations, *in no time at all*, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/http://www.softwaretoolhouse.com/ -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Alberto Mel. *Sent:* May 12, 2010 9:27 AM *To:* arslist@ARSLIST.ORG *Subject:* Question about labels ** Hi all!, Anybody knows if the labels of a regular form are stored in any place of the server, or on a particular table (of the Database)?. Thank you very much!. Alberto _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Invitation: OT: Enhanced Searching within Remedy (May 20 11:00 AM CDT)
Woops - Let me send in plain text. Thanks for pointing that out! Andrew Paolino Column Technologies 130 William Street, 8th Floor New York, New York 10038 Cell: 551-486-2549 Office: 201-676-0277 Fax: 212-227-3040 Email: apaol...@columnit.com LinkedIn: http://www.linkedin.com/in/apaolino Skype ID: apaolino Web: http://www.columnit.com Please consider the environment before printing this email -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of James Lauber Sent: Tuesday, May 11, 2010 3:31 PM To: arslist@ARSLIST.ORG Subject: Invitation: OT: Enhanced Searching within Remedy (May 20 11:00 AM CDT) This is a multipart message in MIME format. --=_mixed FF4A211F4A10F5EE85257720006B2663_= Content-Type: multipart/related; boundary==_related FF4A211F4A10F5EE85257720006B2663_= --=_related FF4A211F4A10F5EE85257720006B2663_= Content-Type: multipart/alternative; boundary==_alternative FF4A211F4A10F5EE85257720006B2663_= --=_alternative FF4A211F4A10F5EE85257720006B2663_= Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 CgoKX19fX19fX19fX19fX19fX19fCgoKKioKCkdvb2QgYWZ0ZXJub29uIGFsbCwKCgoKQ29sdW1u IElUIHdpbGwgYmUgaG9zdGluZyBhIHdlYmluYXIgb24gVGh1cnNkYXksIE1heSAyMHRoIMKgYXQg MTFhbSBDU1QKYWJvdXQgYSBuZXcgdG9vbCB0aGF0IHdlIHdpbGwgYmUgb2ZmZXJpbmcg4oCTIENv bHVtbiBTZWFyY2gg4oCTIGFuZCBpdCB3b3VsZCBiZQpncmVhdCBpZiB5b3UgY291bGQgYXR0ZW5k ISEKCgoKRm9yIHRoZSBmaXJzdCB0aW1lLCBDb2x1bW4gU2VhcmNoIHdpbGwgZW5hYmxlIHVzZXJz IHRvIHNlYXJjaCB0aHJvdWdoIHRoZWlyClJlbWVkeSBkYXRhYmFzZXMgYW5kIHRpY2tldCBoaXN0 b3JpZXMgZnJvbSBhIHNpbmdsZSwgY29udmVuaWVudCB3ZWIgcG9ydGFsOgoKwrfCoMKgwqDCoMKg wqDCoMKgIFdlYiAyLjAgR1VJOwoKwrfCoMKgwqDCoMKgwqDCoMKgIE5hdHVyYWwgbGFuZ3VhZ2Ug cXVlcmllczsKCsK3wqDCoMKgwqDCoMKgwqDCoCBGdXp6eSBTZWFyY2ggQ2FwYWJpbGl0aWVzOwoK b1NpbWlsYXIgdG8gR29vZ2xl4oCZcyDigJxEaWQgeW91IG1lYW4/4oCdCgrCt8KgwqDCoMKgwqDC oMKgwqAgSW5kZXhlZCBzZWFyY2ggdGhyb3VnaCBkb2N1bWVudCByZXBvc2l0b3JpZXM7CgrCt8Kg wqDCoMKgwqDCoMKgwqAgV29ya3Mgd2l0aCBjdXN0b20gYXBwbGljYXRpb25zIQoKCgpUaGUgd2Vi aW5hciBGUkVFIHRvIGF0dGVuZDsgSG9wZSB5b3UgY2FuIG1ha2UgaXQhIOKAk0FuZHJldwoKCgpS ZWdpc3RyYXRpb24gSW5mbzoKCgoKCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICBUaHVyc2RheSwgTWF5IDIwdGggICAg ICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAxMTow MCAtIDEyOjAwIHAubS4gQ1NUICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgCgoKCkFuZHJldyBQYW9saW5vCgpDb2x1bW4gVGVj aG5vbG9naWVzCgoKCjEzMCBXaWxsaWFtIFN0cmVldCwgOHRoIEZsb29yCgpOZXcgWW9yaywgTmV3 IFlvcmsgMTAwMzgKCgoKQ2VsbDogNTUxLTQ4Ni0yNTQ5CgpPZmZpY2U6IDIwMS02NzYtMDI3NwoK RmF4OiAyMTItMjI3LTMwNDAKCkVtYWlsOiBhcGFvbGlub0Bjb2x1bW5pdC5jb20KCkxpbmtlZElu OiBodHRwOi8vd3d3LmxpbmtlZGluLmNvbS9pbi9hcGFvbGlubwoKU2t5cGUgSUQ6IGFwYW9saW5v CgpXZWI6IGh0dHA6Ly93d3cuY29sdW1uaXQuY29tCgoKClAgUGxlYXNlIGNvbnNpZGVyIHRoZSBl bnZpcm9ubWVudCBiZWZvcmUgcHJpbnRpbmcgdGhpcyBlbWFpbAogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAoKCgoKClRoZSBjb250ZW50 cyBvZiB0aGlzIGVtYWlsIGFyZSB0aGUgcHJvcGVydHkgb2YgUE5DLiBJZiBpdCB3YXMgbm90IGFk ZHJlc3NlZCB0byB5b3UsIHlvdSBoYXZlIG5vIGxlZ2FsIHJpZ2h0IHRvIHJlYWQgaXQuIElmIHlv dSB0aGluayB5b3UgcmVjZWl2ZWQgaXQgaW4gZXJyb3IsIHBsZWFzZSBub3RpZnkgdGhlIHNlbmRl ci4gRG8gbm90IGZvcndhcmQgb3IgY29weSB3aXRob3V0IHBlcm1pc3Npb24gb2YgdGhlIHNlbmRl ci4gVGhpcyBtZXNzYWdlIG1heSBjb250YWluIGFuIGFkdmVydGlzZW1lbnQgb2YgYSBwcm9kdWN0 IG9yIHNlcnZpY2UgYW5kIHRodXMgbWF5IGNvbnN0aXR1dGUgYSBjb21tZXJjaWFsIGVsZWN0cm9u aWMgbWFpbCBtZXNzYWdlIHVuZGVyIFVTIExhdy4gUE5D4oCZcyBwb3N0YWwgYWRkcmVzcyBpcyAy NDkgRmlmdGggQXZlbnVlLCBQaXR0c2J1cmdoLCBQQSAxNTIyMi4gSWYgeW91IGRvIG5vdCB3aXNo IHRvIHJlY2VpdmUgYW55IGFkZGl0aW9uYWwgYWR2ZXJ0aXNpbmcgb3IgcHJvbW90aW9uYWwgbWVz c2FnZXMgZnJvbSBQTkMgYXQgdGhpcyBlLW1haWwgYWRkcmVzcywgY2xpY2sgaGVyZSB0byBVbnN1 YnNjcmliZS4gaHR0cHM6Ly9wbmMucC5kZWxpdmVyeS5uZXQvbS91L3BuYy91bmkvcC5hc3AgQnkg dW5zdWJzY3JpYmluZyB0byB0aGlzIG1lc3NhZ2UsIHlvdSB3aWxsIGJlIHVuc3Vic2NyaWJlZCBm cm9tIGFsbCBhZHZlcnRpc2luZyBvciBwcm9tb3Rpb25hbCBtZXNzYWdlcyBmcm9tIFBOQy4gUmVt b3ZpbmcgeW91ciBlLW1haWwgYWRkcmVzcyBmcm9tIHRoaXMgbWFpbGluZyBsaXN0IHdpbGwgbm90 IGFmZmVjdCB5b3VyIHN1YnNjcmlwdGlvbiB0byBhbGVydHMsIGUtbmV3c2xldHRlcnMgb3IgYWNj b3VudCBzZXJ2aWNpbmcgZS1tYWlscy4gICAK --=_alternative FF4A211F4A10F5EE85257720006B2663_= Content-Type: text/html; charset=UTF-8 Content-Disposition: inline Content-Transfer-Encoding: base64
OT: Enhanced Searching within Remedy (Invitation Corrected)
Good morning all, Column IT will be hosting a webinar on Thursday, May 20th at 11am CST about a new tool that we will be offering – Column Search – and it would be great if you could attend!! For the first time, Column Search will enable users to search through their Remedy databases and ticket histories from a single, convenient web portal: • Web 2.0 GUI that can be displayed inline on Mid Tier or deployed separately; • Natural language queries; • Fuzzy Search Capabilities - Similar to Google’s “Did you mean?” • Indexed search through document repositories; • Works with custom applications! The webinar is FREE to attend; Hope you can make it! –Andrew Registration URL: https://columnit.webex.com/columnit/onstage/g.php?t=ad=579289829 Date/Time: Thursday, May 20th - 11am CST Andrew Paolino Column Technologies 130 William Street, 8th Floor New York, New York 10038 Cell: 551-486-2549 Office: 201-676-0277 Fax: 212-227-3040 Email: apaol...@columnit.com LinkedIn: http://www.linkedin.com/in/apaolino Skype ID: apaolino Web: http://www.columnit.com Please consider the environment before printing this email
ADM:Timing Test
Please note: the wwwrug server seems to have died in the last few hours, so there may be delays at the moment. 8:16am Dan ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
notifications not being created
Group and individual/Assignee+ assignment notifications are intermittently not being created Viewing the audit log 9on individual Incident, CRQ, etc), notifications alerts and emails are not being created. Incident creation notifications (email) to customer are being created There are no errors in arerror.log. Upon restarting the email engine all notifications are created. Sincerely, Jesse Isselbacher This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: RKM Browse Tab
You would want to look at using the template.html file and inject some javascript that hides it. Alan BlakeKnowlysis --- On Tue, 5/11/10, versicle versi...@aol.com wrote: From: versicle versi...@aol.com Subject: RKM Browse Tab To: arslist@ARSLIST.ORG Date: Tuesday, May 11, 2010, 12:02 PM All, Does anyone know if it's possible to hide the Browse tab within RKM? If so, how? We are running RKM 7.5 p1. TIA, Mike -- View this message in context: http://old.nabble.com/RKM-Browse-Tab-tp28527420p28527420.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: {Remedy ARS} Re: COLCOUNT not working
Hi Raj,
In the table properties go to the Advanced Display. There under Data Chunking
there is a field named Chunk Size or Size of Chunk depending on your version.
The default is 0 which means unlimited number of records are displayed. Not
sure if the chunking would affect the column count but figure it is worth
checking.
FYI
Mark
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Raj
Sent: Tuesday, May 11, 2010 3:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: {Remedy ARS} Re: COLCOUNT not working
Thank you Mark for the reply.
Where can I check the Table Chunking value?
On May 10, 12:03 pm, Brittain, Mark mbritt...@navisite.com wrote:
Raj,
Any chance the Table Chunking is set to 15? I know it is a wild thought but
it is the only thing I can think of that might explain the behavior.
Mark
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Raj
Sent: Monday, May 10, 2010 2:21 PM
To: arsl...@arslist.org
Subject: Re: {Remedy ARS} Re: COLCOUNT not working
Hi Joe,
Filter is on submit.
Only one If Action
Set Fields Action (Current Transaction- Current Transaction)
FIELD NAME--COLCOUNT($COLUMN NAME$)
(There is only one column in the table, that DB ID of the column field
is COLUMN NAME and DB ID of the field to be set is FIELD NAME. I
am doing the above action , please see below for more details:
Set Fields Action
Name FIELD NAME
Value COLCOUNT($COLUMN NAME$)
This COLCOUNT is not working properly, it is always setting the value
15 to the field FIELD NAME. Although I checked there are 20 entries
in that column(Table).
So the value should be 20 but it is 15.
Thanks,
Raj
On May 10, 11:01 am, Joe DeSouza joe_rem...@yahoo.com wrote:
Raj,
sum(fieldname) is the function used across most standard databases to do
something similar to a colcount()
update table tablename set fieldname = sum(field2name) where your
conditions...
Just curious - what are your actions on your filter that doesn't seem to
work?
Hope this helps..
Cheers
Joe
From: Raj ravi6...@gmail.com
To: arsl...@arslist.org
Sent: Mon, May 10, 2010 11:41:19 AM
Subject: COLCOUNT not working
Hi All,
Setting a field with COLCOUNT($COLUMN FIELD ID$) in a Set Fields
action of a Filter on Submit. Seems is it not working. Always setting
the field to a constant value of 15.
Would like to set the field with the number of rows in that particular
table. Is the any other way around to do this?
How can it be done with the help of Direct SQL ?
Please advise.
Thanks,
Ravi
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist:Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist:Where the Answers Are
--
You received this message because you are subscribed to the Google Groups
Remedy ARS group.
To post to this group, send email to arsl...@googlegroups.com.
To unsubscribe from this group, send email to
arslist+unsubscr...@googlegroups.com.
For more options, visit this group
athttp://groups.google.com/group/arslist?hl=en.
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist: Where the Answers Are
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.
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist: Where the Answers Are
--
You received this message because you are subscribed to the Google Groups
Remedy ARS group.
To post to this group, send email to arsl...@googlegroups.com.
To unsubscribe from this group, send email to
arslist+unsubscr...@googlegroups.com.
For more options, visit this group
athttp://groups.google.com/group/arslist?hl=en.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
fire AL when window open only in Search Mode
Hi Folks! Is it possible to fire AL when window open only in Search Mode (on Mid Tier), I'm tried to play with keyword $OPERATION$ in qualification but without result.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Question on Remedy Performance
We are running ARS 7.1 patch 006 with ITSM 7.0.03 patch 007. The applications for the most part have been out of the box implementations, we have made some customizations but they have been minor in scope. Our application servers are dual 3.0ghz Xeon boxes with 8gb of memory running windows 2003 Enterprise. The database is Oracle 11 on a Sun V440 4 CPU 32gb memory dedicated box. Both the application server and database are on gigabit network connections. This has been bugging me for a while and I can't seem to figure out why the application server and database for the most part sit there at an idle, yet we have lackluster performance of the remedy system in regards to the customer experience on the desktop and web client. The performance is not terrible, however due to the under utilization of the hardware I would expect better response than what we are seeing. What I'm looking for is some pointers or documentation someone might know about that would help to identify anything that would be causing this behavior. I have read the scalability white papers published by BMC, which closely mirrors our configuration and this has been of little value. Jim Coryat Micron Technology Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: fire AL when window open only in Search Mode
Audrey, Here is how I would do it. Write the AL with no Qual, in the If action, add a message action with the value $OPERATION$ in its text, run it in the client (web or client, but if web, flush your cache) when the AL executes it will tell you what operation is being performedfrom there, modify the run-if to only fire on that operation name I often forget the operation names for various actionsI know I can look it up in the docs, but it's sometimes easier to follow the process I just described to get the operation you are looking for :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Andrey Sent: Wednesday, May 12, 2010 8:33 AM To: arslist@ARSLIST.ORG Subject: fire AL when window open only in Search Mode Hi Folks! Is it possible to fire AL when window open only in Search Mode (on Mid Tier), I'm tried to play with keyword $OPERATION$ in qualification but without result.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question on Remedy Performance
Jim, What I would recommend is to turn on SQL/Filter/API logs into a single log and then run one of your 'lackluster' operations. Then run the log through the log analyzer. It'll give you your longest api and sql transactions (depending on the options you select)..then you can analyze the queries to find out what filters they come through and such..the log analyzer is a VERY powerful troubleshooting tool. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jim Coryat (jcoryat) Sent: Wednesday, May 12, 2010 8:35 AM To: arslist@ARSLIST.ORG Subject: Question on Remedy Performance ** We are running ARS 7.1 patch 006 with ITSM 7.0.03 patch 007. The applications for the most part have been out of the box implementations, we have made some customizations but they have been minor in scope. Our application servers are dual 3.0ghz Xeon boxes with 8gb of memory running windows 2003 Enterprise. The database is Oracle 11 on a Sun V440 4 CPU 32gb memory dedicated box. Both the application server and database are on gigabit network connections. This has been bugging me for a while and I can't seem to figure out why the application server and database for the most part sit there at an idle, yet we have lackluster performance of the remedy system in regards to the customer experience on the desktop and web client. The performance is not terrible, however due to the under utilization of the hardware I would expect better response than what we are seeing. What I'm looking for is some pointers or documentation someone might know about that would help to identify anything that would be causing this behavior. I have read the scalability white papers published by BMC, which closely mirrors our configuration and this has been of little value. Jim Coryat Micron Technology Inc. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question on Remedy Performance
The AR system is very latency bound. E.g. if your end users have a latency above 40ms, then you will start to notice a performance hit. Also, ITSM applications at that version was not built for performance but functionality. I have done some work on this and I am happy to share some documents with you off list. Some of the obvious things that were done include removing the option on Refresh on entry change on the tables within the incident form. For example if I remember there were approx 5 tables, so when you open / select an incident, all those refreshed when in reality, you won't want to see the financial information every time etc. Send me an email and I will dig out the docs for you. dkellett (at) javasystemsolutions.com Kind regards Danny Kellett SSO for ARS http://www.javasystemsolutions.com/jss/ssoplugin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jim Coryat (jcoryat) Sent: 12 May 2010 15:35 To: arslist@ARSLIST.ORG Subject: Question on Remedy Performance ** We are running ARS 7.1 patch 006 with ITSM 7.0.03 patch 007. The applications for the most part have been out of the box implementations, we have made some customizations but they have been minor in scope. Our application servers are dual 3.0ghz Xeon boxes with 8gb of memory running windows 2003 Enterprise. The database is Oracle 11 on a Sun V440 4 CPU 32gb memory dedicated box. Both the application server and database are on gigabit network connections. This has been bugging me for a while and I can't seem to figure out why the application server and database for the most part sit there at an idle, yet we have lackluster performance of the remedy system in regards to the customer experience on the desktop and web client. The performance is not terrible, however due to the under utilization of the hardware I would expect better response than what we are seeing. What I'm looking for is some pointers or documentation someone might know about that would help to identify anything that would be causing this behavior. I have read the scalability white papers published by BMC, which closely mirrors our configuration and this has been of little value. Jim Coryat Micron Technology Inc. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: {Remedy ARS} Re: COLCOUNT not working
Hi Mark,
Just checked, it is set to default value 0.
Thank you,
Raj
On Wed, May 12, 2010 at 7:28 AM, Brittain, Mark mbritt...@navisite.comwrote:
Hi Raj,
In the table properties go to the Advanced Display. There under Data
Chunking there is a field named Chunk Size or Size of Chunk depending on
your version. The default is 0 which means unlimited number of records are
displayed. Not sure if the chunking would affect the column count but figure
it is worth checking.
FYI
Mark
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:
arsl...@arslist.org] On Behalf Of Raj
Sent: Tuesday, May 11, 2010 3:52 PM
To: arslist@ARSLIST.ORG
Subject: Re: {Remedy ARS} Re: COLCOUNT not working
Thank you Mark for the reply.
Where can I check the Table Chunking value?
On May 10, 12:03 pm, Brittain, Mark mbritt...@navisite.com wrote:
Raj,
Any chance the Table Chunking is set to 15? I know it is a wild thought
but it is the only thing I can think of that might explain the behavior.
Mark
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:
arsl...@arslist.org] On Behalf Of Raj
Sent: Monday, May 10, 2010 2:21 PM
To: arsl...@arslist.org
Subject: Re: {Remedy ARS} Re: COLCOUNT not working
Hi Joe,
Filter is on submit.
Only one If Action
Set Fields Action (Current Transaction- Current Transaction)
FIELD NAME--COLCOUNT($COLUMN NAME$)
(There is only one column in the table, that DB ID of the column field
is COLUMN NAME and DB ID of the field to be set is FIELD NAME. I
am doing the above action , please see below for more details:
Set Fields Action
Name FIELD NAME
Value COLCOUNT($COLUMN NAME$)
This COLCOUNT is not working properly, it is always setting the value
15 to the field FIELD NAME. Although I checked there are 20 entries
in that column(Table).
So the value should be 20 but it is 15.
Thanks,
Raj
On May 10, 11:01 am, Joe DeSouza joe_rem...@yahoo.com wrote:
Raj,
sum(fieldname) is the function used across most standard databases to
do something similar to a colcount()
update table tablename set fieldname = sum(field2name) where your
conditions...
Just curious - what are your actions on your filter that doesn't seem
to work?
Hope this helps..
Cheers
Joe
From: Raj ravi6...@gmail.com
To: arsl...@arslist.org
Sent: Mon, May 10, 2010 11:41:19 AM
Subject: COLCOUNT not working
Hi All,
Setting a field with COLCOUNT($COLUMN FIELD ID$) in a Set Fields
action of a Filter on Submit. Seems is it not working. Always setting
the field to a constant value of 15.
Would like to set the field with the number of rows in that particular
table. Is the any other way around to do this?
How can it be done with the help of Direct SQL ?
Please advise.
Thanks,
Ravi
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist:Where the Answers Are
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist:Where the Answers Are
--
You received this message because you are subscribed to the Google
Groups Remedy ARS group.
To post to this group, send email to arsl...@googlegroups.com.
To unsubscribe from this group, send email to
arslist+unsubscr...@googlegroups.comarslist%2bunsubscr...@googlegroups.com
.
For more options, visit this group athttp://
groups.google.com/group/arslist?hl=en.
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist: Where the Answers Are
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.
___
UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org
attend wwrug10www.wwrug.comARSlist: Where the Answers Are
--
You received this message because you are subscribed to the Google Groups
Remedy ARS group.
To post to this group, send email to arsl...@googlegroups.com.
To unsubscribe from this group, send email to
arslist+unsubscr...@googlegroups.comarslist%2bunsubscr...@googlegroups.com
.
For more options, visit this group athttp://
groups.google.com/group/arslist?hl=en.
___
Re: fire AL when window open only in Search Mode
All what I need - fire AL if window opened only on Search Mode Currently I have test AL with Execute On: Display, Window Open, Window Load Run If: $OPERATION$=QUERY If Action: Message (test) ... but this AL also triggered when a window opened in New or Modify Mode and I can not understand what is happening ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: notifications not being created
I had a similar issue where a particular support group was sometimes not receiving email notifications. Turned out that that particular support group had Business Hours and Holidays setup, none of the other support group had them. This may not be related to your issue as restarting the EE fixes your issue. When you say notifications are intermittently not being created.. you mean in the AR System Email Messages form, correct? Check form NTE:Notifier Log. Record Identifier = INC0xxx. To make sure your notification is being created. Marcelo -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jesse Sent: Wednesday, May 12, 2010 8:46 AM To: arslist@ARSLIST.ORG Subject: notifications not being created Group and individual/Assignee+ assignment notifications are intermittently not being created Viewing the audit log 9on individual Incident, CRQ, etc), notifications alerts and emails are not being created. Incident creation notifications (email) to customer are being created There are no errors in arerror.log. Upon restarting the email engine all notifications are created. Sincerely, Jesse Isselbacher This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: fire AL when window open only in Search Mode
Which version(s)/Platform(s) are you using? AR Server? Database? Mid-Tier? User Tool? Browser? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Andrey Sent: Wednesday, May 12, 2010 10:13 AM To: arslist@ARSLIST.ORG Subject: Re: fire AL when window open only in Search Mode All what I need - fire AL if window opened only on Search Mode Currently I have test AL with Execute On: Display, Window Open, Window Load Run If: $OPERATION$=QUERY If Action: Message (test) ... but this AL also triggered when a window opened in New or Modify Mode and I can not understand what is happening ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question on Remedy Performance
Also, Check you indexes on things like AR System Message Catalog, and the Help desk form. Our otb Help Desk form had 16 indexes on it (17 if you count entry id). That will cause slowness on a save. Danny, We have been having performance problems as well (same versions too) Usually it has to do with someone running a bad query and locking the table. Or fields not getting set, and then a table using an external table qualification with an empty field (translates it into 1 = 1) Any documentation you have I would be very interested in. Thanks, Matt P. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Danny Kellett Sent: Wednesday, May 12, 2010 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Question on Remedy Performance ** The AR system is very latency bound. E.g. if your end users have a latency above 40ms, then you will start to notice a performance hit. Also, ITSM applications at that version was not built for performance but functionality. I have done some work on this and I am happy to share some documents with you off list. Some of the obvious things that were done include removing the option on Refresh on entry change on the tables within the incident form. For example if I remember there were approx 5 tables, so when you open / select an incident, all those refreshed when in reality, you won't want to see the financial information every time etc. Send me an email and I will dig out the docs for you. dkellett (at) javasystemsolutions.com Kind regards Danny Kellett SSO for ARS http://www.javasystemsolutions.com/jss/ssoplugin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jim Coryat (jcoryat) Sent: 12 May 2010 15:35 To: arslist@ARSLIST.ORG Subject: Question on Remedy Performance ** We are running ARS 7.1 patch 006 with ITSM 7.0.03 patch 007. The applications for the most part have been out of the box implementations, we have made some customizations but they have been minor in scope. Our application servers are dual 3.0ghz Xeon boxes with 8gb of memory running windows 2003 Enterprise. The database is Oracle 11 on a Sun V440 4 CPU 32gb memory dedicated box. Both the application server and database are on gigabit network connections. This has been bugging me for a while and I can't seem to figure out why the application server and database for the most part sit there at an idle, yet we have lackluster performance of the remedy system in regards to the customer experience on the desktop and web client. The performance is not terrible, however due to the under utilization of the hardware I would expect better response than what we are seeing. What I'm looking for is some pointers or documentation someone might know about that would help to identify anything that would be causing this behavior. I have read the scalability white papers published by BMC, which closely mirrors our configuration and this has been of little value. Jim Coryat Micron Technology Inc. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Query format question
HI All I would like to do an Advanced Search query on a group of records based on the Account ID. I could do 'Account ID' = 12345 OR 'Account ID' = 23456 OR 'Account ID' = 98745 OR But I was thinking I could do something like 'Account ID' = 12345;23456;98745 but I can't get the format right. Anyone know the right syntax? Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.commailto:mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Query format question
Advanced Query does not accept the db IN statement which would allow 'Account ID' IN (12345,23456,98745) You have to do 'Account ID' = xxx OR 'Account ID' = yyy ... Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Wednesday, May 12, 2010 11:40 AM To: arslist@ARSLIST.ORG Subject: Query format question ** HI All I would like to do an Advanced Search query on a group of records based on the Account ID. I could do 'Account ID' = 12345 OR 'Account ID' = 23456 OR 'Account ID' = 98745 OR But I was thinking I could do something like 'Account ID' = 12345;23456;98745 but I can't get the format right. Anyone know the right syntax? Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Current LDAP Limitations?
Back around Remedy 5.6 was the last time I tried to pull large quantities of data from Active Directory using the Remedy LDAP/ARDBC Active Directory integration. Setting it up was easy but we had two issues back then: 1.) We couldn't query by date fields - no results were returned 2.) Page sizing was an issue and it would only return X,XXX records - To get the 750,000 I needed we had to do batches. So - does anyone know if these issues are fixed? If I remember right it wasn't actually a BMC problem but it was related to the MS connector. I can't find any good info on this. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com http://www.stratacominc.com/ Blog, www.williamrentfrow.com http://www.williamrentfrow.com/ 715-410-8156 C ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Query format question
You could try the opposite approach: 12345,23456,98745 LIKE %+ 'Account ID + % Dwayne Martin James Madison University -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, May 12, 2010 12:58 PM To: arslist@ARSLIST.ORG Subject: Re: Query format question Advanced Query does not accept the db IN statement which would allow 'Account ID' IN (12345,23456,98745) You have to do 'Account ID' = xxx OR 'Account ID' = yyy ... Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brittain, Mark Sent: Wednesday, May 12, 2010 11:40 AM To: arslist@ARSLIST.ORG Subject: Query format question ** HI All I would like to do an Advanced Search query on a group of records based on the Account ID. I could do 'Account ID' = 12345 OR 'Account ID' = 23456 OR 'Account ID' = 98745 OR But I was thinking I could do something like 'Account ID' = 12345;23456;98745 but I can't get the format right. Anyone know the right syntax? Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com (315) 453-2912 x5335 (Phone) (315) 317.2897 (Cell) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Question on Remedy Performance
You have a remote Oracle instance on Sun. You need to contact support and get the CLOB in-row fix information. This causes severe performance problems in many situations. I've run into this now on a total of 8 Remedy implementations of 7.1 and higher. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com http://www.stratacominc.com/ Blog, www.williamrentfrow.com http://www.williamrentfrow.com/ 715-410-8156 C From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Matthew Perrault Sent: Wednesday, May 12, 2010 11:34 AM To: arslist@ARSLIST.ORG Subject: Re: Question on Remedy Performance ** Also, Check you indexes on things like AR System Message Catalog, and the Help desk form. Our otb Help Desk form had 16 indexes on it (17 if you count entry id). That will cause slowness on a save. Danny, We have been having performance problems as well (same versions too) Usually it has to do with someone running a bad query and locking the table. Or fields not getting set, and then a table using an external table qualification with an empty field (translates it into 1 = 1) Any documentation you have I would be very interested in. Thanks, Matt P. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Danny Kellett Sent: Wednesday, May 12, 2010 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: Question on Remedy Performance ** The AR system is very latency bound. E.g. if your end users have a latency above 40ms, then you will start to notice a performance hit. Also, ITSM applications at that version was not built for performance but functionality. I have done some work on this and I am happy to share some documents with you off list. Some of the obvious things that were done include removing the option on Refresh on entry change on the tables within the incident form. For example if I remember there were approx 5 tables, so when you open / select an incident, all those refreshed when in reality, you won't want to see the financial information every time etc. Send me an email and I will dig out the docs for you. dkellett (at) javasystemsolutions.com Kind regards Danny Kellett SSO for ARS http://www.javasystemsolutions.com/jss/ssoplugin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jim Coryat (jcoryat) Sent: 12 May 2010 15:35 To: arslist@ARSLIST.ORG Subject: Question on Remedy Performance ** We are running ARS 7.1 patch 006 with ITSM 7.0.03 patch 007. The applications for the most part have been out of the box implementations, we have made some customizations but they have been minor in scope. Our application servers are dual 3.0ghz Xeon boxes with 8gb of memory running windows 2003 Enterprise. The database is Oracle 11 on a Sun V440 4 CPU 32gb memory dedicated box. Both the application server and database are on gigabit network connections. This has been bugging me for a while and I can't seem to figure out why the application server and database for the most part sit there at an idle, yet we have lackluster performance of the remedy system in regards to the customer experience on the desktop and web client. The performance is not terrible, however due to the under utilization of the hardware I would expect better response than what we are seeing. What I'm looking for is some pointers or documentation someone might know about that would help to identify anything that would be causing this behavior. I have read the scalability white papers published by BMC, which closely mirrors our configuration and this has been of little value. Jim Coryat Micron Technology Inc. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: RKM Browse Tab
Alan, I looked through the RKM file structure and couldn't find an template.html file. Michael Ziniti DCO Service Excellence - Tools Enablement San Francisco Work: 925-974-5273 Cell: 516-729-8150 AIM: MikePZiniti From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Alan Blake Sent: Wednesday, May 12, 2010 7:16 AM To: arslist@ARSLIST.ORG Subject: Re: RKM Browse Tab ** You would want to look at using the template.html file and inject some javascript that hides it. Alan Blake Knowlysis --- On Tue, 5/11/10, versicle versi...@aol.com wrote: From: versicle versi...@aol.com Subject: RKM Browse Tab To: arslist@ARSLIST.ORG Date: Tuesday, May 11, 2010, 12:02 PM All, Does anyone know if it's possible to hide the Browse tab within RKM? If so, how? We are running RKM 7.5 p1. TIA, Mike -- View this message in context: http://old.nabble.com/RKM-Browse-Tab-tp28527420p28527420.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ADV: ESS Package Includes Mobile Reach
Gidd Calden gcal...@gmail.com wrote: Advertisement: Listers: If you are looking for a robust mature ITSM solution, well you heard it all before. We are offering a bundled solution offering that is a Fixed price solution and includes just about everything you could ask for in a comprehensive suite application. Recently we added integration to Mobile Reach to provide your support personnel, yes Managers too, the ability to interface with ESS using a hand-held device. Need a notification solution that provides real text-to-speech, wow we have that too !! Need an interface for your customers that can easily tie to Kinetic Request or your own Service Catalogs, got that. While the band plays on... Why not contact us off-list to discuss how we can fill your enterprise requirements, save you money and provide real implementation in as little as 12 weeks. Sure we will even customize the delivered application to your needs while providing real transfer of knowledge during the delivery. Ever wonder why our clients don't flood the list with questions and support issues ? Oops, ARS version 7.6 is coming out soon no sweat for the prepared, bolt it on and back to work !!! Regards.Gidd Glidden L. Calden BUOYANT SOLUTIONS, INC. Keeping business afloat ...in a Sea of Solutions Office ( 916.334.0599 FAX 4 916.334.0599 Web 8 http://www.BuoyantSolutions.net http://www.buoyantsolutions.net/ E-mail + mailto:g...@buoyantsolutions.net mailto:gcal...@gmail.com P Please consider the environment before printing this e-mail This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ITSM 7.5 install Incident no item in Service field menu
I just installed ITSM 7.5 suite and all seems to be work except when creating an Incident there are no items in the Service field menu which is a required field. What did I forget to configure? or what configuration is required to populate that menu? Thanks, Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ITSM 7.5 install Incident no item in Service field menu
You can stop this from being required in the Incident Rules form. It is populated from the Business Service form. -Original Message- From: Mike Pingree mping...@speakeasy.net To: arslist@ARSLIST.ORG Sent: Wed, May 12, 2010 1:58 pm Subject: ITSM 7.5 install Incident no item in Service field menu I just installed ITSM 7.5 suite and all seems to be work except when creating an Incident there are no items in the Service field menu which is a required field. What did I forget to configure? or what configuration is required to populate that menu? Thanks, Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ADM:Timing Test
last test 3 minutes instead of 3 seconds. 14:37 pm EST ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Current LDAP Limitations?
2010/5/12 William Rentfrow wrentf...@stratacominc.com: ** Back around Remedy 5.6 was the last time I tried to pull large quantities of data from Active Directory using the Remedy LDAP/ARDBC Active Directory integration. Setting it up was easy but we had two issues back then: 1.) We couldn't query by date fields - no results were returned 2.) Page sizing was an issue and it would only return X,XXX records - To get the 750,000 I needed we had to do batches. It sounds like a limitation of Active Directory about the number of objects returned from a LDAP query, and not use batch will not work. You can try to increase this limit in Active Directory (MaxPageSize) See Windows 2000 and Windows Server 2003 LDAP administration limits - http://support.microsoft.com/kb/315071 So - does anyone know if these issues are fixed? If I remember right it wasn't actually a BMC problem but it was related to the MS connector. I can't find any good info on this. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: fire AL when window open only in Search Mode
We use this configuration AR Server, Mid-Tier, User Client - 7.5 patch 3 RDBMS - Oracle 10 Browser - IE 8 2010/5/12 Grooms, Frederick W frederick.w.gro...@xo.com: Which version(s)/Platform(s) are you using? AR Server? Database? Mid-Tier? User Tool? Browser? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Current LDAP Limitations?
I am currently using ARS 7.1.0 Patch 007 (on Solaris). I can see the Date/Time fields on my vendor form but still cannot query by them. Anybody on 7.5 want to add whenChanged or modifyTimeStamp to your LDAP vendor form and try to query by it? As for #2 I believe it is a setting in the AD for max rows returned. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow Sent: Wednesday, May 12, 2010 12:06 PM To: arslist@ARSLIST.ORG Subject: Current LDAP Limitations? ** Back around Remedy 5.6 was the last time I tried to pull large quantities of data from Active Directory using the Remedy LDAP/ARDBC Active Directory integration. Setting it up was easy but we had two issues back then: 1.) We couldn't query by date fields - no results were returned 2.) Page sizing was an issue and it would only return X,XXX records - To get the 750,000 I needed we had to do batches. So - does anyone know if these issues are fixed? If I remember right it wasn't actually a BMC problem but it was related to the MS connector. I can't find any good info on this. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com Blog, www.williamrentfrow.com 715-410-8156 C ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ITSM 7.5 install Incident no item in Service field menu
Also in the BMC Remedy Service Desk User's Guide on page 154 it talks about how to build the Business Services CIs and how to relate them to be used in the Services drop down. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roger Justice Sent: Wednesday, May 12, 2010 11:13 AM To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.5 install Incident no item in Service field menu ** You can stop this from being required in the Incident Rules form. It is populated from the Business Service form. -Original Message- From: Mike Pingree mping...@speakeasy.net To: arslist@ARSLIST.ORG Sent: Wed, May 12, 2010 1:58 pm Subject: ITSM 7.5 install Incident no item in Service field menu I just installed ITSM 7.5 suite and all seems to be work except when creating an Incident there are no items in the Service field menu which is a required field. What did I forget to configure? or what configuration is required to populate that menu? Thanks, Mike ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ attend wwrug10 www.wwrug.com http://www.wwrug.com/ ARSlist: Where the Answers Are _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Current LDAP Limitations?
You also may need to check the uid your connecting with to query the AD directly (LDAP Searches). Not only are there size limits in most LDAP's for searches, depending on where the search is being conducted (i.e., at the root level or specific container like cn=users,cn=whatever, etc...) the account your connecting with may not have the necessary rights within the directory structure. Hope this helps. Scott From: Action Request System discussion list(ARSList) [arsl...@arslist.org] On Behalf Of Grooms, Frederick W [frederick.w.gro...@xo.com] Sent: Wednesday, May 12, 2010 2:49 PM To: arslist@ARSLIST.ORG Subject: Re: Current LDAP Limitations? I am currently using ARS 7.1.0 Patch 007 (on Solaris). I can see the Date/Time fields on my vendor form but still cannot query by them. Anybody on 7.5 want to add whenChanged or modifyTimeStamp to your LDAP vendor form and try to query by it? As for #2 I believe it is a setting in the AD for max rows returned. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow Sent: Wednesday, May 12, 2010 12:06 PM To: arslist@ARSLIST.ORG Subject: Current LDAP Limitations? ** Back around Remedy 5.6 was the last time I tried to pull large quantities of data from Active Directory using the Remedy LDAP/ARDBC Active Directory integration. Setting it up was easy but we had two issues back then: 1.) We couldn't query by date fields - no results were returned 2.) Page sizing was an issue and it would only return X,XXX records - To get the 750,000 I needed we had to do batches. So - does anyone know if these issues are fixed? If I remember right it wasn't actually a BMC problem but it was related to the MS connector. I can't find any good info on this. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com Blog, www.williamrentfrow.com 715-410-8156 C ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: RKM Browse Tab
That file should be under the folder kms_conf. something like c:\Program Files\ar system applications\BMC Knowledge Management\data\kms_conf On Wed, May 12, 2010 at 1:24 PM, Michael Ziniti michael.p.zin...@accenture.com wrote: ** Alan, I looked through the RKM file structure and couldn’t find an template.html file. Michael Ziniti DCO Service Excellence - Tools Enablement San Francisco Work: 925-974-5273 Cell: 516-729-8150 AIM: MikePZiniti *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Alan Blake *Sent:* Wednesday, May 12, 2010 7:16 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: RKM Browse Tab ** You would want to look at using the template.html file and inject some javascript that hides it. Alan Blake Knowlysis --- On *Tue, 5/11/10, versicle versi...@aol.com* wrote: From: versicle versi...@aol.com Subject: RKM Browse Tab To: arslist@ARSLIST.ORG Date: Tuesday, May 11, 2010, 12:02 PM All, Does anyone know if it's possible to hide the Browse tab within RKM? If so, how? We are running RKM 7.5 p1. TIA, Mike -- View this message in context: http://old.nabble.com/RKM-Browse-Tab-tp28527420p28527420.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ -- Kevin Begosh ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: RKM Browse Tab
Ah ok I found it...but it's a blank file. I'm not sure what I'm supposed to do with this. FYI I'm not too savvy with html or java scripting. Michael Ziniti This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: RKM Browse Tab
I am not either but if you open it with notepad it is actually not blank. I was hoping there was some jsp file you could change but I could not find it Sent from my iPhone On May 12, 2010, at 3:14 PM, Michael Ziniti michael.p.zin...@accenture.com wrote: ** Ah ok I found it…but it’s a blank file. I’m not sure what I’m supposed to do with this. FYI I’m not too savvy with html or java scripting. Michael Ziniti This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Runmacro - UNIX Server Group
Hi Listers; Does anybody has experienced issues with runmacro command on an ARS Server Group? I have to ARS Servers one with NAT address and the other one without NAT; both servers are managed due a Load Balancer, but before i installed the second ARS Server the script with the call for a submit action using runmacro utility was working fine, but now it doesn't work; I'm trying to figure why this could happen, or how can i perform a troubleshooting on this. Best Regards Hugo Ruesga US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _ Prefiero un día sin coche que sin Messenger www.vivirmessenger.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Current LDAP Limitations?
Confirmed on ARS 7.5 p1. I was able to query by createTimeStamp, whenCreated, whenChanged and modifyTimeStamp. I didn't vet the results too thoroughly but the number of results returned looked about right. Jason On Wed, May 12, 2010 at 11:49 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: I am currently using ARS 7.1.0 Patch 007 (on Solaris). I can see the Date/Time fields on my vendor form but still cannot query by them. Anybody on 7.5 want to add whenChanged or modifyTimeStamp to your LDAP vendor form and try to query by it? As for #2 I believe it is a setting in the AD for max rows returned. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] On Behalf Of William Rentfrow Sent: Wednesday, May 12, 2010 12:06 PM To: arslist@ARSLIST.ORG Subject: Current LDAP Limitations? ** Back around Remedy 5.6 was the last time I tried to pull large quantities of data from Active Directory using the Remedy LDAP/ARDBC Active Directory integration. Setting it up was easy but we had two issues back then: 1.) We couldn't query by date fields - no results were returned 2.) Page sizing was an issue and it would only return X,XXX records - To get the 750,000 I needed we had to do batches. So - does anyone know if these issues are fixed? If I remember right it wasn't actually a BMC problem but it was related to the MS connector. I can't find any good info on this. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com Blog, www.williamrentfrow.com 715-410-8156 C ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: fire AL when window open only in Search Mode
Andrey, Are you sure If the window is opened in Modify mode, yes, I would expect this to fire. But not if it is opened in New mode. Why would I expect it in Modify mode? Well, how did you get to modify mode? The window opened in query mode, put in the qualification, did a search, and then opened the details in Modify mode. So, you did transition through Query mode along the way toward the open. I would not expect it to fire for opening in new mode directly since it never transitions through Query mode. Firing on all those execute conditions is odd. Display is when the window is opened in Modify or Display mode (yes, there is a display mode which is a read only Modify mode). You want only the search window so this condition is a waste of effort. Window Open and Window Loaded both being set is redundant since the query window opens and does on open and then on loaded. So, only one of them is really needed -- and you can chose which you want based on whether you need data present or not and whether you are setting values whose value you want to have after the workflow. The real question is what are you trying to accomplish at the end of the day? Is it that when the window is opened in search mode and ready to go, you want something to occur? Well, an idea to consider is changing completely so something like On gain focus of the first field on the screen (where focus goes when the window is opened) and run if of $OPERATION$ = QUERY fire. You will likely find that there is no gain of focus in the sequence above where it cycles through the query window on the way to modify since the window never really gets instantiated. The challenge here is that it will occur again if you tab out of and then back into the field -- so you need to record you have done it once before to avoid repeating the action. What is it that you are doing that you need to happen if you open a search, type in the entry ID and say search that you do not if you have a window that opens directly to the screen on that entry ? Why is there a difference in the functionality using the two different yet equivalent searches? Also, if using the mid-tier, are you sure you have an updated cached copy of the definition? Sometimes you adjust the definition -- like creating without the run if and testing and then adding the run if. Well, it would still be running without the run if unless the cache interval had occurred during that time. Some things to think about, Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Andrey Sent: Wednesday, May 12, 2010 8:13 AM To: arslist@ARSLIST.ORG Subject: Re: fire AL when window open only in Search Mode All what I need - fire AL if window opened only on Search Mode Currently I have test AL with Execute On: Display, Window Open, Window Load Run If: $OPERATION$=QUERY If Action: Message (test) ... but this AL also triggered when a window opened in New or Modify Mode and I can not understand what is happening ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
