PowerCLI with Grafana possible?

[G0nz0UK]

Hello,

I'm very new to PowerCLI, but I've been asked to obtain 3 reports and wonder if there is an example website to help me?

1. List all VMs with snapshots older than 2 days, showing VM name, OS, snapshot size, any tags.

2 VMs assigned with a tag called "Testing" showing VM name, OS, current disk free space.

3. List all datastores, showing name, size and free space.

They want this in Grafana which is what we use for everything.  I already have a lot in there for vCenter using Telegraf but not the above as it needs deeper info.

I'm sure PowerCLI can do the above, but I need to either create these as CSV files somehow or even better would be to send these to SQL and query that, is this even possible?

Thanks

[scott28tt]

Expect a moderator to move this to the PowerCLI area.

[LucD]

Yes, all possible.

But are you looking for scripts retrieving that information?
Or are you looking for a way to upload this data and display it in a Grafana dashboard?

Asking for multiple scripts (3) in one thread, without even giving the code you already have, seems to be stretching the concept of a thread in a community a bit imho.

[G0nz0UK]

ok

[G0nz0UK]

I think I can would out how to write teh PowerCLI and Grafana is already, so it's how I get a PowerCLI into Grafana really.

[LucD]

I think you could find quite a few example with Google.
Just a few that popped up in a search.

grafana-dashboard-and-powercli – Codenotary

VMware vSphere - Overview dashboard for Grafana | Grafana Labs

Building a Dashboard with Grafana, InfluxDB, and PowerCLI - Wahl Network