Resolution
How do I automate the import for Directory and Resource Administrator reporting?
fact
Directory and Resource Administrator 6.50
fact
Directory and Resource Administrator 7.5
fix
The following information can be found within the Directory and Resources MMC online help at NetIQ.com. The specified command can be included in a batch file and then scheduled to run nightly with the Windows Task Scheduler.
To import data from the command line, you must be associated with the 'Built-in Reporting' role. Reporting provides the following command for importing data into the reporting database:
- Syntax
- OAREPT /IMPORTBATCH [/LINKDB:dbname] [/SERVER:AdminServer]
This command uses the import settings most recently specified on the Directory and Resource Reporting Import window. By default, Reporting looks for the specified file in the directory: Program Files\NetIQ\DRA\Reporting.
- Options
- /LINKDB:dbname
This Specifies the database file used for Reporting to import data.
If you do not specify the /LINKDB option, the Reporting creates the OAREPT-adminserver.mdb file and imports the data into the new file.
If you specify the /LINKDB option, the tool imports data into the database file specified by the dbname variable. You can either specify the full path or just the .mdb file name for the dbname variable.
If you only specify.mdb file name, Reporting looks for the specified file in the directory last specified on the Select Import Database window.
To display the 'Select Import Database' window, click Select Import Database on the File menu. By default, Reporting looks for the specified file in the directory: Program Files\NetIQ\DRA\Reporting. - /SERVER:AdminServer
Specifies the Administration server from which you want to import data.
note
The information provided above with regards to importing data from the command line is included within the DRA MMC online help. The specified command can be included in a batch file and then scheduled to run on a nightly basis using the Windows Task Scheduler.