trouble writing custom query report
Hello, I am trying to write a query for a custom report. In a nutshell, I'd like the workstationname, manufacturer, processorcount, cpuname, model, totalmemory, servicetag, osname, and servicepack fields from the systeminfo, osinfo, systemuserinfo, memoryinfo, and processorinfo tables, but only for workstations I have designated in the "Server Room" location. I have a query that successfully executes and returns the correct results that I can run in SQLyog but when I enter it in the "New Query Report" Wizard in ServiceDesk Plus, it does not work.
The errors I get are:
Report design not valid :
1. Field not found : null
2. Field not found : null
3. Class not set for group expression : Bynull
4. Class not set for text field expression.
My query is:
select systeminfo.workstationname AS Server, systeminfo.manufacturer AS Make, processorinfo.processorcount AS "CPU #", processorinfo.cpuname AS "CPU Type", systeminfo.model AS Model, memoryinfo.totalmemory/1024 AS Memory, systeminfo.servicetag AS Tag, osinfo.osname AS "Operating System", osinfo.servicepack AS SP
from systeminfo, osinfo, systemuserinfo, memoryinfo, processorinfo
where systeminfo.workstationid = osinfo.workstationid and systeminfo.workstationid = systemuserinfo.workstationid and systeminfo.workstationid = memoryinfo.workstationid and systeminfo.workstationid = processorinfo.workstationid and systemuserinfo.location = "Server Room"
order by systeminfo.workstationname ASC
Please advise me as to what I'm doing wrong. I am by no means a SQL expert, so if there is a better way to get the info from each of the tables, please let me know. I just find it odd that the query works in SQLyog but not in SDPlus. Thanks in advanced for your help.
The errors I get are:
Report design not valid :
1. Field not found : null
2. Field not found : null
3. Class not set for group expression : Bynull
4. Class not set for text field expression.
My query is:
select systeminfo.workstationname AS Server, systeminfo.manufacturer AS Make, processorinfo.processorcount AS "CPU #", processorinfo.cpuname AS "CPU Type", systeminfo.model AS Model, memoryinfo.totalmemory/1024 AS Memory, systeminfo.servicetag AS Tag, osinfo.osname AS "Operating System", osinfo.servicepack AS SP
from systeminfo, osinfo, systemuserinfo, memoryinfo, processorinfo
where systeminfo.workstationid = osinfo.workstationid and systeminfo.workstationid = systemuserinfo.workstationid and systeminfo.workstationid = memoryinfo.workstationid and systeminfo.workstationid = processorinfo.workstationid and systemuserinfo.location = "Server Room"
order by systeminfo.workstationname ASC
Please advise me as to what I'm doing wrong. I am by no means a SQL expert, so if there is a better way to get the info from each of the tables, please let me know. I just find it odd that the query works in SQLyog but not in SDPlus. Thanks in advanced for your help.