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

Comments

  • Any chance you could put those machines in a label and use that label in the query?
Please log in to comment

Answers

1

Add this to the WHERE section

WHERE MACHINE.IP LIKE '11.53.43.%'

Answered 11/30/2013 by: dugullett
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity