Running the scripts on Windows
Table of Contents
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:
- Place the M42DataCollectionWindows directory including all its files in any folder on the target systems.
- 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
- Copy the M42VMwareDataInventory.ps1 script to any folder on the VMware host system.
- 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"
- 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 | — |