Get-MeasurementCollection

SYNOPSIS

Get measurement collection

SYNTAX

Get-MeasurementCollection
	[[-Device] <Object[]>]
	[[-Type] <String>]
	[[-ValueFragmentType] <String>]
	[[-ValueFragmentSeries] <String>]
	[[-DateFrom] <String>]
	[[-DateTo] <String>]
	[-Revert]
	[-CsvFormat]
	[-ExcelFormat]
	[[-Unit] <String>]
	[-PageSize <Int32>]
	[-WithTotalPages]
	[-WithTotalElements]
	[-CurrentPage <Int32>]
	[-TotalPages <Int32>]
	[-IncludeAll]
	[-Raw]
	[-OutputFile <String>]
	[-OutputFileRaw <String>]
	[-OutputTemplate <String>]
	[-Proxy]
	[-NoProxy]
	[-Timeout <String>]
	[-NoProgress]
	[-Session <String>]
	[-SessionUsername <String>]
	[-SessionPassword <String>]
	[-SessionMode <String>]
	[-Output <String>]
	[-View <String>]
	[-AsHashTable]
	[-AsPSObject]
	[-Flatten]
	[-Compact]
	[-NoColor]
	[-Cache]
	[-NoCache]
	[-CacheTTL <String>]
	[-Insecure]
	[-Help]
	[-Examples]
	[-Confirm]
	[-ConfirmText <String>]
	[-WithError]
	[-SilentStatusCodes <String>]
	[-SilentExit]
	[-Dry]
	[-DryFormat <String>]
	[-Workers <Int32>]
	[-Delay <String>]
	[-DelayBefore <String>]
	[-MaxJobs <Int32>]
	[-Progress]
	[-AbortOnErrors <Int32>]
	[-NoLog]
	[-LogMessage <String>]
	[-Select <String[]>]
	[-Filter <String[]>]
	[-Header <String[]>]
	[-CustomQueryParam <String[]>]
	[<CommonParameters>]

DESCRIPTION

Get a collection of measurements based on filter parameters

EXAMPLES

EXAMPLE 1

Get-MeasurementCollection

Get a list of measurements

EXAMPLE 2

Get-MeasurementCollection -DateFrom -1d -Revert:$false

Get a list of measurements from the last day, showing the oldest first

EXAMPLE 3

Get-MeasurementCollection -Device $Device.id -Type "TempReading"

Get a list of measurements for a particular device

EXAMPLE 4

Get-DeviceCollection -Name $Device.name | Get-MeasurementCollection

Get measurements from a device (using pipeline)

PARAMETERS

-Device

Device ID

Type: Object[]
Parameter Sets: (All)
Aliases:

Required: False
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName, ByValue)
Accept wildcard characters: False

-Type

Measurement type.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ValueFragmentType

value fragment type

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ValueFragmentSeries

value fragment series

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 4
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-DateFrom

Start date or date and time of measurement occurrence.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 5
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-DateTo

End date or date and time of measurement occurrence.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 6
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Revert

Return the newest instead of the oldest measurements. Must be used with dateFrom and dateTo parameters. By default, the results are sorted by the newest measurements first for time series and by the oldest first for legacy measurements

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False

-CsvFormat

Results will be displayed in csv format. Note: -IncludeAll, is not supported when using using this parameter

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False

-ExcelFormat

Results will be displayed in Excel format Note: -IncludeAll, is not supported when using using this parameter

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False

-Unit

Every measurement fragment which contains 'unit' property will be transformed to use required system of units.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: 7
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-AbortOnErrors

Abort batch when reaching specified number of errors

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-AsHashTable

Return output as PowerShell Hashtables

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-AsPSObject

Return output as PowerShell PSCustomObjects

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Cache

Enable cached responses

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-CacheTTL

Cache time-to-live (TTL) as a duration, i.e. 60s, 2m

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Compact

Compact instead of pretty-printed output when using json output. Pretty print is the default if output is the terminal

Type: SwitchParameter
Parameter Sets: (All)
Aliases: Compress

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Confirm

Prompt for confirmation

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-ConfirmText

Custom confirmation text

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-CurrentPage

Current page which should be returned

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-CustomQueryParam

add custom URL query parameters. i.e. --customQueryParam 'withCustomOption=true,myOtherOption=myvalue'

Type: String[]
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Delay

delay after each request. It accepts a duration, i.e. 1ms, 0.5s, 1m etc.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-DelayBefore

delay before each request. It accepts a duration, i.e. 1ms, 0.5s, 1m etc.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Dry

Dry run. Don't send any data to the server

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-DryFormat

Dry run output format. i.e. json, dump, markdown or curl

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Examples

Show examples for the current command

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Filter

Apply a client side filter to response before returning it to the user

Type: String[]
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Flatten

flatten json output by replacing nested json properties with properties where their names are represented by dot notation

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

custom headers. i.e. --header 'Accept: value, AnotherHeader: myvalue'

Type: String[]
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Help

Show command help

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-IncludeAll

Include all results by iterating through each page

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Insecure

Allow insecure server connections when using SSL

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-LogMessage

Add custom message to the activity log

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-MaxJobs

Maximum number of jobs. 0 = unlimited (use with caution!)

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-NoCache

Force disabling of cached responses (overwrites cache setting)

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-NoColor

Don't use colors when displaying log entries on the console

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-NoLog

Disables the activity log for the current command

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-NoProgress

Disable progress bars

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-NoProxy

Ignore the proxy settings

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Output

Output format i.e. table, json, csv, csvheader

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-OutputFile

Save JSON output to file (after select/view)

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-OutputFileRaw

Save raw response to file (before select/view)

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-OutputTemplate

jsonnet template to apply to the output

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-PageSize

Maximum results per page

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Progress

Show progress bar. This will also disable any other verbose output

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Proxy

Proxy setting, i.e. http://10.0.0.1:8080

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Raw

Show raw response. This mode will force output=json and view=off

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Select

Comma separated list of properties to return. wildcards and globstar accepted, i.e. --select 'id,name,type,**.serialNumber'

Type: String[]
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Session

Session configuration

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-SessionMode

Override default session mode for a single command which would normally be disabled

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-SessionPassword

Override session password

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-SessionUsername

Override session username. i.e. peter or t1234/peter (with tenant)

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-SilentExit

Silent status codes do not affect the exit code

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-SilentStatusCodes

Status codes which will not print out an error message

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Timeout

Request timeout. It accepts a duration, i.e. 1ms, 0.5s, 1m etc.

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-TotalPages

Total number of pages to get

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-View

Use views when displaying data on the terminal. Disable using --view off

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-WithError

Errors will be printed on stdout instead of stderr

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-WithTotalElements

Request Cumulocity to include the total elements in the response statistics under .statistics.totalElements (introduced in 10.13)

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-WithTotalPages

Request Cumulocity to include the total pages in the response statistics under .statistics.totalPages

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Workers

Number of workers

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

SYNOPSIS​

SYNTAX​

DESCRIPTION​

EXAMPLES​

EXAMPLE 1​

EXAMPLE 2​

EXAMPLE 3​

EXAMPLE 4​

PARAMETERS​

-Device​

-Type​

-ValueFragmentType​

-ValueFragmentSeries​

-DateFrom​

-DateTo​

-Revert​

-CsvFormat​

-ExcelFormat​

-Unit​

-AbortOnErrors​

-AsHashTable​

-AsPSObject​

-Cache​

-CacheTTL​

-Compact​

-Confirm​

-ConfirmText​

-CurrentPage​

-CustomQueryParam​

-Delay​

-DelayBefore​

-Dry​

-DryFormat​

-Examples​

-Filter​

-Flatten​

-Header​

-Help​

-IncludeAll​

-Insecure​

-LogMessage​

-MaxJobs​

-NoCache​

-NoColor​

-NoLog​

-NoProgress​

-NoProxy​

-Output​

-OutputFile​

-OutputFileRaw​

-OutputTemplate​

-PageSize​

-Progress​

-Proxy​

-Raw​

-Select​

-Session​

-SessionMode​

-SessionPassword​

-SessionUsername​

-SilentExit​

-SilentStatusCodes​

-Timeout​

-TotalPages​

-View​

-WithError​

-WithTotalElements​

-WithTotalPages​

-Workers​

CommonParameters​

INPUTS​

OUTPUTS​

System.Object​

NOTES​

RELATED LINKS​