Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dffe
Engaged Sweeper
I was wondering if it is possible with a store procedure or something to delete computers LanSweeper havent heard from in X days?

Currently am I doing this manually from the Report Viewer or what it is called.. but this isnt a good solution in the long run as I would like it automated... any suggestions?
1 REPLY 1
Hemoco
Lansweeper Alumni
should be something like
delete from tblcomputers where lastseen < getdate()-60

(not checked for syntax errors)