Share via


Publish-SilReport

Publish-SilReport

Generates a report in Software Inventory Logging Aggregator.

Syntax

Parameter Set: All
Publish-SilReport [-All] [-DBServerCredential <PSCredential> ] [-DBServerName <String> ] [-Force] [-OpenReport] [-ReportPath <String> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Parameter Set: ByMonth
Publish-SilReport [-ByMonth <DateTime> ] [-DBServerCredential <PSCredential> ] [-DBServerName <String> ] [-Force] [-OpenReport] [-ReportPath <String> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Parameter Set: ByYear
Publish-SilReport [-ByYear <DateTime> ] [-DBServerCredential <PSCredential> ] [-DBServerName <String> ] [-Force] [-OpenReport] [-ReportPath <String> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Parameter Set: None
Publish-SilReport [-DBServerCredential <PSCredential> ] [-DBServerName <String> ] [-Force] [-OpenReport] [-ReportPath <String> ] [-Confirm] [-WhatIf] [ <CommonParameters>]

Detailed Description

The Publish-SilReport cmdlet generates a Software Inventory Logging Aggregator report. You can generate a report for a particular month, for a particular year, or one that includes all data. By default, this cmdlet generates a report from the start of the month, two months prior to the current date, but does not exceed three months of data. Specify parameter values to modify the report. If necessary, provide the database server name and credentials that this cmdlet uses to connect to the database server.

Parameters

-All

Indicates that this cmdlet generates a report that contains all available data.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ByMonth<DateTime>

Specifies a month for which this cmdlet generates a report. For the current month, the report starts at the start of the month and includes data up to the current date.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ByYear<DateTime>

Specifies a year for which this cmdlet generates a report. For the current year, the report starts at the start of the year and includes data up to the current date.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-DBServerCredential<PSCredential>

Specifies the credentials to connect to the SQL Server Analysis Services (SSAS) database server for the report. To obtain a PSCredential object, use the Get-Credential cmdlet. For more information, type Get-Help Get-Credential. You may also need to open a port on the firewall of the SSAS database server.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-DBServerName<String>

Specifies the SSAS database server for the report.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Force

Forces the command to run without asking for user confirmation.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-OpenReport

Indicates that this cmdlet opens the report that it generates in a new Microsoft Excel application window.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-ReportPath<String>

Specifies the folder path where this cmdlet saves the report that it generates.

Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Confirm

Prompts you for confirmation before running the cmdlet.

Required?

false

Position?

named

Default Value

false

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Required?

false

Position?

named

Default Value

false

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.

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: Generate a default report

This command generates a Software Inventory Logging Aggregator report. This default report contains data for the previous two months and the current month up to the local time. This command generates a report and saves it in your Documents folder.

PS C:\> Publish-SilReport 

Example 2: Generate a monthly report

This command generates a report for the month of October 2014.

PS C:\> Publish-SilReport -ByMonth "10/03/2014" 

Example 3: Generate a yearly report

This command generates a report for the year 2012.

PS C:\> Publish-SilReport -ByYear "1/1/2012" 

Example 4: Generate a complete report

This command generates a report that contains all data.

PS C:\> Publish-SilReport -All 

Example 5: Specify a server and credentials

The first command creates a credential by using the Get-Credential cmdlet. That cmdlet prompts you for user name and password. The command stores those credentials in the $Credentials variable. For more information, type Get-Help Get-Credential.

This command generates a report by providing the name of the database server. The cmdlet uses the credentials stored in $Credential to connect to SSAS on a remote server. You may need to open the correct firewall port on the target server to accept this report request.

PS C:\> $Credential = Get-Credential
PS C:\> Publish-SilReport -DBServerName "SILContoso.com" -DBServerCredential $Credential 

Example 6: Generate and open a report

This command generates a report, and then opens it in a new Excel application window.

PS C:\> Publish-SilReport -OpenReport 

Software Inventory Logging Cmdlets in Windows PowerShell