Veeam ONE/Reporter Powershell

Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V

Veeam ONE/Reporter Powershell

Veeam Logoby Avshalom » Thu May 08, 2014 11:05 am

hello everybody,

Do you know if there is a possibility to get the veeam reporter or veeam one monitor information through powershell?
for example, cpu usage(mhz) for VM for the last month, or Disk IO usage, memory usage etc..

i found on the internet that previous versions of the reporter was including powershell commands, is there any cmdlets on version 7 too?

anyway if there's any way to get this information through powershell it would be very nice...
Also SQL Queries might be solution though, if you know how to get it,

thanks guys.
all the best...
Avshalom
Influencer
 
Posts: 18
Liked: never
Joined: Sun Mar 30, 2014 8:00 am
Full Name: Avshalom

Re: Veeam ONE/Reporter Powershell

Veeam Logoby v.Eremin » Thu May 08, 2014 11:12 am

Unfortunately, Veeam ONE doesn't have PowerShell module any more. We've removed it, as not many people were interested in it. Thanks.
v.Eremin
Veeam Software
 
Posts: 13281
Liked: 970 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Veeam ONE/Reporter Powershell

Veeam Logoby Avshalom » Thu May 08, 2014 1:02 pm

what about getting the information through the sql server queries?
any help with that?
Avshalom
Influencer
 
Posts: 18
Liked: never
Joined: Sun Mar 30, 2014 8:00 am
Full Name: Avshalom

Re: Veeam ONE/Reporter Powershell

Veeam Logoby v.Eremin » Thu May 08, 2014 1:33 pm

what about getting the information through the sql server queries?

It's possible, but we don't publish the particular instructions, as the content of database is constantly changing with every product patch, version. We don't want to destroy any custom data source. You can try and find a way yourself on your own risk, though.

Anyway, your voice for getting PS module back is counted.

Thank you for your understanding.
v.Eremin
Veeam Software
 
Posts: 13281
Liked: 970 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Veeam ONE/Reporter Powershell

Veeam Logoby Vitaliy S. » Thu May 08, 2014 7:23 pm

Avshalom, can you please tell me a bit more what you're trying to achieve with this?
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE/Reporter Powershell

Veeam Logoby Avshalom » Sun May 11, 2014 6:52 am

Thanks Vitaly,

i have a script for gathering lot of information on our vm's, at the moment i'm exporting cpu usage mhz/memory active/usage from the veeam reporter to excel file and then importing the results for each vm with it name through the script,

i'ts mainly for optimizing the vm's hardware settings, by cpu/ram/IOPS and get summary by cost/usage etc.

if i would be able to get the information with powershell directly from the veeam reporter history, it will be wonderful and a great shortcut,
i'm also checking the get-cli/get-esxtop but i rather prefer get it from the veeam directly without the need to export performance report,

again thanks for your interest and help.
all the best

Avshalom
Avshalom
Influencer
 
Posts: 18
Liked: never
Joined: Sun Mar 30, 2014 8:00 am
Full Name: Avshalom

Re: Veeam ONE/Reporter Powershell

Veeam Logoby Vitaliy S. » Sun May 11, 2014 3:11 pm

Thanks for that clarifications, much appreciated. Have you considered using prebuild over/under sized VMs reports in Veeam ONE to get hardware recommendations on CPU and Memory resources?
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE/Reporter Powershell

Veeam Logoby Avshalom » Mon May 12, 2014 9:16 am

Thanks vitaly,
i know the reporter options,but i'm intending to specific solution,
i saw v.Eremin said it's possible to get it from the sql, but i'm not familiar a lot with sql queries, if it's not something for public, can you please direct me in private,

guys, if you know how to do it, please help...

thanks :)
Avshalom
Influencer
 
Posts: 18
Liked: never
Joined: Sun Mar 30, 2014 8:00 am
Full Name: Avshalom

Re: Veeam ONE/Reporter Powershell

Veeam Logoby Vitaliy S. » Tue May 13, 2014 5:29 am

Vladimir is correct that this is not a recommended way to do that, as we cannot guarantee that all table names, views and other SQL data will not be changed with the patch, major update etc. If I were you, I would not build this solution by querying our database directly.
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE/Reporter Powershell

Veeam Logoby tsightler » Thu May 15, 2014 6:13 pm

Avshalom wrote:i have a script for gathering lot of information on our vm's, at the moment i'm exporting cpu usage mhz/memory active/usage from the veeam reporter to excel file and then importing the results for each vm with it name through the script,


Can you clarify this step? It sounds like you're saying you're having Reporter generate an Excel file on a schedule, but then it's not clear to me what you're doing at this point. Are you manually manipulating the data in some way or is your Powershell consuming the data directly from the Excel file. I would think that having Powershell simply data directly from the Excel file wouldn't be much different than just pulling the data from the DB.
tsightler
Veeam Software
 
Posts: 4769
Liked: 1737 times
Joined: Fri Jun 05, 2009 12:57 pm
Full Name: Tom Sightler

Re: Veeam ONE/Reporter Powershell

Veeam Logoby dnl » Fri Mar 04, 2016 11:15 am

Hello,
I know this post has not been active for some time but I am looking too for a way to get maximum cpu and memory values from veeam one into powershell. Any news about native Powershell Module?
dnl
Lurker
 
Posts: 1
Liked: never
Joined: Fri Mar 04, 2016 10:24 am

Re: Veeam ONE/Reporter Powershell

Veeam Logoby Vitaliy S. » Fri Mar 04, 2016 12:38 pm

Hello dnl,

There are no updates to PowerShell module yet, however you can schedule a report that will contain CPU/Memory values and dump this data to a CSV file for further manipulations. Can you please tell us how you're going to use this data?

Thank you!
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE/Reporter Powershell

Veeam Logoby Jamesdld23 » Mon Nov 28, 2016 3:45 pm

I would be intersted too to have a Veeam One Powershell module : )
Could help me building custom attribute for Veeam One businee view.
Jamesdld23
Enthusiast
 
Posts: 25
Liked: 6 times
Joined: Fri Aug 19, 2016 12:59 pm
Full Name: James Dumont

Re: Veeam ONE/Reporter Powershell

Veeam Logoby Vitaliy S. » Mon Nov 28, 2016 5:35 pm

Hi James,

How would you like to use PS module in Veeam ONE? Will it be used mostly to build reports or set some configuration/execute actions?

BTW, since you've mentioned Business View, can you please give us a bit more information on how you currently categorize VMs? Do you use static or dynamic groups?

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19564
Liked: 1104 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam ONE/Reporter Powershell

Veeam Logoby Jamesdld23 » Wed Nov 30, 2016 9:55 am

Of course,

Examples I see :
Get through powershell all custom attributes
Set specific custom attribute when a VM is created through internal tools (scripts)
Compare custom attributes setting difference with a CMDB

Regards,
James
Jamesdld23
Enthusiast
 
Posts: 25
Liked: 6 times
Joined: Fri Aug 19, 2016 12:59 pm
Full Name: James Dumont

Next

Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 6 guests