Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
SecurID® Governance & Lifecycle Recipes
SecurID Governance & Lifecycle recipes is a collection of items, to help you get the most out of your product deployment. For example, a useful report with the SQL to implement or a way to achieve some advanced rule processing.
As part of v7.2x, the RSA IGL team introduced a new telemetry feature, which has some awesome information as part of it. This telemetry data is collected every night and is really useful for using when creating new charts/reports.
The data is all found in this new view: PV_TELEMETRY_DATA
SO WHAT? why do I care about this table and the data?
Good question! The main reasons are that:
This data is collected for you and is much easier to access then creating your own SQL queries. Its all found in a single view = PV_TELEMETRY_DATA
Its also a lot faster, as the data is pre-calculated and stored, so less of a burden on system resources overall (e.g.. you are not running lots of complex SQL queries, across multiple different tables)
OK, tell me more...
The telemetry data that is collected, is broken out into various specific category's (shown below).
Within each category, there are various "names" of items, that are being collected each day.
The category's include the following product areas:
To get a FULL list of all the different options available, please run the following query within your environment (I use SQL Developer):
selectdistinct category, name from PV_TELEMETRY_DATA orderby category, name asc ;
Example screen shot:
Its worth noting that some of the data is collected per item as well, for example per application or AFX connector. So there is a lot of granular data being collected that is specific to your environment too.
Lets say we wanted to look at the total number of completed review items within your environment.
category = 'reviews'
name = 'completed.items.total'
This is the SQL we could use, to gather this data:
selectdistinct * from PV_TELEMETRY_DATA where category ='reviews' and name ='completed.items.total' orderby day desc ;
As we can see when we run this SQL, the "value" changes over the days, from 84 on 19th Sept, then to 85 on 23rd Sept and onto 95 on the 30th Sept.