Show All Projects
This is a sample utility built against Kofax Transformation Toolkit 5.0 which lists databases used by a KTT/KTM project. It allows you to drag a project (fpr file) to load it, then press the button to display any databases used.

I thought it might be useful to build utility which would quickly show a bunch of info about a project file, however building it against KTT means that it can only be used with a license and product installed which very few people have. If I make something along the same lines in the future, I would do it differently, so it didn't have a product and licensing dependency.

Source included, but of course it requires KTT 5.0 to build.

Timeline

Files

Screenshots

  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Project / Id )  0.0166
Total Execution Time  0.0186
  GET DATA  
No GET data exists
  MEMORY USAGE  
905,192 bytes
  POST DATA  
No POST data exists
  URI STRING  
project/id/69/KTM_Project_Hacker
  CLASS/METHOD  
project/id
  DATABASE:  smkprojects (Project:$db)   QUERIES: 5 (0.0081 seconds)  (Hide)
0.0006   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '69' 
0.0049   SELECT *
FROM `Projects`
WHERE `ProjectID` = '69' 
0.0006   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '69' 
0.0011   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) >
0.0010   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) > 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)