Security

Reply
Frequent Contributor I
Posts: 76
Registered: ‎03-09-2015

[Time Source] DB syntax in value

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].

Guru Elite
Posts: 8,000
Registered: ‎09-08-2010

Re: [Time Source] DB syntax in value

select localtimestamp(0)+ interval '90 days' as ninety_days_from_now 

Tim Cappalli | Aruba ClearPass TME
@timcappalli | ACMX #367 / ACCX #480 / ACEAP / CWSP
Frequent Contributor I
Posts: 76
Registered: ‎03-09-2015

Re: [Time Source] DB syntax in value

[ Edited ]

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

 

http://imgur.com/a/Ycz3v

Guru Elite
Posts: 8,000
Registered: ‎09-08-2010

Re: [Time Source] DB syntax in value

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.

Tim Cappalli | Aruba ClearPass TME
@timcappalli | ACMX #367 / ACCX #480 / ACEAP / CWSP
Search Airheads
Showing results for 
Search instead for 
Did you mean: