Lou has been kind enough to share a script he wrote to export the LAS data in buik so the SQL reports can be generated around the summary and trend reports in the NRC console. So one reason to run some thing like this s is you started using DRA today but did not install the DRA reporting until a year later. this script walks the LAS directory and re-exports the LAS data to summarize the data for the SQL reports. This has to be run on each DRA server and you will need to modify the path to the LARK directory and the Logarchive directory in the script.
On Error Goto 0
‘ VBScript to reload all DRA log archive data to NRC. Run from the DRA server.
‘ The Log Archive service must be shutdown (also shutdown the Administration Service ‘ to prevent losing any stray DRA activity logging while this is running).
‘ Best run from a cmd window using CSCRIPT, and piping the output to a log file for review.
‘ CSCRIPT <path>\DRALogExportToNRC.vbs > NRCExport.log
‘ Path to the LARK Data Exporter executable Const ExePath = “D:\PROGRA~2\NetIQ\DRA\Log Archive Resource Kit\LogArchiveReportDataExporter.exe”
‘ Path to the Log Archive data
Const LogDir = “D:\PROGRA~2\NetIQ\DRA\NetIQLogArchiveData”
Dim Shell, Cmd, RC
Dim FSO, Folder, Subfolder, Subfolders
Set Shell = WScript.CreateObject(“WScript.Shell”)
Set FSO = CreateObject(“Scripting.FileSystemObject”)
Set Folder = FSO.GetFolder(LogDir)
Set Subfolders = Folder.SubFolders
‘ Iterate through the log archive partitions and re-export each one For Each Subfolder in Subfolders
If IsNumeric(Subfolder.Name) Then
Cmd = Chr(34) & ExePath & Chr(34) & ” Logvolume ” & Subfolder.Name
WScript.Echo “Running: ” & Cmd
RC = Shell.Run(Cmd,,True)
If RC = 0 Then
WScript.Echo “Partition Exported: ” & Subfolder.Name & vbCrLf
WScript.Echo “ERROR ‘” & RC & “‘ exporting partition ” & Subfolder.Name & vbCrLf
Disclaimer: As with everything else at NetIQ Cool Solutions, this content is definitely not supported by NetIQ, so Customer Support will not be able to help you if it has any adverse effect on your environment. It just worked for at least one person, and perhaps it will be useful for you too. Be sure to test in a non-production environment.