/build/static/layout/Breadcrumb_cap_w.png

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?

0 Comments   [ + ] Show comments

Answers (1)

Posted by: isolinear 12 years ago
Orange Belt
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ