Software Report per IP range
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.
select CONCAT(DISPLAY_NAME, " (", DISPLAY_VERSION ,")") as
MACHINE.NAME as Computer_Name,LABEL.NAME as LABEL_NAME,
IP, MAC, CS_DOMAIN, REPLACE(MACHINE.USER_LOGGED,'\\','\\\\') as
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