/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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