Identify obsolete records in LogService.ObjectName table? How?

MIP
,
1

We have some custom SQL queries for reading XProtect log records. How do we determine which records are active and/or obsolete in the LogService.ObjectName table?

For example, if a camera name was changed from “Buidling1-Gate” to “Building1-FrontGate”, both names will be in the table. We would like to delete or ignore the obsolete record (which contains the old name).

2

Using the Surveillance SQL is not supported and the format of the SQL db is not documented.