Possible to import PowerShell output/table into Influx > Grafana


I’ve been trying for so long to get this working.

I’m been using Grafana and Influx lately and love it. I’ve been using Telegraf and Prometheus as well and have manged to get various systems into Grafana.

In the last week I have finally managed (with a lot of help) to get some PowerShell outputs into Influx using the Influx PowerShell Module. I’ve used it to get metrics from Citrix, so things like connected user numbers, just simple stuff.

My knowledge of PS is Novice level, but I’ve bought 2 uDemy courses to learn the basics.

What I really want to do is get usernames, servername, state, logon times, etc listed in Grafana, but I’m not sure Influx can hold this sort of info, does it only store numeric information?

This PowerShell script is perfect and shows as nice table output that I’d love to show in Grafana, I run in on the Citrix broker server and the Output is good:

Output looks like this (blurred usernames) https://imgur.com/auJLjlv

So I tried to see if I could at least get usernames into Grafana, but something is not right, here is the PS script:

This is what I see in Grafana: https://imgur.com/Hjh1zNQ

So I can select the host and see the fields in the script, but something is not right as there is no way to show the usernames. If I can get that in there I want to build on this and add logon time, servername etc.

Am I attempting something that is impossible?