Re: Path to download the Data Management Client
Hi Carl, Thanks. Checked my archives again and found it! Regards, Rob. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
The Future Thread
But what is he selling, snake oil? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Monday, September 17, 2012 9:25 PM To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** John I think you should have prefixed AD: to the subject. On Mon, Sep 17, 2012 at 7:04 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** It is a little hard to say what version it was Because in 2012 -- BMC renamed it all to BMC Atrium ... threw in the kitchen sink -- which included the Remedy product and the ITSM Suite + some discovery software + a CMDB... But in 2014 Oracle broke it all up -- and peeled off the ITSM software into something they called Oracle Service Support (And the concept of a development admin tool went away) -- it is purely configuration and consulting to configure the product... (Traditional Remedy customer are unhappy - new customers don't know better - think they are eating a juicy steak - turns out it is pink slime) RemedyForce was taken over by Business.com (aka Salesforce.com). RemedyOnDemand - still exists -- but is part of Oracle Scalable Enterprise - which everybody calls Oh say ... can you see -- because nobody can actually see it working... kind of a weird industry joke... (Still not sure about it -- I think 2021 humor goes over my head) Same timeframe -- Oracle renamed Remedy to Oracle Enable ... and it became really the adhoc business back-office apps generator SRM was abandoned by Oracle -- really BMC killed it before Oracle got it (circa 2011) - BMC just never told the customers. Of course Kinetic Data stayed independent and front-ends both Oracle Service Support and the Enable framework - keeping customers happy - regardless of the shenanigans behind the scenes... BTW - the MN Vikings still are without a Superbowl in 2021 :( Obama gets reelected. Republican gets elected 2016 -- does a fair job - but chooses not to rerun. Hillary gets 2020. And that is all I know... -John On Mon, Sep 17, 2012 at 8:15 PM, Shellman, David dave.shell...@te.com wrote: ** John, Do you know what version this introduced? Dave On Sep 17, 2012, at 8:43 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** No - they won't work. :( Sorry... -John On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly ctopke...@gmail.com wrote: ** These are great suggestions But I an in 2012 and I need a solution today As you can tell I know nothing about remedy. So will adding the two lines work? Any help is great, my future self says thanks also Chris On Sep 17, 2012 4:26 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** Sweet... don't think I knew this.. New feature?? Joe From: John Sundberg mailto:john.sundb...@kineticdata.com Sent: Monday, September 17, 2012 4:56 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** You could go into ar.cfg add the 2 lines : ars_track_long_queries: true ars_track_long_queries_min_length: 5000 # This is milliseconds - so all greater than 5 seconds Then -- restart server Look for table called: ARS_TRACK_QUERIES (I think that is the name)...
Re: Querys that kill my system
Just to add for anyone who casually followed this didn't get it, John was joking and saying wouldn't it be nice if there were something like this, but: There is NOT an ars_track_long_queries or ars_track_long_queries_min_length for ar.cfg. Hope you don't mind me explicitly adding that, John - but I got a little confused in there... could imagine someone looking this up in the archives being frustrated when it didn't work... David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg Sent: Monday, September 17, 2012 8:43 PM To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** No - they won't work. :( Sorry... -John On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly ctopke...@gmail.commailto:ctopke...@gmail.com wrote: ** These are great suggestions But I an in 2012 and I need a solution today As you can tell I know nothing about remedy. So will adding the two lines work? Any help is great, my future self says thanks also Chris On Sep 17, 2012 4:26 PM, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: ** Sweet... don't think I knew this.. New feature?? Joe From: John Sundbergmailto:john.sundb...@kineticdata.com Sent: Monday, September 17, 2012 4:56 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** You could go into ar.cfg add the 2 lines : ars_track_long_queries: true ars_track_long_queries_min_length: 5000 # This is milliseconds - so all greater than 5 seconds Then -- restart server Look for table called: ARS_TRACK_QUERIES (I think that is the name)... Look in there -- it will tell who when what how long it ran how many entries returned what ip address what client type and version Pretty sweet feature... (wish I would have thought of it originally) -John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Querys that kill my system
This is true But its still funny On Tue, Sep 18, 2012 at 6:41 AM, David Durling durl...@uga.edu wrote: ** Just to add for anyone who casually followed this didn’t get it, John was joking and “saying wouldn’t it be nice if there were something like this”, but: ** ** There is NOT an ars_track_long_queries or ars_track_long_queries_min_length for ar.cfg. ** ** Hope you don’t mind me explicitly adding that, John – but I got a little confused in there… could imagine someone looking this up in the archives being frustrated when it didn’t work… ** ** David ** ** David Durling University of Georgia ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg *Sent:* Monday, September 17, 2012 8:43 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Querys that kill my system ** ** ** No - they won't work. :( ** ** Sorry... ** ** -John ** ** On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly ctopke...@gmail.com wrote:* *** ** These are great suggestions But I an in 2012 and I need a solution today As you can tell I know nothing about remedy. So will adding the two lines work? Any help is great, my future self says thanks also Chris On Sep 17, 2012 4:26 PM, Joe Martin D'Souza jdso...@shyle.net wrote:** ** ** Sweet... don’t think I knew this.. New feature?? Joe *From:* John Sundberg john.sundb...@kineticdata.com *Sent:* Monday, September 17, 2012 4:56 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Querys that kill my system ** You could go into ar.cfg add the 2 lines : ars_track_long_queries: true ars_track_long_queries_min_length: 5000 # This is milliseconds - so all greater than 5 seconds Then -- restart server Look for table called: ARS_TRACK_QUERIES (I think that is the name)… Look in there -- it will tell who when what how long it ran how many entries returned what ip address what client type and version Pretty sweet feature… (wish I would have thought of it originally) -John _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Querys that kill my system
Oh, I finally got it - I was a little slow, though J David D. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chris Kelly Sent: Tuesday, September 18, 2012 8:46 AM To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** This is true But its still funny On Tue, Sep 18, 2012 at 6:41 AM, David Durling durl...@uga.edumailto:durl...@uga.edu wrote: ** Just to add for anyone who casually followed this didn't get it, John was joking and saying wouldn't it be nice if there were something like this, but: There is NOT an ars_track_long_queries or ars_track_long_queries_min_length for ar.cfg. Hope you don't mind me explicitly adding that, John - but I got a little confused in there... could imagine someone looking this up in the archives being frustrated when it didn't work... David David Durling University of Georgia ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Querys that kill my system
So was I. Dave From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: Tuesday, September 18, 2012 8:49 AM To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** Oh, I finally got it - I was a little slow, though J David D. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chris Kelly Sent: Tuesday, September 18, 2012 8:46 AM To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** This is true But its still funny On Tue, Sep 18, 2012 at 6:41 AM, David Durling durl...@uga.edumailto:durl...@uga.edu wrote: ** Just to add for anyone who casually followed this didn't get it, John was joking and saying wouldn't it be nice if there were something like this, but: There is NOT an ars_track_long_queries or ars_track_long_queries_min_length for ar.cfg. Hope you don't mind me explicitly adding that, John - but I got a little confused in there... could imagine someone looking this up in the archives being frustrated when it didn't work... David David Durling University of Georgia _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Querys that kill my system
also funny you say this, because my Remedy admin just came to me and and said there was some settings that he never herd of that can be made in AR.config that will track Long queries . LOL Thanks Guys On Tue, Sep 18, 2012 at 6:46 AM, Chris Kelly ctopke...@gmail.com wrote: This is true But its still funny On Tue, Sep 18, 2012 at 6:41 AM, David Durling durl...@uga.edu wrote: ** Just to add for anyone who casually followed this didn’t get it, John was joking and “saying wouldn’t it be nice if there were something like this”, but: ** ** There is NOT an ars_track_long_queries or ars_track_long_queries_min_length for ar.cfg. ** ** Hope you don’t mind me explicitly adding that, John – but I got a little confused in there… could imagine someone looking this up in the archives being frustrated when it didn’t work… ** ** David ** ** David Durling University of Georgia ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Sundberg *Sent:* Monday, September 17, 2012 8:43 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Querys that kill my system ** ** ** No - they won't work. :( ** ** Sorry... ** ** -John ** ** On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly ctopke...@gmail.com wrote: ** These are great suggestions But I an in 2012 and I need a solution today As you can tell I know nothing about remedy. So will adding the two lines work? Any help is great, my future self says thanks also Chris On Sep 17, 2012 4:26 PM, Joe Martin D'Souza jdso...@shyle.net wrote:* *** ** Sweet... don’t think I knew this.. New feature?? Joe *From:* John Sundberg john.sundb...@kineticdata.com *Sent:* Monday, September 17, 2012 4:56 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Querys that kill my system ** You could go into ar.cfg add the 2 lines : ars_track_long_queries: true ars_track_long_queries_min_length: 5000 # This is milliseconds - so all greater than 5 seconds Then -- restart server Look for table called: ARS_TRACK_QUERIES (I think that is the name)…*** * Look in there -- it will tell who when what how long it ran how many entries returned what ip address what client type and version Pretty sweet feature… (wish I would have thought of it originally) -John _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Trigger active link on calendar selection.
Jose, Instead of using the Calendar widgit, could you place a button over the widgit and have it open a dialog box with a calendar field on it? You could then execute your active link from the dialog box or after it returns the data to the main form. Greg Givens (Contractor) Network Applications Support ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
iPhones and Aeroprise
Has anyone utilized the iPhone via Aeroprise? We are intending on using handheld scanners that are connected to the iPhone for asset management. Our original solution was to use Blackberry via the BES to aeroprise, but given the current uncertainties surrounding RIM, the decision has been made to move away from Blackberry. iPhone is currently the preferred solution, but I'm unable to find any documentation on using them with the iPhone. Thank you in advance for any information! ARS 7.6.04 Aeroprise Mobiltiy for ITSM 7.6.04 Windows 2008 servers Apache -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: iPhones and Aeroprise
The iPhone works great with Aeroprise. The interface is clean and is very Apple-like. I believe that there is even an app for it. Tommy Morris CMDB Certified Specialist Director of IT Service Management [cid:image001.png@01CD9584.19ADE1A0]http://www.pinebreeze.com/ tommy.mor...@pinebreeze.comhttps://exg5.exghost.com/owa/redir.aspx?C=1d40184b0dc44e86917981c2ecb56197URL=mailto%3atommy.morris%40pinebreeze.com 817.727.1021 - mobile 972.899.2366 - office 972.899.2898 - fax From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: Tuesday, September 18, 2012 9:56 AM To: arslist@ARSLIST.ORG Subject: iPhones and Aeroprise ** Has anyone utilized the iPhone via Aeroprise? We are intending on using handheld scanners that are connected to the iPhone for asset management. Our original solution was to use Blackberry via the BES to aeroprise, but given the current uncertainties surrounding RIM, the decision has been made to move away from Blackberry. iPhone is currently the preferred solution, but I'm unable to find any documentation on using them with the iPhone. Thank you in advance for any information! ARS 7.6.04 Aeroprise Mobiltiy for ITSM 7.6.04 Windows 2008 servers Apache -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.png
Re: iPhones and Aeroprise
Phew! That's what I was hoping to hear! Thanks Tommy! On Tue, Sep 18, 2012 at 10:58 AM, Tommy Morris tommy.mor...@pinebreeze.comwrote: ** The iPhone works great with Aeroprise. The interface is clean and is very Apple-like. I believe that there is even an app for it. ** ** Tommy Morris CMDB Certified Specialist Director of IT Service Management ** ** [image: Description: cid:image001.png@01CCF6B9.D0C054F0]http://www.pinebreeze.com/ tommy.mor...@pinebreeze.comhttps://exg5.exghost.com/owa/redir.aspx?C=1d40184b0dc44e86917981c2ecb56197URL=mailto%3atommy.morris%40pinebreeze.com 817.727.1021 – mobile 972.899.2366 - office 972.899.2898 - fax ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Warren R. Baltimore II *Sent:* Tuesday, September 18, 2012 9:56 AM *To:* arslist@ARSLIST.ORG *Subject:* iPhones and Aeroprise ** ** ** Has anyone utilized the iPhone via Aeroprise? We are intending on using handheld scanners that are connected to the iPhone for asset management. Our original solution was to use Blackberry via the BES to aeroprise, but given the current uncertainties surrounding RIM, the decision has been made to move away from Blackberry. iPhone is currently the preferred solution, but I'm unable to find any documentation on using them with the iPhone.*** * Thank you in advance for any information! ARS 7.6.04 Aeroprise Mobiltiy for ITSM 7.6.04 Windows 2008 servers Apache -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Error on Mid Tier
Hi Prakash, For the below error - One of the common reasons for this Error can occur if Java script try to retrieve the information before html info is fully loaded. This is why 'Unable to get value' message appears. This is a common error for some of the versions of the Internet Explorer. Below solution can resolve the issue: 1) Clear the browser cache (Browsing history / temporary internet files) 2) Clear out temp files under TEMP directory in your client machine. TEMP here usually refers to Documents and Settings\Users\Local Settings\Temp. 3) Login again. -- Regards, Amit Kumar Vyom Labs Pvt. Ltd. BSM Solutions Services || ITIL Consulting Training Email: mailto:i...@vyomlabs.com i...@vyomlabs.com || Web Site: http://www.vyomlabs.com www.vyomlabs.com Follow Vyom Labs http://twitter.com/#!/vyomlabs http://twitter.com/#!/vyomlabs || http://www.linkedin.com/company/vyom-labs http://www.linkedin.com/company/vyom-labs From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Prakash Kodali Sent: Monday, September 17, 2012 11:05 PM To: arslist@ARSLIST.ORG Subject: Error on Mid Tier ** Helloo ARS Friends, After a long time, I am facing an weird error with the Remedy ARS system. We have customized applications running on ARS 7.6 and Midtier 7.6.04 SP1. When we try to access the Display only form, I am getting the below JS error and it is going to the blank page. Alert: Caught exception :Unable to get value of the property 'ARKeywords': object is null or undefined Please let me know, if any other information required. Hope some one crossed this hurdle in the journey and any help is greatly appreciated. Thanks, Prakash. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: [EXTERNAL] iPhones and Aeroprise
Warren: I'm not sure if you're talking about server config/how to install/uninstall or more of a users' guide type of document. We're looking to deploy Mobility (formerly Aeroprise) with the Blackberry, and I searched the web high and low for something along the lines of a user's guide. I found one video on You Tube that sounded like what I wanted, but it was locked down and I couldn't access it. I only write test plans as opposed to user guides (thanks goodness!), but I did have to figure out how the app works on my own. I didn't find it to be that hard to figure out, but it was time-consuming to do (and document!). And at least on the BB, some of the app's behavior is just not intuitive. Searching for users during ticket creation and adding Work Infos in particular weren't obvious procedures, and we are unable to associate a CI with a ticket at all. Your experience may of course vary on the iPhone. Here is a grab bag of stuff I learned: * You can make just about any field from the Incident form appear on the Mobility server. * You can make any Remedy app appear on the Mobility server if you really want to. * Field labels aren't named the same as they are on the Incident form, so you may want to consider renaming them for consistency's sake. * If you make a change on the Mobility Server, users need to Exit Clear Data (clear the cache) before they can pick up changes. * Users can log in to the Mobility server, and, if you're willing to teach them how, rearrange field order or add lookups, but you can't move fields to different sections - they'll just appear at the bottom of the Mobility incident form in a highly inconvenient location if you do. * Attachments aren't available by default. Across the board, the documentation for Mobility is a little lacking. Good luck! Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2008 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: Tuesday, September 18, 2012 8:56 AM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] iPhones and Aeroprise ** Has anyone utilized the iPhone via Aeroprise? We are intending on using handheld scanners that are connected to the iPhone for asset management. Our original solution was to use Blackberry via the BES to aeroprise, but given the current uncertainties surrounding RIM, the decision has been made to move away from Blackberry. iPhone is currently the preferred solution, but I'm unable to find any documentation on using them with the iPhone. Thank you in advance for any information! ARS 7.6.04 Aeroprise Mobiltiy for ITSM 7.6.04 Windows 2008 servers Apache -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: [EXTERNAL] iPhones and Aeroprise
The BB Aeroprise interface is a client and I did not like it at all. The iPhone interface is much better, the Android interface had some issues due to the OS version on the phones that caused it to ignore Java headings. That may have been corrected in the newest version of BMC Mobility or the latest Android OS. Tommy Morris CMDB Certified Specialist Director of IT Service Management [cid:image001.png@01CD958A.F850E910]http://www.pinebreeze.com/ tommy.mor...@pinebreeze.comhttps://exg5.exghost.com/owa/redir.aspx?C=1d40184b0dc44e86917981c2ecb56197URL=mailto%3atommy.morris%40pinebreeze.com 817.727.1021 - mobile 972.899.2366 - office 972.899.2898 - fax From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Stroud, Natalie K Sent: Tuesday, September 18, 2012 10:32 AM To: arslist@ARSLIST.ORG Subject: Re: [EXTERNAL] iPhones and Aeroprise ** Warren: I'm not sure if you're talking about server config/how to install/uninstall or more of a users' guide type of document. We're looking to deploy Mobility (formerly Aeroprise) with the Blackberry, and I searched the web high and low for something along the lines of a user's guide. I found one video on You Tube that sounded like what I wanted, but it was locked down and I couldn't access it. I only write test plans as opposed to user guides (thanks goodness!), but I did have to figure out how the app works on my own. I didn't find it to be that hard to figure out, but it was time-consuming to do (and document!). And at least on the BB, some of the app's behavior is just not intuitive. Searching for users during ticket creation and adding Work Infos in particular weren't obvious procedures, and we are unable to associate a CI with a ticket at all. Your experience may of course vary on the iPhone. Here is a grab bag of stuff I learned: * You can make just about any field from the Incident form appear on the Mobility server. * You can make any Remedy app appear on the Mobility server if you really want to. * Field labels aren't named the same as they are on the Incident form, so you may want to consider renaming them for consistency's sake. * If you make a change on the Mobility Server, users need to Exit Clear Data (clear the cache) before they can pick up changes. * Users can log in to the Mobility server, and, if you're willing to teach them how, rearrange field order or add lookups, but you can't move fields to different sections - they'll just appear at the bottom of the Mobility incident form in a highly inconvenient location if you do. * Attachments aren't available by default. Across the board, the documentation for Mobility is a little lacking. Good luck! Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2008 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: Tuesday, September 18, 2012 8:56 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: [EXTERNAL] iPhones and Aeroprise ** Has anyone utilized the iPhone via Aeroprise? We are intending on using handheld scanners that are connected to the iPhone for asset management. Our original solution was to use Blackberry via the BES to aeroprise, but given the current uncertainties surrounding RIM, the decision has been made to move away from Blackberry. iPhone is currently the preferred solution, but I'm unable to find any documentation on using them with the iPhone. Thank you in advance for any information! ARS 7.6.04 Aeroprise Mobiltiy for ITSM 7.6.04 Windows 2008 servers Apache -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.png
Re: [EXTERNAL] iPhones and Aeroprise
Thanks everyone! On Tue, Sep 18, 2012 at 11:47 AM, Tommy Morris tommy.mor...@pinebreeze.comwrote: ** The BB Aeroprise interface is a client and I did not like it at all. The iPhone interface is much better, the Android interface had some issues due to the OS version on the phones that caused it to ignore Java headings. That may have been corrected in the newest version of BMC Mobility or the latest Android OS. ** ** Tommy Morris CMDB Certified Specialist Director of IT Service Management ** ** [image: Description: cid:image001.png@01CCF6B9.D0C054F0]http://www.pinebreeze.com/ tommy.mor...@pinebreeze.comhttps://exg5.exghost.com/owa/redir.aspx?C=1d40184b0dc44e86917981c2ecb56197URL=mailto%3atommy.morris%40pinebreeze.com 817.727.1021 – mobile 972.899.2366 - office 972.899.2898 - fax ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Stroud, Natalie K *Sent:* Tuesday, September 18, 2012 10:32 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: [EXTERNAL] iPhones and Aeroprise ** ** ** Warren: ** ** I’m not sure if you’re talking about server config/how to install/uninstall or more of a users’ guide type of document. We’re looking to deploy Mobility (formerly Aeroprise) with the Blackberry, and I searched the web high and low for something along the lines of a user’s guide. I found one video on You Tube that sounded like what I wanted, but it was locked down and I couldn’t access it. I only write test plans as opposed to user guides (thanks goodness!), but I did have to figure out how the app works on my own. I didn’t find it to be that hard to figure out, but it *was* time-consuming to do (and document!). And at least on the BB, some of the app’s behavior is just *not* intuitive. Searching for users during ticket creation and adding Work Infos in particular weren’t obvious procedures, and we are unable to associate a CI with a ticket at all. Your experience may of course vary on the iPhone. ** ** Here is a grab bag of stuff I learned: **· **You can make just about any field from the Incident form appear on the Mobility server. **· **You can make *any* Remedy app appear on the Mobility server if you really want to. **· **Field labels aren’t named the same as they are on the Incident form, so you may want to consider renaming them for consistency’s sake. **· **If you make a change on the Mobility Server, users need to Exit Clear Data (clear the cache) before they can pick up changes. **· **Users can log in to the Mobility server, and, if you’re willing to teach them how, rearrange field order or add lookups, but you can’t move fields to different sections – they’ll just appear at the bottom of the Mobility incident form in a highly inconvenient location if you do. **· **Attachments aren’t available by default. ** ** Across the board, the documentation for Mobility is a little lacking. *** * ** ** Good luck! ** ** *Natalie Stroud* SAIC @ Sandia National Laboratories ARS-ITSM Tester Albuquerque, NM USA nkst...@sandia.gov ITSM 7.6.04 SP2 – Windows 2008 – SQL Server 2008 ** ** ** ** *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *Warren R. Baltimore II *Sent:* Tuesday, September 18, 2012 8:56 AM *To:* arslist@ARSLIST.ORG *Subject:* [EXTERNAL] iPhones and Aeroprise ** ** ** Has anyone utilized the iPhone via Aeroprise? We are intending on using handheld scanners that are connected to the iPhone for asset management. Our original solution was to use Blackberry via the BES to aeroprise, but given the current uncertainties surrounding RIM, the decision has been made to move away from Blackberry. iPhone is currently the preferred solution, but I'm unable to find any documentation on using them with the iPhone.*** * Thank you in advance for any information! ARS 7.6.04 Aeroprise Mobiltiy for ITSM 7.6.04 Windows 2008 servers Apache -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Querys that kill my system
So this feature really isn't there? You nearly had me there! It’s a great feature if it was there though.. Maybe a perfect candidate for some sort of an enhancement request.. Joe From: John Sundberg Sent: Monday, September 17, 2012 10:04 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** It is a little hard to say what version it was Because in 2012 -- BMC renamed it all to BMC Atrium ... threw in the kitchen sink -- which included the Remedy product and the ITSM Suite + some discovery software + a CMDB... But in 2014 Oracle broke it all up -- and peeled off the ITSM software into something they called Oracle Service Support (And the concept of a development admin tool went away) -- it is purely configuration and consulting to configure the product... (Traditional Remedy customer are unhappy - new customers don't know better - think they are eating a juicy steak - turns out it is pink slime) RemedyForce was taken over by Business.com (aka Salesforce.com). RemedyOnDemand - still exists -- but is part of Oracle Scalable Enterprise - which everybody calls Oh say ... can you see -- because nobody can actually see it working... kind of a weird industry joke... (Still not sure about it -- I think 2021 humor goes over my head) Same timeframe -- Oracle renamed Remedy to Oracle Enable ... and it became really the adhoc business back-office apps generator SRM was abandoned by Oracle -- really BMC killed it before Oracle got it (circa 2011) - BMC just never told the customers. Of course Kinetic Data stayed independent and front-ends both Oracle Service Support and the Enable framework - keeping customers happy - regardless of the shenanigans behind the scenes... BTW - the MN Vikings still are without a Superbowl in 2021 :( Obama gets reelected. Republican gets elected 2016 -- does a fair job - but chooses not to rerun. Hillary gets 2020. And that is all I know... -John On Mon, Sep 17, 2012 at 8:15 PM, Shellman, David dave.shell...@te.com wrote: ** John, Do you know what version this introduced? Dave On Sep 17, 2012, at 8:43 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** No - they won't work. :( Sorry... -John On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly ctopke...@gmail.com wrote: ** These are great suggestions But I an in 2012 and I need a solution today As you can tell I know nothing about remedy. So will adding the two lines work? Any help is great, my future self says thanks also Chris On Sep 17, 2012 4:26 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** Sweet... don’t think I knew this.. New feature?? Joe From: John Sundberg Sent: Monday, September 17, 2012 4:56 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** You could go into ar.cfg add the 2 lines : ars_track_long_queries: true ars_track_long_queries_min_length: 5000 # This is milliseconds - so all greater than 5 seconds Then -- restart server Look for table called: ARS_TRACK_QUERIES (I think that is the name)… Look in there -- it will tell who when what how long it ran how many entries returned what ip address what client type and version Pretty sweet feature… (wish I would have thought of it originally) -John On Mon, Sep 17, 2012 at 10:21 AM, Chris Kelly ctopke...@gmail.com wrote: ** Thanks so very much. I am not a Remedy Admin so My admin says the Unqualified searches is disabled. I will work on getting the fields indexed asap. The thing is we don't know who is running the queries... is there a way on the remedy system that we could look at to see who is running this and stop it when it is going on? Chris On Mon, Sep 17, 2012 at 9:09 AM, Maddala, Venkat venkat.madd...@ncr.com wrote: ** Hi Chris, Here are the few things that you can do 1) Disable Unqualified searches on server 2) Index the most commonly used fields in search 3) Limit the free form searches by adding custom workflow BTW is this for custom applications? Or OOTB? HTH Venkat Maddala http://RemediesForRemedy.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chris Kelly Sent: Monday, September 17, 2012 10:51 AM To: arslist@ARSLIST.ORG Subject: Querys that kill my system ** Hello all. I have a question for the
Re: iPhones and Aeroprise
Note - there are two versions of the mobility client - Classic and NextGen - and there are different devices supported and different capabilities. I've been learning more about this lately, but recommend checking with your BMC account rep or SC as you are thinking about mobility. Anne Brock Anne Brock Principal SC BMC Software 925-226-0446 anne_br...@bmc.commailto:anne_br...@bmc.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: Tuesday, September 18, 2012 8:11 AM To: arslist@ARSLIST.ORG Subject: Re: iPhones and Aeroprise ** Phew! That's what I was hoping to hear! Thanks Tommy! On Tue, Sep 18, 2012 at 10:58 AM, Tommy Morris tommy.mor...@pinebreeze.commailto:tommy.mor...@pinebreeze.com wrote: ** The iPhone works great with Aeroprise. The interface is clean and is very Apple-like. I believe that there is even an app for it. Tommy Morris CMDB Certified Specialist Director of IT Service Management Error! Filename not specified.http://www.pinebreeze.com/ tommy.mor...@pinebreeze.comhttps://exg5.exghost.com/owa/redir.aspx?C=1d40184b0dc44e86917981c2ecb56197URL=mailto%3atommy.morris%40pinebreeze.com 817.727.1021tel:817.727.1021 - mobile 972.899.2366tel:972.899.2366 - office 972.899.2898tel:972.899.2898 - fax From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Warren R. Baltimore II Sent: Tuesday, September 18, 2012 9:56 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: iPhones and Aeroprise ** Has anyone utilized the iPhone via Aeroprise? We are intending on using handheld scanners that are connected to the iPhone for asset management. Our original solution was to use Blackberry via the BES to aeroprise, but given the current uncertainties surrounding RIM, the decision has been made to move away from Blackberry. iPhone is currently the preferred solution, but I'm unable to find any documentation on using them with the iPhone. Thank you in advance for any information! ARS 7.6.04 Aeroprise Mobiltiy for ITSM 7.6.04 Windows 2008 servers Apache -- Warren R. Baltimore II Remedy Developer 410-533-5367tel:410-533-5367 _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Hiding 'resize handle' character fields on midtier
Jose ( Benny), Thanks, I finally tried “resize:none” and it seems to work well on my test server. Not sure if I’ll get cleared to put it on production since BMC won’t support it, but I might try – David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Monday, June 04, 2012 5:35 PM To: arslist@ARSLIST.ORG Subject: Re: Hiding 'resize handle' character fields on midtier ** You can solve it with CSS with the next modifications: Go to the mozilla ARSystem CSS. midTierInstallDir\resources\moz\stylesheets\ARSystem.css And add the next parameter: resize: none to the next classes: textarea.text textarea.srhttp://textarea.sr textarea.dat textarea.readonly textarea.PopupEditor input.text input.currency input.decimal Let me know if it works. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: 01 June 2012 19:13 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Hiding 'resize handle' character fields on midtier … Benny's suggestion about customizing CSS is an idea, but since it sounds like an upgrade might fix this, I'll probably leave it alone. -Original Message- From: David Durling Sent: Friday, June 01, 2012 11:15 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Hiding 'resize handle' character fields on midtier Hi all, Character fields on our Remedy forms when seen in browsers like Firefox and I think Chrome (not IE) show a little handle at the bottom right that you can drag to resize the field. … ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
MACRO Converter
Can anyone tell me the last version that had the MACRO converter? I have some active links that are using RUN MACRO and I would like to get them converted to Active Links. It seems like I remember this topic being discussed before, but I am unable to search the archives for some reason. My browser goes off in space.. Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: MACRO Converter
It stopped ever since the Dev Studio was introduced if I am not mistaken – so the last version that had the AR Admin tool had it to the best of my knowledge... Joe From: Mayfield, Andy L. Sent: Tuesday, September 18, 2012 2:56 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: MACRO Converter ** Can anyone tell me the last version that had the MACRO converter? I have some active links that are using RUN MACRO and I would like to get them converted to Active Links. It seems like I remember this topic being discussed before, but I am unable to search the archives for some reason. My browser goes off in space…… Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Querys that kill my system
Joe, This feature is available Add following in Ar.cfg Large-Result-Logging-Threshold: 7 7 is the threshold limit enable thread log result will be like THRD 1 /* Mon Jul 09 2012 16:05:38.2310 */ Thread Id 39696 (GLEWF) large result buffer allocation - /Length: 840183/Entries: 3000/Client Ver: =10/RPC ID: 11393/User: UserName/Form: Form name/ Ravi Date: Tue, 18 Sep 2012 14:05:57 -0400 From: jdso...@shyle.net Subject: Re: Querys that kill my system To: arslist@ARSLIST.ORG ** So this feature really isn't there? You nearly had me there! It’s a great feature if it was there though.. Maybe a perfect candidate for some sort of an enhancement request.. Joe From: John Sundberg Sent: Monday, September 17, 2012 10:04 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** It is a little hard to say what version it was Because in 2012 -- BMC renamed it all to BMC Atrium ... threw in the kitchen sink -- which included the Remedy product and the ITSM Suite + some discovery software + a CMDB... But in 2014 Oracle broke it all up -- and peeled off the ITSM software into something they called Oracle Service Support (And the concept of a development admin tool went away) -- it is purely configuration and consulting to configure the product... (Traditional Remedy customer are unhappy - new customers don't know better - think they are eating a juicy steak - turns out it is pink slime) RemedyForce was taken over by Business.com (aka Salesforce.com). RemedyOnDemand - still exists -- but is part of Oracle Scalable Enterprise - which everybody calls Oh say ... can you see -- because nobody can actually see it working... kind of a weird industry joke... (Still not sure about it -- I think 2021 humor goes over my head) Same timeframe -- Oracle renamed Remedy to Oracle Enable ... and it became really the adhoc business back-office apps generator SRM was abandoned by Oracle -- really BMC killed it before Oracle got it (circa 2011) - BMC just never told the customers. Of course Kinetic Data stayed independent and front-ends both Oracle Service Support and the Enable framework - keeping customers happy - regardless of the shenanigans behind the scenes... BTW - the MN Vikings still are without a Superbowl in 2021 :( Obama gets reelected. Republican gets elected 2016 -- does a fair job - but chooses not to rerun. Hillary gets 2020. And that is all I know... -John On Mon, Sep 17, 2012 at 8:15 PM, Shellman, David dave.shell...@te.com wrote: ** John, Do you know what version this introduced? Dave On Sep 17, 2012, at 8:43 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** No - they won't work. :( Sorry... -John On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly ctopke...@gmail.com wrote: ** These are great suggestions But I an in 2012 and I need a solution today As you can tell I know nothing about remedy. So will adding the two lines work? Any help is great, my future self says thanks also Chris On Sep 17, 2012 4:26 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** Sweet... don’t think I knew this.. New feature?? Joe From: John Sundberg Sent: Monday, September 17, 2012 4:56 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** You could go into ar.cfg add the 2 lines : ars_track_long_queries: true ars_track_long_queries_min_length: 5000 # This is milliseconds - so all greater than 5 seconds Then -- restart server Look for table called: ARS_TRACK_QUERIES (I think that is the name)… Look in there -- it will tell who when what how long it ran how many entries returned what ip address what client type and version Pretty sweet feature… (wish I would have thought of it originally) -John On Mon, Sep 17, 2012 at 10:21 AM, Chris Kelly ctopke...@gmail.com wrote: ** Thanks so very much. I am not a Remedy Admin so My admin says the Unqualified searches is disabled. I will work on getting the fields indexed asap. The thing is we don't know who is running the queries... is there a way on the remedy system that we could look at to see who is running this and stop it when it is going on? Chris On Mon, Sep 17, 2012 at 9:09 AM, Maddala, Venkat venkat.madd...@ncr.com wrote: ** Hi Chris, Here are the few things that you can do 1) Disable Unqualified searches on server 2) Index the most commonly used fields in search 3) Limit the free form searches by adding custom workflow BTW is this for custom applications? Or OOTB? HTH Venkat Maddala http://RemediesForRemedy.com From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chris Kelly Sent: Monday, September 17, 2012 10:51 AM To: arslist@ARSLIST.ORG Subject: Querys that kill my system ** Hello all. I
Re: Querys that kill my system
I knew about this one from a post on here a few months ago.. Joe From: ravi rai Sent: Tuesday, September 18, 2012 3:22 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** Joe, This feature is available Add following in Ar.cfg Large-Result-Logging-Threshold: 7 7 is the threshold limit enable thread log result will be like THRD 1 /* Mon Jul 09 2012 16:05:38.2310 */ Thread Id 39696 (GLEWF) large result buffer allocation - /Length: 840183/Entries: 3000/Client Ver: =10/RPC ID: 11393/User: UserName/Form: Form name/ Ravi Date: Tue, 18 Sep 2012 14:05:57 -0400 From: jdso...@shyle.net Subject: Re: Querys that kill my system To: arslist@ARSLIST.ORG ** So this feature really isn't there? You nearly had me there! It’s a great feature if it was there though.. Maybe a perfect candidate for some sort of an enhancement request.. Joe From: John Sundberg Sent: Monday, September 17, 2012 10:04 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** It is a little hard to say what version it was Because in 2012 -- BMC renamed it all to BMC Atrium ... threw in the kitchen sink -- which included the Remedy product and the ITSM Suite + some discovery software + a CMDB... But in 2014 Oracle broke it all up -- and peeled off the ITSM software into something they called Oracle Service Support (And the concept of a development admin tool went away) -- it is purely configuration and consulting to configure the product... (Traditional Remedy customer are unhappy - new customers don't know better - think they are eating a juicy steak - turns out it is pink slime) RemedyForce was taken over by Business.com (aka Salesforce.com). RemedyOnDemand - still exists -- but is part of Oracle Scalable Enterprise - which everybody calls Oh say ... can you see -- because nobody can actually see it working... kind of a weird industry joke... (Still not sure about it -- I think 2021 humor goes over my head) Same timeframe -- Oracle renamed Remedy to Oracle Enable ... and it became really the adhoc business back-office apps generator SRM was abandoned by Oracle -- really BMC killed it before Oracle got it (circa 2011) - BMC just never told the customers. Of course Kinetic Data stayed independent and front-ends both Oracle Service Support and the Enable framework - keeping customers happy - regardless of the shenanigans behind the scenes... BTW - the MN Vikings still are without a Superbowl in 2021 :( Obama gets reelected. Republican gets elected 2016 -- does a fair job - but chooses not to rerun. Hillary gets 2020. And that is all I know... -John On Mon, Sep 17, 2012 at 8:15 PM, Shellman, David dave.shell...@te.com wrote: ** John, Do you know what version this introduced? Dave On Sep 17, 2012, at 8:43 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** No - they won't work. :( Sorry... -John On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly ctopke...@gmail.com wrote: ** These are great suggestions But I an in 2012 and I need a solution today As you can tell I know nothing about remedy. So will adding the two lines work? Any help is great, my future self says thanks also Chris On Sep 17, 2012 4:26 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** Sweet... don’t think I knew this.. New feature?? Joe From: John Sundberg Sent: Monday, September 17, 2012 4:56 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** You could go into ar.cfg add the 2 lines : ars_track_long_queries: true ars_track_long_queries_min_length: 5000 # This is milliseconds - so all greater than 5 seconds Then -- restart server Look for table called: ARS_TRACK_QUERIES (I think that is the name)… Look in there -- it will tell who when what how long it ran how many entries returned what ip address what client type and version Pretty sweet feature… (wish I would have thought of it originally) -John On Mon, Sep 17, 2012 at 10:21 AM, Chris Kelly ctopke...@gmail.com wrote: ** Thanks so very much. I am not a Remedy Admin so My admin says the Unqualified searches is disabled. I will work on getting the fields indexed asap. The thing is we don't know who is running the queries... is there a way on the remedy system that we could look at to see who is running this and stop it when it is going on? Chris On Mon, Sep 17, 2012 at 9:09 AM, Maddala, Venkat
Re: MACRO Converter
I think it was the v5.1 Admin Tool. I don't think any later Admin tool had the converter. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Tuesday, September 18, 2012 1:57 PM To: arslist@ARSLIST.ORG Subject: MACRO Converter ** Can anyone tell me the last version that had the MACRO converter? I have some active links that are using RUN MACRO and I would like to get them converted to Active Links. It seems like I remember this topic being discussed before, but I am unable to search the archives for some reason. My browser goes off in space.. Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: MACRO Converter
I remember 6.3 had one too.. Do not clearly remember about 7. But I know 7.5 Dev Studio didn’t.. Joe From: Grooms, Frederick W Sent: Tuesday, September 18, 2012 3:27 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** I think it was the v5.1 Admin Tool. I don’t think any later Admin tool had the converter. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Tuesday, September 18, 2012 1:57 PM To: arslist@ARSLIST.ORG Subject: MACRO Converter ** Can anyone tell me the last version that had the MACRO converter? I have some active links that are using RUN MACRO and I would like to get them converted to Active Links. It seems like I remember this topic being discussed before, but I am unable to search the archives for some reason. My browser goes off in space…… Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Querys that kill my system
Chris, It will tell you all the big SQL queries running in th esystem. GLEWF API calls which are associated with large queries You can use this to see - which form is getting most of the GLEWF call , need more indexing etc - Which user is issueing it , do he need to do that or can go to alternate source to pull reports etc - Frequency of the call,at what time he is using it can he do it during non peak hours - corelate it if that is actually causing the serve slowness and outage Ravi Date: Tue, 18 Sep 2012 13:26:14 -0600 From: ctopke...@gmail.com Subject: Re: Querys that kill my system To: arslist@ARSLIST.ORG ** Ravi What does this tell you about the system??? On 09/18/2012 01:22 PM, ravi rai wrote: ** Joe, This feature is available Add following in Ar.cfg Large-Result-Logging-Threshold: 7 7 is the threshold limit enable thread log result will be like THRD 1 /* Mon Jul 09 2012 16:05:38.2310 */ Thread Id 39696 (GLEWF) large result buffer allocation - /Length: 840183/Entries: 3000/Client Ver: =10/RPC ID: 11393/User: UserName/Form: Form name/ Ravi Date: Tue, 18 Sep 2012 14:05:57 -0400 From: jdso...@shyle.net Subject: Re: Querys that kill my system To: arslist@ARSLIST.ORG ** So this feature really isn't there? You nearly had me there! It’s a great feature if it was there though.. Maybe a perfect candidate for some sort of an enhancement request.. Joe From: John Sundberg Sent: Monday, September 17, 2012 10:04 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** It is a little hard to say what version it was Because in 2012 -- BMC renamed it all to BMC Atrium ... threw in the kitchen sink -- which included the Remedy product and the ITSM Suite + some discovery software + a CMDB... But in 2014 Oracle broke it all up -- and peeled off the ITSM software into something they called Oracle Service Support (And the concept of a development admin tool went away) -- it is purely configuration and consulting to configure the product... (Traditional Remedy customer are unhappy - new customers don't know better - think they are eating a juicy steak - turns out it is pink slime) RemedyForce was taken over by Business.com (aka Salesforce.com). RemedyOnDemand - still exists -- but is part of Oracle Scalable Enterprise - which everybody calls Oh say ... can you see -- because nobody can actually see it working... kind of a weird industry joke... (Still not sure about it -- I think 2021 humor goes over my head) Same timeframe -- Oracle renamed Remedy to Oracle Enable ... and it became really the adhoc business back-office apps generator SRM was abandoned by Oracle -- really BMC killed it before Oracle got it (circa 2011) - BMC just never told the customers. Of course Kinetic Data stayed independent and front-ends both Oracle Service Support and the Enable framework - keeping customers happy - regardless of the shenanigans behind the scenes... BTW - the MN Vikings still are without a Superbowl in 2021 :( Obama gets reelected. Republican gets elected 2016 -- does a fair job - but chooses not to rerun. Hillary gets 2020. And that is all I know... -John On Mon, Sep 17, 2012 at 8:15 PM, Shellman, David dave.shell...@te.com wrote: ** John, Do you know what version this introduced? Dave On Sep 17, 2012, at 8:43 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** No - they won't work. :( Sorry... -John On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly ctopke...@gmail.com wrote: ** These are great suggestions But I an in 2012 and I need a solution today As you can tell I know nothing about remedy. So will adding the two lines work? Any help is great, my future self says thanks also Chris On Sep 17, 2012 4:26 PM, Joe Martin D'Souza jdso...@shyle.net wrote: ** Sweet... don’t think I knew this.. New feature?? Joe From: John Sundberg Sent: Monday, September 17, 2012 4:56 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** You could go into ar.cfg add the 2 lines : ars_track_long_queries: true ars_track_long_queries_min_length: 5000 # This is milliseconds - so all greater than 5 seconds Then -- restart server Look for table called: ARS_TRACK_QUERIES (I think that is the name)… Look in there -- it will tell who when what how long it ran how many entries returned what ip address what client type and version Pretty sweet feature… (wish I would have thought of it originally) -John On Mon, Sep 17, 2012 at 10:21 AM, Chris Kelly ctopke...@gmail.com wrote: ** Thanks so very much. I am not a Remedy Admin so My admin says the Unqualified searches is disabled. I will work on getting the fields indexed asap. The thing is we don't know who is running the queries... is there a way on the remedy system that
Re: Querys that kill my system
We have Large Result Logging turned on. While it does show us some people who could use some education it has never given us information (form/user) regarding a query that hangs the system. For some reason these hanging queries do not seem to be logged by this feature. We use the below MS SQL query to find the offending process and query but since it is at the SQL level it doesn't tell us who issued the query. I would love to be able to correlated this with the thread log. These hangs happens so rarely now it doesn't warrant keeping SQL logging on at all times. - DROP TABLE #Processes -- Field ID 24007 = Description and Field ID 24008 = Worklog SELECT s.spid, BlockingSPID = s.blocked, DatabaseName = DB_NAME(s.dbid), s.program_name, s.loginame, ObjectName = OBJECT_NAME(objectid, s.dbid), Definition = CAST(text AS VARCHAR(MAX)) INTO#Processes FROM sys.sysprocesses s CROSS APPLY sys.dm_exec_sql_text (sql_handle) WHERE s.spid 50; WITH Blocking(SPID, BlockingSPID, BlockingStatement, RowNo, LevelRow) AS ( SELECT s.SPID, s.BlockingSPID, s.Definition, ROW_NUMBER() OVER(ORDER BY s.SPID), 0 AS LevelRow FROM #Processes s JOIN #Processes s1 ON s.SPID = s1.BlockingSPID WHERE s.BlockingSPID = 0 UNION ALL SELECT r.SPID, r.BlockingSPID, r.Definition, d.RowNo, d.LevelRow + 1 FROM #Processes r JOIN Blocking d ON r.BlockingSPID = d.SPID WHERE r.BlockingSPID 0 ) SELECT * FROM Blocking ORDER BY RowNo, LevelRow -- DROP TABLE #Processes - Jason On Tue, Sep 18, 2012 at 12:22 PM, ravi rai ravira...@hotmail.com wrote: ** Joe, This feature is available Add following in Ar.cfg *Large-Result-Logging-Threshold: 7 * 7 is the threshold limit enable thread log result will be like THRD 1 /* Mon Jul 09 2012 16:05:38.2310 */ Thread Id 39696 (GLEWF) large result buffer allocation - /Length: *840183*/Entries: 3000/Client Ver: =10/RPC ID: 11393/User: UserName/Form: Form name/ Ravi -- Date: Tue, 18 Sep 2012 14:05:57 -0400 From: jdso...@shyle.net Subject: Re: Querys that kill my system To: arslist@ARSLIST.ORG ** So this feature really isn't there? You nearly had me there! It’s a great feature if it was there though.. Maybe a perfect candidate for some sort of an enhancement request.. Joe *From:* John Sundberg john.sundb...@kineticdata.com *Sent:* Monday, September 17, 2012 10:04 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Querys that kill my system ** It is a little hard to say what version it was Because in 2012 -- BMC renamed it all to BMC Atrium ... threw in the kitchen sink -- which included the Remedy product and the ITSM Suite + some discovery software + a CMDB... But in 2014 Oracle broke it all up -- and peeled off the ITSM software into something they called Oracle Service Support (And the concept of a development admin tool went away) -- it is purely configuration and consulting to configure the product... (Traditional Remedy customer are unhappy - new customers don't know better - think they are eating a juicy steak - turns out it is pink slime) RemedyForce was taken over by Business.com (aka Salesforce.com). RemedyOnDemand - still exists -- but is part of Oracle Scalable Enterprise - which everybody calls Oh say ... can you see -- because nobody can actually see it working... kind of a weird industry joke... (Still not sure about it -- I think 2021 humor goes over my head) Same timeframe -- Oracle renamed Remedy to Oracle Enable ... and it became really the adhoc business back-office apps generator SRM was abandoned by Oracle -- really BMC killed it before Oracle got it (circa 2011) - BMC just never told the customers. Of course Kinetic Data stayed independent and front-ends both Oracle Service Support and the Enable framework - keeping customers happy - regardless of the shenanigans behind the scenes... BTW - the MN Vikings still are without a Superbowl in 2021 :( Obama gets reelected. Republican gets elected 2016 -- does a fair job - but chooses not to rerun. Hillary gets 2020. And that is all I know... -John On Mon, Sep 17, 2012 at 8:15 PM, Shellman, David dave.shell...@te.comwrote: ** John, Do you know what version this introduced? Dave On Sep 17, 2012, at 8:43 PM, John Sundberg john.sundb...@kineticdata.com wrote: ** No - they won't work. :( Sorry... -John On Mon, Sep 17, 2012 at 6:05 PM, Chris Kelly ctopke...@gmail.com wrote: ** These are great suggestions But I an in 2012 and I need a solution today As you can tell I know nothing about remedy. So will adding the two lines work?
Re: MACRO Converter
Thanks for the responses, but from reading some of the documentation it sounds like it wouldn’t work on mine. Two Run Macro actions cannot be converted: · When you use the query bar inside the macro and: oField names and field labels on the current form are different. oYou use field IDs not on the current form as a parameter inside the query. · Any action involving logging in. My MACRO appears to match request id’s from two different forms. I may have to find a way to rebuild the functionality from scratch. Or just do away with that functionality altogether (-: Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, September 18, 2012 2:34 PM To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** I remember 6.3 had one too.. Do not clearly remember about 7. But I know 7.5 Dev Studio didn’t.. Joe From: Grooms, Frederick Wmailto:frederick.w.gro...@xo.com Sent: Tuesday, September 18, 2012 3:27 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** I think it was the v5.1 Admin Tool. I don’t think any later Admin tool had the converter. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Tuesday, September 18, 2012 1:57 PM To: arslist@ARSLIST.ORG Subject: MACRO Converter ** Can anyone tell me the last version that had the MACRO converter? I have some active links that are using RUN MACRO and I would like to get them converted to Active Links. It seems like I remember this topic being discussed before, but I am unable to search the archives for some reason. My browser goes off in space…… Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Querys that kill my system
Which kind of makes sense.. You can’t get a heart beat of a dead man.. But you might get the last thing that was run before the system died? Alternately I think if there was a process completely outside the AR System that monitored the DB User, it could monitor these things, you would have it running even after a server restart. Maybe one of the BMC monitoring tools may be an answer to this? Joe From: Jason Miller Sent: Tuesday, September 18, 2012 3:40 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** We have Large Result Logging turned on. While it does show us some people who could use some education it has never given us information (form/user) regarding a query that hangs the system. For some reason these hanging queries do not seem to be logged by this feature. We use the below MS SQL query to find the offending process and query but since it is at the SQL level it doesn't tell us who issued the query. I would love to be able to correlated this with the thread log. These hangs happens so rarely now it doesn't warrant keeping SQL logging on at all times. - DROP TABLE #Processes -- Field ID 24007 = Description and Field ID 24008 = Worklog SELECT s.spid, BlockingSPID = s.blocked, DatabaseName = DB_NAME(s.dbid), s.program_name, s.loginame, ObjectName = OBJECT_NAME(objectid, s.dbid), Definition = CAST(text AS VARCHAR(MAX)) INTO#Processes FROM sys.sysprocesses s CROSS APPLY sys.dm_exec_sql_text (sql_handle) WHERE s.spid 50; WITH Blocking(SPID, BlockingSPID, BlockingStatement, RowNo, LevelRow) AS ( SELECT s.SPID, s.BlockingSPID, s.Definition, ROW_NUMBER() OVER(ORDER BY s.SPID), 0 AS LevelRow FROM #Processes s JOIN #Processes s1 ON s.SPID = s1.BlockingSPID WHERE s.BlockingSPID = 0 UNION ALL SELECT r.SPID, r.BlockingSPID, r.Definition, d.RowNo, d.LevelRow + 1 FROM #Processes r JOIN Blocking d ON r.BlockingSPID = d.SPID WHERE r.BlockingSPID 0 ) SELECT * FROM Blocking ORDER BY RowNo, LevelRow -- DROP TABLE #Processes - Jason On Tue, Sep 18, 2012 at 12:22 PM, ravi rai ravira...@hotmail.com wrote: ** Joe, This feature is available Add following in Ar.cfg Large-Result-Logging-Threshold: 7 7 is the threshold limit enable thread log result will be like THRD 1 /* Mon Jul 09 2012 16:05:38.2310 */ Thread Id 39696 (GLEWF) large result buffer allocation - /Length: 840183/Entries: 3000/Client Ver: =10/RPC ID: 11393/User: UserName/Form: Form name/ Ravi -- Date: Tue, 18 Sep 2012 14:05:57 -0400 From: jdso...@shyle.net Subject: Re: Querys that kill my system To: arslist@ARSLIST.ORG ** So this feature really isn't there? You nearly had me there! It’s a great feature if it was there though.. Maybe a perfect candidate for some sort of an enhancement request.. Joe From: John Sundberg Sent: Monday, September 17, 2012 10:04 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Querys that kill my system ** It is a little hard to say what version it was Because in 2012 -- BMC renamed it all to BMC Atrium ... threw in the kitchen sink -- which included the Remedy product and the ITSM Suite + some discovery software + a CMDB... But in 2014 Oracle broke it all up -- and peeled off the ITSM software into something they called Oracle Service Support (And the concept of a development admin tool went away) -- it is purely configuration and consulting to configure the product... (Traditional Remedy customer are unhappy - new customers don't know better - think they are eating a juicy steak - turns out it is pink slime) RemedyForce was taken over by Business.com (aka Salesforce.com). RemedyOnDemand - still exists -- but is part of Oracle Scalable Enterprise - which everybody calls Oh say ... can you see -- because nobody can actually see it working... kind of a weird industry joke... (Still not sure about it -- I think 2021 humor goes over my head) Same timeframe -- Oracle renamed Remedy to Oracle Enable ... and it became really the adhoc business back-office apps generator SRM was abandoned by Oracle -- really BMC killed it before Oracle got it (circa 2011) - BMC just never told the customers. Of course Kinetic Data stayed independent and front-ends both Oracle Service Support and the Enable framework - keeping customers happy - regardless of the shenanigans behind the scenes... BTW - the MN Vikings still are without a Superbowl in 2021 :( Obama gets
Re: MACRO Converter
What does the macro accomplish? If a set field or push field cannot, I’ll be surprised if you cannot do it with a Direct SQL, although that is the least preferred way to go, given other choices.. Sometimes that’s the only plausible choice.. Joe From: Mayfield, Andy L. Sent: Tuesday, September 18, 2012 3:55 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** Thanks for the responses, but from reading some of the documentation it sounds like it wouldn’t work on mine. Two Run Macro actions cannot be converted: · When you use the query bar inside the macro and: oField names and field labels on the current form are different. oYou use field IDs not on the current form as a parameter inside the query. · Any action involving logging in. My MACRO appears to match request id’s from two different forms. I may have to find a way to rebuild the functionality from scratch. Or just do away with that functionality altogether (-: Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, September 18, 2012 2:34 PM To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** I remember 6.3 had one too.. Do not clearly remember about 7. But I know 7.5 Dev Studio didn’t.. Joe From: Grooms, Frederick W Sent: Tuesday, September 18, 2012 3:27 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** I think it was the v5.1 Admin Tool. I don’t think any later Admin tool had the converter. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Tuesday, September 18, 2012 1:57 PM To: arslist@ARSLIST.ORG Subject: MACRO Converter ** Can anyone tell me the last version that had the MACRO converter? I have some active links that are using RUN MACRO and I would like to get them converted to Active Links. It seems like I remember this topic being discussed before, but I am unable to search the archives for some reason. My browser goes off in space…… Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Data Import Processing.
Solved thanks to Fred Grooms.
I had to use a Set fields action of SQL and CAST the length because for some
reason MS SQL was only returning the first character of the field from the
Asset_Info_System form when the imported field was null.
SELECT ISNULL(CAST(NULLIF('$Class Number$','') AS varchar(100)), Class_Number),
ISNULL(CAST(NULLIF('$Loc-Bldg$','') AS varchar(100)), Building),
ISNULL(CAST(NULLIF('$Loc-Room$','') AS varchar(100)), Room),
ISNULL(CAST(NULLIF('$Loc-Area$','') AS varchar(10)), Cube),
ISNULL(CAST(NULLIF('$People ID$','') AS varchar(10)), People_ID)
FROM Asset_Info_System where Bar_Code = '$Bar Code$'
Thank you,
---
John J. Reiser
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Thursday, September 13, 2012 1:56 PM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: Data Import Processing.
Fred,
I gave it another shot today with some progress.
Now I have the issue of my set fields value $1$ only returns the first
character if the imported column($Field 1$) is NULL. Other than that it's
working.
SELECT ISNULL(NULLIF('$Field 1$',''), Field_1) FROM Asset_Form where Asset_ID
= '$Asset ID$'
The Field 1 field on each form is the same.
If I take out the NULLIF I only get the imported value.
I've got to be missing something simple.
Thank you,
---
John J. Reiser
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Wednesday, September 12, 2012 6:15 PM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: Data Import Processing.
Sorry ... MS SQL uses ISNULL or COALESCE instead
And thinking about it you may also need ISNULL just for the empty string
possibility
ISNULL(NULLIF('$Field1$',''), Field1)
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Wednesday, September 12, 2012 4:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: Data Import Processing.
Fred,
I got a chance to try this.
However this is no built in function NZ or Nz SQL Error 552.
As soon as I get my SQL Manager Studio client back I can look into this
further.
Thank you,
---
John J. Reiser
Remedy Developer/Administrator
Senior Software Development Analyst
Lockheed Martin - MS2
The star that burns twice as bright burns half as long.
Pay close attention and be illuminated by its brilliance. - paraphrased by me
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W
Sent: Tuesday, September 11, 2012 5:21 PM
To: arslist@ARSLIST.ORG
Subject: EXTERNAL: Re: Data Import Processing.
Sounds like a good use for an SQL set fields to me
Use the Set fields to fill in the missing data fields into your Pre-Import form
SELECT Nz('$Field1$', Field1), Nz('$Field2$', Field2), Nz('$Field3$',
Field3) from SQL_FORM_VIEW WHERE x=y
Nz is the MS-SQL function for Non-Null so if the new data has a value it will
be kept otherwise the original value will be pulled in.
Then just a regular single push will work as all fields have data.
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Reiser, John J
Sent: Tuesday, September 11, 2012 4:05 PM
To: arslist@ARSLIST.ORG
Subject: Data Import Processing.
Hello Listers,
ARS 7.6.03 Build 001
MS SQL 2005
Windows Server 2003 VM
I'm working with a group that needs constant data imports to an asset form in
ARSystem.
To handle this we built a Pre-Import form.
Everything gets imported to the Pre-Import form which has filters firing on
merge to see if the asset exists in the ARSystem form. If it exists certain
data is copied to the Pre-import form and used to determine if the asset record
should be updated. If it doesn't exist we just push the Pre-import record
through as a new asset.
Now others want to use this process and they have many more fields to import
but not all of the fields will have data every time.
My dilemma is this, when a record is loaded to the Pre-import form AND it
exists in the asset form, blank fields in the import form clear out the asset
field when merged.
The only way I can think to overcome this is to have a filter per field to
check for $NULL$ and then don't do a filter PUSH on merge for that field.
I'm working on multiple
Re: Hiding 'resize handle' character fields on midtier
A change like this on a CSS file has a minimal impact, and a minimal risk. Also it's very easy to rollback if any issue appears. Regards, Jose Manuel Huerta http://theremedyforit.com/ On Tue, Sep 18, 2012 at 8:52 PM, David Durling durl...@uga.edu wrote: ** Jose ( Benny), ** ** Thanks, I finally tried “resize:none” and it seems to work well on my test server. Not sure if I’ll get cleared to put it on production since BMC won’t support it, but I might try – ** ** David ** ** David Durling University of Georgia ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Jose Huerta *Sent:* Monday, June 04, 2012 5:35 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Hiding 'resize handle' character fields on midtier ** ** ** You can solve it with CSS with the next modifications: ** ** Go to the mozilla ARSystem CSS. midTierInstallDir\resources\moz\stylesheets\ARSystem.css ** ** And add the next parameter: resize: none ** ** to the next classes: textarea.text textarea.sr textarea.dat textarea.readonly textarea.PopupEditor input.text input.currency input.decimal ** ** Let me know if it works. ** ** * * -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: 01 June 2012 19:13 To: arslist@ARSLIST.ORG Subject: Re: Hiding 'resize handle' character fields on midtier *…* Benny's suggestion about customizing CSS is an idea, but since it sounds like an upgrade might fix this, I'll probably leave it alone. -Original Message- From: David Durling Sent: Friday, June 01, 2012 11:15 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Hiding 'resize handle' character fields on midtier Hi all, Character fields on our Remedy forms when seen in browsers like Firefox and I think Chrome (not IE) show a little handle at the bottom right that you can drag to resize the field. … _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Hiding 'resize handle' character fields on midtier
Thanks, I can pass that on to my management J David From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Manuel Huerta Guillén Sent: Tuesday, September 18, 2012 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Hiding 'resize handle' character fields on midtier ** A change like this on a CSS file has a minimal impact, and a minimal risk. Also it's very easy to rollback if any issue appears. Regards, Jose Manuel Huerta http://theremedyforit.com/ On Tue, Sep 18, 2012 at 8:52 PM, David Durling durl...@uga.edumailto:durl...@uga.edu wrote: ** Jose ( Benny), Thanks, I finally tried resize:none and it seems to work well on my test server. Not sure if I'll get cleared to put it on production since BMC won't support it, but I might try - David David Durling University of Georgia From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: Monday, June 04, 2012 5:35 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Hiding 'resize handle' character fields on midtier ** You can solve it with CSS with the next modifications: Go to the mozilla ARSystem CSS. midTierInstallDir\resources\moz\stylesheets\ARSystem.css And add the next parameter: resize: none to the next classes: textarea.text textarea.srhttp://textarea.sr textarea.dat textarea.readonly textarea.PopupEditor input.text input.currency input.decimal Let me know if it works. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of David Durling Sent: 01 June 2012 19:13 To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Hiding 'resize handle' character fields on midtier ... Benny's suggestion about customizing CSS is an idea, but since it sounds like an upgrade might fix this, I'll probably leave it alone. -Original Message- From: David Durling Sent: Friday, June 01, 2012 11:15 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Hiding 'resize handle' character fields on midtier Hi all, Character fields on our Remedy forms when seen in browsers like Firefox and I think Chrome (not IE) show a little handle at the bottom right that you can drag to resize the field. ... _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: MACRO Converter
I believe I can do it with some set and push fields. I just have to map out what all is going on in there. It’s used in an active link that updates information from a ticket to an escalation. Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, September 18, 2012 3:03 PM To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** What does the macro accomplish? If a set field or push field cannot, I’ll be surprised if you cannot do it with a Direct SQL, although that is the least preferred way to go, given other choices.. Sometimes that’s the only plausible choice.. Joe From: Mayfield, Andy L.mailto:almay...@southernco.com Sent: Tuesday, September 18, 2012 3:55 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** Thanks for the responses, but from reading some of the documentation it sounds like it wouldn’t work on mine. Two Run Macro actions cannot be converted: · When you use the query bar inside the macro and: oField names and field labels on the current form are different. oYou use field IDs not on the current form as a parameter inside the query. · Any action involving logging in. My MACRO appears to match request id’s from two different forms. I may have to find a way to rebuild the functionality from scratch. Or just do away with that functionality altogether (-: Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, September 18, 2012 2:34 PM To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** I remember 6.3 had one too.. Do not clearly remember about 7. But I know 7.5 Dev Studio didn’t.. Joe From: Grooms, Frederick Wmailto:frederick.w.gro...@xo.com Sent: Tuesday, September 18, 2012 3:27 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** I think it was the v5.1 Admin Tool. I don’t think any later Admin tool had the converter. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Tuesday, September 18, 2012 1:57 PM To: arslist@ARSLIST.ORG Subject: MACRO Converter ** Can anyone tell me the last version that had the MACRO converter? I have some active links that are using RUN MACRO and I would like to get them converted to Active Links. It seems like I remember this topic being discussed before, but I am unable to search the archives for some reason. My browser goes off in space…… Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Setting up approvals for CIs
Hey guys, a general question regarding approvals. The People/Org/Support Group relationships allow for approved by relationships for the entity related to the CI. Does this have any link to the Approver Engine? And if so, what is it? I know that you can set up approvals for a CI in the Approval Mappings form and do it based on Approval Phase, wonder if the CI approved by relationships have anything to do with it. Thanks Eric Chow Remedy Operations Analyst Research In Motion, Northfield Campus, Building D 2220 University Ave E, Waterloo, ON, N2K 0A8 Office: 519-888-7465 x70469 Direct: 519-597-0469 Mobile: 416-886-3929 [cid:image001.gif@01CD95C3.3B0D2150] - This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.gif
Re: Querys that kill my system
Yes and no. There is a lock in the DB but the app is still alive. And even then I believe it is only one thread and/or table that is locked. We are able to capture he offending SQL but it doesn't translate back to the application layer. Jason On Tue, Sep 18, 2012 at 12:59 PM, Joe Martin D'Souza jdso...@shyle.netwrote: ** Which kind of makes sense.. You can’t get a heart beat of a dead man.. But you might get the last thing that was run before the system died? Alternately I think if there was a process completely outside the AR System that monitored the DB User, it could monitor these things, you would have it running even after a server restart. Maybe one of the BMC monitoring tools may be an answer to this? Joe *From:* Jason Miller jason.mil...@gmail.com *Sent:* Tuesday, September 18, 2012 3:40 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Querys that kill my system ** We have Large Result Logging turned on. While it does show us some people who could use some education it has never given us information (form/user) regarding a query that hangs the system. For some reason these hanging queries do not seem to be logged by this feature. We use the below MS SQL query to find the offending process and query but since it is at the SQL level it doesn't tell us who issued the query. I would love to be able to correlated this with the thread log. These hangs happens so rarely now it doesn't warrant keeping SQL logging on at all times. - DROP TABLE #Processes -- Field ID 24007 = Description and Field ID 24008 = Worklog SELECT s.spid, BlockingSPID = s.blocked, DatabaseName = DB_NAME(s.dbid), s.program_name, s.loginame, ObjectName = OBJECT_NAME(objectid, s.dbid), Definition = CAST(text AS VARCHAR(MAX)) INTO#Processes FROM sys.sysprocesses s CROSS APPLY sys.dm_exec_sql_text (sql_handle) WHERE s.spid 50; WITH Blocking(SPID, BlockingSPID, BlockingStatement, RowNo, LevelRow) AS ( SELECT s.SPID, s.BlockingSPID, s.Definition, ROW_NUMBER() OVER(ORDER BY s.SPID), 0 AS LevelRow FROM #Processes s JOIN #Processes s1 ON s.SPID = s1.BlockingSPID WHERE s.BlockingSPID = 0 UNION ALL SELECT r.SPID, r.BlockingSPID, r.Definition, d.RowNo, d.LevelRow + 1 FROM #Processes r JOIN Blocking d ON r.BlockingSPID = d.SPID WHERE r.BlockingSPID 0 ) SELECT * FROM Blocking ORDER BY RowNo, LevelRow -- DROP TABLE #Processes - Jason On Tue, Sep 18, 2012 at 12:22 PM, ravi rai ravira...@hotmail.com wrote: ** Joe, This feature is available Add following in Ar.cfg *Large-Result-Logging-Threshold: 7 * 7 is the threshold limit enable thread log result will be like THRD 1 /* Mon Jul 09 2012 16:05:38.2310 */ Thread Id 39696 (GLEWF) large result buffer allocation - /Length: *840183*/Entries: 3000/Client Ver: =10/RPC ID: 11393/User: UserName/Form: Form name/ Ravi -- Date: Tue, 18 Sep 2012 14:05:57 -0400 From: jdso...@shyle.net Subject: Re: Querys that kill my system To: arslist@ARSLIST.ORG ** So this feature really isn't there? You nearly had me there! It’s a great feature if it was there though.. Maybe a perfect candidate for some sort of an enhancement request.. Joe *From:* John Sundberg john.sundb...@kineticdata.com *Sent:* Monday, September 17, 2012 10:04 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Querys that kill my system ** It is a little hard to say what version it was Because in 2012 -- BMC renamed it all to BMC Atrium ... threw in the kitchen sink -- which included the Remedy product and the ITSM Suite + some discovery software + a CMDB... But in 2014 Oracle broke it all up -- and peeled off the ITSM software into something they called Oracle Service Support (And the concept of a development admin tool went away) -- it is purely configuration and consulting to configure the product... (Traditional Remedy customer are unhappy - new customers don't know better - think they are eating a juicy steak - turns out it is pink slime) RemedyForce was taken over by Business.com (aka Salesforce.com). RemedyOnDemand - still exists -- but is part of Oracle Scalable Enterprise - which everybody calls Oh say ... can you see -- because nobody can actually see it working... kind of a weird industry joke... (Still not sure about it -- I think 2021 humor goes over my head) Same timeframe -- Oracle renamed Remedy to Oracle Enable ... and it became really the adhoc business back-office apps generator SRM was abandoned by Oracle -- really BMC killed it before Oracle
Re: Setting up approvals for CIs
At least in the version 7.6.03 there is no link between change approval mappings and CI relationship type of Approved by. Approval engine is designed to be out of the box and to be used with non ITSM modules as well. Even Change Mgmt module also can be used without other ITSM or Atrium modules. May be that is the reason they did not built any logic to look at CI relationship types to retrieve approvals and just used the approval mapping form. On Tuesday, September 18, 2012 2:33:08 PM UTC-7, Eric Chow wrote: ** Hey guys, a general question regarding approvals. The People/Org/Support Group relationships allow for “approved by” relationships for the entity related to the CI. Does this have any link to the Approver Engine? And if so, what is it? I know that you can set up approvals for a CI in the Approval Mappings form and do it based on Approval Phase, wonder if the CI “approved by” relationships have anything to do with it. Thanks *Eric Chow* *Remedy Operations Analyst* *Research In Motion, Northfield Campus, Building D* *2220 University Ave E, Waterloo, ON, N2K 0A8* Office: 519-888-7465 x70469 Direct: 519-597-0469 Mobile: 416-886-3929 - This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Setting up approvals for CIs
Yes. That was the intent. In 7.0 you could not use the CI Approver tab and the other approver tab in Approval mapping. To clarify that you COULD put an entry in but if other criteria was populated on other tabs then the CI Approver tab was ignored. I am not sure if this was fixed, I haven't used CI Approvers in 7.5 and up. Tommy Morris CMDB Certified Specialist Director of IT Service Management [cid:image002.png@01CD95C1.1D669020]http://www.pinebreeze.com/ tommy.mor...@pinebreeze.comhttps://exg5.exghost.com/owa/redir.aspx?C=1d40184b0dc44e86917981c2ecb56197URL=mailto%3atommy.morris%40pinebreeze.com 817.727.1021 - mobile 972.899.2366 - office 972.899.2898 - fax From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Eric Chow Sent: Tuesday, September 18, 2012 4:33 PM To: arslist@ARSLIST.ORG Subject: Setting up approvals for CIs ** Hey guys, a general question regarding approvals. The People/Org/Support Group relationships allow for approved by relationships for the entity related to the CI. Does this have any link to the Approver Engine? And if so, what is it? I know that you can set up approvals for a CI in the Approval Mappings form and do it based on Approval Phase, wonder if the CI approved by relationships have anything to do with it. Thanks Eric Chow Remedy Operations Analyst Research In Motion, Northfield Campus, Building D 2220 University Ave E, Waterloo, ON, N2K 0A8 Office: 519-888-7465 x70469 Direct: 519-597-0469 Mobile: 416-886-3929 [cid:image003.gif@01CD95C1.1D669020] - This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image002.pnginline: image003.gif
Re: Setting up approvals for CIs
Hmm, maybe I’m mistaken on where the CI Approver tab did the lookup then. As I stated it’s been a while since I worked with the CI approval tab. Tommy Morris CMDB Certified Specialist Director of IT Service Management [cid:image001.png@01CD95C1.63BE1200]http://www.pinebreeze.com/ tommy.mor...@pinebreeze.comhttps://exg5.exghost.com/owa/redir.aspx?C=1d40184b0dc44e86917981c2ecb56197URL=mailto%3atommy.morris%40pinebreeze.com 817.727.1021 – mobile 972.899.2366 - office 972.899.2898 - fax From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Tuesday, September 18, 2012 5:15 PM To: arslist@ARSLIST.ORG Subject: Re: Setting up approvals for CIs ** At least in the version 7.6.03 there is no link between change approval mappings and CI relationship type of Approved by. Approval engine is designed to be out of the box and to be used with non ITSM modules as well. Even Change Mgmt module also can be used without other ITSM or Atrium modules. May be that is the reason they did not built any logic to look at CI relationship types to retrieve approvals and just used the approval mapping form. On Tuesday, September 18, 2012 2:33:08 PM UTC-7, Eric Chow wrote: ** Hey guys, a general question regarding approvals. The People/Org/Support Group relationships allow for “approved by” relationships for the entity related to the CI. Does this have any link to the Approver Engine? And if so, what is it? I know that you can set up approvals for a CI in the Approval Mappings form and do it based on Approval Phase, wonder if the CI “approved by” relationships have anything to do with it. Thanks Eric Chow Remedy Operations Analyst Research In Motion, Northfield Campus, Building D 2220 University Ave E, Waterloo, ON, N2K 0A8 Office: 519-888-7465 x70469 Direct: 519-597-0469 Mobile: 416-886-3929 - This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.comhttp://www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: image001.png
Re: MACRO Converter
It does sound very doable.. Remember macros were more actively used before the dawn of Push Fields, Window Open, and actions such as those.. All that the converter does is look at things like that and converts them to corresponding AL actions.. Joe From: Mayfield, Andy L. Sent: Tuesday, September 18, 2012 5:05 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** I believe I can do it with some set and push fields. I just have to map out what all is going on in there. It’s used in an active link that updates information from a ticket to an escalation. Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, September 18, 2012 3:03 PM To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** What does the macro accomplish? If a set field or push field cannot, I’ll be surprised if you cannot do it with a Direct SQL, although that is the least preferred way to go, given other choices.. Sometimes that’s the only plausible choice.. Joe From: Mayfield, Andy L. Sent: Tuesday, September 18, 2012 3:55 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** Thanks for the responses, but from reading some of the documentation it sounds like it wouldn’t work on mine. Two Run Macro actions cannot be converted: · When you use the query bar inside the macro and: oField names and field labels on the current form are different. oYou use field IDs not on the current form as a parameter inside the query. · Any action involving logging in. My MACRO appears to match request id’s from two different forms. I may have to find a way to rebuild the functionality from scratch. Or just do away with that functionality altogether (-: Thanks, Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, September 18, 2012 2:34 PM To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** I remember 6.3 had one too.. Do not clearly remember about 7. But I know 7.5 Dev Studio didn’t.. Joe From: Grooms, Frederick W Sent: Tuesday, September 18, 2012 3:27 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: MACRO Converter ** I think it was the v5.1 Admin Tool. I don’t think any later Admin tool had the converter. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mayfield, Andy L. Sent: Tuesday, September 18, 2012 1:57 PM To: arslist@ARSLIST.ORG Subject: MACRO Converter ** Can anyone tell me the last version that had the MACRO converter? I have some active links that are using RUN MACRO and I would like to get them converted to Active Links. It seems like I remember this topic being discussed before, but I am unable to search the archives for some reason. My browser goes off in space…… Andy L. Mayfield Alabama Power Company Protection Control Technician Staff Linc # 10*19140 Cell # 205-288-9140 Office # 205-226-1846 _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
