All Apps and Add-ons

Challenge in Splunk query

jerinvarghese
Communicator

Need help in the query builder.

| dbxquery connection="ITDW" shortnames=true  query="SELECT
[Incident_Number],
[Assignee],
[Last_Modified_By],
[Customer],
[Customer_Site_Group],
[Customer_Site],
[Summary],
[Notes],
[Priority],
[Assigned_Support_Group],
[Status],
[Status_Reason],
[Resolution],
[Reported_Date],
[Last_Resolved_Date],
[Last_Modified_Date],
[Owner_Group],
[Submit_Date]
FROM [shared].[ITSM_INC_MAIN] INC
WHERE [Submit_Date] BETWEEN DATEADD(D,-3,GETDATE()) AND GETDATE()
AND
[Summary] like '%%' "

I am facing challenge in getting the date changed all time for a search.

Submit_Date
2020-04-04 11:35:51.0
2020-04-04 11:35:57.0
2020-04-04 11:36:13.0
2020-04-04 11:37:22.0

here is how Submit date format comes.

Also below is the line where am facing challenge in providing a defined time.

WHERE [Submit_Date] BETWEEN DATEADD(D,-3,GETDATE()) AND GETDATE()

please help me in editing this line

0 Karma

jerinvarghese
Communicator

any suggestions please

0 Karma

DalJeanis
Legend

1) Are you trying to get all the data for the last 3 days, or are you trying to get data since a particualr time, or what?

2) what is the underlying database, SQL Server or Oracle or what? Time functions are often unique to each implementation of SQL.

0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...