Show All Projects
This is intended as a way to see any stations with open modules in Kofax Capture. This correlates checked out licenses with current database connections. In versions before the License API was exposed only database connections will be listed. This utility should work from 6.1 to 10.2, listing license information from 7.50.857+/8.0.1033+ and and subsequent major versions.

I wrote this because AC Connection Lister (not written by me) was not compatible with KC8, and as a way to include the most useful subset of functionality from KELU.

Timeline

Files

Screenshots

  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Project / Id )  0.0332
Total Execution Time  0.0352
  GET DATA  
No GET data exists
  MEMORY USAGE  
906,120 bytes
  POST DATA  
No POST data exists
  URI STRING  
project/id/12/KC_Connection_Lister
  CLASS/METHOD  
project/id
  DATABASE:  smkprojects (Project:$db)   QUERIES: 5 (0.0034 seconds)  (Hide)
0.0005   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '12' 
0.0005   SELECT *
FROM `Projects`
WHERE `ProjectID` = '12' 
0.0004   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '12' 
0.0010   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) >
0.0009   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) > 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)