[sims] How to find which patched are applied in SIMS

[lionsl2005]

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

[Mcshammer_dj]

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.........

[vikpaw]

I run this code

 

use sims
select *
from sims.db_update_log
order by update_log_id desc

 

Or you can order by date_applied

Edited June 24, 2013 by vikpaw

[Drenlin]

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.

Edited June 24, 2013 by Drenlin

[lionsl2005]

Thanks

[bossman]

@lionsl2005:

 

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

 

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!

[Rawns]

solus - login and go to SIMS information

 

For info, this method only shows patches applied after the last main upgrade you received.

[Greg]

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