Running the scripts on Windows

The scripts need to run on every system with Oracle databases and/or Java. If it is a virtualized system, then these must also be run on the "host" system.

Exception: VMware. For VMware "hosts" please use the Dataprovider VMware.

After the installation of the "Oracle Compliance" extension, the scripts can be found in the folder Matrix42\Matrix42 Workplace Management\OracleLocalInventory.

To execute the data collection scripts on Windows systems:

  1. Place the M42DataCollectionWindows directory including all its files in any folder on the target systems.
  2. Run the M42OracleDataCollection.cmd file as an Administrator.

Running the script will generate files and put them in the Output folder in the root directory. In addition, a compressed <hostname>. zip file with contents of the Output folder will be created. 

Starting with Version 3.11, there is a new optional parameter ExecRemoteSigned for the M42OracleDataCollection.cmd.
Running M42OracleDataCollection.cmd ExecRemoteSigned will execute signed PowerShell scripts in environments if the Execution Policy is set to Restricted.

Collecting Information from VMWare Environments

You can find the M42VMwareDataInventory.ps1 script at Matrix42\Matrix42 Workplace Management\OracleLocalInventory\M42DataCollectionVMware. This PowerShell script collects inventory and configuration data from VMware environments via vCenter. It supports both direct credential input and interactive login prompts.

Execution Steps on Windows

  1. Copy the M42VMwareDataInventory.ps1 script to any folder on the VMware host system.
  2. Run the script in PowerShell, with appropriate parameters. For example: 
.\M42VMwareDataInventory.ps1 -vcentername "vcenter.company.local" -user "admin@vsphere.local" -password "yourpassword" -dir "C:\VMwareExport"
  1. Output data files will be saved in the specified output directory, with the file name ($servername)-vmware_data.xml.
Parameter Description Required Default
-vcentername Address of the vCenter server Yes
-user Username to connect to vCenter No
-password Password for the provided user No
-credentials Prompts for credentials via Windows GUI No
-hosthistory Host history days offset No 0
-dir Output directory for export files No .
-version Display script version (1.0.0) No
-help Display usage instructions No