Blog

Managed File Transfer and Network Solutions

Running Reports using Search Results in JSCAPE MFT Server

Posted by John V. on Thu, May 10, 2012 @ 10:24 AM

Do you wish you could run reports on your JSCAPE MFT Server based on specific search results that were previously created on the Logging module? This capability can be particularly useful during audits or investigations, when you would like to get finer levels of reporting.

This is already possible starting with JSCAPE MFT Server 8.3. So if you're still working with an older version, this capability is one good reason to upgrade.

In previous versions, it was already possible to specify certain metrics in reports like Top Users, Top Hosts, Top Uploads, Top Downloads, Monthly Statistics, and so on. But the data used mostly came from all the records in the logs. Thus, the resulting information was often too broad. The only other criteria you could specify were the Username and the Start and End Dates.

 

start and end date resized 600

 

What if you wanted to know the Top Uploads or Monthly Statistics of file transfers involving only image files? This kind of reporting would entail the use of regular expressions to match certain values in the server message column of the logs.

So how would you do this in JSCAPE MFT Server 8.3 and above?

Before we get to that, the way you would do this in the logging module in older versions would be to specify a Date Range ...

 

date range resized 600

 

... and then employ this regular expression against the Server Message column:

 

.*\.jpg.*|.*\.bmp.*|.*\.png.*

 

(Note: If you're not yet familiar with regular expressions, this introductory article to regular expressions is a good place to start.)

 

regex matching image files resized 600

 

Once the Search is run, the managed file transfer server would gather all records in the logs where a .jpg, .bmp, or .png can be found in the Server Message column.

The results would then be made available in the Results tab. 

 

search results resized 600

 

From there, you could view the results (and maybe eventually print it) by clicking on the View button. 

 

view log search results resized 600

 

Or you could Export it to a file by clicking the Export button. I usually export the results as .xls files for easier viewing on a spreadsheet application like MS Excel or OpenOffice Calc.

 

export to spreadsheet resized 600

 

Here's a sample export viewed through OpenOffice Calc.

 

view in openoffice resized 600

 

Everything you've seen up to this point can be done in versions before and after 8.3. But what we're about to show you in the remaining steps is only possible in 8.3 and above. 

If you go over to the Reports module and click the Add button,

 

add reports resized 600

 

you'll now see, starting with version 8.3, these new entries: Search results and Re-run search. You can see the difference by comparing the screenshot below against the first screenshot on this post.

 

adding reports resized 600

 

The two entries in the previous versions, Username and Start Date/End Date, are no longer necessary here because they can be specified in a log search and the results of that log search can already be selected from here. Notice that the item selected below is the name of the search result we generated earlier (see 4th screenshot). 

 

selecting search results resized 600

 

When we run this report, the metrics obtained will be taken specifically from that particular search result. You can even re-run the search to make sure recent records can be included. 

Here are a couple of graphs we grabbed from this particular report.

 

hourly statistics resized 600

 

top uploads resized 600

 

top downloads resized 600

 

Notice how the top uploads and downloads were all image files. Again, this kind of reporting is only supported by JSCAPE MFT Server 8.3 and above, so download the latest version now.

 

 

 

Topics: JSCAPE MFT Server, Managed File Transfer