I think publish reports have both a database record and file in the file system - so RQL is probably the way to go, although you can do it directly in Server Manager - no need for asp/vbs script.
In server manager, there should be a sample job which you can use to do this called "DeleteExportReport" Obviously, you'll need to configure the schedule, supply a valid usr/ pwd and replace the [#xxx#] variables with actual constants ([!yyy!] variables will be substituted at runtime). Paul. On Aug 23, 7:21 pm, markus giesen <[email protected]> wrote: > Hey Jo, > > I actually meant a simpler approach. Your log files are stored on the > CMS server, most likely somewhere under: > \Program Files\Open Text\WS\MS\ASP\LOG\... > > I would bypass the CMS and just delete them using a .bat file or > a .net executable which gets triggered as scheduled event. > No RQL needed I'd say. > > Cheers, > Markus > > On 23 Aug., 15:40, Jo <[email protected]> wrote: > > > > > Thanks Markus, > > > Could you look at the above code which has done as a scheduled job > > inside cms? > > Is that what you meant ? > > > Thanks, > > Jo > > > On Aug 23, 5:00 am, markus giesen <[email protected]> wrote: > > > > you can always write your own batch job outside of CMS and run it as > > > scheduled task on your Windows Server.. > > > Would that work? > > > > On 19 Aug., 03:52, Jo <[email protected]> wrote: > > > > > Thank you Neil, > > > > > We are on version 9 and it has also has got that option. But I don't > > > > want to delete all the reports in one go. I just want to delete > > > > specific days. Can we achieve that using a script or scheduled job? > > > > > Thanks, > > > > Jo > > > > > On Aug 18, 1:57 pm, Neil <[email protected]> wrote: > > > > > > Hi > > > > > > What version are you using? We are on v10 and there is an option to > > > > > 'Delete Job Reports' in the action menu when selecting Administer > > > > > Publication > Job Reports, which deletes all reports in one go. > > > > > > Neil > > > > > > On Aug 18, 8:51 am, Jo <[email protected]> wrote: > > > > > > > Hi, > > > > > > > We have a long list of publishing report for our live project in > > > > > > reddot cms. > > > > > > Other than dleting it manually one by one, is there any way that we > > > > > > could delete it , like for a motnhs report? > > > > > > > I tried to write a script, which didn't work as expected.I tried to > > > > > > run the script as scheduled job. This is based on another post here. > > > > > > > -------------------------------------------start > > > > > > code----------------------------------------------------------------------- > > > > > > ----------------------------- > > > > > > <% > > > > > > > '***************************************************** Settings > > > > > > ***************************************************** > > > > > > > ProjectGUID = "8517ABAA4EB248C795B3344E7B31EE4C" 'Project GUID > > > > > > pageGUID = "F5D623EFABBF407CAE52BF267D775986" 'GUID of page > > > > > > that > > > > > > contains text field > > > > > > linkGUID = "9336EB5B39154C1DACEC9285719E2D7P" 'GUID of > > > > > > anchor or list > > > > > > that the above page is connected to > > > > > > folderGUID = "00F18BD2FD6D4E5DB005E8F644737AC0" 'GUID of > > > > > > resource > > > > > > manager folder where images are stored > > > > > > textField = "txt_images" > > > > > > 'Name of text field to update > > > > > > Username = "xxx" > > > > > > 'Username of user with sufficient rights to > > > > > > publish page > > > > > > Password = "xxx" > > > > > > 'Password of above user > > > > > > reportGUID = "44787BD40B04479C861632D089826358" 'GUID of > > > > > > the job > > > > > > report > > > > > > daysno = "100" 'delete > > > > > > reports before x days > > > > > > > '*************************************************** End Settings > > > > > > *************************************************** > > > > > > %> > > > > > > > <html> > > > > > > <head> > > > > > > <style> > > > > > > body { > > > > > > font-family: Verdana; > > > > > > font-size: 0.8em; > > > > > > } > > > > > > .error { > > > > > > color: #f00; > > > > > > } > > > > > > </style> > > > > > > > </head> > > > > > > <body> > > > > > > > <% > > > > > > 'on error resume next > > > > > > > ' ### Define server objects > > > > > > set objIO = Server.CreateObject("RDCMSAsp.RDPageData") > > > > > > objIO.XmlServerClassName = "RDCMSServer.XmlServer" > > > > > > set objXML=Server.CreateObject("Microsoft.XMLDOM") > > > > > > > ' ### Login to CMS > > > > > > xmlData = "<IODATA>" &_ > > > > > > "<ADMINISTRATION action=""login"" > > > > > > name=""" & Username & """ > > > > > > password=""" & Password & """/>" &_ > > > > > > "</IODATA>" > > > > > > loginData = objIO.ServerExecuteXml(xmlData, strError) > > > > > > Call objXML.LoadXML(loginData) > > > > > > set loginData = objXML.selectSingleNode("//IODATA/LOGIN") > > > > > > LoginGUID = loginData.getAttribute("guid") > > > > > > > ' ### Retrieve session guid > > > > > > xmlData = "<IODATA loginguid=""" & LoginGUID & """>" &_ > > > > > > "<ADMINISTRATION action=""validate"" guid=""" & > > > > > > LoginGUID & """ useragent=""script"">" &_ > > > > > > "<PROJECT guid=""" & ProjectGuid & > > > > > > """/>" &_ > > > > > > "</ADMINISTRATION>" &_ > > > > > > "</IODATA>" > > > > > > sessionData = objIO.ServerExecuteXml(xmlData, strError) > > > > > > Call objXML.LoadXML(sessionData) > > > > > > set sessionData = objXML.selectSingleNode("//IODATA/SERVER") > > > > > > SessionKey = sessionData.getAttribute("key") > > > > > > > Response.Write ("SessionKey : "+SessionKey+" ") > > > > > > > xmlData = "<IODATA sessionkey="""" & SessionKey & """">"&_ > > > > > > "<PROJECT guid=""" & ProjectGuid & """ > > > > > > sessionkey="""" & SessionKey & """">" &_ > > > > > > "<EXPORTREPORT guid=""" & reportGUID & """ > > > > > > action=""deleteall""/>" &_ > > > > > > "</PROJECT>" &_ > > > > > > "</IODATA>" > > > > > > > sessionData = objIO.ServerExecuteXml(xmlData, strError) > > > > > > Call objXML.LoadXML(sessionData) > > > > > > > 'days=""" & daysno & """ > > > > > > > Response.Write ("deleted ??") > > > > > > > ' ### Log out > > > > > > xmlData = "<IODATA loginguid=""" & LoginGUID & """>" &_ > > > > > > "<ADMINISTRATION><LOGOUT guid=""" & LoginGUID & """ > > > > > > /></ADMINISTRATION>" &_ > > > > > > > "</IODATA>" > > > > > > objIO.ServerExecuteXml xmlData, strError > > > > > > > Response.Write ("Job reports deleted.") > > > > > > > ' ### Dispose of objects > > > > > > set objXML = nothing > > > > > > set objIO = nothing > > > > > > %> > > > > > > > </body> > > > > > > </html> > > > > > > > --------------------------------------------------------end > > > > > > code----------------------------------------------------------------------- > > > > > > ------- > > > > > > > Please anybody help me on this ? > > > > > > > Thanks, > > > > > > Jo- Hide quoted text - > > > > > > - Show quoted text -- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en.
