+ Post New Thread
Results 1 to 8 of 8
MIS Systems Thread, How to find which patched are applied in SIMS in Technical; Hi Guys is there any way of checking how to find which patched are applied in SIMS?...
  1. #1
    lionsl2005's Avatar
    Join Date
    Nov 2008
    Location
    Barnet
    Posts
    567
    Thank Post
    392
    Thanked 25 Times in 24 Posts
    Rep Power
    18

    How to find which patched are applied in SIMS

    Hi Guys is there any way of checking how to find which patched are applied in SIMS?

  2. #2
    Mcshammer_dj's Avatar
    Join Date
    Feb 2007
    Location
    Portsmouth
    Posts
    971
    Thank Post
    38
    Thanked 174 Times in 139 Posts
    Rep Power
    96
    solus - login and go to SIMS information

    School Manager - Any released patches will be listed and a report run.

    Solus 3 - Don't know haven't gone to bed with the devil yet.........

  3. Thanks to Mcshammer_dj from:

    lionsl2005 (24th June 2013)

  4. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,817
    Thank Post
    731
    Thanked 1,447 Times in 1,200 Posts
    Rep Power
    361
    I run this code

    Code:
    use sims
    select *
    from sims.db_update_log
    order by update_log_id desc
    Or you can order by date_applied
    Last edited by vikpaw; 24th June 2013 at 05:13 PM.

  5. #4

    Join Date
    Jun 2008
    Location
    Worcester
    Posts
    12
    Thank Post
    1
    Thanked 4 Times in 4 Posts
    Rep Power
    14
    With the following query in SQL Management Studio against the SIMS database (although I cannot confirm this also works with Solus3 patches).
    select patch_id, date_applied, description from sims.db_update_log where successful = 'T'

    You then add to the end how you want it sorted:
    order by patch_id if you are looking for a specific patch
    order by date_applied if you want to see patches by date order
    add DESC at the end of the order by command to reverse the order.


    D'Oh! was 2 minutes too slow.
    Last edited by Drenlin; 24th June 2013 at 05:15 PM.

  6. #5
    lionsl2005's Avatar
    Join Date
    Nov 2008
    Location
    Barnet
    Posts
    567
    Thank Post
    392
    Thanked 25 Times in 24 Posts
    Rep Power
    18
    Thanks

  7. #6

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,967
    Thank Post
    1,212
    Thanked 1,075 Times in 766 Posts
    Rep Power
    332
    @lionsl2005:

    Solus 3 = Deployment history, latest patches deployed will be registered and if they were successful on which date and on which database.

    Quote Originally Posted by Mcshammer_dj View Post
    Solus 3 - Don't know haven't gone to bed with the devil yet.........
    I have gone to bed with it and what a devil it is hehe!

  8. #7
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by Mcshammer_dj View Post
    solus - login and go to SIMS information
    For info, this method only shows patches applied after the last main upgrade you received.

  9. Thanks to Rawns from:

    lionsl2005 (25th June 2013)

  10. #8

    Join Date
    Jan 2007
    Posts
    100
    Thank Post
    0
    Thanked 34 Times in 23 Posts
    Rep Power
    21
    You can also show just patches for the previous year, or change the no of days (365 in example below) as required.

    SELECT patch_id, description, date_applied from sims.db_update_log where datediff(dd, date_applied, getdate()) <= 365 ORDER BY patch_id desc

  11. Thanks to Greg from:

    lionsl2005 (26th June 2013)



SHARE:
+ Post New Thread

Similar Threads

  1. How to find out which machine a student logged onto, & when
    By indiegirl in forum How do you do....it?
    Replies: 32
    Last Post: 16th March 2012, 02:17 PM
  2. How to tell which users are logged on
    By Little-Miss in forum Wireless Networks
    Replies: 5
    Last Post: 5th January 2009, 04:59 PM
  3. how to find mac addresses?
    By FN-GM in forum Wireless Networks
    Replies: 9
    Last Post: 7th September 2007, 08:24 AM
  4. How to find Command Bar ID's in Office 2003
    By originofsymmetry in forum How do you do....it?
    Replies: 1
    Last Post: 15th July 2007, 11:41 PM
  5. Replies: 16
    Last Post: 29th March 2006, 04:52 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
  •