Clearing down the contents library folder in SCCM 2012

[Tinribs]

Morning All

We ran out of disk space on our SCCM server D: drive last week. I managed to free up enough to do what I needed but I need to get more free if I can. Our contents library folder is 275GB and I'm sure there must be some orphaned stuff in there that can be got rid of.

I ran the cleancontentslibrary tool in what-if mode. The first time I ran it the tool failed when it found a distribution package that hadn't completed its distribution. I managed to find and delete that package. Ran the tool again and it came up with another package that had not worked properly. I couldn't find that package in SCCM via the console so I did some research and found it using a SQL query. I know now the name and ID of the package but I cannot find it anywhere in SCCM using the console. I'm pretty sure it can be deleted but I'd like to check it first if possible but more importantly I'd like to delete it. I assume this can be done with powershell or SQL but I can't find a simple way to do it. I'm not at all experienced with SQL or powershell.

Anyone know a) how to find the package's precise location within SCCM and b) how to delete it from SCCM without finding it in the console if a) fails