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