For those of you who are familiar with MMINFO you’ll know how powerful it is and how much information you can get from the media database. Some people like to use the built in reporting functionality built into Networker NMC but personally I find it unreliable and more times that not I find the numbers just don’t add up.
So this week I was importing some mminfo data into Excel to sort when I thought that it might be something worth writing a post on, below you’ll see how to get the MMINFO fields into separate columns.
The command below will ouput results in standard MMINFO format.
C:\>mminfo -avot -r “client,name,ssid,cloneid” -q client=demo.com -t “1 day ago” >report.txt
Now lets take a look at whats in the txt file.
client name ssid clone id
demo.com VSS SYSTEM BOOT:\ 280633504 1236934816
demo.com VSS SYSTEM BOOT:\ 280633504 1236934817
demo.com VSS SYSTEM SERVICES:\ 247079075 1236934818
demo.com VSS SYSTEM SERVICES:\ 247079075 1236934819
demo.com D:\ 4240056601 1236934932
demo.com D:\ 4240056601 1236934933
demo.com VSS USER DATA:\ 4038730332 1236935213
demo.com VSS USER DATA:\ 4038730332 1236935214
demo.com VSS OTHER:\ 4005175900 1236935224
demo.com VSS OTHER:\ 4005175900 1236935225
demo.com VSS ASR DISK:\ 3787072135 1236935293
demo.com VSS ASR DISK:\ 3787072135 1236935294
Ok now lets add a -xc, to the command and we should see every is seperated by a comma. You could how ever replace the comma with any symbol or character.
C:\>mminfo -avot -xc, -r “client,name,ssid,cloneid” -q client=demo.com -t “1 day ago” >report.txt
demo.com,VSS SYSTEM BOOT:\,2964901764,1236865688
demo.com,VSS SYSTEM SERVICES:\,2897792906,1236865688
demo.com,VSS USER DATA:\,2830684090,1236865688
demo.com,VSS SYSTEM FILESET:\,2428031191,1236865688
demo.com,VSS ASR DISK:\,2444808367,1236865688
Now lets rename the report.txt file to report.csv and open it in Excel.
There we go, each field in its own colum.