Yes. Meta-Update can update (or extract) any data - foundation, CMDB, "Root Requests" or bespoke data.
In 2 minutes you could have your CSV from the user form for any list of people that you had. You could even exclude those groups where a permission record exists. No updates to ARS data needed. You could possibly hard-code licenses and other data so that instead of the CSV you could create the people permission records with the script. There is no reason to delete from the user form. The only issue is as I've said: how to fill in extra data and records (remember that you can have the same permission twice and it would only be in the user tool once). Plus the package includes other utilities that would help you determine what is your situation (i.e. are some people's user permission groups wrong? Or is it exactly as you say that all permission groups in the user tool are valid and people permission groups records are missing? Cheers Ben www.softwaretoolhouse.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: May-07-12 21:42 To: arslist@ARSLIST.ORG Subject: Re: Remedy 7.6.04 Removing Permission group 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;2002 4;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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
smime.p7s
Description: S/MIME cryptographic signature