I have made a report, but it shows the RAM in bytes???
How can I make it in Megabytes? We use the latest version of Servicedesk Professional fully licenced.
Here is the query i used:
SELECT workstation.WORKSTATIONNAME 'Werkstation', deptDef.DEPTNAME 'Afdeling',workstation.MANUFACTURER 'Merk',workstation.MODEL 'Model',memInfo.TOTALMEMORY 'Totaal Geheugen',procInfo.CPUNAME 'Processornaam',procInfo.SPEED 'Processorsnelheid (in GHz)',osInfo.OSNAME 'OS Naam',osInfo.SERVICEPACK 'Servicepack' FROM SystemInfo workstation LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID LEFT JOIN DepartmentDefinition deptDef ON rOwner.DEPTID=deptDef.DEPTID LEFT JOIN MemoryInfo memInfo ON workstation.WORKSTATIONID=memInfo.WORKSTATIONID LEFT JOIN OsInfo osInfo ON workstation.WORKSTATIONID=osInfo.WORKSTATIONID LEFT JOIN ProcessorInfo procInfo ON workstation.WORKSTATIONID=procInfo.WORKSTATIONID WHERE ( deptDef.DEPTNAME = 'Automatisering')