Symantec IGA

  • 1.  Generate Orphan account report by Jasper

    Posted Nov 06, 2018 02:53 AM

    In IDM 14.1 Vapp
    There is the "Manage orphan account" menu in IDM userconsole.
    and i want to create the new report of "Orphan account" without to run the default report feature
    in IDM. Can i create the SQL statement from Jasper Studio to get "Orphan account" directly from IDM.



  • 2.  Re: Generate Orphan account report by Jasper

    Posted Nov 06, 2018 10:19 AM

    Where do you want to pull the SQL from? The Orphan Account Data is not in the IM object store. It's in the provisioning store. That's not accessible via SQL, only LDAP.

     

    If you have a defined snapshot, that will be in SQL and there may be a way to get the data there.



  • 3.  Re: Generate Orphan account report by Jasper

    Broadcom Employee
    Posted Nov 07, 2018 06:31 AM

    Orphan accounts report will show all the accounts associated with [default user] ( as per Default Reports - CA Business Intelligence JasperReports® Server - CA Identity Manager - 14.1 - CA Technologies Document…  ) - you can just as well get this data by running etautil command listing all lthe accounts associated with default user. You can use the etautil script given by SumeetM 

    Generate list of IM users without correlated account 

    this could be used to list all accounts associated to [default user]

     

    Regards
    Rinat Matityahu
    Principal Support Engineer
    CA Technical Support - EMEA



  • 4.  RE: Re: Generate Orphan account report by Jasper

    Posted Jan 21, 2021 10:30 AM
    the links are broken, you can update them.
    thank you