Cool Solutions

GWAuditReport



By:

July 23, 2010 12:13 pm

Reads:9,916

Comments:5

Score:Unrated

License:
Free

Download GWAuditReport_1.1

When you need to do an audit of your GroupWise system (for licensing true-up or otherwise), you would create a GWCheck Audit report:

 

which produces a resulting log file that’s not very helpful because it is not in a format that you can import into a spreadsheet for reporting purposes.

I sure wish that GWCheck would give us a delimited output (or an option for it) so that we can have more flexibility to work with the data it produces! if you agree, feel free to submit an enhancement request here)

 

GWAuditReport is a utility, much like my GWAttachmentStats, that takes the GWCheck log file and turns it from this:

 

into a TAB-delimited file, that can then be brought into a spreadsheet, so it looks like this:

 

I can more easily identify outdated/unused and inactive mailboxes so that I can cleanup my system *BEFORE* submitting the audit to Novell. I saved over 10% in my GroupWise licensing costs by taking this proactive measure!

 

2014-02-23: Updated v1.1 to address DirChange error

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.
Loading ... Loading ...


Categories: Uncategorized

Disclaimer: This content is not supported by Novell. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.

5 Comments

  1. By:rjlayton

    When I run this on WInXP I get this message. DirChange(FilePath(FileSpec)).
    It appears to be hard coded to O:\wbt\gwauditreport\
    Here is more info on this.

    1031: DirChange” Dir not found.changed

    on line 819 of O:\wbt\gwauditreport.wbt
    in routine “recentfilesudf”

  2. By:gwittig

    I was looking for a utility like this in Spring of 2009.

    I solved it by using a VBA procedure in Access.

    This is certainly a quicker method for when the boss wants a quick count for licensing.

    Thanks,

    Glen Wittig

  3. By:debbie_hunt

    I am having great trouble downloading this tools. The zip files seems to be corrupt and reports that it is missing 332 bytes of data.

    Would really appreciate getting a copy of this if possible.

    Debbie

  4. This GWAuditReport.exe will run under Windows XP to Windows 8.10.

    This utility, when run, looks for an empty subdirectory of

    c:\Novell\GroupWise\

    to start looking for GWCheck log files. If it can not find this

    subdirectory, you will get a startup error of:

    1031: DirChange: Dir not found/changed
    On line 819 of O:\wbt\GWAuditReport.wbt
    In Routine “recentfilesudf”
    DirChange(FilePath(FileSpec))

    So just create this subdirectory to get this program going.

    After the program has run successfully one time, it creates a

    Windows Registry branch of

    HKCU\Software\KeedleWorks\GWAUDITREPORT\LastOptionsDir

    with the path to the directory you last worked with. Now you

    no longer need the empty subdirectory of c:\Novell\GroupWise\

    After the program runs once, it also creates a WBDHB44I.DLL file

    in the directory where its executable is located.

  5. Looks like bkeadle uploaded a newer v1.11 version dated 3-5-2014 of GWAuditReport.exe that no loner requires the sub-directory of C:\Novell\GroupWise\. Great. Now it looks for files in the sub-directory that you start the program up in. Thanks.

Comment

RSS