-
Notifications
You must be signed in to change notification settings - Fork 0
Find DatabaseValue
external help file: Databaseline-help.xml Module Name: Databaseline online version: https://dbatools.io/ schema: 2.0.0
Searches an entire database for a field value.
Find-DatabaseValue [-Value] <Object> [-SqlInstance] <DbaInstanceParameter> [-Database] <String>
[-IncludeSchemata <String[]>] [-ExcludeSchemata <String[]>] [-IncludeTables <String[]>]
[-ExcludeTables <String[]>] [-IncludeColumns <String[]>] [-ExcludeColumns <String[]>] [-MinRows <Int32>]
[-MaxRows <Int32>] [-FindFirst] [-LikeValue] [-ProgressAction <ActionPreference>] [<CommonParameters>]
{{ Fill in the Description }}
Find-DatabaseValue FR -IncludeSchemata Sales -MaxRows 100 -SqlInstance '(localdb)\ProjectsV13' -Database AdventureWorks2016
TableName : [Sales].[SalesTerritory] TerritoryID : 7 Name : France CountryRegionCode : FR Group : Europe SalesYTD : 4772398.3078 SalesLastYear : 2396539.7601 CostYTD : 0.0000 CostLastYear : 0.0000 rowguid : bf806804-9b4c-4b07-9d19-706f2e689552 ModifiedDate : 04/30/2008 00:00:00
Find-DatabaseValue 41636 -IncludeColumns %OrderID -SqlInstance '(localdb)\ProjectsV13' -Database AdventureWorks2016 |tee order41636.txt
TableName : [Production].[TransactionHistory] TransactionID : 100046 ProductID : 826 ReferenceOrderID : 41636 ReferenceOrderLineID : 0 TransactionDate : 07/31/2013 00:00:00 TransactionType : W Quantity : 4 ActualCost : 0.0000 ModifiedDate : 07/31/2013 00:00:00
TableName : [Production].[WorkOrder] WorkOrderID : 41636 ProductID : 826 OrderQty : 4 StockedQty : 4 ScrappedQty : 0 StartDate : 07/31/2013 00:00:00 EndDate : 08/11/2013 00:00:00 DueDate : 08/11/2013 00:00:00 ScrapReasonID : ModifiedDate : 08/11/2013 00:00:00
TableName : [Production].[WorkOrderRouting] WorkOrderID : 41636 ProductID : 826 OperationSequence : 6 LocationID : 50 ScheduledStartDate : 07/31/2013 00:00:00 ScheduledEndDate : 08/11/2013 00:00:00 ActualStartDate : 08/01/2013 00:00:00 ActualEndDate : 08/11/2013 00:00:00 ActualResourceHrs : 3.0000 PlannedCost : 36.7500 ActualCost : 36.7500 ModifiedDate : 08/11/2013 00:00:00
The value to search for. The datatype is significant, e.g. searching for money/smallmoney columns, cast the type to decimal: [decimal]13.55 Searches, by type:
- string: varchar, char, nvarchar, nchar (char length must be at least as long as value)
- byte: tinyint
- int: bigint, int
- long: bigint, numeric or decimal (where scale is zero)
- decimal: money, smallmoney
- double or float: float, real, numeric, decimal
- datetime: date (if no time specified), datetime, datetime2, datetimeoffset, smalldatetime
- timespan: time
If the -LikeValue switch is specified, the type of value is assumed to be string.
Type: Object
Parameter Sets: (All)
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThe server to use, by name or constructed via Connect-DbaInstance.
Type: DbaInstanceParameter
Parameter Sets: (All)
Aliases: Parent, ServerInstance
Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThe the database to connect to on the server.
Type: String
Parameter Sets: (All)
Aliases: Name
Required: True
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseA like-pattern of database schemata to include (will only include these).
Type: String[]
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseA like-pattern of database schemata to exclude.
Type: String[]
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseA like-pattern of database tables to include (will only include these).
Type: String[]
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseA like-pattern of database tables to exclude.
Type: String[]
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseA like-pattern of database columns to include (will only include these).
Type: String[]
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseA like-pattern of database columns to exclude.
Type: String[]
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseTables with more rows than this value will be skipped.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 1
Accept pipeline input: False
Accept wildcard characters: FalseTables with more rows than this value will be skipped.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: FalseQuit as soon as the first value is found.
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: FalseInterpret the value as a like-pattern (% for zero-or-more characters, _ for a single character, \ is escape).
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False{{ Fill ProgressAction Description }}
Type: ActionPreference
Parameter Sets: (All)
Aliases: proga
Required: False
Position: Named
Default value: None
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.