Tool to query BES Agent properties from the Web Reports

Reporting
1

(imported topic written by BenKus)

Ever wanted to get a list of agent properties in a CSV file?

If so, you have several options including: running a “properties report” in the web reports and exporting to csv or by querying the database directly. However, these are sometimes not convenient methods… So to help with this…

We have created a tool that will connect to the web reports and pull data about properties of computers. For instance, if you wanted the ComputerName, OS, and RAM from computers. You can use this tool and it will spit out a CSV file with these properties for all computers.

Read the readme.txt file if you wish to use it:

http://support.bigfix.com/download/bes/util/queryWebReports-0.9.5.0.zip

Please report any issues you find. Hope you find it useful.

Ben

2

(imported comment written by rdamours91)

Ahhh…very nice.

Haven’t tried it yet but I’m sure it will be very useful

3

(imported comment written by ErnieF91)

Works great, thanks a bunch.

Here’s another project for you:

How about a report/graph that will show disk space utilization over time. The data is already captured, just need it saved by date, so we can run reports to watch for trends of disks filling up.

Ernie

4

(imported comment written by SystemAdmin)

Hi Ben,

Thanks for this very useful tool… Got a little error though…

Getting results from http://Servername/cgi-bin/besreports/besreports.exe. This could take a little while.

syntax error at line 1, column 62, byte 62 at /PerlApp/XML/Parser.pm line 187

Is it something I have done wrong?

Cheers,

5

(imported comment written by BenKus)

Hmm… I wonder if it is related to XML libraries on the computer… Do you mind trying from a different computer and seeing if it works? It works fine for me on my WinXP SP2.

Let me know if you get it to work at all.

Thanks,

Ben

6

(imported comment written by PatNOregon)

Ben,

Can this tool be used to query multiple databases? I have 5 I would like to roll into one report if possible, or at least get 5 different output files that I can merge or reference on my side.

Great tool, thanks!

7

(imported comment written by BenKus)

Multiple databases aren’t directly supported by the tool, but you can copy the tool to 5 different folders, each with a different config file to point to each database, and run each instance.

Ben

8

(imported comment written by Wallen9791)

Very nice tool!! The report that I’m creating with this tool is well over 205,000 rows. I am able to add 2 computer properites without it timing out. I need to add about 5 properties to the report. By how much should I increase the timeout in the config file?

9

(imported comment written by BenKus)

Hey Wallen,

Hmmm… I am not sure… I didn’t really test my little tool against the database of 205,000 computers… I think you should make a pretty big number to be safe…

Also, you might want to keep an eye on the memory usage of the tool because if it goes over 1.8 GB or so, it will probably crash…

Ben

10

(imported comment written by StacyLee)

I get the following pop up error (i am on x64 vista):

This Application has failed to start because SSLEAY32.dll was not found. Re-installing the application may fix the problem.

My webreports is using SSL

11

(imported comment written by BenKus)

Hey Stacy,

I don’t think I built it with HTTPS support, but it might have inherited it based on the libraries I used… You might try putting ssleay32.dll in the same folder as the tool… it might already be on your computer or you can find it online in some places…

Ben

12

(imported comment written by BenKus)

This tool is now deprecated because of this newer and better tool at:

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

Ben