Collection report: Long Unchanged Accounts

Last modified 25 Apr 2024 10:39 +02:00

Please see Report configuration for basic information about configuration variables.

Example Use-case

We need to create a report of users which account attributes have not changed for some time.

Configuration

The configuration consists of an object collection and report definition.

Object collection XML

Git

<?xml version="1.0" encoding="UTF-8"?>
<!--
  ~ Copyright (c) 2010-2024 Evolveum
  ~
  ~ Licensed under the Apache License, Version 2.0 (the "License");
  ~ you may not use this file except in compliance with the License.
  ~ You may obtain a copy of the License at
  ~
  ~     http://www.apache.org/licenses/LICENSE-2.0
  ~
  ~ Unless required by applicable law or agreed to in writing, software
  ~ distributed under the License is distributed on an "AS IS" BASIS,
  ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  ~ See the License for the specific language governing permissions and
  ~ limitations under the License.
  -->

<objectCollection oid="da51efb6-7d8d-43e5-9ea9-c55cf9b528e0">
    <name>Account shadow-raw</name>
    <type>ShadowType</type>
    <filter>
        <and>
            <ref>
                <path>resourceRef</path>
                <value oid="ef2bc95b-76e0-59e2-86d6-9999cccccccc"/>
            </ref>
            <equal>
                <path>kind</path>
                <value>account</value>
            </equal>
            <less>
                <path>synchronizationTimestamp</path>
                <value>2024-04-01T08:10:30.693+02:00</value>
            </less>
        </and>
    </filter>
    <getOptions>
        <option>
            <options>
                <raw>true</raw>
            </options>
        </option>
    </getOptions>
</objectCollection>
Report XML

Git

<?xml version="1.0" encoding="UTF-8"?>
<!--
  ~ Copyright (c) 2024 Evolveum
  ~
  ~ Licensed under the Apache License, Version 2.0 (the "License");
  ~ you may not use this file except in compliance with the License.
  ~ You may obtain a copy of the License at
  ~
  ~     http://www.apache.org/licenses/LICENSE-2.0
  ~
  ~ Unless required by applicable law or agreed to in writing, software
  ~ distributed under the License is distributed on an "AS IS" BASIS,
  ~ WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  ~ See the License for the specific language governing permissions and
  ~ limitations under the License.
  -->
<report xmlns="http://midpoint.evolveum.com/xml/ns/public/common/common-3"
        xmlns:c="http://midpoint.evolveum.com/xml/ns/public/common/common-3"
        xmlns:icfs="http://midpoint.evolveum.com/xml/ns/public/connector/icf-1/resource-schema-3"
        xmlns:org="http://midpoint.evolveum.com/xml/ns/public/common/org-3"
        xmlns:q="http://prism.evolveum.com/xml/ns/public/query-3"
        xmlns:ri="http://midpoint.evolveum.com/xml/ns/public/resource/instance-3"
        xmlns:t="http://prism.evolveum.com/xml/ns/public/types-3"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        oid="1332760d-12b1-4f80-ad2f-8446c4e17853">
    <name>Unchanged accounts</name>
    <assignment>
        <targetRef oid="00000000-0000-0000-0000-000000000171" relation="default" type="ArchetypeType">
            <!-- Collection report -->
        </targetRef>
    </assignment>
    <archetypeRef oid="00000000-0000-0000-0000-000000000171" relation="default" type="ArchetypeType">
        <!-- Collection report -->
    </archetypeRef>
    <roleMembershipRef oid="00000000-0000-0000-0000-000000000171" relation="default" type="ArchetypeType">
        <!-- Collection report -->
    </roleMembershipRef>
    <objectCollection>
        <collection>
            <collectionRef oid="da51efb6-7d8d-43e5-9ea9-c55cf9b528e0" relation="default" type="ObjectCollectionType">
                <!-- Account shadow R2 RAW -->
            </collectionRef>
        </collection>
        <view>
            <identifier>default-shadow</identifier>
            <column>
                <name>nameColumn</name>
                <path>name</path>
            </column>
            <column>
                <name>resourceRefColumn</name>
                <path>resourceRef</path>
                <previousColumn>nameColumn</previousColumn>
            </column>
            <column>
                <name>kindColumn</name>
                <path>kind</path>
                <previousColumn>resourceRefColumn</previousColumn>
            </column>
            <column>
                <name>intentColumn</name>
                <path xmlns="http://midpoint.evolveum.com/xml/ns/public/common/common-3">intent</path>
                <previousColumn>kindColumn</previousColumn>
            </column>
            <column>
                <name>synchronizationSituationColumn</name>
                <path>synchronizationSituation</path>
                <previousColumn>intentColumn</previousColumn>
            </column>
            <type>ShadowType</type>
        </view>
        <useOnlyReportView>true</useOnlyReportView>
    </objectCollection>
</report>
Was this page helpful?
YES NO
Thanks for your feedback