You can safely connect a neon between live and earth.
Your cable should also have an earth wire in it, not just red and black. It may have been cut back, but it should be there. If it's not you may have more important things to worry about than telling if your lights have been left on.
Assuming it is, then connecting a neon indicator between the switched live and earth will show when it is on. You'll need to document it though, as any insulation tests will show grim, failure level, results. Even if the lights are on an RCD circuit (bad design) the current through the lamp will be nowhere near enough to cause a trip.
The switch you have may not be modifiable to change where the neon is wired, so you may have to change it to one which is, or use a grid plate system where you can choose where to wire the neon, or simply buy a small mains voltage panel neon indicator and drill a hole in the faceplate of an ordinary switch.
Your cable should also have an earth wire in it, not just red and black. It may have been cut back, but it should be there. If it's not you may have more important things to worry about than telling if your lights have been left on.
Assuming it is, then connecting a neon indicator between the switched live and earth will show when it is on. You'll need to document it though, as any insulation tests will show grim, failure level, results. Even if the lights are on an RCD circuit (bad design) the current through the lamp will be nowhere near enough to cause a trip.
The switch you have may not be modifiable to change where the neon is wired, so you may have to change it to one which is, or use a grid plate system where you can choose where to wire the neon, or simply buy a small mains voltage panel neon indicator and drill a hole in the faceplate of an ordinary switch.