Time Criteria in Exclude When in Service Targets - not working properly
Hi, Has anyone tried using a time criteria in the Exclude When parameter of Service Targets? We've created Service Targets wherein the Exclude When is defined as: 'Status' = Pending AND 'date/time field in INC form' $\TIMESTAMP$ It works initially wherein when it satisfies the condition, the Service Target is put on hold. However, if you don't modify anything in the ticket and you go past the value of the date/time field, it doesn't put the Service Target back to In Progress. You have to modify something in the ticket first and save it before it would start counting again. Has anyone been able to make this work? Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Kinetic Request at WalMart
o Does KR support SSO? Yes! SSO Plugin can be deployed providing the same high quality solution as currently available for BMC AR System. John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Count of records
Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Midtier querie
Hi All, I am looking for midtier gloabl login implementation .we are not using LDAP server to verify the userid and passwords we are planning to implement in Security Platform it provides authentication (i.e., logon) services for UserID holders and other user domains. Security Platform uses a single sign-on approach. we are using ITSM 7.1 version Basically I am looking for some solution like if a user is logging in using Mid tier he should be logged in automatically if his user credentials are present in the Security Platform. Does anybody have any idea about this, or anybody has tried this before. Thanks in advance . ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
ARWARN 469
I get the message ARWARN (469) when I add a temporal license server (until 30-jun-12) and it doesn't work. After this message appears the next message of BMC saying that everyting is ok but it's not so. The server goes on without license server. Why? What can I do to solve this? The version is 7.6.04. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Count of records
Meta-Update has a sample that runs through arschema and builds a CSV of pertinent details plus a record count. Meta-Query allows you ARS and SQL queries without a database client. A trial license is free and includes this and other samples. You would have your counts after a few minutes of our Live Install WebEx session. Arschema does not give a count of rows. It does give the next available '1' field value but that cannot be used as it will not take deletions and uncreated records into account. You can build a View form on arschema and populate an extra DO field on a Get filter with the count. Cheers Ben Chernys Senior Software Architect Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor and out Freebies Section for an ITSM 7.6.04 Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of remedyarl...@gmail.com Sent: April-26-12 11:58 To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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: ARWARN 469
You should address any license issues directly with BMC Software or your partner. ~ Terje From the error guide: 469 Warning Warning, this key is not valid for this server. This warning indicates that the entered key is not valid for the AR System server on which it was entered. If the server is in a server group, the key might be valid for one of the other servers in the group. In that case, ignore the warning. If this warning appears on a single server, a problem exists with the license entry. Check the fields of the key for leading or trailing spaces, and make sure that the correct Host ID was used when the key was generated. From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of to Ramón [rzara...@pas.ucm.es] Sent: 26 April 2012 11:13 To: arslist@ARSLIST.ORG Subject: ARWARN 469 I get the message ARWARN (469) when I add a temporal license server (until 30-jun-12) and it doesn't work. After this message appears the next message of BMC saying that everyting is ok but it's not so. The server goes on without license server. Why? What can I do to solve this? The version is 7.6.04. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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: remedy license
Thank you for the information. Contacted BMC rep. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: ARWARN 469
Copy and paste will often add a space on the end. I often paste to a text editor to make sure to check for a trailing space and if there is one will copy from the text editor to eliminate it. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Terje Moglestue Sent: Thursday, April 26, 2012 6:50 AM To: arslist@ARSLIST.ORG Subject: Re: ARWARN 469 You should address any license issues directly with BMC Software or your partner. ~ Terje From the error guide: 469 Warning Warning, this key is not valid for this server. This warning indicates that the entered key is not valid for the AR System server on which it was entered. If the server is in a server group, the key might be valid for one of the other servers in the group. In that case, ignore the warning. If this warning appears on a single server, a problem exists with the license entry. Check the fields of the key for leading or trailing spaces, and make sure that the correct Host ID was used when the key was generated. From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] On Behalf Of to Ramón [rzara...@pas.ucm.es] Sent: 26 April 2012 11:13 To: arslist@ARSLIST.ORG Subject: ARWARN 469 I get the message ARWARN (469) when I add a temporal license server (until 30-jun-12) and it doesn't work. After this message appears the next message of BMC saying that everyting is ok but it's not so. The server goes on without license server. Why? What can I do to solve this? The version is 7.6.04. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Count of records
You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Count of records
You can check with the DBA. Usually they will have some stored procedures available already which can give you the table ID and the no. of records across remedy schema. On Thursday, April 26, 2012 4:57:46 AM UTC-5, remedy...@gmail.com wrote: Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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: Def-export of Packing Lists missing objects...
Well...I'm referring specifically to the getContainer call (I use Java) off of the ARServerUser object, and then do a print of that object structure. I'm asking because we are on 7.6.4 SP1, upgrading to SP3 shortly in production. We use packing lists extensively to determine the code that needs to be moved to prod from Dev...but we don't use the Dev studio to export our code, we use a custom app I have written that walks the contents of the packing list and exports each object to its own def file and I've never experienced the situation that you are discussing, but mainly because I don't ask my ARServerUser object to export the entire PL, but instead, a separate export for each object within it...so I'm looking to see if you can identify within the PL Object on the server if each object is 'defined properly'basically...see if you can figure out what's causing the objects that aren't showing up in your def to not show up. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, April 25, 2012 2:29 PM To: arslist@ARSLIST.ORG Subject: Re: Def-export of Packing Lists missing objects... Hi, Do you mean using ARExport() or ARGetContainer()? Why would that differ? The def-file is pretty much an ARExport()-call... Best Regards - Misi, RRR AB, http://rrr.se If you connect to your server via your favorite api language, and output the contents of the containerare all of the references to your workflow there appropriately? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, April 25, 2012 10:22 AM To: arslist@ARSLIST.ORG Subject: Re: Def-export of Packing Lists missing objects... Hi, I have only looked at the PL in the DEF-file. The filters had not change between my exports, the only thing I did was to remove and readd on object. Best Regards - Misi, RRR AB, http://rrr.se You have obviously looked at the PL through the API to be able to find the differences. Have you compared the filters in question having the problem with those that aren't and see if you see ANY difference? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, April 25, 2012 9:43 AM To: arslist@ARSLIST.ORG Subject: Re: Def-export of Packing Lists missing objects... Hi, Exporting as XML changed nothing. I added the objects by right-clicking on the packing list and choosing edit. After that I press the Add... button. I removed, saved, closed, reopened and readded a problematic object. This resulted in 65 exported objects instead of the 63 I had before the change... The ONLY difference if I look at the exported container-definition (packing-list-definition), is that one of the references changed position in the list. Everything els is the same. Very strange! Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * 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. Misi, I'm keenly interested in this problem. Do you have this problem if you export the objects in XML Def instead of regular Def? How were these objects added to the PL...if you remove one of the 'missing' ones, save, then re-add it, is it still missing? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, April 25, 2012 1:55 AM To: arslist@ARSLIST.ORG Subject: Re: Def-export of Packing Lists missing objects... Hi Guillaume, I tried your suggestion, and both when I set 'Add Items With Related Property' to Content and Directly Related Objects, I still get the same result... 20 missing filters and 1 missing filter-guide in the DEF, with a total of 83 objects in the packing-list: $ perl rrrVerPackList.pl RRR-VENDOR-EMAIL-v6.def Missing objects in PACKING LIST ### NOT IN PACK 3/RRR-VENDOR-EMAIL Missing objects in DEF FILE ### NOT IN DEF container/NTE:NPC:TranslateNTMessages NOT IN DEF filter/HPD:INC:NTVendorAssignment_860_Chk NOT IN DEF filter/HPD:INC:NTVendorAssignment_861_SetTag NOT IN DEF filter/NTE:NPC:ChkNotificationMsgExist_015 NOT IN DEF filter/NTE:NPC:CreateNTS_NoBusTime_590_PNTS`! NOT IN DEF filter/NTE:NPC:GetNotificationMessage_231 NOT IN DEF filter/NTE:NPC:GetNotificationMessage_232 NOT IN DEF filter/NTE:NPC:GetNotificationMessage_233 NOT IN DEF filter/NTE:NPC:GetNotificationMessage_554 NOT IN DEF filter/NTE:NPC:GetNotificationMessage_556 NOT IN DEF
Re: Count of records
ARUtilities works great for that! On Thu, Apr 26, 2012 at 9:19 AM, patchsk vamsi...@gmail.com wrote: ** You can check with the DBA. Usually they will have some stored procedures available already which can give you the table ID and the no. of records across remedy schema. On Thursday, April 26, 2012 4:57:46 AM UTC-5, remedy...@gmail.com wrote: Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone __**__**___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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
Rack and Enclosure modeling in CMDB 2.1
Hello all, I am looking for some experience/advice: We are looking at modeling our computer centers in Atrium CMDB 2.1 (w/ ARS ITSM 7.6.4), including the racks and enclosures. I am looking at several concepts right now to model this data and would be interested in any strategies others have found to be useful in their environments. What I am looking to determine now is not only how to model the data itself, but what processes will be automatically provided, and what processes I will have to customize/create in order to help Infrastructure do their job. Here's what I am thinking of right now (in broad terms): 1. Extend the BMC_Equipment class to create PQ_Rack and PQ_Enclosure classes, perhaps with AU (slot) classes as well. 2. Utilize BMC_PhysicalLocation to represent object locations (Rack 3-5, AU slot 2) and use custom reports to track overall locations. 3. Extend the current BMC_Rack and BMC_Chassis to add necessary attributes. 4. Federate the location (rack, enclosure) data into a custom Nlyte-like application. If there is a way to utilize the Common Data Model without customization, that would be my preference. Note that the Racks and Enclosures do not simply hold blades, they also hold network modules/patch panels, SANs, power, etc; each of these may also take up more than one slot per. By processes, I mean that Infrastructure will want to be able to quickly tell from an asset name, where it is precisely (site, grid location, rack and enclosure slot). Or, given a two slot asset, where they can plug it in (display the racks where two consecutive slots are available, or at least show the open slots in a fashion that it is easy to see where two consecutive ones are). For example, if I follow strategy 1. and create PQ_Rack and PQ_Enclosure classes, let's say I create AU (slot) classes as well, with component relationships to the racks and enclosures. It seems like this would allow me to define the number of AUs by creating only those CIs (If a rack has 20 slots, I create 20 AU CIs). This would also let me indicate when a slot is unavailable (because cords it is used for cord management, for example) by setting that AU CI's status. Each thing put into a slot would be connected to it using a location relationship. This seems to be the cleanest and most Object Oriented of the set, and if I understand the system correctly, I could only allow 1:1 relationships between the slot and the slotted asset, which would prevent any mistakes. There is concern however that this would involved too much extra work. Again, if anyone has tried modeling racks and enclosures in this kind of detail or done some investigation on doing it I would appreciate your experience and advice on the subject. Thank you in advance, Kelly Logan, Sr. Systems Administrator (Remedy, Planview), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777 kelly.lo...@proquest.commailto:kelly.lo...@proquest.com www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Abydos is now BMC
the website has been updated to show BMC is now the mother-ship and reseller information of Analyser seems to still be available: www.abydos-workflow.com http://www.abydos-workflow.com/Products/AbydosAnalyser/AbydosAnalyserResellerInformation/tabid/82/Default.aspx ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Needed PRINT functionality
Hi, As part of my implementaion, i need a Dialog form/Regular form dispalying the agreement(some user defined text), along with the PRINT button. When the user clicks on the PRINT button,all the user displayed agreement should get printed. Can any one please let me know how to acheive this PRINT functionality? With Regads, Vikram. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Sequential Approval functionality
I have created a Service Request (SR).Once after it gets created 'Approver1','Approver2' and 'Approver3' should be able to approve it and then only SR should move to the 'Plannng' stage from 'Waiting For Approval'. But these approvals should happen sequentially. i.e once 'Approver1' approves then only 'Approver2'record should get generated and similarly for 'Approver3' record. At the time of SR submission itself , i can write a Filter with Run Process action, where in i can use 'Application-Command-Approval' command for generating the approval. For generating 3 approval records, i can write three RunProcess actions in the same filter.BUt using this, it will generate the 3 records at a time, which will not suite my requirement. I need one approval after the another. Can some one help me with this? With Regards, B.Vkram. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Needed PRINT functionality
Client, Web or both? If I recall correctly you can not print from the web since the Midtier transforms the record into a crystal report before printing it. You can always use the print function of your browser. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail Vikram_Betholi betholi.vik...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/26/2012 12:01 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Needed PRINT functionality Hi, As part of my implementaion, i need a Dialog form/Regular form dispalying the agreement(some user defined text), along with the PRINT button. When the user clicks on the PRINT button,all the user displayed agreement should get printed. Can any one please let me know how to acheive this PRINT functionality? With Regads, Vikram. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are __ This email has been scanned by the Symantec Email Security.cloud service. __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Sequential Approval functionality
Vikram, I will point you to the Approval Server and the documentation about that subsystem. There is a full manual to describe that subsystem and how to configure it. You will end up creating an approval process and you configure the SRM product to call that -- no custom filter is needed. The process you configure for doing what you are calling for can be done in a number of different ways. To some degree, it depends on the relationship between the three approvers. Option 1 -- if the approvers are a management chain Simply define a hierarchical approval model and point it at the form that defines the management chain. Option 2 -- if the approvers are a random list with no stored order other than just needing to happen in sequence You could define a committee approval model with three levels of committee and one person in each committee. This allows you to list a random order of people that happen in sequence and you could have one or several at each level. Option 3 -- if there is some other rule you can use to find who is next after one person approves You could define a rule based approval processes where you supply the rules you want to use to find the next users There are options 4, 5, 6, and more as well. It all depends on what the relationship of the people are. You can even have an option where users are added by one approver specifying who is next or for any option you can just add users at any time for additional approvals or .. More options and controls than you can dream of (like voting where you need 75% of a committee to approve to move forward or to run several full processes either in parallel or serially with each approval process consisting of zero or more people running together to produce a single result of approval or not). All of this is available with the approval server. Your request is actually a very simple flow that is easily configured within the approval rules. And importantly, all of this is CONFIGURATION where you go into the Approval Server and build definitions of processes and rules (and notifications and exception handling and other similar things) and the system will then run your approval process. You do not need to create any workflow or use Dev Studio for anything here. It will also allow you to preview things so you can see who has approved, who is left to approve and what order they are in. Take a look. I think you will find what you are looking for. Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Vikram_Betholi Sent: Thursday, April 26, 2012 9:58 AM To: arslist@ARSLIST.ORG Subject: Sequential Approval functionality I have created a Service Request (SR).Once after it gets created 'Approver1','Approver2' and 'Approver3' should be able to approve it and then only SR should move to the 'Plannng' stage from 'Waiting For Approval'. But these approvals should happen sequentially. i.e once 'Approver1' approves then only 'Approver2'record should get generated and similarly for 'Approver3' record. At the time of SR submission itself , i can write a Filter with Run Process action, where in i can use 'Application-Command-Approval' command for generating the approval. For generating 3 approval records, i can write three RunProcess actions in the same filter.BUt using this, it will generate the 3 records at a time, which will not suite my requirement. I need one approval after the another. Can some one help me with this? With Regards, B.Vkram. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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: Rack and Enclosure modeling in CMDB 2.1
Hi Kelly, Here's what I've done in the past: - A blade chassis is a computer in its own right so map it in the computer system class - Map blades also as computer systems and relate them as components of the blade chassis - Relate computer systems that are in real racks to the racks in the rack class - Relate blades and virtual systems running on the blades to a cluster as you may not know which actual blade is hosting a VM at a particular time - Add height and rack location attributes to the computer system class - Add a new tab and table to the rack class and display the computers in the rack in the table along with their height and position - Add a field under the table showing the sum of the heights of the computers - Add a new attribute to the rack to hold the size of the rack - Create a new power management class (sibling of UPS) to hold power strips and power sources (product categorisation defines each) - Relate the strips and power sources to the computers - Use the CI location fields to identify where the racks are located (including room floor with appropriate naming conventions) The federation you can do to Nlyte might be better and replace some of the above but in my case the client didn't have any data centre tools and wasn't prepared to pay for any!! I've also been involved with mapping building - floor - room to separate, related physical locations as we needed in this case to store access, air conditioning and other details for each of these areas in the CMDB. Don't be afraid of extending the CMDB as you'll get better value from it if it stores what the users want and in doing so can retire the spreadsheets and ad-hoc databases they are probably using now! Cheers Peter From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Logan, Kelly Sent: 26 April 2012 16:51 To: arslist@ARSLIST.ORG Subject: Rack and Enclosure modeling in CMDB 2.1 ** Hello all, I am looking for some experience/advice: We are looking at modeling our computer centers in Atrium CMDB 2.1 (w/ ARS ITSM 7.6.4), including the racks and enclosures. I am looking at several concepts right now to model this data and would be interested in any strategies others have found to be useful in their environments. What I am looking to determine now is not only how to model the data itself, but what processes will be automatically provided, and what processes I will have to customize/create in order to help Infrastructure do their job. Here's what I am thinking of right now (in broad terms): 1. Extend the BMC_Equipment class to create PQ_Rack and PQ_Enclosure classes, perhaps with AU (slot) classes as well. 2. Utilize BMC_PhysicalLocation to represent object locations (Rack 3-5, AU slot 2) and use custom reports to track overall locations. 3. Extend the current BMC_Rack and BMC_Chassis to add necessary attributes. 4. Federate the location (rack, enclosure) data into a custom Nlyte-like application. If there is a way to utilize the Common Data Model without customization, that would be my preference. Note that the Racks and Enclosures do not simply hold blades, they also hold network modules/patch panels, SANs, power, etc; each of these may also take up more than one slot per. By processes, I mean that Infrastructure will want to be able to quickly tell from an asset name, where it is precisely (site, grid location, rack and enclosure slot). Or, given a two slot asset, where they can plug it in (display the racks where two consecutive slots are available, or at least show the open slots in a fashion that it is easy to see where two consecutive ones are). For example, if I follow strategy 1. and create PQ_Rack and PQ_Enclosure classes, let's say I create AU (slot) classes as well, with component relationships to the racks and enclosures. It seems like this would allow me to define the number of AUs by creating only those CIs (If a rack has 20 slots, I create 20 AU CIs). This would also let me indicate when a slot is unavailable (because cords it is used for cord management, for example) by setting that AU CI's status. Each thing put into a slot would be connected to it using a location relationship. This seems to be the cleanest and most Object Oriented of the set, and if I understand the system correctly, I could only allow 1:1 relationships between the slot and the slotted asset, which would prevent any mistakes. There is concern however that this would involved too much extra work. Again, if anyone has tried modeling racks and enclosures in this kind of detail or done some investigation on doing it I would appreciate your experience and advice on the subject. Thank you in advance, Kelly Logan, Sr. Systems Administrator (Remedy, Planview), GMS ProQuest | 789 E. Eisenhower Parkway,
OT: Count of records
A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.netwrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone __**__** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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
Force Logout after inactivity?
Anyone know a way to end an ARS session after a period of inactivity? I thought of using an active link (on Save, Display etc.) to update a ‘last activity’ field; add a timed-active link to compare the timestamp and “close all” after the limit has been reached. BUT that wouldn’t detect keystrokes, which could cause a time-out while entering text. Anyone have a solution? Thanks, Joel Joel Senderjdsen...@earthlink.net310.829.5552 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Count of records
In order to help developers like myself get better at filtering data, my son is named Robert'); DROP TABLE Students;-- Pierson. http://xkcd.com/327/ Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Thursday, April 26, 2012 1:44 PM To: arslist@ARSLIST.ORG Subject: OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.netmailto:jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.commailto:remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry(r) from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.orghttp://www.arslist.org attend wwrug12 www.wwrug12.comhttp://www.wwrug12.com ARSList: Where the Answers Are _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
A question on Remedy 6.3
First off yes I still have a small group of users that are still on 6.3 I have been asked to look at an issue were users are not getting the list menu after they type in a name on a form I have a form call let say Phone Numbers and on this form is a character field in which they can type in a partial name and then an active link fire to set it to all Caps. Then the same active link takes the value in caps and does a look up to the SHR:People form to find LIKE matching Full Name and returns the needed information. I have three environment Dev QA and Production. If I try it, it works on all three servers but if a standard user tries it, it only works on Dev and QA. In the log file I can see it changing to caps and doing the look up but if no match is found it set the field to NULL. If the standard user just types in any letter found in their Full Name it will only return their record. So I think it is working it's just that they can not see others SHR:People records.They have view access to the form and read access to Full Name. I have removed all the workflow and replaced it with a new copy from QA Both server have submitter lock on Is there any other server setting that I can not think of since I think this is a permission issue on the server level. Working in 6.3 Admin I really did miss the function of Dev Studio. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Force Logout after inactivity?
Which version of remedy you are in. Are you using thick client or web or both? Incase if your intention is to save licenses by ending the session, There are a few options already available in latest versions. Midtier -- Session Timeout, License Release timeout ARS -- Floating License Timeout. On Thursday, April 26, 2012 1:51:36 PM UTC-5, Joel Sender wrote: ** Anyone know a way to end an ARS session after a period of inactivity? I thought of using an active link (on Save, Display etc.) to update a ‘last activity’ field; add a timed-active link to compare the timestamp and “close all” after the limit has been reached. BUT that wouldn’t detect keystrokes, which could cause a time-out while entering text. Anyone have a solution? Thanks, *Joel*** Joel Senderjdsen...@earthlink.net310.829.5552 _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: Count of records
That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn shawn.pier...@sug.comwrote: ** In order to help developers like myself get better at filtering data, my son is named Robert’); DROP TABLE Students;-- Pierson. ** ** http://xkcd.com/327/ ** ** Thanks, ** ** *Shawn Pierson * Remedy Developer | Energy Transfer ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller *Sent:* Thursday, April 26, 2012 1:44 PM *To:* arslist@ARSLIST.ORG *Subject:* OT: Count of records ** ** ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. ** ** The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) ** ** Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ** ** _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _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: A question on Remedy 6.3
Not sure the solution for the specific issue but though not a preferred method you could use the work around of active link setfields with an SQL . On Thursday, April 26, 2012 1:53:52 PM UTC-5, John Atherly wrote: ** First off yes I still have a small group of users that are still on 6.3 I have been asked to look at an issue were users are not getting the list menu after they type in a name on a form I have a form call let say Phone Numbers and on this form is a character field in which they can type in a partial name and then an active link fire to set it to all Caps. Then the same active link takes the value in caps and does a look up to the SHR:People form to find LIKE matching Full Name and returns the needed information. I have three environment Dev QA and Production. If I try it, it works on all three servers but if a standard user tries it, it only works on Dev and QA. In the log file I can see it changing to caps and doing the look up but if no match is found it set the field to NULL. If the standard user just types in any letter found in their Full Name it will only return their record. So I think it is working it's just that they can not see others SHR:People records.They have view access to the form and read access to Full Name. I have removed all the workflow and replaced it with a new copy from QA Both server have submitter lock on Is there any other server setting that I can not think of since I think this is a permission issue on the server level. Working in 6.3 Admin I really did miss the function of Dev Studio. _ * John Atherly* | * APC by Schneider Electric ** | Information, Process Organization (IPO)* | *Remedy Administrator / Developer* * Phone:* +305-266-5005 ext. 237 | * Email:* *john.athe...@apcc.com* +john.athe...@apcc.com | *Site:**www.apc.com/ * http://www.apc.com/ | *Address:* 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail _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: A question on Remedy 6.3
Thanks but I'm trying to only fix the issue. I thought it was going to be a simple permission on the field but after trying everything I could think of I still have this issue. It has to be some permission set some where. It works on two of the three servers just not the one I need it to work on. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail patchsk vamsi...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/26/2012 03:14 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: A question on Remedy 6.3 ** Not sure the solution for the specific issue but though not a preferred method you could use the work around of active link setfields with an SQL . On Thursday, April 26, 2012 1:53:52 PM UTC-5, John Atherly wrote: ** First off yes I still have a small group of users that are still on 6.3 I have been asked to look at an issue were users are not getting the list menu after they type in a name on a form I have a form call let say Phone Numbers and on this form is a character field in which they can type in a partial name and then an active link fire to set it to all Caps. Then the same active link takes the value in caps and does a look up to the SHR:People form to find LIKE matching Full Name and returns the needed information. I have three environment Dev QA and Production. If I try it, it works on all three servers but if a standard user tries it, it only works on Dev and QA. In the log file I can see it changing to caps and doing the look up but if no match is found it set the field to NULL. If the standard user just types in any letter found in their Full Name it will only return their record. So I think it is working it's just that they can not see others SHR:People records.They have view access to the form and read access to Full Name. I have removed all the workflow and replaced it with a new copy from QA Both server have submitter lock on Is there any other server setting that I can not think of since I think this is a permission issue on the server level. Working in 6.3 Admin I really did miss the function of Dev Studio. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ __ This email has been scanned by the Symantec Email Security.cloud service. __ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: A question on Remedy 6.3
John, Check the permissions they have to the request ID on Prod.I would bet that they don't have access to everyone elses record.so you likely have assignee in there.but not public, or something similar. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Atherly Sent: Thursday, April 26, 2012 12:54 PM To: arslist@ARSLIST.ORG Subject: A question on Remedy 6.3 ** First off yes I still have a small group of users that are still on 6.3 I have been asked to look at an issue were users are not getting the list menu after they type in a name on a form I have a form call let say Phone Numbers and on this form is a character field in which they can type in a partial name and then an active link fire to set it to all Caps. Then the same active link takes the value in caps and does a look up to the SHR:People form to find LIKE matching Full Name and returns the needed information. I have three environment Dev QA and Production. If I try it, it works on all three servers but if a standard user tries it, it only works on Dev and QA. In the log file I can see it changing to caps and doing the look up but if no match is found it set the field to NULL. If the standard user just types in any letter found in their Full Name it will only return their record. So I think it is working it's just that they can not see others SHR:People records.They have view access to the form and read access to Full Name. I have removed all the workflow and replaced it with a new copy from QA Both server have submitter lock on Is there any other server setting that I can not think of since I think this is a permission issue on the server level. Working in 6.3 Admin I really did miss the function of Dev Studio. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: mailto:%20john.athe...@apcc.com john.athe...@apcc.com | Site: http://www.apc.com/ www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail _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: A question on Remedy 6.3
The permission on QA and Prod matched. But while closing the window on the SHR:People form production I click save by mistake even though I made no changes to the form or permission. How it is working!I forgot about the trick of just opening and saving it. Thanks everyone _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail LJ LongWing lj.longw...@gmail.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 04/26/2012 03:22 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: A question on Remedy 6.3 ** John, Check the permissions they have to the request ID on Prod…I would bet that they don’t have access to everyone elses record…so you likely have assignee in there…but not public, or something similar. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of John Atherly Sent: Thursday, April 26, 2012 12:54 PM To: arslist@ARSLIST.ORG Subject: A question on Remedy 6.3 ** First off yes I still have a small group of users that are still on 6.3 I have been asked to look at an issue were users are not getting the list menu after they type in a name on a form I have a form call let say Phone Numbers and on this form is a character field in which they can type in a partial name and then an active link fire to set it to all Caps. Then the same active link takes the value in caps and does a look up to the SHR:People form to find LIKE matching Full Name and returns the needed information. I have three environment Dev QA and Production. If I try it, it works on all three servers but if a standard user tries it, it only works on Dev and QA. In the log file I can see it changing to caps and doing the look up but if no match is found it set the field to NULL. If the standard user just types in any letter found in their Full Name it will only return their record. So I think it is working it's just that they can not see others SHR:People records.They have view access to the form and read access to Full Name. I have removed all the workflow and replaced it with a new copy from QA Both server have submitter lock on Is there any other server setting that I can not think of since I think this is a permission issue on the server level. Working in 6.3 Admin I really did miss the function of Dev Studio. _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ __ This email has been scanned by the Symantec Email Security.cloud service. __ _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
SRM 7.6.04 - Changing Companies
All, I've got a requirement to have to change SRDs and of course the PDTs and AOTs associated with it so that the Company is set to -Global- instead of a specific company. By default, the SRD, PDT, and AOT forms each have the company field set to RO. Has anyone ever done this before and if so, are there any other supporting forms involved in changing the Company? The options I'm thinking are to find the AL that makes the field RO and disable it temporarily so I can modify the Company directly. The other option may be to export and re-import with the updated Company. -- *Tauf Chowdhury * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Count of records
I know you can't customize nor access the DB. I see no solution to your
case.
But I can provide you some solutions, customizing or accessing the database.
All of this is for Oracle.
1.- Run an SQL sentence:
SELECT A.SCHEMAID, A.NAME, A.NEXTID, T.NUM_ROWS FROM ARSCHEMA A JOIN
user_tables T ON ( ('T' ||TRIM(TO_CHAR(A.SCHEMAID))) = T.TABLE_NAME)
Provides you the next ID and number of requests at each regular form.
2.- Create a view using the previous SQL and map it to a View Form.
3.- Create a view form mapping the user_tables table. Then create a join
view between this form and the AR System metadata:arschema form, with the
join qualification like the provided one.
Regards,
Jose Huerta
http://theremedyforit.com/
On Thu, Apr 26, 2012 at 21:09, Jason Miller jason.mil...@gmail.com wrote:
**
That is great!
On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn shawn.pier...@sug.comwrote:
**
In order to help developers like myself get better at filtering data, my
son is named Robert’); DROP TABLE Students;-- Pierson.
** **
http://xkcd.com/327/
** **
Thanks,
** **
*Shawn Pierson *
Remedy Developer | Energy Transfer
** **
*From:* Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller
*Sent:* Thursday, April 26, 2012 1:44 PM
*To:* arslist@ARSLIST.ORG
*Subject:* OT: Count of records
** **
**
A good reason to not run your application as root/admin... I had a
system once were I didn't have admin access on the app server but the AR
System ran as root. I built a form where I could enter an OS command in a
text field and Remedy would issue the command to the OS in a Run Process.
Worked great for things like sending a chown command on log files that I
couldn't view because they were created by root.
** **
The same could hold true if your ARSystem db user is a sysadmin. Be
careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem.
:-)
** **
Jason
On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.net
wrote:
You do not require the ARAdmin password to run a direct SQL on your
application..
Customize your app wherein, you run a direct SQL in a set field operation
to set a field with $1$ of the SQL statement ==
select count(*) from view name
Do not use the terminating ; character on your direct SQL as the AR
System engine takes care of that..
Use that statement in a set field action and set a temp field to return
your count to.. This will not limit your count by what your get list limits
on your server or your clients are..
Joe
-Original Message- From: remedyarl...@gmail.com
Sent: Thursday, April 26, 2012 5:57 AM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Count of records
Quick question..
Do we have a form in remedy 7.6.X where we can check the count of rows in
each table. I know we have a form to check schema ID's but will this also
give count of rows. My Getlist query on server is restricted to 2K records
only so I have to run 1=1 query on each target form in web mode to get the
count. Unfortunately user too do not give the count. Also I don't have read
access to DB and client is not ready to share ARAdmin pwd (for security).
And as usual no customization allowed.
Any help would be appreciated.
Sent on my BlackBerry® from Vodafone
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
** **
_attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_
Private and confidential as detailed
herehttp://www.sug.com/disclaimers/default.htm#Mail.
If you cannot access hyperlink, please e-mail sender.
_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
Re: Time Criteria in Exclude When in Service Targets - not working properly
Service targets criteria are only evaluated at submit or modifications on the original request. You must force an update on the request. I solved it in the past, for a more complex requisite, using a scheduler. You can find a description at http://theremedyforit.com/2012/01/scheduling-actions-in-bmc-remedy-action-request-system/ My recommendation is not to use the date/time field at the incident, but to use a flag field that reports something like: In Time Out of time. And have the scheduler to change the value at the desired time. To have one escalation running at every minute is a high CPU consuming task if the qualification is over the HPD:Help Desk form, but not for a almost always empty form. Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24 Fax: 971 75 07 94 http://www.sm2baleares.es/ SM2 Baleares S.A. C/Rita Levi Edificio SM2 Parc Bit 07121 Palma de Mallorca http://es-es.facebook.com/pages/SM2-Baleares/158608627954 http://twitter.com/#!/SM2Baleares http://www.linkedin.com/company/sm2-baleares La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato. P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. On Thu, Apr 26, 2012 at 09:13, Kali Obsum kali.ob...@macquarie.com wrote: ** Hi, ** ** Has anyone tried using a time criteria in the Exclude When parameter of Service Targets? We’ve created Service Targets wherein the Exclude When is defined as: *'Status' = Pending AND 'date/time field in INC form' $\TIMESTAMP$** *** ** ** It works initially wherein when it satisfies the condition, the Service Target is put on hold. However, if you don’t modify anything in the ticket and you go past the value of the date/time field, it doesn’t put the Service Target back to In Progress. You have to modify something in the ticket first and save it before it would start counting again. ** ** Has anyone been able to make this work? ** ** Regards, *Kali* ** ** NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _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 image001.jpgimage003.jpgimage002.jpgimage004.jpg
Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA
Michael, We have reached critical mass 2012/4/20 Nau, Michael m@ing-diba.de ** I’ve got my browser set to auto-refresh and am waiting for question no.2 to be posted. I think this will be the critical mass. ** ** Hey, it’s Friday ;-) Good luck with the site! ** ** Regards Michael ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Michael Latham *Sent:* Monday, April 16, 2012 3:18 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA ** ** ** POLITICAL ANSWER: The idea is to present exclusivity and a sense of community in regards to the Remedy folks that is not an appendage of yet another conglomeration of tech sites. ** ** MY ANSWER: ** ** I just wanted to provide something I thought was cool to other cool people like myself. You know those individuals who would like to feel more interaction and gain more credit for their knowledge with Remedy and all associated technologies. I also felt like it was an easier interface to collaborate on when it comes to Q A but at the same time providing a forum atmosphere without the forum look. ** ** TLDR Version: ** ** I just wanted to do something exclusive but familiar to those who share my passion of Remedy...or not. Date: Fri, 13 Apr 2012 09:53:37 -0400 From: jon.sla...@amway.com Subject: Re: RE-POST DUE TO FORMAT ERRORS: ARSFAQ! ARSFAQ! - Stackoverflow(ish) clone for Remedy QA - BETA To: arslist@ARSLIST.ORG I was going to say Why not just create a stack exchange site proposal? AFAIK they're free, you just have to prove you have enough users to make it worthwile ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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_ ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727, Handelsregister Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout (Vorsitzender), Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen, Katharina Herrmann, Martin Krebs. Aufsichtsrat: Ben Tellings (Vorsitzender) Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.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: Force Logout after inactivity?
Since 7.6.04 users will be on the WEB you can do this in the MT configurations. I know your customer are not on 7.6.04 and do not plan on upgrading. I thought I would try Long time no see. -Original Message- From: Joel Sender jdsen...@earthlink.net To: arslist arslist@ARSLIST.ORG Sent: Thu, Apr 26, 2012 5:00 pm Subject: Force Logout after inactivity? ** Anyone know a way to end an ARS session after a period of inactivity? I thought of using an active link (on Save, Display etc.) to update a ‘last activity’ field; add a timed-active link to compare the timestamp and “close all” after the limit has been reached. BUT that wouldn’t detect keystrokes, which could cause a time-out while entering text. Anyone have a solution? Thanks, Joel Joel Senderjdsen...@earthlink.net310.829.5552 _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: Force Logout after inactivity?
ARS 7.6.4 WUT now, moving to M/T This is a security requirement, not related to license management. Requirement is to duplicate windows automatic screen lock in ARS application. My initial suggestion to just reply upon Windows to lock up, but the ARS owner wants an even shorter time than the enterprise default. 60 Min floating license time-out is too long and this must apply to fixed license users, too. Session timeout in M/T has same 60 minute minimum. License Timeout has to do with the session license expiring after a browser is improperly closed: “The mid-tier initiates a delay timer when the user closes the last browser window associated with the established HTTP session. When the delay timer expires, the user’s license is released, and the HTTP session terminated. If the user navigates back to the mid-tier URL before the delay time expires, the delay timer is cancelled, and the current HTTP session is resumed.” There has GOT to be an ARS way to do this (without an active link on every field!) ? Joel Joel Senderjdsen...@earthlink.net310.829.5552 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Thursday, April 26, 2012 12:08 PM To: arslist@ARSLIST.ORG Subject: Re: Force Logout after inactivity? ** Which version of remedy you are in. Are you using thick client or web or both? Incase if your intention is to save licenses by ending the session, There are a few options already available in latest versions. Midtier -- Session Timeout, License Release timeout ARS -- Floating License Timeout. On Thursday, April 26, 2012 1:51:36 PM UTC-5, Joel Sender wrote: ** Anyone know a way to end an ARS session after a period of inactivity? I thought of using an active link (on Save, Display etc.) to update a ‘last activity’ field; add a timed-active link to compare the timestamp and “close all” after the limit has been reached. BUT that wouldn’t detect keystrokes, which could cause a time-out while entering text. Anyone have a solution? Thanks, Joel Joel Senderjdsen...@earthlink.net310.829.5552 _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
Resolved: Question: How can you detect corrupted form?
Thanks to all that responded. This permission issue on the midtier is a bug. SW00376993, resolved in Mid-Tier 7.5 patch 8. So work around for now, is to give the customer write access. -- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Question-How-can-you-detect-corrupted-form-tp759p7504462.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
OT: Count of records
I like this command even better.. DROP USER aradmin CASCADE; This command should be only used by trained professionals.. Do not try this at home :-) Seriously!! Do not try this! Joe From: Jason Miller Sent: Thursday, April 26, 2012 2:43 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Count of records
I want that on a T-Shirt From: Jason Miller Sent: Thursday, April 26, 2012 3:09 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Count of records ** That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn shawn.pier...@sug.com wrote: ** In order to help developers like myself get better at filtering data, my son is named Robert’); DROP TABLE Students;-- Pierson. http://xkcd.com/327/ Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Thursday, April 26, 2012 1:44 PM To: arslist@ARSLIST.ORG Subject: OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Count of records
rm -Rf /* Lol Sent from my iPhone On Apr 26, 2012, at 18:32, Joe Martin D'Souza jdso...@shyle.net wrote: ** I want that on a T-Shirt From: Jason Miller Sent: Thursday, April 26, 2012 3:09 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Count of records ** That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn shawn.pier...@sug.com wrote: ** In order to help developers like myself get better at filtering data, my son is named Robert’); DROP TABLE Students;-- Pierson. http://xkcd.com/327/ Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller Sent: Thursday, April 26, 2012 1:44 PM To: arslist@ARSLIST.ORG Subject: OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone _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: Count of records
Awe man!!! My Fedora box died when I read this email on it. On Thu, Apr 26, 2012 at 3:39 PM, Pat Zandi remedy...@gmail.com wrote: ** rm -Rf /* Lol Sent from my iPhone On Apr 26, 2012, at 18:32, Joe Martin D'Souza jdso...@shyle.net wrote: ** I want that on a T-Shirt *From:* Jason Miller jason.mil...@gmail.com *Sent:* Thursday, April 26, 2012 3:09 PM *Newsgroups:* public.remedy.arsystem.general *To:* arslist@ARSLIST.ORG *Subject:* Re: Count of records ** That is great! On Thu, Apr 26, 2012 at 11:52 AM, Pierson, Shawn shawn.pier...@sug.comwrote: ** In order to help developers like myself get better at filtering data, my son is named Robert’); DROP TABLE Students;-- Pierson. http://xkcd.com/327/ Thanks, *Shawn Pierson * Remedy Developer | Energy Transfer *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Jason Miller *Sent:* Thursday, April 26, 2012 1:44 PM *To:* arslist@ARSLIST.ORG *Subject:* OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone _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
Re: Count of records
Would that actually do anything in Oracle? (it is almost Friday). Daniel From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: April 26, 2012 6:30 PM To: arslist@ARSLIST.ORG Subject: OT: Count of records ** I like this command even better.. DROP USER aradmin CASCADE; This command should be only used by trained professionals.. Do not try this at home :-) Seriously!! Do not try this! Joe From: Jason Miller mailto:jason.mil...@gmail.com Sent: Thursday, April 26, 2012 2:43 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerryR from Vodafone _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: Count of records
In oracle it would pretty much drop the ARAdmin user and everything it owns.. It’s a cascaded delete.. So long as you have the rights to DROP USER, it will work and drop the entire ARSystem database and everything else that ARAdmin was the owner of :-).. Its useful to rebuild test boxes from scratch http://www.dba-oracle.com/t_oracle_drop_user_cascade.htm I just noticed you typed that its almost friday so I’m not sure now if you were serious when you asked this or not :-) Joe From: arslist Sent: Thursday, April 26, 2012 9:24 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Count of records ** Would that actually do anything in Oracle? (it is almost Friday). Daniel From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: April 26, 2012 6:30 PM To: arslist@ARSLIST.ORG Subject: OT: Count of records ** I like this command even better.. DROP USER aradmin CASCADE; This command should be only used by trained professionals.. Do not try this at home :-) Seriously!! Do not try this! Joe From: Jason Miller Sent: Thursday, April 26, 2012 2:43 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: OT: Count of records ** A good reason to not run your application as root/admin... I had a system once were I didn't have admin access on the app server but the AR System ran as root. I built a form where I could enter an OS command in a text field and Remedy would issue the command to the OS in a Run Process. Worked great for things like sending a chown command on log files that I couldn't view because they were created by root. The same could hold true if your ARSystem db user is a sysadmin. Be careful that the SELECT COUNT(*) doesn't turn into DROP DATABASE ARSystem. :-) Jason On Thu, Apr 26, 2012 at 7:07 AM, Joe Martin D'Souza jdso...@shyle.net wrote: You do not require the ARAdmin password to run a direct SQL on your application.. Customize your app wherein, you run a direct SQL in a set field operation to set a field with $1$ of the SQL statement == select count(*) from view name Do not use the terminating ; character on your direct SQL as the AR System engine takes care of that.. Use that statement in a set field action and set a temp field to return your count to.. This will not limit your count by what your get list limits on your server or your clients are.. Joe -Original Message- From: remedyarl...@gmail.com Sent: Thursday, April 26, 2012 5:57 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone _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
Re: Force Logout after inactivity?
Joel, Whatever method you use to get your timing, PERFORM-ACTION-APPLICATION-EXIT will actually logout and not just close windows.. Closing windows would not logout, especially if you are using Windows Explorer with tabs or one of the other browsers with tabs.. the action stated above will.. This is available since version 5.5 if I am not mistaken... Joe From: Joel Sender Sent: Thursday, April 26, 2012 5:28 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Force Logout after inactivity? ** ARS 7.6.4 WUT now, moving to M/T This is a security requirement, not related to license management. Requirement is to duplicate windows automatic screen lock in ARS application. My initial suggestion to just reply upon Windows to lock up, but the ARS owner wants an even shorter time than the enterprise default. 60 Min floating license time-out is too long and this must apply to fixed license users, too. Session timeout in M/T has same 60 minute minimum. License Timeout has to do with the session license expiring after a browser is improperly closed: “The mid-tier initiates a delay timer when the user closes the last browser window associated with the established HTTP session. When the delay timer expires, the user’s license is released, and the HTTP session terminated. If the user navigates back to the mid-tier URL before the delay time expires, the delay timer is cancelled, and the current HTTP session is resumed.” There has GOT to be an ARS way to do this (without an active link on every field!) ? Joel Joel Senderjdsen...@earthlink.net310.829.5552 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patchsk Sent: Thursday, April 26, 2012 12:08 PM To: arslist@ARSLIST.ORG Subject: Re: Force Logout after inactivity? ** Which version of remedy you are in. Are you using thick client or web or both? Incase if your intention is to save licenses by ending the session, There are a few options already available in latest versions. Midtier -- Session Timeout, License Release timeout ARS -- Floating License Timeout. On Thursday, April 26, 2012 1:51:36 PM UTC-5, Joel Sender wrote: ** Anyone know a way to end an ARS session after a period of inactivity? I thought of using an active link (on Save, Display etc.) to update a ‘last activity’ field; add a timed-active link to compare the timestamp and “close all” after the limit has been reached. BUT that wouldn’t detect keystrokes, which could cause a time-out while entering text. Anyone have a solution? Thanks, Joel Joel Senderjdsen...@earthlink.net310.829.5552 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
