Forgot to mention we don't have ITSM, just AR System w/o Approval Server installed.
Brien On Wed, Sep 24, 2008 at 6:54 AM, Axton <[EMAIL PROTECTED]> wrote: > Is the approval server bound to a custom form or a form in the ITSM > suite? If bound to one of the ITSM forms, there are bypasses in the > licensing enforcement that allow people to approve with a read > license. If bound to a custom form, you can in essence bypass the > licensing requirements by using filters to update the underlying > records, simply put some filters on a display on form and have the > user with the read license push to that display only form using an > active link and then pick up the remainder of the updates using > filters. I worked with BMC support at one point in the past and > verified that this was not a violation of our licensing agreement if > used in this way for this specific purpose. > > You should consider describing the problem you are trying to address > from the start as there may be approaches you have not considered that > people can share. > > Axton Grams > > On Tue, Sep 23, 2008 at 4:01 PM, Brien Dieterle > <[EMAIL PROTECTED]> wrote: > > ** > > Thanks for the warnings, list-- Since it seems so problematic, I am not > > going to bother with the remove-from-group or downgrading of License. > So, > > my process will basically "upgrade" a user account by appending a group > to > > their Group List, and changing their License Type from Read to Floating. > > The list is fairly static so it shouldn't be a big deal to clean it up > once > > in a while. > > > > What is the purpose of all of this, you might wonder? It is so a typical > > end-user (Read License) can make a request for a certain something that > is > > approved by a certain person. Here is a generalized example: > > > > If Bob requests a computer, Jane or Dan would have to approve the > request. > > So my reference table has: > > > > 'computer', 'jane;dan' > > 'monitor', 'greg;bob' > > 'mouse', 'kathy' > > > > So, Jane, Dan, Greg, Kathy, and Bob all need Floating licenses to be able > to > > change the status of the request (approval). They are also added to a > > specific Approver group that has 5 floating licenses allocated to it. > > > > Eventually, Bob might be removed from the "monitor" approver list, so he > > wouldn't really need a Floating license anymore. In fact, leaving Bob > with > > a Floating license would be wasteful, since it seems that Floating > licenses > > are consumed even when doing tasks that only "require" a Read license. > > > > It would be nice if I could just give everyone Floating license and not > > worry about this... > > > > Thanks again! > > > > Brien > > > > On Tue, Sep 23, 2008 at 12:12 PM, Thad K Esser <[EMAIL PROTECTED]> > wrote: > >> > >> ** > >> I'm just catching up on my arslist, and might have missed a nuance of > your > >> goal, but would a computed group help you in any way that would prevent > you > >> from having to monkey with the user data? > >> > >> --- > >> Having said that, and with full awareness of the issues brought up by > >> Axton, you can eliminate issues with a preceding semi-colon by adding > one in > >> as part of the replace: > >> Assuming: > >> Group List = "511;507;508;501;518;521;55598;" > >> xtmpchar2 = "55598" > >> > >> Then: > >> New List = REPLACE(";" + $Group List$ + ";", ";" + $xtmpchar2$ + ";", > >> ";") > >> > >> You could end up with a Group List that starts with a semi-colon, pull > it > >> out with a RIGHT() function if you need to. > >> Also, depending on details, you could end up with a double semi-colon in > >> your list. After any looping is done, you can pull the 2nd one out with > an > >> additional: > >> REPLACE($Group List$, ";;", ";") > >> --- > >> > >> I am curious, what is the nature of this group that only needs members > for > >> a day? > >> > >> Thad Esser > >> Remedy Developer > >> "Argue for your limitations, and sure enough, they're yours."-- Richard > >> Bach > >> > >> > >> Brien Dieterle <[EMAIL PROTECTED]> > >> Sent by: "Action Request System discussion list(ARSList)" > >> <arslist@ARSLIST.ORG> > >> > >> 09/23/2008 11:17 AM > >> > >> Please respond to > >> arslist@ARSLIST.ORG > >> To > >> arslist@ARSLIST.ORG > >> cc > >> Subject > >> Re: split a field and loop on each piece > >> > >> > >> > >> > >> ** > >> Right, I am only flipping read-only to floating, and back again... Also, > >> the database looks like: > >> > >> 511;507;508;501;518;521;55598; > >> > >> So, I think I can do a > >> REPLACE($Group List$,"55598;","") > >> > >> and it should be all good after all. Interestingly, Remedy Admin won't > >> even let you save an action that threatens to corrupt the format of this > >> field (for instance, I tried saving it with replace: ";55598" instead of > >> "55598;" and it actually said "Error with one of the field/assignments > in > >> the set filter/active link/escalation definition : User (ARERR 168)." > >> > >> I thought I was good to go there, and I just realized that > >> > >> REPLACE($Group List$, "55598;", "") or even using the group's > text-name > >> > >> upon saving, gets converted to: > >> > >> REPLACE($Group List$, " 55598;", "") > >> > >> Notice the extra space before the group id? Any other variation seems > to > >> trigger the error message referenced above. Weird!! > >> > >> Other than that, I can successfuly add a user to a group, and change > their > >> license from Read to Floating, and back again. I just can't remove them > >> from the group. Presumably, I can copy the Group List to a tmp field, > do > >> the REPLACE() there, and then put that back in the user group field to > get > >> around Remedy Admin tool being too "smart"... > >> > >> Thanks for the suggestions!! > >> > >> > >> > >> On Tue, Sep 23, 2008 at 10:17 AM, Opela, Gary L CTR USAF AFMC 72 > CS/SCBAH > >> <[EMAIL PROTECTED]> wrote: > >> I'm not sure of the implications with a floating license of > >> adding/removing a license, since they are not tied to a user. > >> > >> However, with a Fixed License (which is not what you stated you are > >> using), you can only reassign it 3 times per week before it is locked > >> for the rest of the seven days. > >> > >> Gary > >> > >> -----Original Message----- > >> From: Action Request System discussion list(ARSList) > >> [mailto:[EMAIL PROTECTED] On Behalf Of Brien Dieterle > >> Sent: Tuesday, September 23, 2008 11:26 AM > >> To: arslist@ARSLIST.ORG > >> Subject: Re: split a field and loop on each piece > >> > >> ** > >> Haha, thanks for the tip-- I was planning to use "" in the replace. I > >> forgot to add that anyone that I add to this group also needs a floating > >> license ... and so I'll be changing that license back to read-only as > >> part of the group "flush". Of course, when I set it back to read-only, > >> I won't know if that user had previously been givin a floating license > >> for some other reason... Unless I add another field to the user table, > >> like a checkbox that says "user had a floating license before I messed > >> with this". > >> > >> This is almost getting silly! :-) > >> > >> Brien > >> > >> > >> On Tue, Sep 23, 2008 at 9:00 AM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH > >> <[EMAIL PROTECTED]> wrote: > >> > >> > >> Actually, I think you might want to do a REPLACE($Group List$, > >> ";1234;" > >> ";") > >> > >> This way, ;1;1234;12;23;4; would go to ;1;12;23;4; > >> > >> So, the ;1234; would go to ;, so you would still have your > >> proper > >> delimiter. Test this in a small scale first to make sure you > >> don't screw > >> up all of your user's groups. I've seen before where junk > >> characters > >> would get put in this field at the database level, and break the > >> user's > >> access to anything. > >> > >> Gary > >> > >> > >> -----Original Message----- > >> From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH > >> Sent: Tuesday, September 23, 2008 10:58 AM > >> To: arslist@ARSLIST.ORG > >> > >> Subject: RE: split a field and loop on each piece > >> > >> Hey, I got an idea. > >> > >> Whenever you are trawling the user table, you can use the > >> REPLACE > >> function. > >> > >> SO, have an escalation hat runs against user, that does the > >> following: > >> REPLACE($Group List$, ";1234;" ";;") > >> > >> You might have to tweak the statement a bit, but that should > >> chop out > >> the group id that you are getting rid of. > >> > >> Have the escalation that adds people back in run about 30 > >> minutes to an > >> hour later. > >> > >> > >> Gary > >> > >> -----Original Message----- > >> From: Action Request System discussion list(ARSList) > >> [mailto:[EMAIL PROTECTED] On Behalf Of Brien Dieterle > >> > >> Sent: Tuesday, September 23, 2008 10:45 AM > >> > >> To: arslist@ARSLIST.ORG > >> Subject: Re: split a field and loop on each piece > >> > >> ** > >> Yes on trawling User table, I want to remove everyone from this > >> group > >> every night and then add everyone back from the guide. > >> > >> I'll have to think about the trigger some more, but I think I > >> want the > >> guide to trigger on modify so that if a new user is added to > >> that field > >> they are added to the group immediately instead of only during > >> the > >> nightly sync. > >> > >> Thanks again for all your help! > >> > >> Brien > >> > >> > >> On Tue, Sep 23, 2008 at 4:52 AM, Opela, Gary L CTR USAF AFMC 72 > >> CS/SCBAH > >> <[EMAIL PROTECTED]> wrote: > >> > >> > >> Yeah, I was wondering if filter phasing would cause you > >> an > >> issue. Adding > >> the `! was good. > >> > >> For the part on the escalations, why are you trawling the > >> user > >> table, > >> looking for the group and removing it? Are you going > >> through > >> each night > >> and removing all users from the group, then re-adding > >> only the > >> users > >> from the guide? > >> > >> As far as having a field to modify to trigger the > >> workflow, I > >> would > >> suggest adding a read/only radio button so that your > >> filter that > >> calls > >> the guide can explicitly check for that flag being set. > >> This way > >> you can > >> lock it down to run exactly only when you want it to. > >> > >> > >> Gary > >> > >> -----Original Message----- > >> From: Action Request System discussion list(ARSList) > >> [mailto:[EMAIL PROTECTED] On Behalf Of Brien Dieterle > >> > >> Sent: Monday, September 22, 2008 6:15 PM > >> To: arslist@ARSLIST.ORG > >> Subject: Re: split a field and loop on each piece > >> > >> ** > >> > >> Gary, brilliant. Works like a champ! > >> > >> For posterity, just had to add `! to the filter that > >> actually > >> does the > >> group adding,and a tmpgroups field to store the user's > >> other > >> groups, > >> because I can't seem to append to a field during a push > >> operation. > >> > >> Now I just need to setup an escalation to "flush" this > >> group > >> (crawl User > >> table and do a set fields/string replace on the group I > >> want to > >> flush?), > >> and then trigger this filter guide to push everyone back > >> into > >> the group > >> (crawl my other table (escalation) and modify a field to > >> trigger > >> filter > >> action (modify) to launch the filter guide?. The idea > >> being to > >> keep a > >> group list populated with exactly and only the users from > >> the > >> filter > >> guide Gary outlined. > >> > >> If there is a better way than above, please feel free to > >> let me > >> know.... > >> I'll save this for tomorrow. > >> > >> Thanks again Gary and everyone else that responded! > >> > >> Brien > >> > >> > >> On Mon, Sep 22, 2008 at 12:32 PM, Opela, Gary L CTR USAF > >> AFMC 72 > >> CS/SCBAH <[EMAIL PROTECTED]> wrote: > >> > >> > >> Good point, you are using usernames. > >> > >> Whatever the format in the database is what you > >> should go > >> by, as > >> filters > >> are server-side code, and couldn't care less what > >> the > >> client > >> displays. > >> > >> Let me know if it works, so I'll feel good and > >> will be > >> nicer to > >> my > >> co-workers :) > >> > >> Gary > >> > >> > >> -----Original Message----- > >> From: Action Request System discussion > >> list(ARSList) > >> > >> __Platinum Sponsor: www.rmsportal.com ARSlist: > >> "Where the > >> Answers Are" html___ > >> > >> > >> > >> ________________________________________________________________________ > >> _______ > >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > >> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the > >> Answers > >> Are" > >> > >> > >> > >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the > >> Answers Are" > >> html___ > >> > >> > >> ________________________________________________________________________ > >> _______ > >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > >> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers > >> Are" > >> > >> > >> > >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > >> html___ > >> > >> > >> > _______________________________________________________________________________ > >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > >> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > >> > >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > >> html___ > >> > >> *IMPORTANT NOTICE: This communication, including any attachment, > contains > >> information that may be confidential or privileged, and is intended > solely > >> for the entity or individual to whom it is addressed. If you are not the > >> intended recipient, you should delete this message and are hereby > notified > >> that any disclosure, copying, or distribution of this message is > strictly > >> prohibited. Nothing in this email, including any attachment, is intended > to > >> be a legally binding signature. * > >> > >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > >> html___ > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"