[EAS] configuring idmrpt_dc_service_cfg_v questions


Hi guys,

Product : IDM 4.0.2
UserApp : Yes
Reporting Module : Yes

So, currently we have a complete idm solution, using both userApp and
Reporting Module(Patch E). We have total of 7 reports, 5 of them are
gathering data from the public schema of the EAS postgres db. the
another 2 is using views from idm_rpt_cfg schema.

Based on previous experience, it has been noted that those table under
public schema is already harden for 3 months purge. This issue we
already have our own work around.

Now the current question is can we set our custom retention period for
those tables under idm_rpt_data? Since my report are pulling data from
views under idm_rpt_cfg, which this views are pulling data from tables
under idm_rpt_data schema(under SIEM db of course). If canis there any
is the maximum rentention period that can be set?

Note: from Identity Reporting Module Guide,Identity Manager 4.0.2, it
say that the table idmrpt_dc_service_cfg_v will show the Contains
information about the reporting data collection service configuration.
this view is pointing to the table idmrpt_dc_service_cfg. I have not
done any changes to this tables yet, awaiting any approval

Current settings:
182


----------------------------------------------------------------------
|Filename: retention.JPG |
|Download: https://forums.netiq.com/attachment.php?attachmentid=182 |
----------------------------------------------------------------------

--
kevinjit_singh
------------------------------------------------------------------------
kevinjit_singh's Profile: https://forums.netiq.com/member.php?userid=7415
View this thread: https://forums.netiq.com/showthread.php?t=51475

  • On 08/06/2014 12:59 AM, kevinjit singh wrote:
    >
    > Hi guys,
    >
    > Product : IDM 4.0.2
    > UserApp : Yes
    > Reporting Module : Yes
    >
    > So, currently we have a complete idm solution, using both userApp and
    > Reporting Module(Patch E). We have total of 7 reports, 5 of them are
    > gathering data from the public schema of the EAS postgres db. the
    > another 2 is using views from idm_rpt_cfg schema.
    >
    > Based on previous experience, it has been noted that those table under
    > public schema is already harden for 3 months purge. This issue we
    > already have our own work around.
    >
    > Now the current question is can we set our custom retention period for
    > those tables under idm_rpt_data? Since my report are pulling data from
    > views under idm_rpt_cfg, which this views are pulling data from tables
    > under idm_rpt_data schema(under SIEM db of course). If canis there any
    > is the maximum rentention period that can be set?
    >
    > Note: from Identity Reporting Module Guide,Identity Manager 4.0.2, it
    > say that the table idmrpt_dc_service_cfg_v will show the Contains
    > information about the reporting data collection service configuration.
    > this view is pointing to the table idmrpt_dc_service_cfg. I have not
    > done any changes to this tables yet, awaiting any approval
    >
    > Current settings:
    > 182
    >
    >
    > ----------------------------------------------------------------------
    > |Filename: retention.JPG |
    > |Download: https://forums.netiq.com/attachment.php?attachmentid=182 |
    > ----------------------------------------------------------------------
    >

    Greetings,

    1) EAS will only keep Audit data for 90 days. That is expected
    behavior. It is is not an "issue". It is the way the product is designed.

    2) Vault Data, which is pushed from the DCS driver is kept forever
    (unless you issue the rest call to purge it)

    3) Managed or Non-Managed System data that is collected (Data
    Collection), will be kept based upon the setting in the database. You
    can control this by logging into the Reporting Module, press the
    Settings link, then look at the settings for "Keep collected reporting
    data for"


    The default value 365 days. Which is what the screenshot you provided
    is showing. I am not sure where you are getting the value of 182.


    To summarize, there are three (3) different data retentions in EAS
    depending upon which type of "data":

    A) Audit data will only ever be kept for 90 days
    B) Vault data will be kept forever (unless the database is purged)
    C) Managed data will only be kept based upon the setting "Keep collected
    reporting data for"


    --

    Sincerely,
    Steven Williams
    Lead Software Engineer
    NetIQ

  • based on ur summary..
    A) Audit data will only ever be kept for 90 days
    B) Vault data will be kept forever (unless the database is purged)
    C) Managed data will only be kept based upon the setting "Keep
    collected
    reporting data for"

    can i asssume all this data/table will be in..
    A)public schema
    B)idm_rpt_cfg schema
    C)idm_rpt_data schema

    A), B), and C) under SIEM db, under EAS postgres

    Please clarify, thanks


    --
    kevinjit_singh
    ------------------------------------------------------------------------
    kevinjit_singh's Profile: https://forums.netiq.com/member.php?userid=7415
    View this thread: https://forums.netiq.com/showthread.php?t=51475