Hardware Model Report assistance
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?
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
Answers (1)
Please log in to answer
Posted by:
isolinear
13 years ago
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
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
