Get-SilAggregatorData
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"