Installed Applications for Windows with filters

(imported topic written by Kenz91)

Here is what I’m trying to figure out. Say I want to see machine counts for a particular windows app. I select content then I type in “Application Information (windows)” to narrow it down to that Analysis. So far so good. Then I can click on that and it brings up all of the app counts for all installed apps on every machine. The problem is once in that view I can’t figure out any way to filter by a single app or only give me counts for certain machines like all servers. The only way I’ve been able to get around this is every time I want to filter at this point I have to create a new analysis that is specific to what app or machine group I need. There must be an easier way or am I just SOL?

(imported comment written by NoahSalzman)

What version of Web Reports are you using?

(imported comment written by Kenz91)

8.0.635

(imported comment written by SystemAdmin)

Unfortunately, as you have discovered this is not easy to do in your version of Web Reports. In 8.1 within “Explore Data” you can split apart results with multiple values (e.g. Installed Applications), filter on individual results (e.g. “Flash”), and then aggregate the results for each value (count of all computers with “Flash”). Then you can filter down to a specific set of computers.

(imported comment written by Lee Wei)

If I modify this report to give you a filter to search for any apps, will that work?

http://forum.bigfix.com/viewtopic.php?id=6109

(imported comment written by Kenz91)

Lee Wei

If I modify this report to give you a filter to search for any apps, will that work?
http://forum.bigfix.com/viewtopic.php?id=6109

Would it be able to filter by app and computer group at the same time?

(imported comment written by Lee Wei)

Here is the report with filters (both app and computer group) for you to try.

While working on this report, I notice that the Explore Data/Computer section for this property with the percentage count does not make sense to me.

I believe the percentage calculation in this report is more interesting, so please note the difference.

Web Reports use “Total Apps Found” as the Divisor.

I use “Total Computers in Group” as the Divisor.

Please verify which one you want.

http://leewei.com/bigfix/prod/forum/InstalledWindowsAppsWithFilters.besrpt

(imported comment written by Lee Wei)

I have also edited the thread title from the original “New to the latest version of Webreports and need help” to the current one.

(imported comment written by Kenz91)

Does the printable version work on these reports. I haven’t tried your new one yet but on the other one when I select printable version it starts a new web page with the title at the top but just sits there like it’s loading. I’ve given it a good 20 minutes and nothing comes back.

(imported comment written by Kenz91)

Well the report finally came back and I found out why it took so long. It appears that when you click “printable version” it drops all filters so it returns app counts for all computers. I guess that’s why it took forever. Can this be fixed?

(imported comment written by Lee Wei)

Kenz,

I cannot reconcile the behavior you are seeing.

Assuming you are using this new report on Web Reports 8.1.x.

When you click “Printable Version”, you get a new blank report that you have to select the app and computer group, then rerun “Generate Report”.

The new report should not be running a query right away.

Can you please confirm?

Lee Wei

(imported comment written by Kenz91)

As stated above I’m on version 8.0.635

(imported comment written by Lee Wei)

Hi Kenz,

Are you using the new report?

(imported comment written by MattBoyd)

Hey Kenz, maybe this will help you: http://forum.bigfix.com/viewtopic.php?pid=28549#p28549

You can export to PDF for printing, or copy and paste the results into Excel.

(imported comment written by Kenz91)

Ok tried the new report and that gives me the option to print using the filters. Thanks but I also found an issue with the report. I used the new one and filtered on a computer group populated with 188 servers all running server 2003 sp2. I left the application field blank so it pulled the report for all installed apps. When I look down the list most things seem right. I see 188 installs of the BES client and so on. Then when I get down to the OS I’m missing around 58 servers. It only lists 130 Server 2003 SP2 installs. Any ideas?

(imported comment written by Kenz91)

boyd

Hey Kenz, maybe this will help you: http://forum.bigfix.com/viewtopic.php?pid=28549#p28549

You can export to PDF for printing, or copy and paste the results into Excel.

Thanks Boyd but the issue is I’m very limited in what I can do. We don’t have access to the Webreports server. We are a single district (3 states) out of the national system. Getting them to install anything at the national(system level) takes an act of god.

(imported comment written by Lee Wei)

Kenz

…when I get down to the OS I’m missing around 58 servers. It only lists 130 Server 2003 SP2 installs. Any ideas?

What you are seeing has less to do with the report, but with the data collected via the Analysis.

The analysis is returning Installed Applications by scanning the “HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall” registry.

Looks like Server 2003 SP2 is registered as being installed, which makes sense.

However, if a server does not have a service pack, it will not show up.

We need to track this by going back to the analysis in the Console, and investigate a server if it is missing an installed application that you are expecting.

Are you trying to report on the OS installed, which would not work well with this report right now.

(imported comment written by Kenz91)

You’re right in that it’s the data being collected that’s the problem. They all have SP2 but when I physically checked these machines the OS is not showing up in add/remove. Why these 60 machines are doing this I don’t have a clue. I used an OS analysis to pull the data I needed. Thanks.

(imported comment written by MattBoyd)

Perhaps they Windows 2003 was installed on those systems with installer media that already contained SP2? In other words, they didn’t download and install SP2 via Windows Update.

(imported comment written by JasonBigham91)

How do you figure out what computer has the software you are looking for? This report seems to only provide a count of detected installations.