Re: Process Designer ITSM 8.1
Hi, In my infinite wisdom, i decided to get the server up to 8.1.01 and the mid tier to 8.1.01.P1 Bad decision, the upgrade said it had failed on the server and its been rolling back transactions all evening, it also decided to remove the email service ..[?] So looks like going to have to install all over again On Wed, Jul 16, 2014 at 5:06 PM, Carl Wilson carlbwil...@gmail.com wrote: ** Hi, PD will work on 8.1 or 8.0 with no issue, you just require the Mid-Tier Hotfix if using the latest PD version 8.3.04 - this does not require you to update the whole ARS/ITSM system. Alternately, you could install a later version of the Mid-Tier that would include the Hot-Fix e.g. 8.1.01. -- Kind Regards, *Carl Wilson* *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Peters *Sent:* 16 July 2014 16:50 *To:* arslist@ARSLIST.ORG *Subject:* Re: Process Designer ITSM 8.1 ** I was looking on the product download patch site. There is no patch to go from 8.1 to 8.1.01 that I can see for arserver, look like you have to download the big installer and apply it. So I will have arserver mid tier on 8.1.01 and the ITSM application on 8.1 Then I will apply the 8.1.01.P1 patches that are available Then maybe it will all work Its enough to make you turn to drink On Wed, Jul 16, 2014 at 4:36 PM, Carl Wilson carlbwil...@gmail.com wrote: ** For the full ITSM upgrade? You can upgrade the Mid-Tier only where required, or just apply the Mid-Tier patch to your current setup. However, the Mid-Tier does come as part of the overall installer, so you would need to download this. -- Kind Regards, *Carl Wilson* http://www.missingpiecessoftware.com/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Peters *Sent:* 16 July 2014 16:13 *To:* arslist@ARSLIST.ORG *Subject:* Re: Process Designer ITSM 8.1 ** So if I want to go from 8.1 to 8.1.01 i have to download another 2gig and install that... please tell me Ive got it wrong On Wed, Jul 16, 2014 at 4:06 PM, Carl Wilson carlbwil...@gmail.com wrote: ** Hi, I am sure no one would blame you … -- Kind Regards, *Carl Wilson* *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Peters *Sent:* 16 July 2014 15:57 *To:* arslist@ARSLIST.ORG *Subject:* Re: Process Designer ITSM 8.1 ** Im trying to apply the mid tier patch and the installer says Destination Problemarrrgghhh Thinking of getting the white flag out On Wed, Jul 16, 2014 at 1:56 PM, Carl Wilson carlbwil...@gmail.com wrote: ** Hi John, This should help (Hotfix = MT_8100_2014JAN07_CU_ALL): https://communities.bmc.com/thread/103868 There is an executable jar ProcessDesigner.jar in the following directory (if Windows) which you can launch the client with: C:\Program Files\BMC Software\ProcessDesigner\Resources -- Kind Regards, *Carl Wilson* http://www.missingpiecessoftware.com/ *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *John Peters *Sent:* 16 July 2014 13:40 *To:* arslist@ARSLIST.ORG *Subject:* Re: Process Designer ITSM 8.1 ** Hi Carl Im using the Single Stack Preconfigured 8.1 system with no patches. I will try and find these hotfixes and the fat client for process designer. Thanks JP On Wed, Jul 16, 2014 at 1:30 PM, Carl Wilson carlbwil...@gmail.com wrote: ** Hi John, With the user, no you do not need to run the installer as this user - the installer must be run as an ARS Administrator. The User is required for the ARID plugin that is installed and used by Process Designer so it requires the correct ITSM permissions to be able to access the forms, etc. Have you applied the necessary hotfix to the Mid-Tier as required by Process Designer - this is required with the latest version dependent on you ARS/MT version installed? You also need to restart the Mid-Tier completely after the installation to get it to pick up all the necessary changes. You might also want to flush your Mid-Tier plugin cache. You can also run the standalone Client from the local system install (which is better as I BMC have never really explained how to get past the errors when launching from the Mid-Tier) I posted a Blog post on BMC Communities on some of the things to look out for when using Process Designer - unfortunately it worked well when it was a standalone product but BMC have yet to get it fully integrated as most users would expect it to be, so there are lots of little things to note when implementing. -- Kind Regards, *Carl
Query in Database to find difference between two date fields
Hi All, We are using SQL 2005 Database for Remedy Application, the Remedy version is 7.1. I need to run a query in Database to find difference between two date fields. We all know that in AR system DB the date time will be store in Epoch time. I am not that much expert in SQL to write a query to find the difference. Can anyone help me out on this. Regards, Karthick S ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Query in Database to find difference between two date fields
Hi,
Why do you want to do it through SQL instead of through the normal interfaces?
Timestamps are stored as an integer counting seconds since 1970.
To find differences in Advanced Search, you do: ('date1' != 'date2')
In SQL you do (date1 != date2) replacing the fields with the fields column
name, for example C536870913.
Both these searches (API and SQL) will miss the case where one value is NULL
and the other has a date set. This must be handled by explicitly checking for
nulls.
But you might also be talking about finding differences as a specific
difference in time. Examples:
('date1' 'date2) which gives you a list of calles where date1 is earlier
than date2.
('date2' - 'date1' 3600) gives you all records where date2 is at least one
hour greater than date1.
...
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
Hi All,
We are using SQL 2005 Database for Remedy Application, the Remedy version
is 7.1.
I need to run a query in Database to find difference between two date
fields.
We all know that in AR system DB the date time will be store in Epoch
time.
I am not that much expert in SQL to write a query to find the difference.
Can anyone help me out on this.
Regards,
Karthick S
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Where the Answers Are, and have been for 20 years
Addmin new CI and service 7.6.04
Dears, Please advise as I'm trying to add new CI and service using 7.6.04 version but I don't know from where can I do this function. I'd like to add multiple via CSV file or one by one on Remedy form. Thanks, Best Regards, Mahmoud Mahdy Mohammed,PMP | Business Process Automation Technology | Products Services Delivery Phone: +20(0)1004999638 Mail: mahmoud.mahdy-moha...@vodafone.commailto:mohamed.abdel-haf...@vodafone.com * The content of this document is classified as Vodafone Egypt S.A.E. Confidential and Proprietary Information. The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, information) and not to disclose to any third party without the prior written consent of Vodafone Egypt S.A.E. Recipient will be held liable for any unauthorized disclosure. If you have received this message in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments. http://www.vodafone.com.eg * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
email templates
how to attach a template to outgoing email? I need a HTMl template with logo first then a broad header and then notification content with a footer internal-Confidential. How to do this? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Analytics report comes with partial data of two years period but while breaking the reports query for one year gives complete result. any idea ?
Hi Team, Analytics report comes with partial data of two years period but while breaking the reports query for one year gives complete result. any idea ? -harry ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [EXTERNAL] Analytics report comes with partial data of two years period but while breaking the reports query for one year gives complete result. any idea ?
The timeout you have may be too short for the amount of data you are trying to process. Do you see a 'Partial Results' message down in the status bar after the 2-year report completes? Thanks, Natalie Stroud ARS/ITSM Reporting Specialist SAIC @ Sandia National Laboratories nkst...@sandia.govmailto:nkst...@sandia.gov From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG on behalf of Harry amrutharida...@gmail.com Sent: Thursday, July 17, 2014 2:47 PM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Analytics report comes with partial data of two years period but while breaking the reports query for one year gives complete result. any idea ? ** Hi Team, Analytics report comes with partial data of two years period but while breaking the reports query for one year gives complete result. any idea ? -harry _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Partial upgrade from 8.1 to 8.1 SP1
Hello Rebacca, we have done this upgrade. before doing this activity we need segregate from server group to individual kserver and Comment the FTS PLugin from ar.cfg and armonitor.cfg. We haven't done for CMDB suite. We Can help for this activity. Please let us know the error message if any issue due to installation. Regards, Suresh Loganathan. On Jul 15, 2014 6:21 PM, rebecca.beatty rebecca.bea...@windstream.com wrote: ** Given the amount of time it takes to update an entire suite (AR server, CMDB, AIE, ITSM, SRM, SLM, Migrator, Midtier), we were thinking of splitting the installs into two separate days. One being AR Server, CMDB, AIE, and Midtier. Then the next weekend being the remaining of the list above). BMC has given us the indication that this will cause no problems. We have a server group with one primary AR server and three secondary servers. We did discover that you are unable to install the secondaries at the same time because of an install user that is created in the database then removed during the ARserver and CMDB installs). Has anyone attempted this? If so, what has your result been? Any tips or suggestions? Thank you. -- This email message and any attachments are for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message and any attachments. -- View this message in context: Partial upgrade from 8.1 to 8.1 SP1 http://ars-action-request-system.1.n7.nabble.com/Partial-upgrade-from-8-1-to-8-1-SP1-tp117803.html Sent from the ARS (Action Request System) mailing list archive http://ars-action-request-system.1.n7.nabble.com/ at Nabble.com. _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
