Detect which nuget packages are part of the .NET runtime or the .NET SDK

[bitbonk]

When we analyze the transitive nuget dependencies of a solution, we get a list like the example below. Is there a way to generate such a list of all transitive dependencies recursively for the solution but by excluding all the packages that come from (are part of) the .NET Runtime and .NET SDK?

Use cases:

1. We want to generate a report for our customers what external nuget packages our proprietary framework depends on. But we don't want to list the indiviual .NET Runtime, BCL, SDK nuget packages individually, we just want to say "we depend on .NET 8".
2. In the context of SBOM security analysis we would like to have the general .NET CPE as our dependency.
3. We are maintaining our own in-house "approved" nuget feed that contains only a small subset of nuget.org. It is not allowed to release anything that contains nuget packages that are not part of this feed and hence nuget.org cannot be used as package source directly. Now we want to add all of the .NET BCL, Runtime, SDK packages to that feed, whenever a new version of .NET is released. But how do we find them?

Castle.Core
FluentAssertions
Humanizer.Core
Microsoft.Bcl.AsyncInterfaces
Microsoft.Build.Tasks.Git
Microsoft.CodeAnalysis.Analyzers
Microsoft.CodeAnalysis.Common
Microsoft.CodeAnalysis.CSharp
Microsoft.CodeAnalysis.PublicApiAnalyzers
Microsoft.CodeAnalysis.Workspaces.Common
Microsoft.Extensions.Configuration
Microsoft.Extensions.Configuration.Abstractions
Microsoft.Extensions.Configuration.Binder
Microsoft.Extensions.Configuration.CommandLine
Microsoft.Extensions.Configuration.EnvironmentVariables
Microsoft.Extensions.Configuration.FileExtensions
Microsoft.Extensions.Configuration.Ini
Microsoft.Extensions.Configuration.Json
Microsoft.Extensions.Configuration.UserSecrets
Microsoft.Extensions.DependencyInjection
Microsoft.Extensions.DependencyInjection.Abstractions
Microsoft.Extensions.FileProviders.Abstractions
Microsoft.Extensions.FileProviders.Physical
Microsoft.Extensions.FileSystemGlobbing
Microsoft.Extensions.Hosting
Microsoft.Extensions.Hosting.Abstractions
Microsoft.Extensions.Logging
Microsoft.Extensions.Logging.Abstractions
Microsoft.Extensions.Logging.Configuration
Microsoft.Extensions.Logging.Console
Microsoft.Extensions.Logging.Debug
Microsoft.Extensions.Logging.EventLog
Microsoft.Extensions.Logging.EventSource
Microsoft.Extensions.Options
Microsoft.Extensions.Options.ConfigurationExtensions
Microsoft.Extensions.Primitives
Microsoft.NET.StringTools
Microsoft.NETCore.Platforms
Microsoft.NETCore.Targets
Microsoft.SourceLink.AzureDevOpsServer.Git
Microsoft.SourceLink.Common
Microsoft.Win32.Primitives
Microsoft.Win32.Registry
Microsoft.Win32.SystemEvents
Microsoft.Xaml.Behaviors.Wpf
Moq
NETStandard.Library
PdfSharpCore
runtime.debian.8-x64.runtime.native.System.Security.Cryptography.OpenSsl
runtime.fedora.23-x64.runtime.native.System.Security.Cryptography.OpenSsl
runtime.fedora.24-x64.runtime.native.System.Security.Cryptography.OpenSsl
runtime.native.System
runtime.native.System.IO.Compression
runtime.native.System.Net.Http
runtime.native.System.Security.Cryptography.Apple
runtime.native.System.Security.Cryptography.OpenSsl
runtime.opensuse.13.2-x64.runtime.native.System.Security.Cryptography.OpenSsl
runtime.opensuse.42.1-x64.runtime.native.System.Security.Cryptography.OpenSsl
runtime.osx.10.10-x64.runtime.native.System.Security.Cryptography.Apple
runtime.osx.10.10-x64.runtime.native.System.Security.Cryptography.OpenSsl
runtime.rhel.7-x64.runtime.native.System.Security.Cryptography.OpenSsl
runtime.ubuntu.14.04-x64.runtime.native.System.Security.Cryptography.OpenSsl
runtime.ubuntu.16.04-x64.runtime.native.System.Security.Cryptography.OpenSsl
runtime.ubuntu.16.10-x64.runtime.native.System.Security.Cryptography.OpenSsl
Serilog
Serilog.Extensions.Logging
Serilog.Sinks.Console
Serilog.Sinks.Debug
System.AppContext
System.Buffers
System.CodeDom
System.Collections
System.Collections.Concurrent
System.Collections.Immutable
System.ComponentModel.Composition
System.Composition
System.Composition.AttributedModel
System.Composition.Convention
System.Composition.Hosting
System.Composition.Runtime
System.Composition.TypedParts
System.Configuration.ConfigurationManager
System.Console
System.Data.DataSetExtensions
System.Diagnostics.Debug
System.Diagnostics.DiagnosticSource
System.Diagnostics.EventLog
System.Diagnostics.Tools
System.Diagnostics.Tracing
System.Drawing.Common
System.Formats.Asn1
System.Globalization
System.Globalization.Calendars
System.Globalization.Extensions
System.IO
System.IO.Compression
System.IO.Compression.ZipFile
System.IO.FileSystem
System.IO.FileSystem.Primitives
System.IO.Pipelines
System.Linq
System.Linq.Expressions
System.Management
System.Memory
System.Net.Http
System.Net.Primitives
System.Net.Sockets
System.Numerics.Vectors
System.ObjectModel
System.Reactive
System.Reflection
System.Reflection.Emit
System.Reflection.Emit.ILGeneration
System.Reflection.Emit.Lightweight
System.Reflection.Extensions
System.Reflection.Metadata
System.Reflection.Primitives
System.Reflection.TypeExtensions
System.Resources.ResourceManager
System.Runtime
System.Runtime.CompilerServices.Unsafe
System.Runtime.Extensions
System.Runtime.Handles
System.Runtime.InteropServices
System.Runtime.InteropServices.RuntimeInformation
System.Runtime.Numerics
System.Security.AccessControl
System.Security.Cryptography.Algorithms
System.Security.Cryptography.Cng
System.Security.Cryptography.Csp
System.Security.Cryptography.Encoding
System.Security.Cryptography.OpenSsl
System.Security.Cryptography.Pkcs
System.Security.Cryptography.Primitives
System.Security.Cryptography.ProtectedData
System.Security.Cryptography.X509Certificates
System.Security.Cryptography.Xml
System.Security.Permissions
System.Security.Principal.Windows
System.ServiceProcess.ServiceController
System.Text.Encoding
System.Text.Encoding.CodePages
System.Text.Encoding.Extensions
System.Text.Encodings.Web
System.Text.Json
System.Text.RegularExpressions
System.Threading
System.Threading.AccessControl
System.Threading.Channels
System.Threading.Tasks
System.Threading.Tasks.Extensions
System.Threading.Timer
System.ValueTuple
System.Windows.Extensions
System.Xml.ReaderWriter
System.Xml.XDocument
UnitsNet
xunit.abstractions
xunit.extensibility.core
xunit.extensibility.execution
Xunit.StaFact