topic Re: Splunk SQL query in Knowledge Management https://community.splunk.com/t5/Knowledge-Management/Splunk-SQL-query/m-p/508976#M4626 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/222802">@rahul2gupta</a>&nbsp;</P><P>It is possible to query database from Splunk.</P><UL><LI>You need read permissions to the database.</LI><LI>You need to install splunk app for dbconnect on splunk</LI></UL><P>The syntax to run this query is</P><P>&nbsp;</P><LI-CODE lang="markup">| dbxquery connection="connection_name" query="select ...."</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>Hope this helps</P> Tue, 14 Jul 2020 04:16:35 GMT anilchaithu 2020-07-14T04:16:35Z Splunk SQL query https://community.splunk.com/t5/Knowledge-Management/Splunk-SQL-query/m-p/508954#M4624 <P>Hi&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/161352">@gcusello</a>&nbsp;,</P><P class="x_MsoNormal">Is it possible to run a SQL query from Splunk search bar to a SQL server? i.e. I want to run a SQL query against server abc1sql07.</P><P class="x_MsoNormal">Is this possible ? if so, what permission do we need to setup on SQL server to ensure Splunk has permission to query the database?</P><P class="x_MsoNormal">Regards,</P><P class="x_MsoNormal">Rahul</P> Tue, 14 Jul 2020 02:04:22 GMT https://community.splunk.com/t5/Knowledge-Management/Splunk-SQL-query/m-p/508954#M4624 rahul2gupta 2020-07-14T02:04:22Z Re: Splunk SQL query https://community.splunk.com/t5/Knowledge-Management/Splunk-SQL-query/m-p/508976#M4626 <P><a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/222802">@rahul2gupta</a>&nbsp;</P><P>It is possible to query database from Splunk.</P><UL><LI>You need read permissions to the database.</LI><LI>You need to install splunk app for dbconnect on splunk</LI></UL><P>The syntax to run this query is</P><P>&nbsp;</P><LI-CODE lang="markup">| dbxquery connection="connection_name" query="select ...."</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>Hope this helps</P> Tue, 14 Jul 2020 04:16:35 GMT https://community.splunk.com/t5/Knowledge-Management/Splunk-SQL-query/m-p/508976#M4626 anilchaithu 2020-07-14T04:16:35Z