Workstations/servers hardware details

Below Query is not fetching perfect Inventory,Is anyone can help ?. I am using latest version in evolution mode .

SDP build 8115

select (SELECT CASE WHEN min(CAST(sys.ISSERVER AS CHAR)) = 1 THEN 'Server Details' ELSE 'Workstation Details' END) 'Is Server',max(WORKSTATIONNAME) 'Name',max(IPADDRESS) 'IP Address',max(MACADDRESS) 'MAC Address',max(SERVICETAG) 'Service Tag',max(BIOSDATE) 'BIOS Date', max(BIOSVERSION) 'BIOS Version',max(LOGGEDUSER) 'Last Logged User',max(OSInfo.OSNAME) 'Operating System',max(cd.COMPONENTNAME) 'Model', max(rest.DISPLAYSTATE) 'Asset State', max(aau.FIRST_NAME) 'User',max(dd.DEPTNAME) 'Department',max(sdorg.NAME) 'Site',max(resl.LOCATION) 'Location',max(dinf.DOMAINNAME) 'Domain',LONGTODATE(max(ACQUISITIONDATE)) 'Acquisition Date', LONGTODATE(max(EXPIRYDATE)) 'Expiry Date', LONGTODATE(max(WARRANTYEXPIRY)) 'Warranty Expiry', SUM(COST) 'Purchase Cost', CAST(CEILING(SUM(TOTALMEMORY)/(1024 * 1024 * 1024)) AS CHAR(3)) + ' GB' 'Memory Details',dbo.GCDriveDetails(sys.WORKSTATIONID) 'Hard Disk Details', dbo.GCMonitorDetails(sys.WORKSTATIONID) 'Monitor Details', dbo.GCKeyboardDetails(sys.WORKSTATIONID) 'Keyboard Details', dbo.GCProcessorDetails(sys.WORKSTATIONID) 'Processor Details' from SystemInfo sys LEFT JOIN Resources res ON sys.WORKSTATIONID = res.RESOURCEID LEFT JOIN ComponentDefinition cd ON res.COMPONENTID = cd.COMPONENTID LEFT JOIN ResourceState rest ON res.RESOURCESTATEID = rest.RESOURCESTATEID LEFT JOIN ResourceOwner reso ON res.RESOURCEID = reso.RESOURCEID LEFT JOIN DepartmentDefinition dd ON reso.DEPTID = dd.DEPTID LEFT JOIN SDUser sdu ON reso.USERID = sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID = aau.USER_ID LEFT JOIN MemoryInfo minf ON sys.WORKSTATIONID = minf.WORKSTATIONID LEFT JOIN NetworkInfo ninf ON res.RESOURCEID = ninf.WORKSTATIONID LEFT JOIN OSInfo ON sys.WORKSTATIONID = OSInfo.WORKSTATIONID LEFT JOIN ResourceLocation resl ON res.RESOURCEID = resl.RESOURCEID LEFT JOIN SiteDefinition site ON resl.SITEID = site.SITEID LEFT JOIN SDOrganization sdorg ON site.SITEID = sdorg.ORG_ID LEFT JOIN SystemInfoDomain sysd ON sys.WORKSTATIONID = sysd.WORKSTATIONID LEFT JOIN DomainInfo dinf ON sysd.DOMAINID = dinf.DOMAINID LEFT JOIN ResourceCost rcost ON res.RESOURCEID = rcost.RESOURCEID LEFT JOIN ResourceCostFactor rcostf ON rcost.RESOURCECOSTFACTORID = rcostf.RESOURCECOSTFACTORID WHERE rest.DISPLAYSTATE NOT IN ('Disposed', 'Expired') AND (COSTFACTORDESC != 'Purchase Cost' OR COSTFACTORDESC IS NULL) GROUP BY sys.WORKSTATIONID ORDER BY 1