| external help file | Module Name | online version | schema |
|---|---|---|---|
PSWorkItem-help.xml |
PSWorkItem |
2.0.0 |
Get raw database table data.
Get-PSWorkItemData [[-Table] <String>] [-Path <String>] [<CommonParameters>]Most of the time you will use commands like Get-PSWorkItem to get data from the PSWorkItem database. Get-PSWorkItemData can be used to query the database directly and skip creating custom objects. This could be a helpful command for troubleshooting or debugging.
PS C:\> Get-PSWorkItemData | Out-GridViewGet all data from the Tasks table and display using Out-GridView.
PS C:\> Get-PSWorkItemData Categories
category description rowid
-------- ----------- -----
Work 6
Customer 7
Other Miscellaneous catch-all 8
Personal 9
Project Module or assigned work 10
Event Conference, webinar, or other event 12Get all data from the Categories table.
The path to the PSWorkItem SQLite database file. It should end in .db
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: $PSWorkItemPath
Accept pipeline input: False
Accept wildcard characters: FalseSpecify the table name. The default is Tasks
Type: String
Parameter Sets: (All)
Aliases:
Accepted values: Tasks, Categories, Archive
Required: False
Position: 0
Default value: Tasks
Accept pipeline input: False
Accept wildcard characters: FalseThis cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Learn more about PowerShell: http://jdhitsolutions.com/blog/essential-powershell-resources/