Why is Splunk DB connect not getting all the data from the server?

[SathyaNarayanan]

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

[mstjohn_splunk]

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!

[SathyaNarayanan]

Splunk Setup
4 Indexer , 1 server for DB Connect , 3 search head with cluster