I can get the scirpt id like this select * from script where scripttype = 'RESTLET' order by id desc but how can I get the script name ?

Do you mean the script “file name”?

yes

Join on the “file” table with the scriptfile column.

Thanks a lot