as many others we have had the issue that projects change PM and collaboration manager were not an auto inherited right for PM's, so we made a proces to add collaboration manager right to current PM on project update of the PM field.
A few years down the road now, we have realized that this has quite a significant impact on licenses.
So now we need to clean up and run through all projects and make sure that only the current PM is collaboration manager.
Since collaboration manager essentially is just a security group mapped the project and since you can open this group in the UI by replacing the ID in the URL i thought it might be possible to run XOG statements, updating all these groups using the complete="true" inside the members tag.
something like this:
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_group.xsd">
<Header action="write" externalSource="NIKU" objectType="group" version="188.8.131.52"/>
<group code="CLB_PROJECT_MANAGERS[+project_id]" isActive="true">
<nls description="" languageCode="en" name=""/>
<resource userName="[user_name of current PM]"/>
but I can't really get it to work.
XOG actually reports back that it has inserted records and not updated records, but i can't see that it has inserted any records.
It would of course be possible to update all users and use complete="true" on their group memberships, but it seems like a much more complex task than updating the groups.
Does anyone have experience with removing the collaboration manager right using group XOG.