All Apps and Add-ons

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

Path Finder


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

0 Karma

Splunk Employee
Splunk Employee

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!

0 Karma

Path Finder

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

0 Karma
Get Updates on the Splunk Community!

Splunk Security Content for Threat Detection & Response, Q1 Roundup

Join Principal Threat Researcher, Michael Haag, as he walks through:An introduction to the Splunk Threat ...

Splunk Life | Happy Pride Month!

Happy Pride Month, Splunk Community! 🌈 In the United States, as well as many countries around the ...

SplunkTrust | Where Are They Now - Michael Uschmann

The Background Five years ago, Splunk published several videos showcasing members of the SplunkTrust to share ...