Symantec IGA

  • 1.  Where are Snapshots in the SQL DB tables

    Posted Feb 12, 2016 12:31 PM

    We take snapshots on a regular basis, and run reports against them.

    We have a number of snapshots (about 10-15) that we see in the IdMgr GUI when running reports.

    Does anyone know where the snapshot entry itself (not the snapshot data) is located in the SQL database tables ?

    Which table?

    We have looked in the Reports database, and see the imrptsnapshots12 table, but that is not it.

    We have also looked in the IM database, and reviewed the SNAPSHOT_TYPE and SNAPSHOT_TYPE_LD tables, and that is not it either.

     

    Is there an architecture diagram of how IdMgr snapshots work?

    Which tables contain the snapshot entries?



  • 2.  Re: Where are Snapshots in the SQL DB tables

    Broadcom Employee
    Posted Feb 19, 2016 01:41 PM

    Hello,

      Because they are a scheduled task these would be in the quartz tables.

    Capture.JPG

     

      You should be able to find them in the JOB_DETAILS

     

      However editing them from the object store is not suggested, So I am unsure why this information is needed. Are you looking for something in particular?

     

    Thanks,

    Bill



  • 3.  Re: Where are Snapshots in the SQL DB tables
    Best Answer

    Posted Feb 22, 2016 03:20 PM

    Thanks... but we found them in the imreport6 table....