Security

Hi All,

during guest registration i collect attributes from a dropdown list asking the user why they are visiting. 

These are stored in a custom field in the Guest User repository indicating the reason for visiting. 

Is there any way i can run a custom report to display the stats for these users?

Currently running ClearPass 6.6

Thanks

Scott

I could not get this out in ClearPass 6.6

What we ended up doing was logging into the SQL database directly using the app external account, and dumping the endpoints table with attributes to a csv file. it took some effort but the info is there in the database. 

_ELiasz

Thanks for the suggestion, i figured out a way to do it ,would be nice to have this more integrated into a dashboard report but this will do.

Here is what i did:

• Created a Standard Report using the Guest Authentication > Guest - Auth by ClearPass option. 
• Selected the Include  Raw Data in output option in the report configuration 
• In the Raw Data Configuration the list of fileds able to be selected should include the custom field

 Then once the report runs the CSV will include the values for this field 

From here you can insert a pivot chart / table to count the values. You could then substitute the numbers for the actual descriptions in the clearpass guest option drop down list. 

I wonder if this could be somehow rolled into the dashboard or standard reporting in future. 

If anybody has a neater and less manual way to do it i'd appreciate the feedback!

Scott

Sorry my mistake, I was looking at Endpoint DB, you were looking for Guest Repo. 

I wasn't able to find a way in Insight to export custom Endpoint Attributes. 

_ELiasz

yes the custom variable is tied to the guest account and not the endpoint record. I'm sure you could do as you suggested as well provided you find the right table to query.