I didn't think of the meta update actually.. does it do foundation records
such as the people group permissions?
I cannot delete from the user as doing so will mean it will take off the
permissions from the user form. I do not want that to happen. Those
permissions are correct and should be as is. I cannot afford to loose that
before creating the csv data load for the PPG form. After that it wont
matter..
For eg if user dsouzaj has the following..
SQL> select group_list from user_x where login_name = 'dsouzaj';
;20311;20301;20310;20300;482;20214;20218;20219;20212;20217;20501;20500;20504;20008;20010;71001;71000;20004;20005;1102;20034;20052;20026;20041;20025;20024;20023;20029;20028;20060;402;805;812;20013;20014;809;806;20021;20020;20350;1303;20000;1;20216;20222;20002;1302;20032;20003;20007;71002;20012;1000000169;20302;20019;1400;
However until I added it manually, I had nothing in the PPG form.. I need to
generate this data in the PPG form of near 44 records, based on the contents
of group_list for dsouzaj. The above example is perfect in fact as there are
only 44 qualifying groups that need to be present in PPG for dsouzaj whereas
the user form has 50+ groups.. I need to know what are the qualifying groups
that need to be present configured for a user in PPG..
Joe
-----Original Message-----
From: Ben Chernys
Sent: Monday, May 07, 2012 3:17 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 7.6.04 Removing Permission group
Find the form in the user tool;
enter a query to delete (ie perm = xx and (person =a or person=b ...)) ;
delete.
The workflow on the form should fix up the User record's Permission Groups
without any DO field being set.
It's a 5-minute Meta-Update script if you have a list of those people in any
format at all :)
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/
www.softwaretoolhouse.com
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sanford, Claire
Sent: May-07-12 21:08
To: arslist@ARSLIST.ORG
Subject: Remedy 7.6.04 Removing Permission group
I have 470 users that I need to remove a permission set from. I tried to
use
the People Management console but that did not work. Any ideas other than
going one by one?
ITSM 7.6.04.02
ARS 7.6.0.4.03
_______________________________________________________________________________
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"