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)" <
> [email protected]>
>
> 09/23/2008 11:17 AM
> Please respond to
> [email protected]
>
> To
> [email protected] 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] <[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] <[email protected]>] On Behalf Of Brien
> Dieterle
> Sent: Tuesday, September 23, 2008 11:26 AM
> To: [EMAIL PROTECTED] <[email protected]>
> 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] <[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: [EMAIL PROTECTED] <[email protected]>
>
> 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] <[email protected]>] On Behalf Of
> Brien Dieterle
>
> Sent: Tuesday, September 23, 2008 10:45 AM
>
> To: [EMAIL PROTECTED] <[email protected]>
> 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] <[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] <[email protected]>] On
> Behalf Of Brien Dieterle
>
> Sent: Monday, September 22, 2008 6:15 PM
> To: [EMAIL PROTECTED] <[email protected]>
> 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]<[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*<http://www.rmsportal.com/>ARSlist:
> "Where the
> Answers Are" html___
>
>
>
> ________________________________________________________________________
> _______
> UNSUBSCRIBE or access ARSlist Archives at
> *www.arslist.org*<http://www.arslist.org/>
> Platinum Sponsor:
> *www.rmsportal.com*<http://www.rmsportal.com/>ARSlist: "Where the
> Answers
> Are"
>
>
>
> __Platinum Sponsor: *www.rmsportal.com*
> <http://www.rmsportal.com/>ARSlist: "Where the
> Answers Are"
> html___
>
>
> ________________________________________________________________________
> _______
> UNSUBSCRIBE or access ARSlist Archives at
> *www.arslist.org*<http://www.arslist.org/>
> Platinum Sponsor: *www.rmsportal.com*
> <http://www.rmsportal.com/>ARSlist: "Where the Answers
> Are"
>
>
>
> __Platinum Sponsor: *www.rmsportal.com* <http://www.rmsportal.com/>ARSlist:
> "Where the Answers Are"
> html___
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at
> *www.arslist.org*<http://www.arslist.org/>
> Platinum Sponsor: *www.rmsportal.com* <http://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___
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
