Report: Show Loaded Parts

The following query can be entered into the Administration > Run SQL Query… dialog to show what parts are loaded.

select pb.partnumber, pb.pid, pb.BrandID, b.brandnm as [BrandName], b.isPrimary, 
  ab.AAIABrandCD as [AutoCareBrand], pb.GTIN, pb.EffectiveDate, pb.AvailableDate
from partmaster pm
join partbrand pb on pb.pid = pm.pid
join brand b on b.brandid = pb.brandid
join aaiabrand ab on ab.aaiabrandid = b.aaiabrandid
order by pb.partsort