History of changes to site Properties
182
Views
3
Comments
New
Service Center

History of changes to site Properties, having the possibility to know who and when changed the site property and consult previous values.

Changed the category to
Service Center

For traceability effects this is actually a really good idea! 

You can read site property changes from the general audit log using SQL, but this is clunky and I agree Service Centre should have a better way of handling this.

with cte as

(

  select * from oslog_general_0 with (nolock)

  union select * from oslog_general_1 with (nolock)

  union select * from oslog_general_2 with (nolock)

  union select * from oslog_general_3 with (nolock)

  union select * from oslog_general_4 with (nolock)

  union select * from oslog_general_5 with (nolock)

  union select * from oslog_general_6 with (nolock)

  union select * from oslog_general_7 with (nolock)

  union select * from oslog_general_8 with (nolock)

  union select * from oslog_general_9 with (nolock)

)

select top(20) *

from cte

where Espace_Id = 0

        and Message_Type = 'INFO'

        and message like '%site property%'

order by Instant desc