Subscribe

SMVI job status export to CSV

[ Edited ]

Is there a way to automate the export to a CSV file the status of SMVI jobs?

Specifically we are looking for the following

Client Name

Client IP Address

Vendor Job Type (backup, restore)

Start Date String

Finish Date String

Backup Kilobytes

Number of Files

Status (0 for successful, 1 for partial, 2 for failed)

We want to automate the export of this data on a routine basis for import into a 3rd party reporting system.  I asked a similar question for OSSV jobs out of DFM and got that answer.  I'm assuming that SMVI job status is not recorded or managed with DFM anyways so this data would have to come from SMVI?

Thanks!
-jason

Re: SMVI job status export to CSV

bump

anything?

-jj

ydk Former NetApp Employee

Re: SMVI job status export to CSV

SMVI logs some of the information like backup start/finish. But one would have to write a script to parse SMVI repository and logs and parse that info.

Re: SMVI job status export to CSV

Hi

But we do have a logviewer tool that you can use to take a look at our logs easily.

http://now.netapp.com/NOW/download/tools/logviewer/

REgards

Amrita

Re: SMVI job status export to CSV

Hi,

I'm aware regarding this tools, however I'm not able to use it with SMVI 2.0

Have you a tips to use it with SMVI.

This tools must be install on SMVI server?

Regards.

Re: SMVI job status export to CSV

it currently works on 32 bit and not 64 bit. you could install it on a 32 bit machine after copying files to the desktop

Regards

Amrita

Re: SMVI job status export to CSV

Dear amritad,

I have an issue when I try to open an or more XML genreted by SMVI 2.0 on my own computer (32bits)

Log parsser accept to open my flie but nothing was displayed except the open duration.

If I try to change the level error display I have an error

System.NullReferenceException: La référence d'objet n'est pas définie à une instance d'un objet.
   à LogViewer.LogViewerForm.messageToolStripMenuItem_Click(Object sender, EventArgs e) dans C:\Development\nnf_log_viewer\AladdinLogViewer\LogViewer.cs:ligne 243
   à System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   à System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
   à System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   à System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   à System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   à System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   à System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   à System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
   à System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   à System.Windows.Forms.Control.WndProc(Message& m)
   à System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   à System.Windows.Forms.ToolStrip.WndProc(Message& m)
   à System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
   à System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   à System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   à System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Assemblys chargés **************
mscorlib
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3603 (GDR.050727-3600)
    CodeBase : file:///c:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
SMVILogViewer
    Version de l'assembly : 1.4.0.0
    Version Win32 : 1.4.0.0
    CodeBase : file://frcf1hdu10/users0$/E0025158/My%20Documents/From%20NetApp/SMVI-log/LogViewer%201.4/SMVILogViewer.exe
----------------------------------------
System.Windows.Forms
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Windows.Forms.resources
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_fr_b77a5c561934e089/System.Windows.Forms.resources.dll
----------------------------------------
System.Deployment
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
----------------------------------------
System.Deployment.resources
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_MSIL/System.Deployment.resources/2.0.0.0_fr_b03f5f7f11d50a3a/System.Deployment.resources.dll
----------------------------------------
System.Data.SqlServerCe
    Version de l'assembly : 3.5.0.0
    Version Win32 : 3.5.5386.0
    CodeBase : file://frcf1hdu10/users0$/E0025158/My%20Documents/From%20NetApp/SMVI-log/LogViewer%201.4/System.Data.SqlServerCe.DLL
----------------------------------------
System.Data
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.Configuration
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.EnterpriseServices
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.Data.resources
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3053 (netfxsp.050727-3000)
    CodeBase : file:///C:/WINNT/assembly/GAC_MSIL/System.Data.resources/2.0.0.0_fr_b77a5c561934e089/System.Data.resources.dll
----------------------------------------
mscorlib.resources
    Version de l'assembly : 2.0.0.0
    Version Win32 : 2.0.50727.3603 (GDR.050727-3600)
    CodeBase : file:///c:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------

Regards,

ydk Former NetApp Employee

Re: SMVI job status export to CSV

You need to point the LogViewer tool to SMVI log file instead of the XML files generated from backup jobs. Typically the log file is located in folder <ProgramFiles>\NetApp\SMVI\server\log.

To answer your earlier question regarding the Logviewer location:

The LogViewer can be installed on different server than SMVI server. Just make sure it can open and read SMVI server log located on SMVI server.

Re: SMVI job status export to CSV

thank you Ydk

well done.

Regards

Re: SMVI job status export to CSV

YDK, I am running this on a 32 bit windows workstation. I have copied the server.log to my local computer, so the resource in not in use. I am having this same problem where nothing appears, it just tells me how long the parse took to complete. I am running 2.0.1 P1.

Doesn't matter where I try to open this from, it won't open. I've tried loading the server.log directly from the live copy, no dice. Any advice would be appreciated as this doesn't work at all.

Thanks,