https://community.splunk.com/t5/Getting-Data-In/pass-hostname-to-scripted-input/m-p/46504#M8781 <P>Hi, I want to create a scripted input, a script that will query sql server on a machine. I want the query to be executed on whatever host I set up the input for, so I assume I should pass the hostname as an argument to the script. How can I do that dynamically? is there a variable in splunk that can expand automatically? So I could set splunk up to run the script something like this:</P> <P>script.cmd $hostname</P> Fri, 18 Feb 2011 01:55:02 GMT jgeyer14 2011-02-18T01:55:02Z https://community.splunk.com/t5/Getting-Data-In/pass-hostname-to-scripted-input/m-p/46504#M8781 <P>Hi, I want to create a scripted input, a script that will query sql server on a machine. I want the query to be executed on whatever host I set up the input for, so I assume I should pass the hostname as an argument to the script. How can I do that dynamically? is there a variable in splunk that can expand automatically? So I could set splunk up to run the script something like this:</P> <P>script.cmd $hostname</P> Fri, 18 Feb 2011 01:55:02 GMT https://community.splunk.com/t5/Getting-Data-In/pass-hostname-to-scripted-input/m-p/46504#M8781 jgeyer14 2011-02-18T01:55:02Z https://community.splunk.com/t5/Getting-Data-In/pass-hostname-to-scripted-input/m-p/46505#M8782 <P>nevermind i figured it out. right now I am adding a new scripted input for each host and passing it manually like so:</P> <H1>first arg is the hostname the script will use to do the query</H1> <PRE> [script://$SPLUNK_HOME\bin\scripts\test.cmd testhost] interval = 5 sourcetype = sql:test source = jamiesqltest host=testhost disabled=0 [script://$SPLUNK_HOME\bin\scripts\test.cmd testhost-2] interval = 5 sourcetype = sql:test source = jamiesqltest host=testhost-2 disabled=0 </PRE> Fri, 18 Feb 2011 03:09:32 GMT https://community.splunk.com/t5/Getting-Data-In/pass-hostname-to-scripted-input/m-p/46505#M8782 jgeyer14 2011-02-18T03:09:32Z