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

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

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
Answered 05/09/2011 by: rmeyer
Second Degree Blue Belt

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