Getting Data In

Dynamic lookup table

Sangu
Explorer

Hi,

I have request to create dashboard with user information, but that user information is provided by AD team, So I need to create a lookup table to access that information. Issue is that the user information may change everyday and AD team will give new excel sheet with updated info, so how can I update the lookup table automatically,

Otherwise I need to upload the csv file everyday to splunk which is not best option.

Please give some ideas, Can we replace that file from splunk server lookup directory? does that work or any other way to do this.

Thanks in Advance!

Labels (1)
Tags (1)
0 Karma

venkatasri
SplunkTrust
SplunkTrust

Hi @Sangu 

There is a solution here - Solved: How can I upload & Replace lookup files on a weekl... - Splunk Community

You need to replace the old CSV with new CSV on Splunk SH cluster/standalone. Above link having steps instead of direct replacement of file a safe approach.

---

An upvote would be appreciated if it helps!

Tags (1)
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...