/bundles/itninjaweb/img/Breadcrumb_cap_w.png
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   [ - ] Hide 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.
Answer this question or Comment on this question for clarity

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