Hi,
I have added a new table to Splunk DB Connect, but it's fetching only 30% of the data from the Database.
Below is the SQL query given
SELECT Guid, JobName, UsageEnd, TotalAllPages, TotalPrintedPages, PrintPages, CopyPages, ScanPages, FaxPages, BWPages, ColourPages, DuplexPages, LargePages, SmallPages, PrintLargePages, PrintSmallPages, PrintBWLargePages, PrintBWSmallPages, PrintColLargePages, PrintColSmallPages, CopyLargePages, CopySmallPages, CopyBWLargePages, CopyBWSmallPages, CopyColLargePages, CopyColSmallPages, ScanLargePages, ScanSmallPages, ScanBWLargePages, ScanBWSmallPages, ScanColLargePages, ScanColSmallPages, ColLargePages, ColSmallPages, BWLargePages, BWSmallPages, Print2ColPages, Copy2ColPages, RXFaxPages, TXFaxPages, AmountPaid, AltPrice0, AltPrice1, AltPrice2, PrinterID, PrinterName, PrinterLocation, ServerName, SerialNumber, UserID, UserName, UserLogin, GroupID, GroupName, CCID, CCName, CCPathName, SheetsUsed, NonChargeable, NonChargeReason, TypeOfJob, LFPJob, LFPCopyJob, LFPPrintJob, LFPScanJob, LFPCopyBW, LFPCopyCol, LFPPrintBW, LFPPrintCol, LFPScanBW, LFPScanCol, DateMMDDYYYY_101, DateMMDDYYYY_110, DateYYYYMMDD_102, DateYYYYMMDD_111, DateYYYYMMDD_112, DateDDMMYYYY_103, DateDDMMYYYY_104, DateDDMMYYYY_105
FROM DsPcDb.dbo.uFExport WHERE UsageEnd>=? ORDER BY UsageEnd ASC
Thanks in advance
... View more