Get-SilAggregatorData

Windows Server 2016 and Windows 10

Get-SilAggregatorData

Gets data from the Software Inventory Logging Aggregator database.

Syntax

Parameter Set: ComputerName
Get-SilAggregatorData [-ComputerName <String[]> ] [-EndTime <DateTime> ] [-StartTime <DateTime> ] [ <CommonParameters>]

Parameter Set: ID
Get-SilAggregatorData [-ID <System.String[]> ] [ <CommonParameters>]

Parameter Set: UUIDSet
Get-SilAggregatorData [-EndTime <DateTime> ] [-StartTime <DateTime> ] [-UUId <String[]> ] [ <CommonParameters>]

Parameter Set: VMHostName
Get-SilAggregatorData [-EndTime <DateTime> ] [-StartTime <DateTime> ] [-VMHostName <String[]> ] [ <CommonParameters>]

Parameter Set: VMIDSet
Get-SilAggregatorData [-EndTime <DateTime> ] [-StartTime <DateTime> ] [-VMId <String[]> ] [ <CommonParameters>]




Detailed Description

The Get-SilAggregatorData cmdlet gets data from the Software Inventory Logging Aggregator database. This cmdlet returns the same data as the Excel report that the Publish-SilData cmdlet creates. Specify parameter values to narrow your query.

Parameters

-ComputerName<String[]>

Specifies an array of names of computers for which this cmdlet gets data from the database.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

true(ByValue)

Accept Wildcard Characters?

false

-EndTime<DateTime>

Specifies the polling end date and time. This cmdlet gets data based on the value that this parameter specifies.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ID<System.String[]>

Specifies an array of IDs. This cmdlet gets data from the database for the virtual machines that this parameter specifies.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

true(ByValue)

Accept Wildcard Characters?

false

-StartTime<DateTime>

Specifies the polling start date and time. This cmdlet gets data based on the value that this parameter specifies.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-UUId<String[]>

Specifies an array of universally unique identifiers. This cmdlet gets data from the database for the IDs that this parameter specifies.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

true(ByValue)

Accept Wildcard Characters?

false

-VMHostName<String[]>

Specifies an array of virtual machine host names. This cmdlet gets data from the database for the virtual machine hosts that this parameter specifies.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

true(ByValue)

Accept Wildcard Characters?

false

-VMId<String[]>

Specifies an array of virtual machine IDs. This cmdlet gets data from the database for the virtual machines that this parameter specifies.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

true(ByValue)

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.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

Examples

Example 1: Get all data

This command returns data from the database. This is the same data as the Excel report that the Publish-SilData cmdlet creates.


PS C:\> Get-SilAggregatorData

Example 2: Get data for named virtual machine hosts

This command returns data from the database for the virtual machine hosts named Host01 and Host02.


PS C:\> Get-SilAggregatorData -VMHostName "Host01","Host02"

Example 3: Gets host data since a specified time

This command returns all the host data objects from the database since the specified date and time.


PS C:\> Get-SilAggregatorData -StartTime "12/29/2014 11:00 AM"

Example 4: Gets host data up to a specified time

This command returns all the host data objects from the database up to the specified date and time.


PS C:\> Get-SilAggregatorData -EndTime "12/29/2014 11:00 AM"

Example 5: Get data for the named computers

This command returns data from the database for the computers named VMExample01 and VMExample02.


PS C:\> Get-SilAggregatorData -ComputerName "VMExample01","VMExample02"

Example 6: Get host data based on UUIDs

This command gets data from the database for the specified UUIDs.


PS C:\> Get-SilAggregatorData -UUId "00000000-0000-0000-0000-000000000000","00000000-0000-0000-0000-000000000001"

Example 7: Get host data based on virtual machine IDs

This command gets data objects from the database for the specified virtual machine IDs.


PS C:\> Get-SilAggregatorData -VMId "00000000-0000-0000-0000-000000000000","00000000-0000-0000-0000-000000000001" 

Example 8: Get host data based on IDs

This command gets data objects from the database for the specified IDs.


PS C:\> Get-SilAggregatorData -ID "00000000-0000-0000-0000-000000000000","00000000-0000-0000-0000-000000000001"

Example 9: Get host data between two times

This command returns all the host data objects from the database between the specified date and time values.


PS C:\> Get-SilAggregatorData -StartTime "12/29/2014 11:00 AM" -EndTime "12/30/2014 11:00 AM" 

Related topics

Community Additions

ADD
Show: