I would like to be able to validate the existence of CCTV survey videos linked to CCTV Surveys.
I have found a CCTV survey that has an invalid "Media_Label". In this case I believe the .mpg file was renamed after the survey was submitted since the video name in the .xml file does not match the saved video. A way to select CCTV surveys referencing invalid CCTV video files would be very helpful.
This might be something that needs to be pre-processed on the InfoAsset Manager side of things but would be nice if InfoAsset Planner users could run the query themselves.
