Vision Database Systems

Introduction

In IDMS v7.12.1.16 adds the Windows computer name to IDMS Auditlog transactions.

Requirements

• IDMS v7.12.1.16
• A varchar column named COMPUTER_NAME in the Auditlog database table
• The [Auditlog] section of the IDMS environment INI must have ComputerName=1

Step 1 - Add ComputerName to the IDMS environment

1. Open IDMS then select Utilities > Setup > Environments > Edit for the environment you wish to modify
2. Use Notepad's Edit > Find option to easily find the section titled [Auditlog]
3. Add a new line with ComputerName=1
4. Repeat steps 1-3 if your IDMS system has multiple environments

[AuditLog]
DSN=Vt…wf€|‡{Nh\WP†tNcjWP†w|„ƒ|w†NTccPi|†fNjf\WP]bXdf†x3fŒ†‡x€†3\W`fNjf\WP]bXj\aDCNWTgTUTfXPVt…wf€|‡{N
Table=AUDITLOG
  ;For Oracle put in Date=LOGDATE and Time=LOGTIME (The Default 'Date' and 'Time' were reserved words)
Date=LOGDATE
Time=LOGTIME
;Write to new Fields in Auditlog (1=Yes 0=No Default)
USER46=1
IS_PRIVATE=1
FINGERPRNT=0
ComputerName=1

Step 2 - Add COMPUTER_NAME to the Auditlog database table

1. Open SQL Management Studio and run the below script against the IDMS database
   

    

    

   USE [IDMS] --Replace with the actual IDMS database name if different
   GO
   ALTER TABLE AUDITLOG
   ADD COMPUTER_NAME VARCHAR(25)
   GO
     

    

    

Result