Abort all users sessions after midnight

Viewpoint
New Member

Abort all users sessions after midnight

Dear All,

 

I have to find a way to kill all sessions that users name starts with "PL..." on midnight. I believe that it can by setup on ViewPoint.

Can someone tell me where I can find that option?

 

query for that will be like:

sel TRIM('SYSLIB.AbortSessions (-1, ''*'',')||CAST(SessionNo AS INT)||', ''Y'', ''Y'');' from Dbc.SessioninfoV WHERE Username LIKE 'PL1%'

 

1 REPLY
Teradata Employee

Re: Abort all users sessions after midnight

Viewpoint doesn't have a function to do it right now. We can set up alert to abort sessions with some account name but couldn't set it to do the abort at certain time.

 

You might need to consult with PS team to do it through PM/API.

 

You can also open a RFC request through TAYS for viewpoint.

 

Hope this helps.