Still no success parsing through the SMSProv log. I think I am getting closer. I think it is contained in one of the queries below.
I know that If I go to prestage a file and check the box to include dependencies, it will list the superseded packages as well, so I did that from the console and searched the smsprov log or the unique content ID. From this, I know how to see if the package is superseded or not. However, I don't know how to see WHICH packages are related and how.
Here are my results from the SMSPROV log. I am still going though them.
ExecQueryAsync: COMPLETE SELECT * FROM