Unsolved
This post is more than 5 years old
3 Posts
0
12305
How to get a list of all vm's backed up by networker?
Hi All,
I need the above mentioned list for reporting purposes.
Has anyone idea to to extract the list, preferable with any useful attributes.
I need the list in some text format in order to convert it to csv
bingo.1
2.4K Posts
1
March 27th, 2018 01:00
You can't get it easily with NetWorker tools. Here is my suggestion (for NW 9.2.1 & NVP backups):
- run 'mminfo' for a resonable amount of backups and make sure that you also report the parameter 'vmname', like:
mminfo -q "savetime>-1weeks" -r "client,name,vmname,level,savetime,sumsize(20)" -ot -xc, > outfile
This way you already created a CSV file
- Import it to an Excel sheet
- Filter for all save sets names starting with 'vm:'
The result is that you now have a table with all VM (NVP) backups
- Sort by vm_name
- Eliminate duplicates
- Retrieve the column vm_name only
If you can script that to run automatically - even better ;-)
muetzd
18 Posts
1
March 27th, 2018 20:00
The NMC -> Reports -> Policy Statistics -> Client Summary
At the bottom of the right pane change "From" to before the installation of NetWorker.
Scroll to the top and select the "View Report" tab
This report can be exported by right click, select export, and CSV.
The command line equivalent, from a WINDOWS NMC server the gstclreport.bat can be used by:
cd to where the gstclreport.bat is, by default "C:\Program Files\EMC NetWorker\Management\GST\bin"
enter
set JAVA_HOME=C:\Program Files\Java\jre1.8.0_111
where your bin\java.exe is, mine was at that path.
Then run
C:\Program Files\EMC NetWorker\Management\GST\bin> gstclreport -u administrator -P -r "/Reports/Policy Statistics/C lient Summary" -C "Workflow Start Time" "1/1/10 01:00 AM" -x csv -f "C:\Users\david\Client_Summary.csv"
java version "1.8.0_111"
Java(TM) SE Runtime Environment (build 1.8.0_111-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.111-b14, mixed mode)
Generated report "Client Summary" as file C:\Users\david\Client_Summary.csv
C:\Program Files\EMC NetWorker\Management\GST\bin>
LINUX would be similar.
bingo.1
2.4K Posts
0
March 27th, 2018 22:00
Nice. However, it needs NMC.
muetzd
18 Posts
0
March 28th, 2018 08:00
Have we thoroughly answered this query?
If so, can it be marked answered.
Thanks in advance.
wies22
3 Posts
0
March 28th, 2018 10:00
David, Bingo,
Thank you for the helpful answers.
I was pressed for time so I couldn't wait for your tips.
What I did is:
- I have used nsradmin to get VBAs list
print type:NSR VBA Server
show name
- I have logged using ssh to every VBA and being there I used 'psql' to run sql script extracting the needed columns to csv file
- everything above was done by a simple shell script using 'for loop' to run sql scripts on every VBA and copy back the resulting csv files
My solution may seem to be too complicated but I am not networker guru and couldn't find anything better.
And @bingo you're right I have no NMC - so CLI was the only way I could use.
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
1
April 17th, 2018 17:00
Hi, I would also prefer a shell script though the above methods are also good n descriptive.
And a small script you can get the count of clients protected by VBA=
1. First get the vcenter name using the below command :-
cat /usr/local/vdr/etc/vcenterinfo.cfg | grep vcenter-hostname | cut -d '=' -f 2
2.Using the output from the above command , use that in below command:-
avmgr getl --path=/$vcenter_name/VirtualMachines | awk '{print $2}' | tail -n+2 | wc -l
==========================================================
To be simplified if you want in a script then :-
1. ssh to vba and then create a file using ==> vi count.sh
2.Paste the below lines in it and save using :wq!
#!/bin/bash
clear
vcenter_name=$(cat /usr/local/vdr/etc/vcenterinfo.cfg | grep vcenter-hostname | cut -d '=' -f 2)
client_count=$(avmgr getl --path=/$vcenter_name/VirtualMachines | awk '{print $2}' | tail -n+2 | wc -l)
echo $client_count
3.After that change the permission of the file using => chmod 755 count.sh
4.Run the script using ==> ./count.sh
====================================
Hope that helps !!
Remember to mark the thread as helpful and resolved if that resolves your query.
Aayush.
callustactic
1 Message
0
December 10th, 2018 07:00
I know this thread is old, but for reference purposes, there is a simple way to list all VMs (protected or not) from NMC
Go to Protection, select VMware View, hit Ctrl+T (changes to table view), Right Click on the headers and select Export then CSV
Once you've saved the file you can work with the Data in Excel
Real_Digioso
12 Posts
0
January 4th, 2019 07:00
Starting with NetWorker 9.1 you can also query the REST API./vmware/protectedvms should do the trick.
MeemerK
3 Posts
0
October 3rd, 2019 08:00
/vmware/.... endpoints in Networker REST API always return 404 (not found) error. Is this permission issue or is there a known bug/issue with using the /vmware/... endpoints through the REST API?
MeemerK
3 Posts
0
October 3rd, 2019 13:00
Answered my own question. Versioning. The API is versioned. If you call the REST API version v1, you get no VMWare endpoints. Not sure if v2 has the endpoints or not but v3 definitely does.
Dsantibanez
1 Rookie
1 Rookie
•
82 Posts
0
October 7th, 2019 06:00
Hi. i use two options:
mminfo -xc; -q client=servername,family=disk,copies=1 -r volume,ssid,sscreate,level,sumflags,sumsize,name | findstr cb | findstr full > ssid3.cvs
Ben122
8 Posts
0
November 29th, 2019 08:00
Option 1 is not 100% true and I actually had to raise a SR to have this resolved in either DPA or NetWorker.
DPA uses NSR client resource command to extract all clients and the VMs are not included part of the output. Of course you can use DPA to report client name that had backups but you can't list clients configured in NetWorker via DPA unless a backup ran.
I'll give a try to option 2. Thanks