/build/static/layout/Breadcrumb_cap_w.png

Report with PC Count

Hi,
I already have a report that gives me the system name, user full name, and system model. I just want a count/total number of machines to show on the report. How do I do this? This is what the SQL looks like:

SELECT MACHINE.NAME AS SYSTEM_NAME, USER_FULLNAME, CS_MODEL FROM MACHINE WHERE CS_MODEL LIKE '%4610%' ORDER BY MACHINE.NAME asc,USER_FULLNAME asc,CS_MODEL asc

0 Comments   [ + ] Show comments

Answers (1)

Posted by: rmeyer 13 years ago
Second Degree Blue Belt
0
Hi

Try to add "count(*) as Amount" like in the report below, this is just an example I have to count PC's in each country with a custom language code enviroment variable on PC's

SELECT (SELECT MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE FROM MACHINE_CUSTOM_INVENTORY WHERE MACHINE_CUSTOM_INVENTORY.ID=MACHINE.ID AND MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID=2443) AS Language_Code, count(*) as Amount FROM MACHINE group by Language_Code ORDER BY Language_Code asc
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