Show All Projects
Each time a KTM batch class is published, the current version of the KTM project is copied to CaptureSV\PubTypes\Custom. This utility will detect projects that are no longer needed and move them to location folder where they can be archived or deleted.

This is no longer be needed as of Capture 9.0.3.8 or 10.0.1. You should upgrade rather than use this utility.

Timeline

  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Project / Id )  0.0109
Total Execution Time  0.0128
  GET DATA  
No GET data exists
  MEMORY USAGE  
870,920 bytes
  POST DATA  
No POST data exists
  URI STRING  
project/id/81/KTM_Published_Project_Cleanup
  CLASS/METHOD  
project/id
  DATABASE:  smkprojects (Project:$db)   QUERIES: 5 (0.0033 seconds)  (Hide)
0.0006   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '81' 
0.0005   SELECT *
FROM `Projects`
WHERE `ProjectID` = '81' 
0.0005   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '81' 
0.0009   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)