Tables [dbo].[lmt_unsupported_metric_usage]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count4
Created8:38:53 AM Wednesday, July 20, 2011
Last Modified8:38:53 AM Wednesday, July 20, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
us_idint4
No
1 - 1
us_metric_idint4
No
product_uuidbinary(16)16
No
Valuefloat8
Yes
DiscoveredDatedatetime8
Yes
ComputerCountbigint8
Yes
ManualValuebigint8
Yes
ManualInitnvarchar(255)510
Yes
Attestationnvarchar(1000)2000
Yes
ManualDatedatetime8
Yes
SQL Script
CREATE TABLE [dbo].[lmt_unsupported_metric_usage]
(
[us_id] [int] NOT NULL IDENTITY(1, 1),
[us_metric_id] [int] NOT NULL,
[product_uuid] [binary] (16) NOT NULL,
[Value] [float] NULL,
[DiscoveredDate] [datetime] NULL,
[ComputerCount] [bigint] NULL,
[ManualValue] [bigint] NULL,
[ManualInit] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Attestation] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ManualDate] [datetime] NULL
) ON [PRIMARY]

GO
Uses
Used By