+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Finding out who is deleting my stuff In SIMS in Technical; Hi All I need a bit of advice. I have noticed that someone is deleting things on SIMS that I'm ...
  1. #1

    Join Date
    Mar 2013
    Posts
    168
    Thank Post
    42
    Thanked 6 Times in 5 Posts
    Rep Power
    23

    Finding out who is deleting my stuff In SIMS

    Hi All

    I need a bit of advice. I have noticed that someone is deleting things on SIMS that I'm doing. Now there may be a tiny wenny chance that something is wrong with the database/with SIMS but I need to make sure for my own protection that someone is not trying to get me into trouble.

    I went into Focus - System Manager - User Acess Log to see if I can find anything but all it tell me is that someone logged into SIMS but not details of what they have done in SIMS.

    Could anyone help me and advice me on the best way of getting to the bottom of this as this is a new job as well and I'm afraid that if this continues it is not only going to create extra work but also I will get into trouble.

    Thanks

  2. #2

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    2,002
    Thank Post
    116
    Thanked 510 Times in 344 Posts
    Blog Entries
    2
    Rep Power
    288
    First, tell your manager that you suspect the database isn't behaving properly. He must be made aware now. Don't cast aspersions or speculate - it's doesn't matter what you think, or even what you know, it's what you can prove.
    Keep a journal of your actions, and if you find something odd, show it to your manager who should then try to get to the bottom of it.

    There are quite a few SIMS experts on here who will be able to tell you if more comprehensive logging is available.
    Last edited by jinnantonnixx; 20th September 2013 at 11:01 AM.

  3. Thanks to jinnantonnixx from:

    vikpaw (20th September 2013)

  4. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    Logging is rubbish and there is no audit.
    Jinn's advice is good, declare an issue.
    What is your role with SIMS, what are your permissions and what is changing?
    The access log can help with who is logged in when, and you used to be able to tell what module was used. In practise it will be hard, but depends in what is changing as some fields have history which at least might log date and time.
    Registers should be audited but I've never trusted they tell the true situation.

  5. #4

    Join Date
    Jan 2007
    Posts
    100
    Thank Post
    0
    Thanked 34 Times in 23 Posts
    Rep Power
    21
    What kind of data, this could give an indication of motive (if it's not a technical issue).

    Have you checked the data is there after you have saved it to make sure it is not an issue with data entry (technical or user, I've seen both).

    If this is happening regularly then you can see if data has been deleted be restoring SIMS to a new standalone server and restoring from a relevant backup to show that the data was there.

    SIMS logs are useless, your SIMS manager will know who has data editing rights to the relevant areas in SIMS, SQL Profiler could help with who is doing what but it's not that friendly.

  6. #5

    Join Date
    Mar 2012
    Posts
    46
    Thank Post
    17
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    You can run a change history on certain fields - what is altering?

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 18th March 2011, 06:29 PM
  2. How to find out who deleted what
    By Chrish5 in forum Windows
    Replies: 9
    Last Post: 17th October 2008, 10:37 AM
  3. finding out who has logged into a PC in AD
    By Oops_my_bad in forum Windows
    Replies: 6
    Last Post: 22nd November 2007, 03:51 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •