Click here to Skip to main content
15,885,366 members
Articles / Product Showcase

Funnel IT for Free

20 Nov 20039 min read 83K   8   19
A fully-functional freeware tool, Funnel IT for Free is a one-stop resource for capturing and sharing the environment in which a defect occurred, answering the frequent questions between Development and QE that delay defect resolution.

This article is in the Product Showcase section for our sponsors at CodeProject. These articles are intended to provide you with information on products and services that we consider useful and of value to developers.

This is a showcase review for our sponsors at CodeProject. These reviews are intended to provide you with information on products and services that we consider useful and of value to developers.

We Pour Big Things Into Little Files.

Go Ahead, Funnel IT!  Download your free copy here from ByStorm Software.

What it Means to Funnel IT

Unless you work in a vacuum (which sounds nice some days), you’ve probably had or heard a conversation similar to this:

02.01 9:01 AM Sam (QE): The print function doesn’t work. Click on print and it blows up.
02.01 10:05 AM Bob (Dev): Weird, it works for me.  Can’t reproduce.
02.01 10:57 AM Sam (QE):Can’t reproduce!?!?  I get it every time!
02.01 1:05 PM Bob (Dev): Well, I did your repro steps and it doesn’t happen for me.
02.01 4:26 PM Harry (Dev Manager): BOB, GO INTO SAM’S OFFICE AND WATCH HIM REPRO IT.
02.02 8:47 AM Bob (Dev):  It did blow up . . . don’t know why . . . I’ll need to use Sam’s computer.
02.02 9:45 AM Sam (QE): You can’t use my computer! I need it to make a 3/15 ship date?!
02.02 11:15 AM Sam (QE): He’ll install tools on it!
02.02 1:17 PM Bob (Dev): I’ll need to, so I can figure out what is happening.
02.02 2:31 PM Sam (QE): If he installs anything on this machine, everything will start working. Customers in the field DON’T have development tools on their machines!

You can’t reproduce a defect, or you have a question about some configuration issue of the test machine, and now you and QE are bouncing a defect report back and forth instead of being able to resolve it.  Switching gears all day isn’t very fun or productive.

In his position as Director of Engineering for several software vendors, Funnel IT developer Gene Allen saw too many high-salaried and highly-trained development and testing staff caught in endless communications about a test or development environment. “This is frustrating for them, expensive for the company, and ultimately affects the amount of bugs that can be found and fixed,” says Allen. 

The essence of “Funneling IT” is to gather relevant environment information into a small, sharable file that can be attached to an email or defect report.  When trying to resolve a defect, if you would like the first place you look—and the last place you look—to be the SAME place, then read on.

Figure One; Funnel IT in action:

Image 1

How You Will Use This Tool

In General

Funnel IT for Free is a Windows platform, language-independent freeware tool that actually serves three masters.  

  • For QE, it is a one-click assimilation of the operating environment surrounding a defect—information that would otherwise have to be collected individually.
    • Funnel IT gathers: running tasks, loaded modules, screen resolution and depth, system up-time, virtual memory settings, load address, OS version, component details, processor information, and physical memory information.
  • For management, it helps free employees from the above-mentioned communication volley resulting in quicker defect resolution time.
  • For development, in addition to the above benefits, this product addresses DLL HELL, locked DLLs, and relocated load addresses, for starters.  More on this below.

A note about our footprint before we step into the discussion:

We felt it was important to leave no footprint on your development (or test) environment.  Funnel IT for Free is an executable using statically linked runtime libraries and has no installation.

Because of this, you will never have to reinstall our tool, and it will work the same every time, regardless of what else is on your system.  We do need just a little disk space and one registry key to keep the license agreement from unnecessarily hassling you. 

Components of a Funnel IT for Free File

The captured environment, now a .sqa file, is organized in an easy-to-use tree interface. At the root are the name of the computer and the time of day that Funnel IT captured the information.  The rest of the tree is divided into three main branches:

  • Modules Grouped by Process
  • Processes Grouped by Module
  • General Information

How each of these will benefit a user is discussed below under the branch heading.

Loaded Modules Grouped by Process

Goodbye, DLL Hell.  This section of your Funnel IT tree shows all the running tasks on the system where the information was captured—and every loaded module associated with each process (see Figure Two for visual).  Funnel IT for Free actually queries the OS for this information so it is a more complete list than with some other tools.  The list shows modules loaded not only implicitly (linked) but explicitly (LoadLibrary).  In short, if there are multiple DLLs with the same name on a system, you’ll be able to see which one a given application is loading (which is probably not the right one, if you’re looking).

Hover over a module, and the tool tip gives the path of the loaded module.  Is that where you thought it was loading from?

Double clicking on a loaded module will display a window with file details for that module (see Figure Three).  From that window, you can easily scan the complete details of every module under that process by clicking “next” or “previous.” This is very useful to ensure consistency of version, copyright, and other information in testing.

Figure Two; Modules Grouped By Process

Image 2

Figure Three; Module Properties Box

Image 3

Running Processes Grouped By Module

What else is using this locked DLL?  This branch of the Funnel IT tree shows all the loaded modules on the system where the information was captured—and every task that is using each module.  If this sounds familiar, it is the same information as before, but in the opposite format, and has different benefits (see Figure Four for visual).

Aside from the obvious benefit of being able to see all the places a DLL is moonlighting (if only the current job market were as kind to people), this view addresses module rebasing.  Hover over the module, and the tool tip will display its load address.

Each DLL is built to be loaded at a specific base address.  If multiple DLLs are mapped into the same address space and their ranges butt heads, Windows automatically relocates (rebases) a module to another space in memory.  Funnel IT for Free shows not only the load address, but the relocated address.

If you want to avoid this runtime relocation (which uses extra physical memory) you can use Funnel IT to identify which modules are being relocated, and then build those DLLs to load at different, unique addresses outside the system range.

Back at the Funnel IT tree, double click on the module and you will get the same Module Properties window as described above.  If you’re in this branch, you might be looking to see who originally built this module, or what silly things they might have written in their version information.

Figure Four; Processes Grouped By Module

Image 4

General System Information

Which version with how much memory?  To diagnose what kind of equipment is showing the problems, this information is standard.  However, it is now also instant with each .sqa file generated.  Requirements matching made simple, with the addition of computer uptime (which is useful if you need to call someone and ask them: “when was the last time you actually left your desk?”).

  • OS Version
  • Processor Information
  • Memory Information
  • Display Information
  • Computer uptime

Figure Five; General Information

Image 5

Usability Features:

  • When a Funnel IT file is saved, the file is copied to the clipboard for easy pasting with existing defect systems or emails.
  • Runs on Windows 98 and above with IE 5 or above installed.
  • The Funnel file is compressed into a file that is usually about 20K—a very high rate of compression. 
  • Accepts a command line argument for quick launching of saved data—this is handy when you want to be able to launch the application from email or a defect report.
  • Automatically registers .sqa as a Funnel IT file for easy identification.
  • Accepts a command line argument to run “silent mode” to gather all the data and put it in a clipboard for easy emailing or attaching to a defect report, which is useful for test automation.

Why You Will Use This Tool

In various forms and by various means, you could get all this information somewhere else.  What you can’t get is one little application that holds all the answers in an easy-to-use tree format, the ability to gather it all in one click, and the ability to SAVE it and SEND it to someone.

The Future

A quick peak into what’s next?  Now that you have a very deep snapshot into any system at any time you want, wouldn’t it be cool if you could quickly compare .sqa files?  Or better yet, tell the Funnel IT application to gather specific information and files from any system.  Funnel IT for QE, available for sale December 8, 2003, does just that.

Compare IT

Load two .sqa files and they will show up in side-by-side windows in their normal tree format.  Click compare and they become a synched, color-coded (color-blind friendly) comparison report that you can still navigate for additional information.

Capture IT

In addition to everything gathered in Funnel IT for Free, Funnel IT for QE also captures:

  • TCP/IP Address information for found adaptors
    • DNS information
    • Domain name
    • Subnet mask, WINS settings, etc.
  • Network adaptor information
    • IP address, MAC address, etc.
  • Services
    • Running status, name, dependencies, start-up information
  • Installed software
  • On XP, Microsoft Updates (do you have the latest security patch?)
  • Drive information
    • Letter and path, UNC path
    • Total free space to user (quota)
    • Size/Used
  • Time zone information

Customize IT

Now for the really great part!  Funnel IT for QE is packaged with Funnel EdIT, an editor program that lets you configure your own versions of the Funnel IT application.  You can make your own information-gathering tool for your own purposes, with the capability to capture:

  • Specific files (files will be compressed and included, and will open on any system with compatible software for viewing)
  • File list information (directory)
  • Complete registry hives
  • Specific registry values

All of this is subject to a high rate of compression, and unless you do a file capture on the whole Windows System Directory the resulting .sqa file can still be easily attached and shared.

What it Means to Funnel IT, Revisited

Let’s go back and visit Sam and Bob.  In the initial scenario, the defect wouldn’t reproduce, and the developer ended up using one of the tester’s machines for half a day to track down the problem that was keeping them from resolving the actual defect.  With Funnel IT for QE, the whole conversation would have been:

02.01 9:10 AM Bob (Dev): Hey Sam, regarding your last PR, I compared our .sqa files and you had an old version of the print module. We updated it three days ago; it must not have gotten into the build.  Reassigning to Build/Install.


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Written By
Web Developer
United States United States
ByStorm Software's developer Gene Allen launched his commercial software career in the early 80’s at the age of 18 when he built an integrated word publishing, spreadsheet, and graphics package using Z80 Assembler on a TRS-80. Since then, he has alternated between the roles of architect, manager, and director at several companies including DacEasy, McAfee, Mission Critical and Net IQ. Owning his own company now allows him to be all three roles at the same time. He currently goes by the title of Development Guy, and takes great joy in using ByStorm’s products to streamline the testing of ByStorm’s products.

Marketing Gal Amy Anderson is the other side of the equation. While Gene is engineering fantastic software, Amy uses her MBA, background in marketing and communications, and sheer belief in the usefulness and quality of the products to do everything else. Her background as a professional ballet dancer helps her to lead the company Tai Chi sessions.

Comments and Discussions

GeneralOur Goal for Funnel IT Pin
ByStorm Software3-Dec-03 6:19
ByStorm Software3-Dec-03 6:19 
GeneralPicking on the wrong issue Pin
Stu B2-Dec-03 7:27
Stu B2-Dec-03 7:27 
GeneralMisuderstood comments Pin
dog_spawn2-Dec-03 12:07
dog_spawn2-Dec-03 12:07 
GeneralRe: Misuderstood comments Pin
Stu B4-Dec-03 10:25
Stu B4-Dec-03 10:25 
GeneralDependency Walker for Free! Pin
Sam Levy21-Nov-03 21:37
Sam Levy21-Nov-03 21:37 
QuestionWhere's the rating guage? Pin
WREY21-Nov-03 20:27
WREY21-Nov-03 20:27 
AnswerRe: Where's the rating guage? Pin
Uwe Keim22-Nov-03 2:45
sitebuilderUwe Keim22-Nov-03 2:45 
GeneralGUI questions Pin
dog_spawn21-Nov-03 7:26
dog_spawn21-Nov-03 7:26 
GeneralRe: GUI questions Pin
ByStorm Software21-Nov-03 7:47
ByStorm Software21-Nov-03 7:47 
GeneralRe: GUI questions Pin
Joel Holdsworth21-Nov-03 7:52
Joel Holdsworth21-Nov-03 7:52 
GeneralRe: GUI questions Pin
mogwai21-Nov-03 10:45
mogwai21-Nov-03 10:45 
GeneralSpot on Pin
dog_spawn21-Nov-03 12:35
dog_spawn21-Nov-03 12:35 
GeneralRe: GUI questions Pin
Anonymous22-Nov-03 0:00
Anonymous22-Nov-03 0:00 
GeneralRe: GUI questions Pin
.gonad22-Nov-03 4:40
.gonad22-Nov-03 4:40 
GeneralRe: GUI questions Pin
Owen Hines22-Nov-03 13:27
Owen Hines22-Nov-03 13:27 
GeneralRe: GUI questions Pin
sequoia971-Dec-03 7:39
susssequoia971-Dec-03 7:39 
GeneralRe: GUI questions Pin
Dia-menz30-Dec-03 9:08
Dia-menz30-Dec-03 9:08 
GeneralRe: GUI questions Pin
dog_spawn9-Jan-04 6:25
dog_spawn9-Jan-04 6:25 
GeneralRe: GUI questions Pin
rnichols5-Mar-04 21:26
rnichols5-Mar-04 21:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.