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
Store

Installed Software Report

I would like to create a report that shows computers that have "Software A" AND "Software B" installed. If I create a report that shows "Software A", it gives me the list of all the machines with that software installed. Likewise, if I create a report for "Software B", I get the expected results. However, if I create a report that is defined as "Choose records where all of the following apply", "Display Name contains Software A", "Display Name contains Software B", I get no records being returned.

After changing the report definition from "all of the following" to "any of the following", I now have a feeling I know why I'm getting no records returned. I get multiple rows for each computer that has both softwares installed (one row per software).

Is there a way to make this work like I was hoping?

Thanks!

Find more posts tagged with

Accepted answers

All comments

solarwinds-admin

Yes, and you're on the right track.

Change the Return all rows option to Return excluding duplicate rows at the top of the column list window.

Use the "any of the following" option to get the dataset for all computers with either product installed.

Use the "all of the following" option to get the dataset for all computers with both products installed.

solarwinds-admin

And, in the process of editing my reply, I left out the important step . . .

Remove the Software Name column from the column list so that the rows will be recognized as duplicate and suppress the extra rows for each computer.

solarwinds-admin

Hmm...I must be doing something wrong.

Return excluding duplicate rows of ... Limit # of rows to All

-> TCP/IP Address Sort Ascending (1)

-> Computer Name Not Sorted

+-> Domain or Workgroup Not Sorted

Choose records where all of the following apply

-> Display Name contains Software A and

+-> Display Name contains Software B

I get no results. If I remove one or the other software names, I get a list of machines with the other software installed (as expected).

solarwinds-admin

Oopss.. I make this mistake all of the time... the 'and' option won't actually work in this manner because Display Name can only have one value in each row, so there will never be a case where both options will return rows.

In order to get just the rows with both option, what you'll need to do is build an Aggregate on Count for the Display Name column (keep the column in the display), and then in the report viewer filter that column for Count=2.