/build/static/layout/Breadcrumb_cap_w.png

Software Report per IP range

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


1 Comment   [ + ] Show comment
  • Any chance you could put those machines in a label and use that label in the query? - Jbr32 10 years ago

Answers (1)

Posted by: dugullett 10 years ago
Red Belt
1

Add this to the WHERE section

WHERE MACHINE.IP LIKE '11.53.43.%'

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ