Hi Guy's,
I need to change my report to give to me all computers on a ComputerLabel.
My script is providing all installed programs on a computer.
In moment my script is:
Select CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) as MACHINE_NAME, DISPLAY_NAME,
DISPLAY_VERSION, PUBLISHER from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE) where MACHINE.ID =
MACHINE_SOFTWARE_JT.MACHINE_ID and SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID and not IS_PATCH
and MACHINE.NAME = 'enter machine name here'
order by MACHINE_NAME, DISPLAY_NAME
How can a change my script to be able to do the same for a ComputerLabelGroup.
I'm sorry. But i'm very bad on SQL and i really need your help on this problem.
Best regards,
Rildo
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

1
Hey rgiroux,

Try something like this:

It looks at all the machines in the workstation label.

SELECT
CONCAT(
MACHINE. NAME,
"\\",
MACHINE.SYSTEM_DESCRIPTION
) AS MACHINE_NAME,
DISPLAY_NAME,
DISPLAY_VERSION,
PUBLISHER
FROM
(
SOFTWARE,
MACHINE_SOFTWARE_JT,
MACHINE,
MACHINE_LABEL_JT ML,
LABEL L
)
WHERE
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID
AND SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
AND MACHINE.ID = ML.MACHINE_ID
AND ML.LABEL_ID = L.ID
AND NOT IS_PATCH
AND L.`NAME` = 'WORKSTATIONS'
ORDER BY
MACHINE_NAME,
DISPLAY_NAME
Answered 03/01/2012 by: dchristian
Red Belt

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