Page last updated on March 3, 2010
The following is a list of recent changes and improvements made to iFileAudit. Most
changes are made as the direct result of a customer request. If you have changes you would like
to see made to iFileAudit, send E-mail to us by clicking here
Index:
iFileAudit Updates:
Release 2:
Release 1:
Effective date: March 3, 2010
This PTF includes a change to the Work With File Registrations process. In prior releases, when a
journal gets detached from a file by some event outside of iFileAudit's control, the '*ACTIVE' status
shown in the file list is flagged with an alternate color, normally orange. By placing a '9' option
next to the file, you could re-connect the file to the journal.
With this change, the journal reset will now also do a full file reset for the registered file and
force iFileAudit to pick up the latest file definition and file key definition for analysis use purposes.
This is based on the assumption that when a journal gets detached from the file, it is normally caused by
the file being changed.
This update is available via the Internet as PTF package FAPTF309. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: September 16, 2009
When using the report features or export feature in iFileAudit, a starting date is always requested
for the function. With this change, a new option has been added. When you specify a starting date
of *WEEK, the start date for the process will be set to one week prior to when it is run.
These updates are all available via the Internet as PTF package FAPTF305. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: July 13, 2009
Several customers have requested that iFileAudit make its extracted information available to end users
who are not defined to the system as security officers. This has now been changed. With this new
release, a security officer can maintain a table of end user profiles that should be allowed access
to the display and reporting functions in iFileAudit. As of this change, this only applies to the
terminal interface. The browser interface still requires a security officer for use.
These updates are all available via the Internet as PTF package FAPTF302. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: July 1, 2009
Release 3 of iFileAudit is now available. Release 3 includes a major upgrade to the product with
the introduction of a browser-based web-enabled interface to the product.
This update is only available to current customers via direct update from CD or by web download. To request
your upgrade, just let us know by email and we'll send the update to you right away. This
update combines all of the changes made since the product's last major release and includes
a complete update to the documentation manual. A second manual is also now available that concentrates
on the web-enabled features.
Release 2 updates:
iFileAudit now adjusts to database changes automatically.
Effective date: June 22, 2009
A new release of iFileAudit made available today (Release 2.27) now automatically senses when
changes have been made to a database that is being tracked by the software. When this happens,
iFileAudit will now adjust itself to the new database including auditing new fields added, dropping
fields that have been deleted and adjusting for changes made to specifications for fields already
being tracked. Prior to this, a clumsy manual process was required when changes were made to a
database that was being tracked.
These updates are all available via the Internet as PTF package FAPTF227. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: April 30, 2009
Prior to this release level (2.24), when you specified a default journal for a file, the journal
would be stored either in the iFileAudit application library or the library where the file object
is stored. This approach created some customer problems with iFileAudit version upgrades and
with journal management. With this release, iFileAudit gives the customer control over where
the default journals are stored by separating them out into their own library. A conversion
process will run during PTF installation for all currently registered files so that your current
journals will continue to be used.
These updates are all available via the Internet as PTF package FAPTF224. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
and Export processing enhanced.
and Add option to unregister files from WRKIFAREGS command.
Effective date: March 31, 2009
All of these changes have recently been requested by customers and have now been implemented. Prior
versions of iFileAudit provided some support for VARCHAR fields, this is now fully supports. The
Export process has been enhanced to support processing *ALL or GENERIC* file selections similar to
the way the reports are now processed. The Work With iFileAudit Status (WRKIFAREGS) command has
been enhanced to allow for files to be unregistered when they are changed to inactive status.
These updates are all available via the Internet as PTF package FAPTF222. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: March 26, 2009
A customer requested that we add tracking on journal stop and start activity for each file
registered to iFileAudit. This capability has now been added.
This update is available via the Internet as PTF package FAPTF221. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: January 30, 2009
Several customers have requested the ability to create reports based on archived history from
the iFileAnalysis process. The archive is an option on the iFileAudit purge process. This feature
is now available for all reports in iFileAudit as an option.
This update is available via the Internet as PTF package FAPTF218. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: January 21, 2009
Some customers have expressed an interest in limiting the scope of the file analysis process
in iFileAudit due to disk capacity constraints. To help with this, we have added new
parameters to the file analysis process that allow you to only analyze up to a specific
date and time. This allows the customer to run a large analysis in segments to avoid
disk capacity issues on a system with limited disk resources.
This update is available via the Internet as PTF package FAPTF217. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: January 15, 2009
Based on customer feedback, we looked at the process for analyzing many files at once
to see if processing efficiency could be improved. With this change, we have re-engineered
the file analysis process. With these changes, when you run the file analysis for *ALL files
in a library or for a GENERIC* file group in a library, the process will take less time
to complete. The improvement will be especially dramatic for customers who have a large
number of files defined and who are using shared file journals (multiple files using the same
journal objects). The performance improvements have also been extended to include the
Automatic Analysis process for those customers who have implemented that feature.
This update is available via the Internet as PTF package FAPTF216. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: November 18, 2008
Based on a customer request, we have added the text description of the file being reported to
the headings for all reports. This is in addition to the library name and file name. It makes
reviewing reports a little easier, especially for non-IT resources.
This update is available via the Internet as PTF package FAPTF213. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: July 31, 2008
iFileAudit uses several alternate view files for information display and reporting. Until now,
these files were always built on-the-fly as needed and then discarded. A new feature now
implemented allows you to maintain these alternate view files permanently. While this uses
some additional overhead, it speeds to information display and reporting.
This update is available via the Internet as PTF package FAPTF211. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
and ....
New field on Auto Analysis Status display.
Effective date: July 17, 2008
All printed reports in iFileAudit now include report headings that show the selection criteria
that were used when the report was run. At the end of each report, a set of summary totals
is also now printed.
Also with this release, the Automatic Analysis Status display is enhanced. To the right of the
"Last analysis start time/date" fields, the date when this last analysis was started is also now
shown.
These updates are available via the Internet as PTF package FAPTF209. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
and ....
Option added to run current analysis during display feature.
Effective date: June 19, 2008
iFileAudit now supports a selection prompt for finding the library name and file name on
your system. When registering new files, this makes finding the exact library and file
name information easier.
Also, the display file analysis results in iFileAudit now supports an option to update the
analysis with the most recent file information. This will let you display the most recent
results by running a single step.
These updates are available via the Internet as PTF package FAPTF206. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: May 28, 2008
At the request of a customer, we have expanded the change analysis within iFileAudit to
include rollback transactions. These were not processed in earlier versions of the product.
This update is available via the Internet as PTF package FAPTF204. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: May 22, 2008
A key component of iFileAudit is the periodic analysis journals for registered files to
extract file activity. Prior to this change, it was the customer's responsibility to see
that this analysis process was done on a regular and timely basis. With the addition of
this new Automatic Analysis process, iFileAudit now supports a batch process that will
periodically run the analysis process for all registered files.
This update is available via the Internet as PTF package FAPTF203. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: April 29, 2008
For some time now, iFileAudit has allowed you to manually specify a key structure for flat
files that have no built-in key structure. With this change, iFileAudit will now let you
choose a key structure from an logical file that is associated with your sequential flat
file.
This update is available via the Internet as PTF package FAPTF202. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: April 15, 2008
Release 2 of iFileAudit is now available.
This update is only available to current customers via direct update from CD. To request
your upgrade CD, just let us know by email and we'll ship the update to you right away. This
update combines all of the changes made since the product's original introduction and includes
a complete update to the documentation manual.
Release 1 updates:
Effective date: April 2, 2008
A new field has been added to the iFileAudit tracking database to record the job number of
the job that updated the field being reported. This information is reported on the detail
display screen and is also available using the new export database function.
This update is available via the Internet as PTF package FAPTF133. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: February 21, 2008
Several customers have expressed interest in working with the output of the iFileAudit file
update analysis process using their own database reporting tools. To make this process
easier, we have added a new Export File Information utility. It will transfer information
on any database into your own file for use by your own tools such as SQL and Query/400.
This update is available via the Internet as PTF package FAPTF130. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: December 19, 2007
The Work With Registered Files display has been enhanced to highlight problems when files are
no longer on the system and when the journal connection to a file has been broken.
This update is available via the Internet as PTF package FAPTF128. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: November 8, 2007
This new feature in iFileAudit lets you optionally specify to limit the file tracking to only
a specific list of users for a file, or to include all users except those on a specific list.
The default continues to be tracking on all user profiles. For some customers who only want
to observer file changes for selected customers, this option can save storage space, especially
on very active database files.
This update is available via the Internet as PTF package FAPTF127. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: July 9, 2007
Based on a customer request, we have now changed all of the report printing commands to allow
for selecting *ALL file names or generic* file names when processing reports.
This update is available via the Internet as PTF package FAPTF125. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: June 14, 2007
We have added a new date selection parameter for all of the reports. In addition to selecting
records for the *CURRENT date, *STARTing date and a specific given date, we have now added an
option for records from *YESTERDAY.
This update is available via the Internet as PTF package FAPTF124. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: May 23, 2007
At the request of a customer, we have added the journal sequence number to the iFileAudit
transaction history database. It will now also be displayed with the online details and
can also be included in your own query reports against the data.
This update is available via the Internet as PTF package FAPTF123. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: May 18, 2007
To simplify purging of audit transaction history records, a second option has been added
which will allow you to purge based on the number of days of history that you want to keep
on file. The former method based on a specific date is still supported.
This update is available via the Internet as PTF package FAPTF122. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: May 18, 2007
For added processing flexibility, several of the processing commands in iFileAudit have
had a job queue name parameter added. When used, the processing will be sent to a system
job queue for execution, freeing up the interactive session.
This update is available via the Internet as PTF package FAPTF122. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: May 14, 2007
A new global option has been added to iFileAudit. When initially registering files, you can
now control how much of existing transaction activity will be included in the initial
analysis process. Until now, iFileAudit would always go back and pickup the oldest journal
transactions available. With this change, you can optionally specify that iFileAudit start
the analysis from the point in time when the file is registered.
This update is available via the Internet as PTF package FAPTF121. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: May 10, 2007
iFileAudit supports using existing journals, even when those journal only capture the "after"
record images. When this happens, the effectiveness of iFileAudit is limited. For these
customers, iFileAudit will generate a lot of analysis records, all containing information
of dubious value. To help these customers, we have introduced a new option at the file
level that will reduce the output from the file analysis process to one record per record
changed. This way, the customer will know the records that have been changed, but the field
values will be supressed.
This update is available via the Internet as PTF package FAPTF120. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: May 7, 2007
With this change, there are several new filter parameters that can be invoked when displaying
the files currently registered to iFileAudit for tracking purposes. You can limit the display to
just active or inactive files, files from a given library or library group, files with a
given filename or files using a specific journal or journal type.
This update is available via the Internet as PTF package FAPTF119. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: May 7, 2007
For customers who are not already journalling, iFileAudit has always had the ability to create
a journal for change tracking purposes. The option available until now created a separate
journal for each file registered and activated.
Within the operating system, it is possible for multiple files to share a common journal. This
change implements that as an option for iFileAudit customers.
This update is available via the Internet as PTF package FAPTF119. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: April 30, 2007
We found that a recent program change in the mass registration command, CRTIFAREG, resulted
in user-based journal information getting incorrectly recorded when registered with this command.
This has now been corrected.
This update is available via the Internet as PTF package FAPTF118. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: April 24, 2007
To make is easier to purge history information, we have added new options that allow you
to purge data from multiple files in a single process.
This update is available via the Internet as PTF package FAPTF117. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: April 11, 2007
To speed up the analysis process for customers with a lot of file update and change activity,
especially those customers who keep journals online for an extended period, iFileAudit has
been changed to limit journal extract processing by date and time.
This update is available via the Internet as PTF package FAPTF115. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: April 4, 2007
At the request of a customer, we have modified the report by user profile by adding more selection
options. With this change, you can select by specific user profile, generic* user profile or *ALL
profiles. You can also specify a specific filename, a generic* file name or *ALL files to be reported.
The report is run from option #8 on the MASTER menu. It is also called from option F11 when the
display by user profile is selected.
This update is available via the Internet as PTF package FAPTF114. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: March 30, 2007
When a programmer recompiles a database file that is being tracked by
iFileAudit, the link to the operating system journal is broken. When
this happens, tracking activity stops until the journal connection
can be re-established. A new option on the "Work With Registered Files
for Audit" (MASTER menu option #1) will now easily help you do this.
This update is available via the Internet as PTF package FAPTF113. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: February 22, 2007
To conserve disk resources, customers have requested that we add a feature that will allow
the security officer to optionally exclude specific fields from the iFileAudit analysis. This
feature is now available in the product. Once a file has been registered to iFileAudit, you
can call up a list of fields in the file and flag those fields that you want to exclude from
iFileAudit analysis processing.
This update is available via the Internet as PTF package FAPTF111. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: February 6, 2007
Several customers contacted us to request that the File Analysis process be improved by
allowing the analysis to be run for multiple files at once. As of this change, the process
has been improved to support processing for *ALL files within a library or for GENERIC*
filename selection within a library.
This update is available via the Internet as PTF package FAPTF110. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: January 25, 2007
A new feature has been added to iFileAudit that lets you manually enter and maintain a key structure
for files on your system where no key structure already exists for the file. For customers with a lot
of data stored in flat files, this change improved the ability to identify records in the iFileAudit
reports and displays.
This update is available via the Internet as PTF package FAPTF109. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Effective date: January 23, 2007
When originally released, all file registration was manually done from the menu option. With this
improvement, we have added two new commands to iFileAudit that let you register multiple files in a
single use of a command. Support includes registering all files in a library or the files in a library
that meet a generic* filename pattern.
In addition to file registration, the new commands also let you to multiple file activations and
de-activations by using a command. Multiple files can have their status changed in a single run
of the command.
This update is available via the Internet as PTF package FAPTF108. Registered customers of
iFileAudit can obtain this PTF as an E-mail attached file by just requesting it from us.
Instructions for installing the PTF will be provided along with the file. To request the PTF, click
on the E-mail link at the start of this page.
Phone: (518) 897-5002 Fax: (518) 897-5003
E-mail your questions or suggestions: 
Support@Kisco.com and we'll add your change to
our list of possible implementations.
To register your
E-mail address and receive automatic notification when this page is updated,
CLICK HERE.
iFileAudit Recent Changes Log
Release 3:
Journal reset option enhanced.
New starting date option added for reporting and extract processing.
Access to reporting features for non-security officer profiles.
iFileAudit Release 3 now available - with new browser interface.
Customer control of default journal library added.
Support added for VARCHAR data type fields.
Journal stop and start activity now tracked.
Reports can now be run from the Archive History data.
File analysis scope limits by date and time.
Analysis performance improvements implemented.
File descriptions added to report headings.
Control over maintenance of alternate view files.
Reports enhanced with new headings and report summaries.
Library and File selection prompts added during registration.
Analysis expanded to include rollback transactions.
Automatic Analysis process added.
New feature for manual key selection and specification.
iFileAudit Release 2 now available.
Export File Information utility feature added
Work With Registered Files Enhanced
Optionally limit file tracking by user profile
Exanded file selection parameter for reporting
New report selection parameter
Journal sequence number added to database
Additional purge selection option
New JOBQ options on processing commands
New file registration option
New file option for record level changes only
Registration Filter Parameters
New Shared Common Journal option
My files with pre-existing journals are getting registered
incorrectly
New history purge options
Performance enhanced for Journal Analysis processing
New Selection Options for User Profile Report
Journal Reset Option Added
Optional Field Level Exclude Feature
Process Multiple File Analysis
Manual File Key Maintenance Option
New Options for Multiple File Registration
Contact Information
Kisco Information Systems
89 Church Street
Mt Kisco, New York 12983
Support@Kisco.com