Security

last person joined: yesterday 

Forum to discuss Enterprise security using HPE Aruba Networking NAC solutions (ClearPass), Introspect, VIA, 360 Security Exchange, Extensions, and Policy Enforcement Firewall (PEF).
Back to discussions
Expand all | Collapse all

[Time Source] DB syntax in value

This thread has been viewed 1 times

  • 1.  [Time Source] DB syntax in value

    Posted Sep 30, 2016 11:34 AM

    Hi folks,

    I want to create an attribute that equals the following value.

    'Current Date/Time + 90days'.

    How can I use [Time Source] local SQL DB to do this ? What is the value syntax to build that using [Time Source].



  • 2.  RE: [Time Source] DB syntax in value

    EMPLOYEE
    Posted Sep 30, 2016 11:36 AM 
    select localtimestamp(0)+ interval '90 days' as ninety_days_from_now


  • 3.  RE: [Time Source] DB syntax in value

    Posted Sep 30, 2016 11:40 AM

    So I can just paste that line in my highlighted red area ? Screenshot below

     

    http://imgur.com/a/Ycz3v



  • 4.  RE: [Time Source] DB syntax in value
    Best Answer

    EMPLOYEE
    Posted Sep 30, 2016 11:43 AM
    No, you would need to add it as a custom attribute to your Time Source auth
    source, then add the parameterized string to your enforcement profile.