Security

Reply
Occasional Contributor II

ClearPass Time Source - Next Monday

I'm looking for assistance with adding a filter to the time source auth source. I'm looking for a filter to return the date of the next Monday.

 

If a user connects on a Monday, the time source filter would return the date of the following Monday. If the same user next connects on a Wednesday, the time source filter would still return the date of the following Monday.

 

Any help in generating the SQL syntax to place in the filter will be appreciated.

Highlighted
Occasional Contributor II

Re: ClearPass Time Source - Next Monday

If anyone was interested in the solution for their own environment, here's what I received from TAC.

 

select date_trunc('day', localtimestamp(0) + interval '1 day' * (select 8 - extract(isodow from date_trunc('hour', localtimestamp(0))) as temp)) as next_monday

 2018-09-10 12_58_52-ClearPass Policy Manager - Aruba Networks.png

 

Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: