version: BOXI rls2
platform: MS Windows
download grep @ GnuWin - Browse Files at SourceForge.net
Updated 8/14/2007 – Version 1.1:
-fix export path, spaces were not allowed
-added FullClient documents to documentlist (no object scan is done, other tools available)
-added filesize in KB of the documents
-Instances are (if wanted) excluded in a proper way
WIDScanner_1_2.zip (43.0 KB)
jbo 
(BOB member since 2005-07-31)
Approved, and moved to BOB’s Downloads.
MichaelWelter 
(BOB member since 2002-08-08)
Revised with updated attachment – 8/14/2007
Bobarella (BOB member since 2004-02-12)
All I keep getting is “File not found”, every time I tell it to retrieve. Strangely, it does seem to find the files in the repo (saying 0/410) in the lower-right.
Can anyone help out with this?
XI R2 SP2, .Net InfoView only.
Thanks,
Kevin.
kevish 
(BOB member since 2005-06-01)
It sounds like your BOE environment has references to report objects in the CMS database, but the actual report objects no longer reside on the FRS. I had the same issue as you when using this tool - you’ll want to modify the code to check for existence of the file before the filesize is checked, and before the file is grepped for objects used.
A good first step might be to take a look at the records that were generated to the flat file / access DB and see if you can identify which report is causing your issue.
crystal01 (BOB member since 2006-08-30)
Has anyone tried to use the SECWINDOWSAD auth to access the information needed. I have tried it and it says I need the plugin but I don’t understand because we have AD setup in BOE.
Also, I am correct if you don’t have authority to the filestore path it will not access the information.
DonS (BOB member since 2006-06-26)
@kevish: I updated the program some time ago and it checks for missing files now. If it still doesn’t work for you it probably has to do with not having access rights to the filestore.
cannot get it uploaded to bob so you will have to download here:
http://rapidshare.com/files/115347212/WIDScanner_1_2.zip.html
jbo (BOB member since 2005-07-31)
This tool is AMAZING – incredible. 
The only thing I find is that, when I refresh to an MDB file (the only way to get the objects used, which is what we’re really looking for here), the MDB table wid_document_objects is empty. The Universes table is populated at looks great at first blush, just the objects table is empty.
You all have been so awesome on this with the input, so any additional help to get us the last couple steps would be very appreciated.
Thanks again,
Kevin. 
kevish 
(BOB member since 2005-06-01)
Do you have Grep installed and your classpath configured correctly? I experienced the same thing (everything worked fine but blank wid_document_objects table) when I didn’t yet have Grep configured correctly…
You should see a command line window “flicker” as it repeatedly executes the .wid file greps while the program is running - is this happening?
crystal01 (BOB member since 2006-08-30)
I do have grep installed (2.5.1a-2) from SourceForge. The bin directory of grep is added to the path environment variable, and I have verified that typing an unqualified “grep” at a command prompt results in the command asking for options:
C:\>grep
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.I do not observe the “flickering” that you mentioned.
You mentioned the classpath variable. Do I need to configure classpath also? I didn’t notice any .class files in the GnuWin32 directory.
Thanks again & Keep the input coming! 
Kevin.
kevish (BOB member since 2005-06-01)
jbo,
Will this work in Java env?
We are on BO XI R2 SP3 (Solaris) mounted on weblogic(Solaris) .
anair_bo (BOB member since 2006-12-05)
it’s a vba macro so it will only work in a windows environment, if your server resides on a java env it doens’t matter as long you have access to deski…
jbo 
(BOB member since 2005-07-31)
Got it! I added this line at 311, after noticing that the If bFileExists loop was short-circuiting. I’m not sure if I just got a bad download, since this code is definitely necessary, given the logic structure. The line I added is the third in this excerpt:
sFileName = CStr(IS_property.properties("si_files").properties("SI_FILE" & iCnt))
sFilePath = Replace(Replace(CStr(IS_property.properties("si_files").properties("si_path")), "frs://", ""), "/", "\")
bFileExists = oFso.FileExists(cFileStorePath + "\\" + sFilePath + sFileName)
If bFileExists ThenSo, previous to my edit, the code was calculating an update to the file name and path, but was not reupping the bFileExists to reflect this change.
Hope this helps someone out there! I always like to post my resolutions and keep this board kickin’ butt! 
Kevin.
kevish (BOB member since 2005-06-01)
Oops 
, updated the link above.
jbo (BOB member since 2005-07-31)
Great tool! Very useful. However I did find one bug (using the new version). The flat file extract breaks if a report has a carriage return in the comment section; it creates more than one row for that report.
Again, Thanks for a great tool! :o
Snabbles (BOB member since 2006-07-07)
I don’t have the full client 
meutte 
(BOB member since 2007-12-06)
This is a great tool, and this is a bit cheeky, but, is there any way I can add the number of rows returned for each document (what you see in Infoviews data summary page ? 8)
sdimb 
(BOB member since 2007-04-18)
I am not that expert on Grep command. Can some one please help me step by step to use this wonderful tool?
Thanks in advance.
BOpat (BOB member since 2006-11-09)
You really dont need to know about the Grep command, you just need to have it installed on your PC - do a search in Google for a free download - then unzip the WID scanner and in Deski open the report. You will see an extra option on the menu bar ‘WID’ click on it and follw the instructions - its really is that simple.
Hope that helps
sdimb (BOB member since 2007-04-18)
Hi,
Its a great function and working fine on XIR2 SP2
But can we get the same information about Universe log file instead of Reports
.
Thanks in advance,
Cva
cva (BOB member since 2006-05-20)