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.0141
Total Execution Time  0.0159
  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.0070 seconds)  (Hide)
0.0004   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '81' 
0.0034   SELECT *
FROM `Projects`
WHERE `ProjectID` = '81' 
0.0004   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '81' 
0.0015   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) >
0.0012   SELECT TagCOUNT(1) AS cnt
FROM 
`ProjectTags`
WHERE `Tag` != 'Private'
GROUP BY `Tag`
HAVING COUNT(1) > 
  HTTP HEADERS  (Show)
  CONFIG VARIABLES  (Show)