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
hi @SathyaNarayanan ,
Could you give us some more context to your Splunk set up? In general, your question has a better chance of getting answered by the community the more information you give.
Thanks for posting and good luck with your question!
Splunk Setup
4 Indexer , 1 server for DB Connect , 3 search head with cluster