I've upgraded to 5.4. Currently I can run a software inventory report for my Linux machines but it shows 800+ programs. There are a lot of -libs and -rpm files. It makes the report worthless. Is there a way to filter the firmware and plugins and just give me a list of the .exes? As always, thanks for the help.

Andrew 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1

I don't know not much about Kace with Linux, but, in the Red Hat flavored Linux world, use:

rpm -qa | sort | sed -n -e "s/\-[0-9].[0-9]*.*//p" | uniq

to get a clean sorted list.  There are no standard executable to search for.

Answered 01/30/2013 by: worzie
Second Degree Green Belt

Please log in to comment

Answers

0

First I would like to say that I'm not a Linux person at all. I have it installed on a few of my test VMs to make sure the client works basically, and then make it available for our Linux techs. Looking through the inventory on some of these it looks like the version for the system files end end ".el5" and ".el6". Would a report that filters out the display version ending in those two work?

SELECT M.NAME,IP, LAST_INVENTORY, S.DISPLAY_NAME

FROM MACHINE M

LEFT JOIN MACHINE_SOFTWARE_JT MSJT ON M.ID = MSJT.MACHINE_ID

LEFT JOIN SOFTWARE S ON MSJT.SOFTWARE_ID = S.ID

WHERE OS_NAME LIKE 'RED HAT ENTERPRISE%' AND

S.DISPLAY_VERSION NOT LIKE '%.EL5' AND

S.DISPLAY_VERSION NOT LIKE '%.EL6'

 

.... or filtering out the publisher of Red Hat?

SELECT M.NAME,IP, LAST_INVENTORY, S.DISPLAY_NAME

FROM MACHINE M

LEFT JOIN MACHINE_SOFTWARE_JT MSJT ON M.ID = MSJT.MACHINE_ID

LEFT JOIN SOFTWARE S ON MSJT.SOFTWARE_ID = S.ID

WHERE OS_NAME LIKE 'RED HAT ENTERPRISE%' AND

S.DISPLAY_VERSION NOT LIKE '%.EL5' AND

S.DISPLAY_VERSION NOT LIKE '%.EL6' AND

S.PUBLISHER NOT LIKE 'RED HAT%'
Answered 01/31/2013 by: dugullett
Red Belt

  • This took my list from 1,711 to 82. Some more filtering might need to happen. You should be able to adjust the query to filter out what you don't need. Let me know if you need help.
Please log in to comment
Answer this question or Comment on this question for clarity