Hello,

I can see that some of the assets we scan have an entry for firmware, but I can't figure out where that's stored in the database.  I have this query report, which pulls everything I need except the firmware.  Any idea what I need to add to it?  Thanks!

SELECT resource.RESOURCENAME AS "Asset Name", product.COMPONENTNAME AS "Product", productType.COMPONENTTYPENAME AS "Product Type", resource.ASSETTAG AS "Asset Tag", resource.SERIALNO AS "Org Serial Number", resFields.UDF_CHAR1 AS "CMMC Asset Category", aaov.NAME AS "Site" FROM Resources resource LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID LEFT JOIN ResourceType rtype ON productType.RESOURCETYPEID=rtype.RESOURCETYPEID LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID LEFT JOIN Resource_Fields resFields ON resource.RESOURCEID=resFields.RESOURCEID WHERE ( ( ( rtype.TYPE != 'Software' ) OR ( rtype.TYPE IS NULL ) ) AND ( ( ( productType.COMPONENTTYPENAME != 'Server' ) AND ( productType.COMPONENTTYPENAME != 'Workstation' ) ) OR ( productType.COMPONENTTYPENAME IS NULL ) ) )  ORDER BY 7,1