Powershell results - working with son

Question

Hi everyone,

I'm trying to get some results off a Simplivity system using power shell and json. &nbsp;I have the powershelgl working as I would expect, but I can't get the results to show up in LogicMonitor.&nbsp;

In collector debug, I see this when running the script.

&gt;!posh
	returns 0
	output:
	[
	&nbsp; &nbsp; {
	&nbsp; &nbsp; &nbsp; &nbsp; "id": &nbsp;"53466cdf-ee82-435e-8619-334b3a3e7583",
	&nbsp; &nbsp; &nbsp; &nbsp; "name": &nbsp;"Fakename",
	&nbsp; &nbsp; &nbsp; &nbsp; "type": &nbsp;"OMNISTACK",
	&nbsp; &nbsp; &nbsp; &nbsp; "members": &nbsp;[
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "4230cce1-f672-e708-0ed6-3310d6db8222",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "4230e3c6-4cf6-7228-fc86-cbce8cfa4af7",
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "564dcac8-b774-c644-cb22-e63acfd07cb9"
	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ],
	&nbsp; &nbsp; &nbsp; &nbsp; "arbiter_connected": &nbsp;true,
	&nbsp; &nbsp; &nbsp; &nbsp; "arbiter_address": &nbsp;"10.1.1.6",
	&nbsp; &nbsp; &nbsp; &nbsp; "stored_compressed_data": &nbsp;731283120128,
	&nbsp; &nbsp; &nbsp; &nbsp; "compression_ratio": &nbsp;"1.8 : 1",
	&nbsp; &nbsp; &nbsp; &nbsp; "deduplication_ratio": &nbsp;"300.9 : 1",
	&nbsp; &nbsp; &nbsp; &nbsp; "free_space": &nbsp;14779864866201,
	&nbsp; &nbsp; &nbsp; &nbsp; "capacity_savings": &nbsp;387454100800512,
	&nbsp; &nbsp; &nbsp; &nbsp; "efficiency_ratio": &nbsp;"530.8 : 1",
	&nbsp; &nbsp; &nbsp; &nbsp; "local_backup_capacity": &nbsp;385825262157824,
	&nbsp; &nbsp; &nbsp; &nbsp; "used_logical_capacity": &nbsp;388185382895616,
	&nbsp; &nbsp; &nbsp; &nbsp; "remote_backup_capacity": &nbsp;0,
	&nbsp; &nbsp; &nbsp; &nbsp; "allocated_capacity": &nbsp;15511146961305,
	&nbsp; &nbsp; &nbsp; &nbsp; "stored_virtual_machine_data": &nbsp;2360120737792,
	&nbsp; &nbsp; &nbsp; &nbsp; "stored_uncompressed_data": &nbsp;1290225192960,
	&nbsp; &nbsp; &nbsp; &nbsp; "used_capacity": &nbsp;731282095104
	&nbsp; &nbsp; }
	]

I've attached example of what I've tried for output. &nbsp;Nothing is showing up.

&nbsp;

matthew_dunham · Answer

Because the fundamental JSON datastructure&nbsp;is an&nbsp;array, I believe you'll need to reference the root array element&nbsp;as&nbsp;$[0]. So:

$[0].compression_ratio
$[0].used_capacity
...

&nbsp;

tmiller · Answer

I ended up working with support on this. &nbsp;It turns out that the information coming back from Powershell is actually strings. &nbsp;I had to use regex to access the data.

Forum Discussion

Powershell results - working with son

Related Content

Fail to get the script result

DataSource with PowerShell script

Batch PowerShell Script

Monitoring google work space status page

glob expression excluding resources not working

Recent Discussions

Dashboard Sharing – An Inline Framing Method

2021-12-15 US Office Hours

Live Training - Tuning Datapoints and Alerts - 15th JUNE 2022 - APAC

Live Training - Introduction to Dashboards - 18th MAY 2022 - APAC

2022-05-11- APAC Product Overview -Collectors, Resources/Groups, Dashboards