Automate Empty Database once per year

Apr 23, 2015 at 3:28 PM
Is it possible to automate (Windows Scheduled task or MS SQL job ) the WinAudit.exe advanced function of Deleting all data within the WinAudit database?
Coordinator
Jun 15, 2015 at 4:53 PM
Hi Jastronomy,

(Still can't get the FireFox No-Script plugin to work properly with Codeplex. I always have Javascript disabled, if sites don't work, that's just too bad for me.)

I'd be relucant to implement this as always a bit shy to delete everything from a database. Since this would be a once a year task, I think it would be far safer for you to manually empty the data tables. The schema is very simple. There are only three tables: Audit_Data, Audit_Master and Computer_Master. If you haven't added any of your own objects then you could DROP the database and get WinAudit to create a fresh one. This would have the advantage of reseting the auto/identity counters.


Steven