topic Re: Why does the tSessions_Lookup_Update report take a long time to complete? in All Apps and Add-ons

Why does the tSessions_Lookup_Update report take a long time to complete?

danielbb — Tue, 07 Jan 2020 20:55:16 GMT

The tSessions_Lookup_Update report from the splunk_app_windows_infrastructure is the main or only report for which we see many skipped searches.

The code is -

`tsessions` 
| eval _key = session_id 
| sort 0 _time 
| outputlookup tSessions append=true

| inputlookup tSessions is not even responsive.

What can it be?

Re: Why does the tSessions_Lookup_Update report take a long time to complete?

danielbb — Tue, 14 Jan 2020 17:44:42 GMT

Looking via the MC at search->kvstore->instance and we see -

We see 268,809,800 objects for this collection. Does it make sense to have so many objects? Should we maybe initialize this collection?

Re: Why does the tSessions_Lookup_Update report take a long time to complete?

lim2 — Wed, 23 Jun 2021 21:11:38 GMT

You may need to add the index, especially if running the SPL as Splunk admin. Else will look through all available Splunk indexes. The actual saved search for tSessions_Lookup_Update in https://splunkbase.splunk.com/app/1680/ (Splunk App for Windows Infrastructure) included index as following.

`wineventlog-index` `tsessions`|eval _key = session_id |sort 0 _time|outputlookup tSessions append=true