Tables [dbo].[InvalidPrinterAudit]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:02 AM Thursday, March 21, 2019
Last Modified1:20:25 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_InvalidPrinterAudit_ID: IDIDint4
False
1 - 1
Remarksvarchar(1024)1024
False
PrinterAuditIDint4
True
PrinterIPAddrvarchar(40)40
True
LocalIDnvarchar(100)200
True
Manufacturervarchar(32)32
True
Modelvarchar(64)64
True
SerialNrvarchar(32)32
True
PrinterNamevarchar(32)32
True
PrinterLocationnvarchar(250)500
True
PrinterAssetNrvarchar(100)100
True
PageCountTotalint4
True
PageCountMonoint4
True
PageCountColorint4
True
PageCountPrinterint4
True
PageCountFaxint4
True
PageCountCopyint4
True
PageCountListint4
True
ScanCountTotalint4
True
ScanCountFaxint4
True
ScanCountCopyint4
True
ScanCountNetint4
True
ScanCountEmailint4
True
CovSumBlackfloat8
True
CovSumCyanfloat8
True
CovSumMagentafloat8
True
CovSumYellowfloat8
True
CovSqSumBlackfloat8
True
CovSqSumCyanfloat8
True
CovSqSumMagentafloat8
True
CovSqSumYellowfloat8
True
Foreign Keys FK_InvalidPrinterAudit_AuditID_Audit_AuditID: [dbo].[Audit].AuditIDAuditIDint4
False
MacAddressvarchar(64)64
True
Foreign Keys FK_InvalidPrinterAudit_DeviceID_Device_DeviceID: [dbo].[Device].DeviceIDDeviceIDint4
True
PageCountPrinterMonoint4
True
PageCountPrinterColorint4
True
PageCountCopyMonoint4
True
PageCountCopyColorint4
True
ScanCountCopyMonoint4
True
ScanCountCopyColorint4
True
HostNamevarchar(100)100
True
ServiceContactnvarchar(100)200
True
InstalledMemoryint4
True
FirmwareVersionvarchar(50)50
True
InstallationDatedatetime8
True
SheetCountTotalint4
True
PageCountTotalUsagefloat8
True
ScanCountTotalUsagefloat8
True
FaxCountSendint4
True
FaxCountReceiveint4
True
CovAverageBlackfloat8
True
CovAverageCyanfloat8
True
CovAverageMagentafloat8
True
CovAverageYellowfloat8
True
PageCountMonoUsagefloat8
True
PageCountColorUsagefloat8
True
PageCountColorUsageProffloat8
True
PageCountColorUsageProfAccentfloat8
True
PageCountColorUsageOfficefloat8
True
PageCountColorUsageOfficeAccentfloat8
True
PageCountXeroxBLevel1int4
True
PageCountXeroxLevel2int4
True
PageCountXeroxLevel3int4
True
PageCountFaxMonoint4
True
PageCountFaxColorint4
True
StapleCountint4
True
ScanCountColorint4
True
ScanCountMonoint4
True
TabloidCountTotalint4
True
TabloidCountMonoint4
True
TabloidCountColorint4
True
TabloidSheetCountTotalint4
True
ContinuousSquareFeetfloat8
True
ContinuousSquareMetersfloat8
True
DoubleClickTotalint4
True
DoubleClickMonoint4
True
DoubleClickColorint4
True
DoubleClickFullColorint4
True
DoubleClickTwoColorint4
True
DoubleClickSingleColorint4
True
DoubleClickDuplexint4
True
DevelopmentTotalint4
True
DevelopmentMonoint4
True
DevelopmentColorint4
True
CopyPagesFullColorint4
True
CopyPagesTwoColorint4
True
CopyPagesSingleColorint4
True
OtherPagesint4
True
OtherPagesMonoint4
True
OtherPagesColorint4
True
OtherPagesFullColorint4
True
OtherPagesTwoColorint4
True
OtherPagesSingleColorint4
True
ScansUsageMonofloat8
True
ScansUsageColorfloat8
True
ScansFaxMonoint4
True
ScansFaxColorint4
True
ScansEmailMonoint4
True
ScansEmailColorint4
True
ScansNetMonoint4
True
ScansNetColorint4
True
TotalPagesFullColorint4
True
TotalPagesTwoColorint4
True
TotalPagesSingleColorint4
True
UsagePagesFullColorfloat8
True
UsagePagesTwoColorfloat8
True
UsagePagesSingleColorfloat8
True
PrinterPagesFullColorint4
True
PrinterPagesTwoColorint4
True
PrinterPagesSingleColorint4
True
LargePagesFullColorint4
True
LargePagesTwoColorint4
True
LargePagesSingleColorint4
True
LinearFeetfloat8
True
MeterSourcetinyint1
False
((0))
UsagePagesAccentfloat8
True
PageCountAccentUsagePresfloat8
True
PageCountColorUsagePresfloat8
True
PageCountAccentUsageMaxfloat8
True
PageCountColorUsageMaxfloat8
True
TotalImpressionsfloat8
True
TotalImpressionsMonofloat8
True
TotalImpressionsColorfloat8
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_InvalidPrinterAudit_ID: IDPK_InvalidPrinterAudit_IDID
True
80
NameColumns
FK_InvalidPrinterAudit_AuditID_Audit_AuditIDAuditID->[dbo].[Audit].[AuditID]
FK_InvalidPrinterAudit_DeviceID_Device_DeviceIDDeviceID->[dbo].[Device].[DeviceID]
CREATE TABLE [dbo].[InvalidPrinterAudit]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PrinterAuditID] [int] NULL,
[PrinterIPAddr] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocalID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Manufacturer] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNr] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrinterName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrinterLocation] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrinterAssetNr] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PageCountTotal] [int] NULL,
[PageCountMono] [int] NULL,
[PageCountColor] [int] NULL,
[PageCountPrinter] [int] NULL,
[PageCountFax] [int] NULL,
[PageCountCopy] [int] NULL,
[PageCountList] [int] NULL,
[ScanCountTotal] [int] NULL,
[ScanCountFax] [int] NULL,
[ScanCountCopy] [int] NULL,
[ScanCountNet] [int] NULL,
[ScanCountEmail] [int] NULL,
[CovSumBlack] [float] NULL,
[CovSumCyan] [float] NULL,
[CovSumMagenta] [float] NULL,
[CovSumYellow] [float] NULL,
[CovSqSumBlack] [float] NULL,
[CovSqSumCyan] [float] NULL,
[CovSqSumMagenta] [float] NULL,
[CovSqSumYellow] [float] NULL,
[AuditID] [int] NOT NULL,
[MacAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeviceID] [int] NULL,
[PageCountPrinterMono] [int] NULL,
[PageCountPrinterColor] [int] NULL,
[PageCountCopyMono] [int] NULL,
[PageCountCopyColor] [int] NULL,
[ScanCountCopyMono] [int] NULL,
[ScanCountCopyColor] [int] NULL,
[HostName] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ServiceContact] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InstalledMemory] [int] NULL,
[FirmwareVersion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InstallationDate] [datetime] NULL,
[SheetCountTotal] [int] NULL,
[PageCountTotalUsage] [float] NULL,
[ScanCountTotalUsage] [float] NULL,
[FaxCountSend] [int] NULL,
[FaxCountReceive] [int] NULL,
[CovAverageBlack] [float] NULL,
[CovAverageCyan] [float] NULL,
[CovAverageMagenta] [float] NULL,
[CovAverageYellow] [float] NULL,
[PageCountMonoUsage] [float] NULL,
[PageCountColorUsage] [float] NULL,
[PageCountColorUsageProf] [float] NULL,
[PageCountColorUsageProfAccent] [float] NULL,
[PageCountColorUsageOffice] [float] NULL,
[PageCountColorUsageOfficeAccent] [float] NULL,
[PageCountXeroxBLevel1] [int] NULL,
[PageCountXeroxLevel2] [int] NULL,
[PageCountXeroxLevel3] [int] NULL,
[PageCountFaxMono] [int] NULL,
[PageCountFaxColor] [int] NULL,
[StapleCount] [int] NULL,
[ScanCountColor] [int] NULL,
[ScanCountMono] [int] NULL,
[TabloidCountTotal] [int] NULL,
[TabloidCountMono] [int] NULL,
[TabloidCountColor] [int] NULL,
[TabloidSheetCountTotal] [int] NULL,
[ContinuousSquareFeet] [float] NULL,
[ContinuousSquareMeters] [float] NULL,
[DoubleClickTotal] [int] NULL,
[DoubleClickMono] [int] NULL,
[DoubleClickColor] [int] NULL,
[DoubleClickFullColor] [int] NULL,
[DoubleClickTwoColor] [int] NULL,
[DoubleClickSingleColor] [int] NULL,
[DoubleClickDuplex] [int] NULL,
[DevelopmentTotal] [int] NULL,
[DevelopmentMono] [int] NULL,
[DevelopmentColor] [int] NULL,
[CopyPagesFullColor] [int] NULL,
[CopyPagesTwoColor] [int] NULL,
[CopyPagesSingleColor] [int] NULL,
[OtherPages] [int] NULL,
[OtherPagesMono] [int] NULL,
[OtherPagesColor] [int] NULL,
[OtherPagesFullColor] [int] NULL,
[OtherPagesTwoColor] [int] NULL,
[OtherPagesSingleColor] [int] NULL,
[ScansUsageMono] [float] NULL,
[ScansUsageColor] [float] NULL,
[ScansFaxMono] [int] NULL,
[ScansFaxColor] [int] NULL,
[ScansEmailMono] [int] NULL,
[ScansEmailColor] [int] NULL,
[ScansNetMono] [int] NULL,
[ScansNetColor] [int] NULL,
[TotalPagesFullColor] [int] NULL,
[TotalPagesTwoColor] [int] NULL,
[TotalPagesSingleColor] [int] NULL,
[UsagePagesFullColor] [float] NULL,
[UsagePagesTwoColor] [float] NULL,
[UsagePagesSingleColor] [float] NULL,
[PrinterPagesFullColor] [int] NULL,
[PrinterPagesTwoColor] [int] NULL,
[PrinterPagesSingleColor] [int] NULL,
[LargePagesFullColor] [int] NULL,
[LargePagesTwoColor] [int] NULL,
[LargePagesSingleColor] [int] NULL,
[LinearFeet] [float] NULL,
[MeterSource] [tinyint] NOT NULL CONSTRAINT [DF_InvalidPrinterAudit_MeterSource] DEFAULT ((0)),
[UsagePagesAccent] [float] NULL,
[PageCountAccentUsagePres] [float] NULL,
[PageCountColorUsagePres] [float] NULL,
[PageCountAccentUsageMax] [float] NULL,
[PageCountColorUsageMax] [float] NULL,
[TotalImpressions] [float] NULL,
[TotalImpressionsMono] [float] NULL,
[TotalImpressionsColor] [float] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[InvalidPrinterAudit] ADD CONSTRAINT [PK_InvalidPrinterAudit_ID] PRIMARY KEY CLUSTERED  ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[InvalidPrinterAudit] ADD CONSTRAINT [FK_InvalidPrinterAudit_AuditID_Audit_AuditID] FOREIGN KEY ([AuditID]) REFERENCES [dbo].[Audit] ([AuditID])
GO
ALTER TABLE [dbo].[InvalidPrinterAudit] ADD CONSTRAINT [FK_InvalidPrinterAudit_DeviceID_Device_DeviceID] FOREIGN KEY ([DeviceID]) REFERENCES [dbo].[Device] ([DeviceID])
GO