last person joined: an hour ago 

Enterprise security using ClearPass Policy Management, ClearPass Security Exchange, IntroSpect, VIA, 360 Security Exchange, Extensions and Policy Enforcement Firewall (PEF).
Expand all | Collapse all

ClearPass Time Source Attributes

Jump to Best Answer
  • 1.  ClearPass Time Source Attributes

    Posted Aug 18, 2020 02:09 PM

    I am looking to add an additional attribute to the Time Source in ClearPass.  I would like to have an attribute for 12 months to use for the MAC-Auth Expiry for guest registrations.  When I try to add the 12 month attribute following the same pattern as the 6 month attribute I get a SQL error.  


    Does anyone have the correct syntax to add the attribute for 12 months?

    Screen Shot 2020-08-18 at 11.02.41 AM.png

    Screen Shot 2020-08-18 at 11.02.53 AM.png

  • 2.  RE: ClearPass Time Source Attributes
    Best Answer

    Posted Aug 18, 2020 02:16 PM

    Always create a custom filter. Don't add to the existing one.


    SELECT date_trunc('hour', localtimestamp(0)+ interval '365 days') as one_year


  • 3.  RE: ClearPass Time Source Attributes

    Posted Aug 18, 2020 04:47 PM

    Thanks so much for that, it worked like a charm!!