All Apps and Add-ons

dbxquery : query to print two Select Statements in email

New Member

I have a query which has two select statements having different columns.
Example:
SELECT STATE, COUNTRY FROM MYCOUNTRY
SELECT COUNTRY, CURRENCY FROM MYCOUNTRY

EXPECTED OUTPUT IN EMAIL:

STATE COUNTRY
CA USA
London UK

COUNTRY CURRENCY
USA DOLLAR
UK POUND

I am not sure how to get this kind of output. I have over simplified it but each select statements which I have are completely unrelated and cannot be merged in any way. USERS do not want multiple emails and want data in one email output.

Tags (1)
0 Karma

If you can create a dashboard containing those two queries as separate panels, you could schedule delivery of a dashboard view in PDF format. Would that meet your goals? If so, the exact process will vary based on the version of Splunk you are running, but here's a link to documentation for the current Splunk version:
http://docs.splunk.com/Documentation/Splunk/7.0.1/Viz/DashboardPDFs

0 Karma