+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, Track when a Change of Address was made in Technical; Does any body know how you can track who has made a change of address in Sims? Currently got an ...
  1. #1

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348

    Track when a Change of Address was made

    Does any body know how you can track who has made a change of address in Sims?

    Currently got an awkward case (with solicitor parent!!) where a change was made (i know it had been as i saw it being done and we double checked about 5 times due to the nature of the case) but Sims is now showing the parent living back at the old address?

    Any Ideas?

    Toby

  2. #2

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,201
    Thank Post
    174
    Thanked 371 Times in 301 Posts
    Rep Power
    173
    There are very few logs of changes by users. The only one that works well is Dinner Money. Anything else would produce some huge log files.

    I would have thought the fact you witnessed it would be enough.

  3. #3
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Quote Originally Posted by glennda View Post
    Does any body know how you can track who has made a change of address in Sims?

    Currently got an awkward case (with solicitor parent!!) where a change was made (i know it had been as i saw it being done and we double checked about 5 times due to the nature of the case) but Sims is now showing the parent living back at the old address?

    Any Ideas?

    Toby
    This may have happened by accident if somebody did not know when to use the Edit Address routine or the Move House routine. Using the wrong one at the wrong time can result in other changes being made for anybody ever connected to the address that is being changed.
    See KB50243 - Modifying the address of one pupil changes another. Random address changes. on SupportNet

  4. #4


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,619
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223
    Sivadam's explanation is most likely, and yes it gets awkward if someone messes it up and the "move" is due to divorce / separation.

  5. #5

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    Sorry should have made myself clearer - rereading i made a mistake - its for a contact rather then a pupil.

    Toby

  6. #6

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    Quote Originally Posted by glennda View Post
    Sorry should have made myself clearer - rereading i made a mistake - its for a contact rather then a pupil.

    Toby
    I think to answer the original point, there is very little tracking/logging available in SIMS, certainly none for address changes.

  7. #7

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    Quote Originally Posted by GREED View Post
    I think to answer the original point, there is very little tracking/logging available in SIMS, certainly none for address changes.
    Ahh not to worry was worth a shot!

  8. #8

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Isn't there a history for addresses? at the least a date for when they 'moved' there would allow you to narrow down the date it reverted??
    Then, though it's unlikely, try and track it down based on that date / time, and who was logged in at the time, sql server could have logs of logins.
    plus there is some logging available in system manager but i only got it to run once with very very narrow filters, the only other person who i've heard of that gets it to work is @bossman.
    Probably not any help, but worth a punt.

  9. #9

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    Quote Originally Posted by vikpaw View Post
    Isn't there a history for addresses? at the least a date for when they 'moved' there would allow you to narrow down the date it reverted??
    That's true Vik, but it could depend on the circumstances, ie if it was changes rather than through the 'moved house' procedure.

  10. #10

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    Quote Originally Posted by GREED View Post
    That's true Vik, but it could depend on the circumstances, ie if it was changes rather than through the 'moved house' procedure.
    Basicly we Know it was changed but want to know who did it!!

    I think they may have worked out who has done it anyway!

    Thanks Guys

  11. #11

    creese's Avatar
    Join Date
    Feb 2009
    Location
    -28 31' 48.89", +28 25' 37.42" ... if only.
    Posts
    3,201
    Thank Post
    174
    Thanked 371 Times in 301 Posts
    Rep Power
    173
    Quote Originally Posted by glennda View Post
    Basicly we Know it was changed but want to know who did it!!

    I think they may have worked out who has done it anyway!

    Thanks Guys
    This is something that crops up quite a lot. Sadly there is no way to deal with it other than tighten the security and restrict access.

  12. #12

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,786
    Thank Post
    272
    Thanked 1,130 Times in 1,026 Posts
    Rep Power
    348
    Quote Originally Posted by creese View Post
    This is something that crops up quite a lot. Sadly there is no way to deal with it other than tighten the security and restrict access.
    Hmm i was hoping SQL/sims had some sort of change tracking just like exchange does - unfortuantly this isnt the case!!

  13. #13

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    2,938
    Thank Post
    361
    Thanked 354 Times in 290 Posts
    Blog Entries
    8
    Rep Power
    172
    You could probably get SQL to record this directly, away from SIMS... but after the effort of that is it worth it?

SHARE:
+ Post New Thread

Similar Threads

  1. Talk to a 192.168 address from a 10.0 address
    By mattx in forum Wireless Networks
    Replies: 10
    Last Post: 17th August 2010, 12:12 PM
  2. Keeping track of workstation IP address history
    By Diatom in forum Windows Server 2000/2003
    Replies: 2
    Last Post: 24th June 2010, 06:55 PM
  3. Change DC ip address
    By duxbuz in forum How do you do....it?
    Replies: 1
    Last Post: 1st March 2010, 04:40 PM
  4. IP Address change in AD Integrated domain
    By albertwt in forum Windows Server 2000/2003
    Replies: 5
    Last Post: 18th June 2009, 12:18 AM

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
  •