Atrium Integrator - Date Field - Data type
We are planning to use Atrium Integrator 7.6.04 to transfer data from a Oracle staging database to the respective Classes. What Oracle Datatype to be used for the Date fields in the staging database ? For e.g. Submit date Installation date etc Oracle Datatype Integer or Timestamp? Thanks, Regards, Madhu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
FW: Atrium Integrator - Date Field - Data type
Oracle Datetime will do. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Madhu Sent: Friday, January 17, 2014 4:38 PM To: arslist@ARSLIST.ORG Subject: Atrium Integrator - Date Field - Data type We are planning to use Atrium Integrator 7.6.04 to transfer data from a Oracle staging database to the respective Classes. What Oracle Datatype to be used for the Date fields in the staging database ? For e.g. Submit date Installation date etc Oracle Datatype Integer or Timestamp? Thanks, Regards, Madhu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: FW: Atrium Integrator - Date Field - Data type
Thanks Yogesh. I'll try. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
SQL Server2012
List, Anybody have any words of wisdom from there experience of installing SQL Server 64 bit on a Windows 2008 server that will be used by ITSM 8.1. Both will be fresh installs no upgrading. Thanks, Teresa ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
arsignal - mystery flag
I've been troubleshooting a problem with my server group. Along the way, I noticed in the arsignal log that the following was being issued fairly regularly: arsignal *-z* [SERVERNAME]:[PORT] [RANDOMUSERNAME]:258999161|, Q-size=0 When I pulled the documentation on arsignal though, there is no flag listed as -z. Anybody have an idea of what is going on here? -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [EXTERNAL] Reporting MTTR in ITSM 7.6.4 from SRM?
Howard: I can tell you that we measure MTTR using the Business Hours Duration field from the Assignment Log form. But I can't tell you whether that value gets calculated excluding the time spent in Pending status or not. And you have to be a little careful with it, at least if you build your reports in Analytics. If you bring in any element with a many-to-one relationship to the ticket (such as Work Info or both resolution and response targets from SLM), it can end up incorrectly doubling the value for MTTR in your report. Dunno if that helps you or not... Most of the data in the SLM portion of the incident ticket comes from SLM:Measurement. If what you are looking for exists specifically within SLM, it's probably in there somewhere. Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Richter, Howard (CEI - Atlanta) Sent: Thursday, January 16, 2014 7:14 PM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Reporting MTTR in ITSM 7.6.4 from SRM? ** Hello all, I am looking for a way to report MTTR of incidents with excluding the time for which it was in PENDING status. I think that that data is held some place on an SLA form/field, however, I cannot find it. This is because when you open the SLM Status details (from a closed incident) one of the fields displayed on the Related Service Targets from now says Completed Time (in this case just 21 minutes). However, on a open incident (that is in progress) it shows Time Until Due (in this case 165 hr and 49 min) So I am asking: One am I correct and this would give me the correct MTTR without time in pending? Two anyone have an idea where this form/field is? As always thanks, Howard [Description: Description: Description: Cox Enterprises, Inc]http://www.coxenterprises.com/ Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = howard.rich...@coxinc.commailto:howard.rich...@coxinc.com Office = 678.645.4633, Cell = 404.226.2745 Cox Innovation Agent (CIA) [Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/BadgeA-Md.png][Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge20-Md.png]http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge20-Lg.png[Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge50-Md.png]http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge50-Lg.png Submit your idea today for a chance to earn a badge and be entered into a monthly drawing for a $10 gift card. Submit your idea: http://innovation.coxenterprises.com/ideas View your badges: http://innovation.coxenterprises.com/ideas/SitePages/yourbadges.aspx _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 inline: image001.gifinline: image002.pnginline: image003.pnginline: image004.png
Re: CMDB 8.1 Status bug?
This hasn't impacted me yet, but I think BMC created a lot of this mess by having CMDB = Asset Management for so long and now splitting it out further. Based on what you've said, it will be interesting to me as well to see what happens with ADDM because we're discovering the location based on part of the hostname and sending that through ADDM's integration with Atrium. Either way, we come up with a lot of smart ways to track asset data on computer systems that we would like to pass through Atrium Integrator or whatever tool to eventually synchronize with our CIs even though it's technically Asset Management data. Fortunately we aren't using our CMDB heavily yet so it won't impact my organization like it has Jesus's, but it seems like it would be helpful for BMC to provide a migration path for things like this. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of RainingRemedy Sent: Friday, January 17, 2014 1:07 AM To: arslist@ARSLIST.ORG Subject: Re: CMDB 8.1 Status bug? Jesus, This is not considered a bug. The AssetLifeCycle status field has been effectively moved from the CMDB forms and placed on the AST:Attributes form. The Status field you see is just the leftover core field that is not being used. From what I've read, I don't think there is any plan to use that field in the future. Would be curious to see what BMC says about it. The whole point of the CMDB and Asset split was to separate the configuration(discovery) of CIs with the lifecycle managing (Asset Mgmt) of the CI. That is why they reconstructed all of the joins and now all the classes are joined with the AST:Attributes form. This is the form where all lifecycle managed attributes will be stored. These are typically non-discovered attributes like financial info, location info, status, etc. The CMDB forms are now in theory supposed to only be tracking what is discovered, or the configuration of a CI. The configuration may change several times during the lifecycle of the CI however, the actual lifecycle attributes can remain the same. This is the vision BMC had when they split the attributes up. Config data in one spot, lifecycle management data in another spot. As far as your current scenario is concerned, why do you need to use the status field as the trigger to promote the data into the production dataset? Would it be possible to bring in the data as you do now, allow the asset admins to modify the data as you stated, and then when they are finished the admins could set a custom attribute to Ready for Import for example? Then during the Identify and Merge job you could just set the Status field of these CIs to Constant In Inventory as stated in your process? Not sure if something like this would work in your case without knowing more info about your integration and process. Just trying to throw an idea out there as a work around. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/CMDB-8-1-Status-bug-tp7594610p7594641.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Oracle to MSSQL
AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage? Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I'm just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn't even have to be real current. Tommy Morris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Report from multiple forms
I need to run a report for all open tickets for the past 24 hours. This will include SRM requests, incidents, changes, work orders, and problem tickets. Is there a backend form that I could report off of or should I create a join for reporting for all of them? Trying not to do multiple reports if I can help from it. Thanks in advance for your suggestions! ~~~ Terri Lockwood ARS 7.6.03 ITSM 7.6.03 Midtier 7.6.04 Windows 2008 MS SQL 2008 R2 SP2 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Oracle to MSSQL
I would be shocked if you could get that information from them. I don't believe that anything they do requires them to find out from you what DB you are using. Any shop I am familiar with has made the decision based on the people they have to support a specific DB type. If you have MSSQL DBAs then why would you bring in Oracle? And vice versa. As for the size I would tell him that what is currently being used would be a good start. But also, how much has it grown over it's lifespan because it will keep growing unless you are one of the few shops that maintains good archival policies. Personally speaking I would go with Oracle, but that is only because I feel more comfortable in Oracle. And that is the only real justification I have for that decision. HTH, Brian Goralczyk On Fri, Jan 17, 2014 at 10:25 AM, Tommy Morris tommy.mor...@radioshack.comwrote: ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. “My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage?” Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I’m just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn’t even have to be real current. Tommy Morris _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: Oracle to MSSQL
My guess is that BMC could probably answwer the question regarding overall usage. I can tell you that MS SQL is widely used though (we use it here). Oracle v. MS SQL arguments are kind of like apple v. windows. Lots of emotion Have fun! On Fri, Jan 17, 2014 at 11:25 AM, Tommy Morris tommy.mor...@radioshack.comwrote: ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. “My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage?” Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I’m just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn’t even have to be real current. Tommy Morris _ARSlist: Where the Answers Are and have been for 20 years_ -- Warren R. Baltimore II Remedy Developer 410-533-5367 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Oracle to MSSQL
Oracle to SQL X .20 or add 20% for sizing ... Why? Clobs and Blobs are different in sizing. Speed -- well... Cough cough... ... hopefully you are not leveraging your cluster.. --- hope that helps some. I am doing the same right now.. sniff sniff On Fri, Jan 17, 2014 at 11:25 AM, Tommy Morris tommy.mor...@radioshack.comwrote: ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. “My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage?” Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I’m just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn’t even have to be real current. Tommy Morris _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: CMDB 8.1 Status bug?
There is a defect open for this : SW00462392, but BMC considers this a RFE. Thank you for the information about what they did. It makes it a bit more clear about they did it, but it still does not help me sell the upgrade. The is more to it than just the process itself. This change impacts a large number of Business objects reports and will require that we evaluate whether the latest version's universe, 7.6.6., takes into account the new structure. We are forced to upgrade that application and to rewrite report. So, our upgrade path has gotten more complicated than we anticipated. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of RainingRemedy Sent: Friday, January 17, 2014 1:07 AM To: arslist@ARSLIST.ORG Subject: Re: CMDB 8.1 Status bug? Jesus, This is not considered a bug. The AssetLifeCycle status field has been effectively moved from the CMDB forms and placed on the AST:Attributes form. The Status field you see is just the leftover core field that is not being used. From what I've read, I don't think there is any plan to use that field in the future. Would be curious to see what BMC says about it. The whole point of the CMDB and Asset split was to separate the configuration(discovery) of CIs with the lifecycle managing (Asset Mgmt) of the CI. That is why they reconstructed all of the joins and now all the classes are joined with the AST:Attributes form. This is the form where all lifecycle managed attributes will be stored. These are typically non-discovered attributes like financial info, location info, status, etc. The CMDB forms are now in theory supposed to only be tracking what is discovered, or the configuration of a CI. The configuration may change several times during the lifecycle of the CI however, the actual lifecycle attributes can remain the same. This is the vision BMC had when they split the attributes up. Config data in one spot, lifecycle management data in another spot. As far as your current scenario is concerned, why do you need to use the status field as the trigger to promote the data into the production dataset? Would it be possible to bring in the data as you do now, allow the asset admins to modify the data as you stated, and then when they are finished the admins could set a custom attribute to Ready for Import for example? Then during the Identify and Merge job you could just set the Status field of these CIs to Constant In Inventory as stated in your process? Not sure if something like this would work in your case without knowing more info about your integration and process. Just trying to throw an idea out there as a work around. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/CMDB-8-1-Status-bug-tp7594610p7594641.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years Information contained in this email is subject to the disclaimer found by clicking on the following link: http://www.lyondellbasell.com/Footer/Disclaimer/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Oracle to MSSQL
Tommy, BMC has customers on both Oracle and MS SQL in significant numbers. UNAUDITED but from what we see, the most used database is MS SQL (maybe 60% and then Oracle in the say 30% or a bit more range and others in the less than 10%). Smaller customers are much higher on the MS SQL side. Enterprise customers tend to be more heavily on the Oracle side. The Remedy On Demand (the SaaS offering) system runs on MS SQL for all customers. The capabilities of the database are in the same ballpark - the 8.1 release of the AR System and the final completion of the work by Oracle has solved the case insensitive difference and Oracle finally has full case insensitivity option like SQL Server has had for years which closes the main functional difference between the databases. In general, decisions are made based on in house expertise with a database - a lot based on what other products they are using use as the database. Hardware things are on is an issue of course given that MS SQL runs only on Windows. Either database will do a good job for you. BMC has large customers on both databases with large data volumes (millions of records) and large number of users (thousands of concurrent users). I hope this is useful, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tommy Morris Sent: Friday, January 17, 2014 8:25 AM To: arslist@ARSLIST.ORG Subject: Oracle to MSSQL ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage? Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I'm just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn't even have to be real current. Tommy Morris _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
Why do service requests require a Login ID?
Hi Guys, We have a customer who has a few managers that use the SRM Request portal to submit/view requests and also view tickets raised by other users via the Busniess manager console. Not all of this customers users have login Ids for Remedy. 90% submit calls via phone and only a select few access Remedy via the SRM portal. So 90% have people profiles but no User profile/Login ID. When the Create Service Request on Submit rule is enabled and an Incident/Change is created for a person that does not have a Login ID you get the warning Login ID is missing for the registered user. An incident will be created but the request will not be created because Login ID is required. (ARWARN 45459) Question is: why does the Service Request need a Login ID? Surely any relationship to a person should be done via the People ID. Has anyone came accross this before or have any solutons? Thanks Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Oracle to MSSQL
Thanks to everyone. I think that I have enough to send to the DBA's. Good info here and I also received some info from our Remedy support partner. All this should help. Gotta love ARSList! From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Friday, January 17, 2014 10:52 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle to MSSQL ** Tommy, BMC has customers on both Oracle and MS SQL in significant numbers. UNAUDITED but from what we see, the most used database is MS SQL (maybe 60% and then Oracle in the say 30% or a bit more range and others in the less than 10%). Smaller customers are much higher on the MS SQL side. Enterprise customers tend to be more heavily on the Oracle side. The Remedy On Demand (the SaaS offering) system runs on MS SQL for all customers. The capabilities of the database are in the same ballpark - the 8.1 release of the AR System and the final completion of the work by Oracle has solved the case insensitive difference and Oracle finally has full case insensitivity option like SQL Server has had for years which closes the main functional difference between the databases. In general, decisions are made based on in house expertise with a database - a lot based on what other products they are using use as the database. Hardware things are on is an issue of course given that MS SQL runs only on Windows. Either database will do a good job for you. BMC has large customers on both databases with large data volumes (millions of records) and large number of users (thousands of concurrent users). I hope this is useful, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tommy Morris Sent: Friday, January 17, 2014 8:25 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Oracle to MSSQL ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage? Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I'm just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn't even have to be real current. Tommy Morris _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: [EXTERNAL] Report from multiple forms
Terry: Do you have Analytics? If so, you'd have to create separate queries for each module, and it would be easier if you created separate tabs for each module, but you could generate a single report document that pulls all of that. Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terri Lockwood Sent: Friday, January 17, 2014 9:28 AM To: arslist@ARSLIST.ORG Subject: [EXTERNAL] Report from multiple forms ** I need to run a report for all open tickets for the past 24 hours. This will include SRM requests, incidents, changes, work orders, and problem tickets. Is there a backend form that I could report off of or should I create a join for reporting for all of them? Trying not to do multiple reports if I can help from it. Thanks in advance for your suggestions! ~~~ Terri Lockwood ARS 7.6.03 ITSM 7.6.03 Midtier 7.6.04 Windows 2008 MS SQL 2008 R2 SP2 _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: Oracle to MSSQL
Fred, The 8.1 release of the AR System requires Oracle 11g. So, 11g and later has everything. Now, Oracle has been doing things for years and closing in on this issue. They have added partial support and some conditions. But, until now, we have not had success with finding all the right settings and configuration and options to make the capability completely work. There are special indexes to build (we do that for you for all new indexes and you have to do a cleanup script to convert any existing indexes to the new type) for indexed searches to work and with the right settings of options all other comparison operations work. Doug From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, January 17, 2014 9:16 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle to MSSQL ** Doug, When you say final completion of the work by Oracle has solved the case insensitive difference, which Oracle version/patch level are you referring to (so I know what version we need to get Oracle up to)? Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Friday, January 17, 2014 10:52 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Oracle to MSSQL ** Tommy, BMC has customers on both Oracle and MS SQL in significant numbers. UNAUDITED but from what we see, the most used database is MS SQL (maybe 60% and then Oracle in the say 30% or a bit more range and others in the less than 10%). Smaller customers are much higher on the MS SQL side. Enterprise customers tend to be more heavily on the Oracle side. The Remedy On Demand (the SaaS offering) system runs on MS SQL for all customers. The capabilities of the database are in the same ballpark - the 8.1 release of the AR System and the final completion of the work by Oracle has solved the case insensitive difference and Oracle finally has full case insensitivity option like SQL Server has had for years which closes the main functional difference between the databases. In general, decisions are made based on in house expertise with a database - a lot based on what other products they are using use as the database. Hardware things are on is an issue of course given that MS SQL runs only on Windows. Either database will do a good job for you. BMC has large customers on both databases with large data volumes (millions of records) and large number of users (thousands of concurrent users). I hope this is useful, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tommy Morris Sent: Friday, January 17, 2014 8:25 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Oracle to MSSQL ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage? Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I'm just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn't even have to be real current. Tommy Morris _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
BMC Support would like feed back on the Support KB
Thought I would share this here. Jesse from Support has asked for feedback on how they can make their KB better (not RKM). He started a discussion specific to AR System here: How can we make the ARSystem knowledge base better?https://communities.bmc.com/message/390122#390122 Which is a offshoot of: How can we make the knowledge base better?https://communities.bmc.com/message/390118#390118 Let yourself be heard... Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Oracle to MSSQL
There are special indexes to build (we do that for you for all new indexes and you have to do a cleanup script to convert any existing indexes to the new type) for indexed searches to work and with the right settings of options all other comparison operations work. Do I request those scripts from BMC or is in the docs and installation package already? On Fri, Jan 17, 2014 at 12:19 PM, Mueller, Doug doug_muel...@bmc.comwrote: ** Fred, The 8.1 release of the AR System requires Oracle 11g. So, 11g and later has everything. Now, Oracle has been doing things for years and closing in on this issue. They have added partial support and some conditions. But, until now, we have not had success with finding all the right settings and configuration and options to make the capability completely work. There are special indexes to build (we do that for you for all new indexes and you have to do a cleanup script to convert any existing indexes to the new type) for indexed searches to work and with the right settings of options all other comparison operations work. Doug *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W *Sent:* Friday, January 17, 2014 9:16 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Oracle to MSSQL ** Doug, When you say “final completion of the work by Oracle has solved the case insensitive difference”, which Oracle version/patch level are you referring to (so I know what version we need to get Oracle up to)? Fred *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Mueller, Doug *Sent:* Friday, January 17, 2014 10:52 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Oracle to MSSQL ** Tommy, BMC has customers on both Oracle and MS SQL in significant numbers. UNAUDITED but from what we see, the most used database is MS SQL (maybe 60% and then Oracle in the say 30% or a bit more range and others in the less than 10%). Smaller customers are much higher on the MS SQL side. Enterprise customers tend to be more heavily on the Oracle side. The Remedy On Demand (the SaaS offering) system runs on MS SQL for all customers. The capabilities of the database are in the same ballpark – the 8.1 release of the AR System and the final completion of the work by Oracle has solved the case insensitive difference and Oracle finally has full case insensitivity option like SQL Server has had for years which closes the main functional difference between the databases. In general, decisions are made based on in house expertise with a database – a lot based on what other products they are using use as the database. Hardware things are on is an issue of course given that MS SQL runs only on Windows. Either database will do a good job for you. BMC has large customers on both databases with large data volumes (millions of records) and large number of users (thousands of concurrent users). I hope this is useful, Doug Mueller *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Tommy Morris *Sent:* Friday, January 17, 2014 8:25 AM *To:* arslist@ARSLIST.ORG *Subject:* Oracle to MSSQL ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. “My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage?” Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I’m just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn’t even have to be real current. Tommy Morris _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Oracle to MSSQL
Doug, This is awesome!! Thank you for sharing this! You have no idea how happy some of my users will be!I have already asked my DBA to look into the Oracle version we are on and the possibility of doing an upgrade! ITSM 7.6.04 SP2 ARS 7.6.04 SP3 Oracle 11.2.0.3.0 - 64bit Production Win 2008 Server Claire Sanford Information Systems Division Memorial Hermann Healthcare System claire.sanf...@memorialhermann.org From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Friday, January 17, 2014 10:52 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle to MSSQL ** Tommy, BMC has customers on both Oracle and MS SQL in significant numbers. UNAUDITED but from what we see, the most used database is MS SQL (maybe 60% and then Oracle in the say 30% or a bit more range and others in the less than 10%). Smaller customers are much higher on the MS SQL side. Enterprise customers tend to be more heavily on the Oracle side. The Remedy On Demand (the SaaS offering) system runs on MS SQL for all customers. The capabilities of the database are in the same ballpark - the 8.1 release of the AR System and the final completion of the work by Oracle has solved the case insensitive difference and Oracle finally has full case insensitivity option like SQL Server has had for years which closes the main functional difference between the databases. In general, decisions are made based on in house expertise with a database - a lot based on what other products they are using use as the database. Hardware things are on is an issue of course given that MS SQL runs only on Windows. Either database will do a good job for you. BMC has large customers on both databases with large data volumes (millions of records) and large number of users (thousands of concurrent users). I hope this is useful, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tommy Morris Sent: Friday, January 17, 2014 8:25 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Oracle to MSSQL ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage? Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I'm just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn't even have to be real current. Tommy Morris _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Report from multiple forms
I would look at the form the Overview uses in the main table Sent from my iPhone On Jan 17, 2014, at 11:28 AM, Terri Lockwood teresa.lockw...@sungard.com wrote: ** I need to run a report for all open tickets for the past 24 hours. This will include SRM requests, incidents, changes, work orders, and problem tickets. Is there a backend form that I could report off of or should I create a join for reporting for all of them? Trying not to do multiple reports if I can help from it. Thanks in advance for your suggestions! ~~~ Terri Lockwood ARS 7.6.03 ITSM 7.6.03 Midtier 7.6.04 Windows 2008 MS SQL 2008 R2 SP2 _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: Oracle to MSSQL
Completely unscientific but it seems I have noticed more people asking about moving from Oracle to SQL Server in recent years. A trend? Jason On Fri, Jan 17, 2014 at 8:41 AM, patrick zandi remedy...@gmail.com wrote: ** Oracle to SQL X .20 or add 20% for sizing ... Why? Clobs and Blobs are different in sizing. Speed -- well... Cough cough... ... hopefully you are not leveraging your cluster.. --- hope that helps some. I am doing the same right now.. sniff sniff On Fri, Jan 17, 2014 at 11:25 AM, Tommy Morris tommy.mor...@radioshack.com wrote: ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. “My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage?” Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I’m just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn’t even have to be real current. Tommy Morris _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi _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: Why do service requests require a Login ID?
I don't have the answer to your question however we moved from only IT and certain business users having User records (our older system) to all employees and affiliates having User records so SRM can be used by everybody. To us it just made sense that we want them authenticated so we added them. This solves issues we have always have had with trying to work with unauthenticated users (having to ask them their username, employee ID, etc.). Jason On Fri, Jan 17, 2014 at 9:12 AM, SUBSCRIBE ARSLIST theReel tony.r...@bt.com wrote: Hi Guys, We have a customer who has a few managers that use the SRM Request portal to submit/view requests and also view tickets raised by other users via the Busniess manager console. Not all of this customers users have login Ids for Remedy. 90% submit calls via phone and only a select few access Remedy via the SRM portal. So 90% have people profiles but no User profile/Login ID. When the Create Service Request on Submit rule is enabled and an Incident/Change is created for a person that does not have a Login ID you get the warning Login ID is missing for the registered user. An incident will be created but the request will not be created because Login ID is required. (ARWARN 45459) Question is: why does the Service Request need a Login ID? Surely any relationship to a person should be done via the People ID. Has anyone came accross this before or have any solutons? Thanks Tony ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Oracle to MSSQL
cost:: that is all... for us. IMHO now sure how scientific that is.. 8-) On Fri, Jan 17, 2014 at 12:57 PM, Jason Miller jason.mil...@gmail.comwrote: ** Completely unscientific but it seems I have noticed more people asking about moving from Oracle to SQL Server in recent years. A trend? Jason On Fri, Jan 17, 2014 at 8:41 AM, patrick zandi remedy...@gmail.comwrote: ** Oracle to SQL X .20 or add 20% for sizing ... Why? Clobs and Blobs are different in sizing. Speed -- well... Cough cough... ... hopefully you are not leveraging your cluster.. --- hope that helps some. I am doing the same right now.. sniff sniff On Fri, Jan 17, 2014 at 11:25 AM, Tommy Morris tommy.mor...@radioshack.com wrote: ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. “My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage?” Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I’m just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn’t even have to be real current. Tommy Morris _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Oracle to MSSQL (really now is Oracle case insensitivity in 8.1 and later)
Patrick, Here is a KB article on the subject that includes a discussion configuration and a reference to the cleanup script for the indexes. https://kb.bmc.com/infocenter/index?page=contentid=KA406947 Oh, and Fred I notice you need the 11.2 Oracle clients not just 11g. (see what reading the actual details of the docs points out) And finally, yes, it talks about cursor sharing EXACT and the recommendation is for cursor sharing FORCE... YES, this is a conflict. FORCE is a better cursor sharing mode for AR System and that is still true. HOWEVER, if you set the sharing to FORCE, case insensitivity really doesn't work correctly. It does with cursor sharing set to EXACT. So, to get full and complete and always cursor sharing, I strongly recommend that you use EXACT as the cursor sharing. This does mean that you need to deal with the performance impact on the system that using EXACT vs. FORCE generates. This can be mitigated to a reasonable degree by giving your DB more memory. NOTE that is the DB not AR System. Giving the DB more memory for its working space helps overcome the performance penalty of the EXACT mode vs. the FORCE mode. NOTE: Full support is in the 8.1 and later releases of the AR System (you don't need 8.1 apps, just 8.1 AR System). NOTE: Before 8.1, if you have the right DB, and all the right settings (you can override things using triggers or the ardb.conf file, and you build all the indexes right and do all the maintenance of them (since we don't do that until 8.1), you may be able to get this to work. Best to upgrade to 8.1 server as it is a lot of hassle and work to do it all yourself. I hope this is useful, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Friday, January 17, 2014 9:40 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle to MSSQL ** There are special indexes to build (we do that for you for all new indexes and you have to do a cleanup script to convert any existing indexes to the new type) for indexed searches to work and with the right settings of options all other comparison operations work. Do I request those scripts from BMC or is in the docs and installation package already? On Fri, Jan 17, 2014 at 12:19 PM, Mueller, Doug doug_muel...@bmc.commailto:doug_muel...@bmc.com wrote: ** Fred, The 8.1 release of the AR System requires Oracle 11g. So, 11g and later has everything. Now, Oracle has been doing things for years and closing in on this issue. They have added partial support and some conditions. But, until now, we have not had success with finding all the right settings and configuration and options to make the capability completely work. There are special indexes to build (we do that for you for all new indexes and you have to do a cleanup script to convert any existing indexes to the new type) for indexed searches to work and with the right settings of options all other comparison operations work. Doug From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Friday, January 17, 2014 9:16 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Oracle to MSSQL ** Doug, When you say final completion of the work by Oracle has solved the case insensitive difference, which Oracle version/patch level are you referring to (so I know what version we need to get Oracle up to)? Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Friday, January 17, 2014 10:52 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Oracle to MSSQL ** Tommy, BMC has customers on both Oracle and MS SQL in significant numbers. UNAUDITED but from what we see, the most used database is MS SQL (maybe 60% and then Oracle in the say 30% or a bit more range and others in the less than 10%). Smaller customers are much higher on the MS SQL side. Enterprise customers tend to be more heavily on the Oracle side. The Remedy On Demand (the SaaS offering) system runs on MS SQL for all customers. The capabilities of the database are in the same ballpark - the 8.1 release of the AR System and the final completion of the work by Oracle has solved the case insensitive difference and Oracle finally has full case insensitivity option like SQL Server has had for years which closes the main functional difference between the databases. In general, decisions are made based on in house expertise with a database - a lot based on what other products they are using use as the database. Hardware things are on is an issue of course given that MS SQL runs only on Windows. Either database will do a good job for you. BMC has large customers on both databases with large data volumes (millions of records) and large number of users (thousands of concurrent users). I hope this is useful,
Re: CMDB 8.1 Status bug?
Isn't this the nature of software? Software changes. Hopefully over all for the better but often better isn't better for everybody. Remember when MS introduced the ribbon? That worked well for some and not very well for those that were depending on the old menu style. Every software company faces these challenges. If BMC didn't try to improve their products then they would lose market share and go out of business. Do these improvements work well for everybody? No. That doesn't mean it isn't the right thing to do. Managing IT is complex and IT professionals can be very creative when finding solutions (on that note I find many IT people are musicians, artists, etc.). BMC (or any software vendor) cannot make and maintain a product that works for everybody 100% of the time; especially a flexible product. BMC CMDB and Asset being implemented as more or less the same thing as Shawn noted might be considered a mistake. The BMC CMDB has come a long way since v1 and BMC was very active in making it a common IT tool. They had to make choices when starting out. Some of them in hindsight they probably wish they went a different direction. At the end of the day they needed to draw some lines and ship a product. This recent change around life cycle data addresses an issue with the original implementation of some attributes. Do I think there are times when BMC could be more helpful in making successful transitions? Absolutely! Just like our organizations they have resource and time limitations that impact the feasibility how much help they can provide; how gentle and forgiving a technology transition can be. There comes a point where you just need to let the fallout happen and deal with it on a case by case basis. If we waited for everything to be perfect all the time nothing would ever move forward. Ok, that turned out a bit longer than I thought it would... By no means do I want to minimize the impact to your organization. This change has obviously presented challenges that your organization and any organization would rather not have to deal with to keep on a current version. Jason On Fri, Jan 17, 2014 at 8:38 AM, Ortega, Jesus A Jesus.Ortega@ lyondellbasell.com wrote: There is a defect open for this : SW00462392, but BMC considers this a RFE. Thank you for the information about what they did. It makes it a bit more clear about they did it, but it still does not help me sell the upgrade. The is more to it than just the process itself. This change impacts a large number of Business objects reports and will require that we evaluate whether the latest version's universe, 7.6.6., takes into account the new structure. We are forced to upgrade that application and to rewrite report. So, our upgrade path has gotten more complicated than we anticipated. -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of RainingRemedy Sent: Friday, January 17, 2014 1:07 AM To: arslist@ARSLIST.ORG Subject: Re: CMDB 8.1 Status bug? Jesus, This is not considered a bug. The AssetLifeCycle status field has been effectively moved from the CMDB forms and placed on the AST:Attributes form. The Status field you see is just the leftover core field that is not being used. From what I've read, I don't think there is any plan to use that field in the future. Would be curious to see what BMC says about it. The whole point of the CMDB and Asset split was to separate the configuration(discovery) of CIs with the lifecycle managing (Asset Mgmt) of the CI. That is why they reconstructed all of the joins and now all the classes are joined with the AST:Attributes form. This is the form where all lifecycle managed attributes will be stored. These are typically non-discovered attributes like financial info, location info, status, etc. The CMDB forms are now in theory supposed to only be tracking what is discovered, or the configuration of a CI. The configuration may change several times during the lifecycle of the CI however, the actual lifecycle attributes can remain the same. This is the vision BMC had when they split the attributes up. Config data in one spot, lifecycle management data in another spot. As far as your current scenario is concerned, why do you need to use the status field as the trigger to promote the data into the production dataset? Would it be possible to bring in the data as you do now, allow the asset admins to modify the data as you stated, and then when they are finished the admins could set a custom attribute to Ready for Import for example? Then during the Identify and Merge job you could just set the Status field of these CIs to Constant In Inventory as stated in your process? Not sure if something like this would work in your case without knowing more info about your integration and process. Just trying to throw an idea out there as a work around. -- View this message
Re: [EXTERNAL] Reporting MTTR in ITSM 7.6.4 from SRM?
All, I think that the field I was looking for is called UpTimeChar on the incident is closed. I think that this will only show the total time the incident was worked, minus pending, holiday schedule and non-working hours. However, that I need to verify. With that said have a great weekend, Howard From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Stroud, Natalie K Sent: Friday, January 17, 2014 10:39 AM To: arslist@ARSLIST.ORG Subject: Re: [arslist] [EXTERNAL] Reporting MTTR in ITSM 7.6.4 from SRM? ** Howard: I can tell you that we measure MTTR using the Business Hours Duration field from the Assignment Log form. But I can't tell you whether that value gets calculated excluding the time spent in Pending status or not. And you have to be a little careful with it, at least if you build your reports in Analytics. If you bring in any element with a many-to-one relationship to the ticket (such as Work Info or both resolution and response targets from SLM), it can end up incorrectly doubling the value for MTTR in your report. Dunno if that helps you or not... Most of the data in the SLM portion of the incident ticket comes from SLM:Measurement. If what you are looking for exists specifically within SLM, it's probably in there somewhere. Natalie Stroud SAIC @ Sandia National Laboratories ARS-ITSM Reporting Specialist Albuquerque, NM USA nkst...@sandia.govmailto:nkst...@sandia.gov ITSM 7.6.04 SP2 - Windows 2003 - SQL Server 2008 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Richter, Howard (CEI - Atlanta) Sent: Thursday, January 16, 2014 7:14 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: [EXTERNAL] Reporting MTTR in ITSM 7.6.4 from SRM? ** Hello all, I am looking for a way to report MTTR of incidents with excluding the time for which it was in PENDING status. I think that that data is held some place on an SLA form/field, however, I cannot find it. This is because when you open the SLM Status details (from a closed incident) one of the fields displayed on the Related Service Targets from now says Completed Time (in this case just 21 minutes). However, on a open incident (that is in progress) it shows Time Until Due (in this case 165 hr and 49 min) So I am asking: One am I correct and this would give me the correct MTTR without time in pending? Two anyone have an idea where this form/field is? As always thanks, Howard [Description: Description: Description: Cox Enterprises, Inc]http://www.coxenterprises.com/ Howard Richter, Remedy Administrator 6205 Peachtree Dunwoody Road, Atlanta, GA 30328-4524 Email = howard.rich...@coxinc.commailto:howard.rich...@coxinc.com Office = 678.645.4633, Cell = 404.226.2745 Cox Innovation Agent (CIA) [Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/BadgeA-Md.png][Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge20-Md.png]http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge20-Lg.png[Description: Description: http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge50-Md.png]http://innovation.coxenterprises.com/ideas/Badge%20Library/Badge50-Lg.png Submit your idea today for a chance to earn a badge and be entered into a monthly drawing for a $10 gift card. Submit your idea: http://innovation.coxenterprises.com/ideas View your badges: http://innovation.coxenterprises.com/ideas/SitePages/yourbadges.aspx _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: Where the Answers Are and have been for 20 years_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years inline: image001.gifinline: image002.pnginline: image003.pnginline: image004.png
Re: Incident SLM Data
** Because the current status isn't really an important value to the service target, it is not stored on the SLM:Measurement form. They way I've gotten around this in the past is to either create a reporting join or an actual Remedy join form. You can do all kinds of interesting reporting if you have a join between HPD:HelpDesk and SLM:Measurement :) Kelly DeaverUnisys Corporation kdea...@kellydeaver.com (ARSlist mail)kelly.dea...@unisys.com(Business mail) Original Message Subject: Incident SLM DataFrom: Josh S remedyd...@gmail.comDate: Wed, January 08, 2014 11:15 amTo: arslist@ARSLIST.ORGHey everyone,I have a multitendency 7.1 system. My requirement is to pull all the SLM Data for only a certain company's Incident tickets that are not closed,resolved or cancelled. You have been kind enough to help me find the SLM Data on the SLM:Measurement form.Getting a certain company on the SLM:Measurement form is not hard as the title houses the company name for us. But I cannot figure out how to pull SLM:Measurement data for ONLY not closed, resolved or cancelled Incident tickets. I hope my explanation makes sense. Any ideas?Thank you!___UNSUBSCRIBE or access ARSlist Archives at www.arslist.org"Where the Answers Are, and have been for 20 years" _ARSlist: "Where the Answers Are" and have been for 20 years_
Re: arsignal - mystery flag
I don't have an answer but if you ask about it on the wiki page the IDD team should research and update the documentation. Jason On Jan 17, 2014 7:17 AM, Warren R. Baltimore II warrenbaltim...@gmail.com wrote: ** I've been troubleshooting a problem with my server group. Along the way, I noticed in the arsignal log that the following was being issued fairly regularly: arsignal *-z* [SERVERNAME]:[PORT] [RANDOMUSERNAME]:258999161|, Q-size=0 When I pulled the documentation on arsignal though, there is no flag listed as -z. Anybody have an idea of what is going on here? -- Warren R. Baltimore II Remedy Developer 410-533-5367 _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