GWAuditReport

0 Likes
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

Labels:

How To-Best Practice
Comment List
Parents
  • 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.
Comment
  • 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.
Children
No Data
Related
Recommended