3 Replies Latest reply on Sep 21, 2009 1:28 AM by mcolen

    Unable to Delete Template Copies

    Rookie

      Hi,

       

      I'm having al little problem with deleting some old templates within the Landesk OSD.

      Normally the templates copies ( with the timestamp) are locked and after the job is finished you can delete them.

      But now I have several of those template copies which are NOT locked and they cannot be deleted.

       

      I allready used the "Managing Template Copies in Provisioning Rev 1.0.pdf" which works fine for cleaning up the normal template copies

      But stil these few unusual copies remain in my list.

       

      I did a little SQL searching and found that the following statement gives me a list of the template copies

       

      SELECT [PROV_TEMPLATE_DEF_IDN]
            ,[OWNING_USER_IDN]
            ,[NAME]
            ,[DESCRIPTION]
            ,[PREBOOT_OS]
            ,[FINAL_OS]
            ,[LAST_MODIFIED_DATE]
            ,[FROZEN_IN_TIME]
            ,[IN_OUBLIETTE]
            ,[LUID]
        FROM [LDMS].[dbo].[PROV_TEMPLATE_DEF]where [NAME] LIKE 'Laptop%' AND [IN_OUBLIETTE]=0 AND [PROV_TEMPLATE_DEF_IDN]<2700
      GO

       

      I think that replacing the SELECT command with DELETE will delete it and cleanup my  public template list but I'm not sure if it doesn't destroy other things.

      Any one who can give me some advise ?

       

       

       

       

       

       

      ( using LDMS 8.8 sp3)