Custom Report - PC's with specific installed apps

Reporting
1

(imported topic written by rdamours91)

I will take a crack at creating a custom report for a list of specific installed apps shortly. I was looking at creating a report that looks somewhat like the following that will sort by “location by ip range” and computer name filtering on a specific application in this case “QuickBooks Pro Edition 2007” or a list of applications.

I’m getting more and more requests for reports on paper even though the console gives me exactly the info I need. Just wondering if there is any sample code kicking around…I’m into recycling. :slight_smile:

Location by IP Computer Name Installed Application

Abbott OFF100-001 QuickBooks Pro Edition 2007

OFF100-002 QuickBooks Pro Edition 2003

Avonmore OFF200-005 Quickbooks Pro Edition 2007

2

(imported comment written by rdamours91)

I’m wondering if I should do a variation of a retrieved property first and then report on that.

Is there more overhead in adding another retrieved property or should I write a custom report on the installed applications that contains “quickboooks” for example.

3

(imported comment written by BenKus)

Hi rdamours,

The standard retrieved property report with filters would work… but it would display all the applications and not just QuickBooks.

Let’s try this:

<?Relevance trs of (td of name of it & td of concatenation "," of (values of result (it, bes property "Location by IP") ) & td of concatenation "," of (values of result (it, bes property "Installed Applications - Windows") ) whose (it as lowercase contains "quickbooks pro edition")) of bes computers whose (exists (value of result (it, bes property "Installed Applications - Windows")) whose (it as lowercase contains "quickbooks pro edition") AND exists (value of result (it, bes property "Location by IP"))) ?>

Make sure the property names are right and let me know if that works for you…

Ben

4

(imported comment written by rdamours91)

You’ve really got to ask for a raise man.

The web QNA could not parse the code but it runs when I add the code in as a custom report. I’m getting an “expression could not be parsed” when I try to web QNA it…

Here’s a rought sampling sampling of the output…I’ll of course add headers, etc. as time permits.

380-HLE Centre For Education Quickbooks Basic Edition 2003

380-JGRISWOL Centre For Education QuickBooks

384-LGEBARA Centre For Education QuickBooks Basic Edition 2003,QuickBooks Pro Edition 2007,QuickBooks Pro Edition 2006,QuickBooks Transfer - 1.0.0

OFF225-001 Caernarvon 225 QuickBooks Basic Edition 2003

OFF055-SROFF-06 Victoria School of Performing And Visual Arts QuickBooks Basic Edition 2003

384-AASARIA Centre For Education QuickBooks Basic Edition 2003,QuickBooks Pro Edition 2007,QuickBooks Pro Edition 2006,QuickBooks Transfer - 1.0.0

OFF055-SROFF-09 Victoria School of Performing And Visual Arts QuickBooks Basic Edition 2003

347-MADAMS2 Centre For Education QuickBooks Basic Edition 2003,QuickBooks Pro Edition 2007,QuickBooks Transfer - 1.0.0

TCH106-STFROOM Beacon Heights 106 QuickBooks Basic Edition 2003

OFF253-06 Bannerman 253 QuickBooks Basic Edition 2003

OFFICE-05 Balwin 502 QuickBooks Basic Edition 2003

OFFICE-04 Balwin 502 QuickBooks Basic Edition 2003

OFF253-008 Bannerman 253 QuickBooks Basic Edition 2003

Here’s the code that ran…

I can now do variations of this report to get any specific installed app…thanks a ton…you’ve been a big time saver. I had the code partially written on my own but did not have time to finish.

<?relevance trs of (td of name of it & td of concatenation "," of (values of result (it, bes property "School Name by IP Range")) & td of concatenation "," of (values of result (it, bes property "Installed Applications - Windows")) whose (it as lowercase contains "quickbooks")) of bes computers whose (exists (value of result (it, bes property "Installed Applications - Windows")) whose (it as lowercase contains "quickbooks") AND exists (value of result (it, bes property "School Name By IP Range"))) ?>

The data is exactly what I’m looking for…i"ll just see if I can sort the first 2 columns in the web report somehow…or I’ll port the output out to csv and manipulate it that way for the time being.

You da man…I’m sure there are others that would be interested in a variation of this code.

5

(imported comment written by BenKus)

Thanks rdamours! Glad I could help…

I think we will try to incorporate a report like this directly in the product because it seems quite like many people commonly asked for a report like this.

Ben

6

(imported comment written by rdamours91)

You da man…

7

(imported comment written by frankc91)

Hi guys, this is a great report. Is there a way to also summarize (or group) computer counts by application as well?

8

(imported comment written by BenKus)

Hi Frank,

Let’s try this:

<?Relevance trs of ( td of (tuple string item 0 of item 0 of it) & td of (tuple string item 1 of item 0 of it) & td of (item 1 of it) ) of ( (it, (multiplicity of it as string) )) of unique values of (((concatenation "," of (unique values of values of result (it, bes property "OS") ) ), (concatenation "," of (unique values of values of result (it, bes property "Installed Applications - Windows") ) whose (it as lowercase contains "bigfix enterprise client")) ) as string ) of bes computers whose (exists (value of result (it, bes property "Installed Applications - Windows")) whose (it as lowercase contains "bigfix enterprise client") AND exists (value of result (it, bes property "OS"))) ?>
Property Grouping (OS in this case) Application Number of computers

Again, substitute “OS” for any property that you want to “group by” and “bigfix enterprise client” for any application you want to look for…

As an example output, here are the results from my home deployment:

Property Grouping (OS in this case) Application Number of computers

Win2000 5.0.2195 BigFix Enterprise Client - 6.1.1.21 1

Win2003 5.2.3790 BigFix Enterprise Client - 6.1.1.21 1

WinXP 5.1.2600 BigFix Enterprise Client - 6.0.15.07 1

WinXP 5.1.2600 BigFix Enterprise Client - 6.0.3.04 1

WinXP 5.1.2600 BigFix Enterprise Client - 6.1.1.21 12

WinXP Media Center Edition.2600 BigFix Enterprise Client - 6.0.15.07 1

WinXP Media Center Edition.2600 BigFix Enterprise Client - 6.0.5.13 1

WinXP Media Center Edition.2600 BigFix Enterprise Client - 6.1.1.21 1

There is a straightforward way to remove the version number if you don’t want it too…

Ben

9

(imported comment written by rdamours91)

Hey man…you’re going to start dreaming in relevence.

I’ll post again with a variation of this to count instances of some apps I’ve been asked to find. Thanks again…

10

(imported comment written by abrice)

This report didn’t work on my system. I only saw the title.

11

(imported comment written by BenKus)

Hi abrice,

Make sure you have the property “Installed Applications - Windows” active (it should be in the “Application Information (Windows)” site) and make sure you replaced “bigfix enterprise client” in the two places with the application you are looking for (and make sure to use lowercase letters).

Ben

12

(imported comment written by vicky23)

I need a different variation of this report in the following format

Is this possible?

Group by subnet

Subnet Computername Adobe Reader 5 6 7 Adobe Acrobat 5 6 7 Adobe Illustrator 10 11 …

10.1.1.0 RDS0034 1 1 1

10.1.1.0 RDS0052 1 1

subnet total 1 1 1 1 1

10.1.2.0 ITD0062 1 1

subnet total 1 1

13

(imported comment written by rupalshah91)

Hi,

I want to generate a report which gives me number of computer having a particular application say “Regaional Applications Portal” installed.

The expected report output should be as below:

Number of Window Computers Number of Computers with RAP installed

50 30