Two identical records on the People permission group form could have a
problem actually I think.. if you delete one of the records, it would delete
it from the user form, but the other record would still remains on the PPG
form depending on what the query is to delete the record that is selected to
be deleted...
This may create application level problems as the application would think a
user is a member of a group he is no longer really a member of..
That’s my theory.. not really checked it out..
Is meta update a paid tool. If so could you run the numbers by me? If it is
a requirement, I may be able to get them to consider it given this problem
we have. I'm hoping to offer them a SQL based resolution - it might only be
a little longer to resolve it that way as its something I'll need to develop
from scratch..
There are no known issues with the actual permissions on the User form. None
of those have been lost without deliberately removing them. Its just that
the PPG form doesn't have some of the records which got modified to create
the Unrestricted Access records for new users.
Joe
-----Original Message-----
From: Ben Chernys
Sent: Monday, May 07, 2012 4:24 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Remedy 7.6.04 Removing Permission group
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;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"
_______________________________________________________________________________
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"
