By David Crowther
Question:
How can you identify the date of the last updates that I have made within the DynamicMaps Address & Street Management Application?
Answer:
Within the DynamicMaps Address & Street Management Application when you view the Address records, the main table shows you each record in your LLPG.
The last column shown on the right-hand side shows the Update date.
Simply click on the Update field name to sort the records into date order….either to show you the records by oldest or latest update date.
This is a great way to double check when the last records were updated in your LLPG!
For backend administrators of the LLPG, a journal log is also kept in database tables which record all updates to the LLPG, LPIs and LSG. Running a SQL script like the below…
Select top 50 * FROM [dbo].[NLPG_BLPU_JN] order by JN_DATETIME desc
… will identify the most recent changes to the database.