How to make a report with all software installed on a computer Label?
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
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
Answers (1)
Please log in to answer
Posted by:
dchristian
12 years ago
Hey rgiroux,
Try something like this:
It looks at all the machines in the workstation label.
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.
