Generate a CSV containing ParentObject and SPN name from BloodHound export of GetAllSPNS Query

Program.cs

using System;
using System.IO;
using System.Linq;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

namespace spns
{
    class Program
    {
        static void Main(string[] args)
        {
            string json = "";
            using (StreamReader reader = new StreamReader("allSPNS.json")){
                json = reader.ReadToEnd();
            }
            
            var parsedJSON = JObject.Parse(json);
            try{
                
                int nodeCount = 0;
                //parsedJSON["nodes"].Count(); will get you just as far, i forgot to include system.linq when i wrote this                
                foreach (var element in parsedJSON){
                    Console.WriteLine(element.Value.Count());
                    if (element.Key == "nodes"){
                        nodeCount = element.Value.Count();                        
                    }
                }

                for (int i = 0;i < nodeCount;i++){
                    string label = parsedJSON["nodes"][i]["label"].ToString();
                    for (int ii = 0;ii< parsedJSON["nodes"][i]["props"]["serviceprincipalnames"].Count();ii++){
                        Console.WriteLine(label + "," + parsedJSON["nodes"][i]["props"]["serviceprincipalnames"][ii]);
                    }
                }
            }
            catch(Exception e){

            }
        }
    }
}

Uhh, for csv output, just pipe to a file