Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

I need to write a report to find out which nodes don't have LEM agent Installed on.

Hi , I have installed several LEM agents in our environment on Linux boxes, I need to discover which nodes don't have LEM agents installed on. I am using advanced SQL option in web reports as following:

Select Nodes.Caption as Hostname,AssetInventory_Software.Name

FROM

Nodes,AssetInventroy_Software

Where AssetInventrory_Software.Name LIKE 'SolarWinds Log & Event Manager Agent'

The above code is not generating what is expected. Any help or ideas is appreciated.

Thanks,

Find more posts tagged with

Accepted answers

All comments

HolyGuacamole

If you drill down to the Linux node that does have the LEM Agent installed and look at the Asset Inventory sub-view, how exactly does the software name appear? I am assuming you are using SAM to determine which nodes don't have a LEM Agent

mheydari

On my Linux boxes cannot find them, but on windows they are like this:

SolarWinds Log & Event Manager Agent

The agents on the linux are installed and running.

HolyGuacamole

I'm not finding LEM Agent in SAM's software inventory for my Linux node. Do you see see it in your list when you drill down to the Linux node, and in the Asset Inventory sub-view? I am not sure if only certain type of installed software is detected by net-SNMP

mheydari

Not all the Linux nodes in Orion have the Asset inventory sub menu. I don't know why. I even listed the resources thinking maybe when I was adding them I didn't select the Asset inventory option, however, that was not the case. It is not there at all. I am using SNMP method for performance data collection.