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.0019
Controller Execution Time ( Project / Id )  0.0117
Total Execution Time  0.0136
  GET DATA  
No GET data exists
  MEMORY USAGE  
901,608 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.0037 seconds)  (Hide)
0.0006   SELECT *
FROM `ProjectResources`
WHERE `ProjectID` = '81' 
0.0006   SELECT *
FROM `Projects`
WHERE `ProjectID` = '81' 
0.0005   SELECT *
FROM `ProjectTags`
WHERE `ProjectID` = '81' 
0.0011   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)