BusinessObjects Board

Bulk Delete User Documents

I got this to work fine on BOE XI3.1 SP3 by simply copying the folder to

C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\warfiles\WebApps\AdminTools

Restarting Tomcat

calling the start.jsp page
http://:8080/AdminTools/cleanup/start.jsp

did not need to recompile the .war file and all worked just fine - great little app for sure. But be aware of the note in the first post…

Users who simply open and refresh documents in their favorites folder (don’t resave them) don’t update the timestamp so the file appears to be old even though they’re using it… delete that and your the bad BO guy :hb:


paul@wil5on.com :south_africa: (BOB member since 2010-04-14)

Hi Red
I don’t suppose there is any chance of a copy of your VB utility is there?
Pretty please!
Cheers,
Sandi


SandiR :uk: (BOB member since 2004-12-20)

Have you used this little app on SP3/FP3.3 by any chance? I tried to follow your instructions, but when I got to the part of ‘calling the start.jsp page’ (I opened an IE and typped in the path to the warfiles/webappas/admintools/cleanup folder) adding the ‘start.jsp’.

but I just got errors Http, etc.

Here is what I put into the Address bar:

http://:80/admintools/cleanup/start.jsp

also

http://:8080/admiontools/cleanup/start.jsp

both got Http errors.

I had restarted Tomcat prior to both. What am I missing or did I miss a step? (I just unzipped the download and put the cleanup folder into specified directory for my server installation.)

Any thoughts on what I may be doing incorrectly?

Thanks if you can help !!!

Carol


carol.gottlieb (BOB member since 2008-10-01)

I am having this same issue. I keep getting a 404 error. I downloaded the cleanup folder locally. I extracted the folder and copied it to the \BusinessObjects Enterprise 12.0\warfiles\WebApps\AdminTools folder. I then restarted the Tomcat server. No matter what I do I continue to get the 404 error. Pls HELP!


marrigo (BOB member since 2011-08-24)

Hi we’re trying to use this tool and it appears that it only appears to work for users up through the letter D. We’ve looked at the query and we can’t see anything that would be limiting it to this and we really need to get this working so that we can move to a new load balanced environment. We have a lot of cleanup to do.


tim schulte :us: (BOB member since 2003-12-11)

I haven’t looked at this code but perhaps wherever you see a " SELECT SI_ID, SI_NAME …"

Change it to:

“SELECT TOP 200000 SI_ID, S_NAME …”

unless it already has a “TOP x” present.

Hope this helps


Atul Chowdhury (BOB member since 2003-07-07)

Does this actually delete the objects from the filestore folders??? I just used the tool to delete 7000+ objects from user inboxes, but the size of the INPUT folder did not go down AT ALL.

EDIT: I did not put this in the warfiles directory, is this the problem?

oh boy, what have i done??? the records are gone from the database but the files are still in the filestore.

Also, I ran this against production while the ‘cleanup’ folder is on the dev server, could this also be part of the problem?

EDIT 2: Files do not show in user inbox, but DO show up in query analyzer, and DO exist in FRS.

EDIT 3: color me stupid. the files are in the personal folders, not the inbox.

I’m just going to go ahead and leave you all alone now…


KimberlyJ (BOB member since 2008-10-28)

I got it to work and I’m on XIR3.1 SP3 FP 3.3. I put the folder under :\Program Files\Business Objects\Tomcat55\webapps\AdminTools


rxvera :us: (BOB member since 2005-10-11)

Kalyan - I’m assuming this scripts deletes inbox/favorite documents from the FRS as well, in addition to the entries in CMS DB?


sdeshpan :us: (BOB member since 2005-06-28)

can any one post the script for deleting log files on BO servers whose are X days older.


vk_0432 (BOB member since 2011-11-02)

This is off-topic for this thread but here is your answer.

The code below is for Windows. Change the folder path in the CD and in the Forfiles to the folder you wish to delete the old files from. The -d -30 is the number of days old to delete files. The example below deletes all files in the directory listed with dates more than 30 days ago. There are many temp folders and I do not have a list of all of them.


C:
CD "\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Logging"
Forfiles -p "C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\Logging" -m *.* -d -30 -c "Cmd /C DEL /Q @FILE"

Steve Rademacher :us: (BOB member since 2004-02-17)

Thanks Steve.


vk_0432 (BOB member since 2011-11-02)

Has anybody tried this on BI 4.0 (assuming that BI 4.0 doesn’t have something built in to do this, if it does I can’t find it :roll_eyes: )

Andy


andytheman :uk: (BOB member since 2005-01-28)

Should be ok since CMS sdk XI3 is equivalent to CMS sdk BI4 …

Give a try and let us know …

I’m having the same issue. i only see the accounts that start with a number and some of the ones that start with the letter A.

Is there a limit in one of the JSP’s?


sabeasey (BOB member since 2010-07-19)

Has anyone got it to work on XI R2? Folder structure is slightly different than in 3.1, so if anyone knows how to implement such a useful tool on XI R2 please share :slight_smile: Thanks.


Roger45 (BOB member since 2012-10-17)

I’m using BOXI R3.1 and AIX OS. After I deployed cleanup folder into Admintool.war I restarted my WebSphere. I can able to login Non - Production Environment.

After I delete all inbox instances, my disk size didn’t change. I think this deletion doesn’t work for Physical file under frsinput folder. It only work for API (CMC).

Any suggestions on how to delete inbox instances from frsinput dir.


Madu :us: (BOB member since 2008-02-08)

Hi All,

Regarding your post on

I have tried to call the start.jsp page
http://:8080/AdminTools/cleanup/start.jsp ,and I could login , but it is not showing all list of reports which are there in user inboxes & also not showing any favourate folder reports.

It has shown only 1 or 2 docs which are in EXCEL formate.

Please help me if there is anything missing…


Regards,
Mohan


mohancanada (BOB member since 2013-10-23)

Didn’t I see or hear about a VB macro that does deletes both from repository as well as the file system?!

I thought it was in an Excel spreadsheet but cannot remember the name. If anyone can help that would be much appreciated


ColumbiaIT (BOB member since 2011-06-15)

What about a script that Deletes folders->subfolders based on a name derived by date.

i.e.
Public Folders
…01_01_14
…02_01_14

So the script would need to delete all the reports withing the folders both on the server as well as within the CMS

anyone have something similar to this… please?


CrystalSx (BOB member since 2014-05-15)