Reporting on Reports....

[#1]

A common question we get asked... "How many reports are there within RSA IGL"

The answer: LOADS!

Within RSA IGL we have a LOAD of out the box (OTB) reports included and shipped as standard.

All these reports can be found in the UI, by going to “Reports/Tabular” then “Create Report” button at the top.

From here you can find a lot of OTB reports by using the “type” and “Template” dropdowns.

For example, if you wanted a report on all your orphan accounts, you would select “Account” and then “Orphaned Accounts” - thats it! really simple

If you want a simple way to see all the reports you have in the system overall, you can execute the following query, either within something like SQL Developer or create a new a report within the UI itself

Main Query:

Select * from V_LIST_REPORTS;

This table tells you all the reports you have in your enviroment, both OTB and any you have also created as well.

Steps to create this in the UI are as follows

Note: this takes <5minutes to complete

1. Log in as an admin user or as a user who can create reports
2. Go to “Reports/Tabular”
3. Click “Create Report” button
   
4. Give you report a title and some details so you know what its for in future.
   
   
   
5. Click the “Query” tab at the top
6. Add the following SQL query:
   

   (select *  from avuser.V_LIST_REPORTS)

   Note: makes sure you wrap you the SQL in parenthesis “(“ and “)”

   
7. Click the “Columns” tab
8. Select only the following columns in the right-hand pane called “Displayed Columns” – everything else should be moved to the right.
   • Name
   • Report Description
   • Report Title
   • Last Modified Date
9.    Click on “preview” button at the bottom to check its worked.
   
   

   These are more nice to have changes, that might make the report look a bit better, in my opinion

10. Go to the “Grouping and Sorting” tab
11. Select “Report Type” under Grouping, so that we can see the groups of reports we have created
    
    
    
    

12. Click the “style” button at the bottom of the row

13. Select “slate”

14. Click "OK" to save and exit your report

Thats it, all done!