I am trying to generate a report/query to determine the model of hard drives that we have.
I found this in a different forum and I get an error:
ERROR: relation "systeminfo" does not exist

SELECT workstation.WORKSTATIONNAME "Workstation",

workstation.SERVICETAG "Service Tag",

workstation.MODEL "Model",

hdi.Modelnumber "HardDisk Model number",

hdi.Manufacturer "HardDisk Manufacturer" FROM SystemInfo workstation

LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID

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 HardDiskInfo hdi ON workstation.WORKSTATIONID= hdi.WORKSTATIONID

Can someone help me out?