Seeking some help creating report to generate a count list of system manufacturer and system model;
If I use the wizard I can choose Manufacturer and BIOS Info.System Manufacturer and Manufacturer and BIOS Info.System Manufacturer and it creates a line for each machine. How can I just create one entry per model with a count of each type?
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

1
Try this - i had to do a report like you are asking a few weeks back.

SELECT MACHINE.CHASSIS_TYPE as "Chassis", CS_MODEL as "Model", MACHINE.BIOS_NAME as "BIOS Name", COUNT(MACHINE.CHASSIS_TYPE) as "Number"
FROM MACHINE
group by MACHINE.CHASSIS_TYPE, CS_MODEL, MACHINE.BIOS_NAME
order by MACHINE.CHASSIS_TYPE, CS_MODEL, MACHINE.BIOS_NAME
Answered 04/13/2011 by: isolinear
Orange Belt

Please log in to comment
Answer this question or Comment on this question for clarity