[sims] SIMS - deleted data query

[mrbios]

First of all, is there any way in sims to find out if someone deleted something that should be in the database, such as a detention? If not in sims itself, is there any way of finding this out via an SQL query?

 

I've got a student name, i know what im looking for and i know the date it was meant to be on. Quite urgently need evidence.

[Esteban_Child_of_the_Sun]

Unfortunately not, Capita advise keeping regular backups for this sort of thing, not ideal I know but the best Capita can offer for SIMS 7.

[mrbios]

So if a detention is deleted from sims, there's no way at all of knowing who deleted it? (We know who, we just need hard evidence unfortunately)

 

I don't even need to recover the deleted item, just see that it was deleted and who by. Seems really stupid that something as sensitive as the information in sims wouldn't have thorough audit logging for everything....but then this is sims.

[kennysarmy]

That age old problem...

[AlanD]

Have you asked capita? We don't use SIMS, but what we use has an Audit trail....and I'd be surprised (possibly even shocked) if SIMs didn't have something similar - with the very purpose of following up on things like that...and to help undo mistakes.

[kennysarmy]

Have you asked capita? We don't use SIMS, but what we use has an Audit trail....and I'd be surprised (possibly even shocked) if SIMs didn't have something similar - with the very purpose of following up on things like that...and to help undo mistakes.

 

Believe me, there is nothing!

 

We had an incident where attendance marks were altered, edited, wiped out - all inadvertently and we never got to the bottom of who did what and when...

[Esteban_Child_of_the_Sun]

It is theoretically possible to do forensic investigation of the SQL database's log file (assuming you don't keep your database in simple recovery mode) using a backup to find the primary key of the entry you are interested in but you'll probably need a 5 day course to learn how then a few days to understand Capita's database schema then a few days to do the investigation. I looked into the possibility a while ago and the school concluded that it would be too expensive an endeavor to undertake.

[matt40k]

You'd thought they'd created a patch to put some some SQL triggers on the tables by now. Oh, sorry, forgot... it's Capita.

[bobsmith]

It is theoretically possible to do forensic investigation of the SQL database's log file (assuming you don't keep your database in simple recovery mode) using a backup to find the primary key of the entry you are interested in but you'll probably need a 5 day course to learn how then a few days to understand Capita's database schema then a few days to do the investigation. I looked into the possibility a while ago and the school concluded that it would be too expensive an endeavor to undertake.

You mean if we don't use Capita's recommended SQL setup......

[Esteban_Child_of_the_Sun]

I did say theoretically