
12
APPENDIX B—DATA DICTIONARIES FOR DATABASE VIEWS
The following tables include all the attributes contained in each database view that is generated by
either reports data collections for Device Utilization and Supplies Utilization or by the attributes polled
in the configuration file described in Appendix A—Configure the default poller.
Media size and color usage utilization view
(PUBLIC_MEDIA_COLOR_USE_VW)
A GUID that serves as a unique identifier for the device.
A GUID that serves as a unique identifier for a communication
interface.
A string representation of the media size that is associated with the
page counts. A value of ”Total” indicates that the page count column
values represent the total page counts for all media sizes. See
1
for the list of valid values.
Describes whether or not these were monochrome pages or color
pages and, if color, what type of color was used. Possible values
are: “Mono”, ”Color”, “GeneralOffice”, “GeneralOfficeAccent”,
“Professional”, “ProfessionalAccent”, or “Total”.
The number of single-sided sheets of pages printed by the printer.
2
The number of sheets of paper printed with an impression on both
sides of the sheet.
2
The number of blank sides of paper printed as the final page of a
duplex job that contains an odd number of pages.
2
If a duplex job
has an odd number of pages, the last page of the job is a sheet of
paper with only one impression on it (the other side is blank).
The total number of page impressions printed (simplex_count + 2
times the duplex_count).
2
___________________
1
Valid values for media_size column: “Total”, “Other”, “eUSExecutive”, “eUSLetter”, “eUSLegal”, “eUSEDP”, “eEuropeanEDP”,
“eUSGovernmentLetter”, “eUSGovernmentLegal”, “eFolio”, “eFoolscap”, “eLedger”, “eCSize”, “eDSize”, “eESize”,
“eStatement”, “eSuperB”, “eROC16K”, “eJISExecutive”, “eROC8K”, “eISOandJISA10”, “eISOandJISA9”, “eISOandJISA8”,
“eISOandJISA7”, “eISOandJISA6”, “eISOandJISA5”, “eISOandJISA4”, “eISOandJISA3”, “eISOandJISA2”, “eISOandJISA1”,
“eISOandJISA0”, “eISOandJIS2A0”, “eISOandJIS4A0”, “ePRC8K270X390”, “eROC16K195X270”, “ePRC8K260x368”,
“eISORA4”, “eISOSRA4”, “eISOSRA3”, “eISORA3”, “eJISB10”, “eJISB9”, “eJISB8”, “eJISB7”, “eJISB6”, “eJISB5”, “eJISB4”,
“eJISB3”, “eJISB2”, “eJISB1”, “eJISB0”, “eISOB10”, “eISOB9”, “eISOB8”, “eISOB7”, “eISOB6”, “eISOB5”, “eISOB4”,
“eISOB3”, “eISOB2”, “eISOB1”, “eISOB0”, “eJapansePostcardSingle”, “eJapansePostcardDouble”, “eISOA6Postcard”,
“eIndexCard4x6”, “eIndexCard5x8”, “ePhoto4x6”, “eJapanesePostcardWithTab”, “eIndexCard3x5”, “eMonarch”,
“eCommercial10”, “eCatalog”, “eNo10Envelope”, “eROC16K184X260”, “eInternationalDL”, “eInternationalC5”,
“eInternationalC6”, “eInternationalC4”, “eInternationalB5”, “eCustom”, “eCustomCard”, “eUSEnvelopeA2”,
“eJapanseEnvLong3”, “eJapanseEnvLong4”, “eJapanseEnv2”, “ePhoto10x15”, “ePhotoCabinet”, “eTabloidExtra”,
“ePhotoLSizeCard”, “eIndexCard5x7”, “ePhotoESizeCard”, “ePhotoKGSizeCard”, “ePhoto2ESizeCard”, “ePhoto2LSizeCard”,
“eUSExecutiveR”, “eUSLetterR”, “eROC16KR”, “eISOandJISA6R”, “eISOandJISA5R”, “eISOandJISA4R”, “eJISBR6R”,
“eJISB5R”, “eStatementR”, “eAnyCustomSize”, “eAnySize”, “eCustomRoll”, “eUnknownMediaSize”, “eStatementWR”,
“eJISB5WR”, “eISOandJISA4WR”, “eISOandJISA5WR”, “eUSLetterWR”, “eJISB4W”, “eJISB5W”, “eISOandJISA3W”,
“eISOandJISA4W”, “eISOandJISA5W”, “eStatementW”, “eLedgerW”, “eUSLetterW”.
2
All pages printed, including copied pages and incoming fax pages.
Comentarios a estos manuales