Software

Hi There,

I need to generate a report with all software installed installed per computer. I have the following query that s working fine but I want this for a specific IP range.

11.53.43.0 /24

select CONCAT(DISPLAY_NAME, " (", DISPLAY_VERSION ,")") as
Software_Title,
MACHINE.NAME as Computer_Name,LABEL.NAME as LABEL_NAME,
SYSTEM_DESCRIPTION,
IP, MAC, CS_DOMAIN, REPLACE(MACHINE.USER_LOGGED,'\\','\\\\') as
USER_LOGGED

from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE,MACHINE_LABEL_JT,LABEL)
where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and
MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
and MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID
and MACHINE_LABEL_JT.LABEL_ID = LABEL.ID
and LABEL.TYPE != 'hidden'
and not IS_PATCH
order by LABEL_NAME,Software_Title