All Apps and Add-ons

dbxquery : query to print two Select Statements in email

mxshar1
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

elliotproebstel
Champion

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
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...