Re: Removing stale expired accounts from SQL

2013/6/4 Ethan Hayon <ehayon@gmail.com>:

Hi, Thanks for the response.

I only want to run the SQL query if the user's account is already expired. Wouldn't I need to put it in here?

No, You can adapt the instruction I gave you to delete the entries based on the attributes you want to check for a "stale expired account". You could do, for instance: if(User-Name){ "%{sql:DELETE FROM radreply WHERE username='%{User-Name}' AND attribute='%{WhatEverYouUse} AND value='%{Calling-Station-Id}' }" } -- Roney Eduardo