Hi @eerasmuss,
Take a look at this thread, which provides a data warehouse query that returns solution level results. Is this close to what you are trying to accomplish?
If yes, it might be possible to convert and slightly modify to the Security Console schema if that’s your working environment.
If no, providing an example of the information you are looking to return would be helpful.