About vm_molson

vm_molson

Thanks for the quick reply! One correction to something I said earlier: the format of the "Date" in my lookup file is YYYY-MM-DD. It is in the same dashboard. I tried what you had mentioned already, but with the global parameters within quotes. That didn't seem to return what I wanted, but it did not lead to an error. Then I tried without quotes, and I get this error: Error in 'where' command: The operator at 'mon@mon AND Date<=@mon ' is invalid. The where clause is like: where customer="XYZ" AND Date>=$global_time.earliest$" AND Date<=$global_time.latest$" I've also tried this: | inputlookup mylookup.csv | eval lookupfiledatestart =strftime($global_time.earliest$, "%Y-%m-%d") | eval lookupfiledateend =strftime($global_time.latest$, "%Y-%m-%d") | where client="XYZ" AND Date>=lookupfiledatestart AND Date<=lookupfiledateend That gives me this error: Error in 'EvalCommand': The expression is malformed. An unexpected character is reached at '@mon, "%Y-%m-%d")'.

vm_molson

How do I take a dashboard global time (i.e. - $global_time.earliest$, $global_time.latest$) and convert it into a date to be used when searching a lookup file that only has a date column (i.e. - 04/15/2024)?

vm_molson · ‎10-04-2022

Thanks! So it would just be weighting the input of certain values... it would be cars * 2.6, people * 0.001, packages *.25 to come up with a result.. then looking the result up in a table to determine which size ferry (to extend the example) to take.

vm_molson · ‎10-03-2022

I know this is now what Splunk is, but since we have so much of our current monitoring built into it, I wanted to see if I can just add this also. I am looking to create a dashboard that a user pulls up and provides values for certain inputs, takes the values, and produces a result based on a pre-defined algorythm. For (an extremely simple) example: User has to enter: Number of Cars Number of packages Number of People And then there is a formula we have stored somewhere that takes the inputs, weights them, and produces a result (i.e. - "take the blue ferry" vs. "take the white ferry"). It would be nice if we could do this, even though it's very simple, since we're asking our users to spend more time in the tool. TIA!

vm_molson · ‎01-27-2021

Appreciate you sticking with me, @scelikok ! I actually am still not able to make it work. Let me specify the exact file names I should be getting... maybe I missed something in my explanation? Maybe it is that there is no character directly after the date on three of them? I had assumed a space would count as any character, but I'm not as up on my RegEx as I should be. The log entries look like: ...created /Companyname_POS_20210126 - ... ...created /Companyname_TRN_20210126 - ... ...created /Companyname_TRD_20210126 - ... ...created /COMPANYIDTAXLOT.20210126.230053 - ...

vm_molson · ‎01-14-2021

Hey @scelikok ... thank you for the tip! It seems to work pretty well, but 3 out of the 4 filenames are like: blahblahblah_DATE_blahblahblah .. and only one of the filenames is like blahblahblah.DATE.blahblahblah The exact syntax you suggested works to get the file with the periods in the filename, but not with the underscores. I've tried various permutations and I know I am missing something.. but any thoughts about how I might get the others as well?

vm_molson · ‎01-11-2021

Thank you! Will try this out

vm_molson · ‎01-06-2021

I would like to write an alert that runs Tuesday through Saturday, and looks for files that have been dropped off on our FTP server with the previous day in the filename and fires when four of those files have been found. Example, on 1/6/2021, I want my alert to tell me when 4 files have been delivered matching a filename of xxx_20210105_yyy (where xxx_ and _yyy can be anything). Those files are typically delivered in the morning hours, but possibly have come in as early as 11:30 PM the night before. What is the best way to do this?

Posts	8
Solutions	0
Karma Given	4
Karma Received	0
Member Since	‎02-20-2020

Online Status	Offline
Date Last Visited	3 weeks ago

Converting global_time to date for lookup file

Can I build a simple dashboard tool taking user in...

Alert for filename with previous date

Re: Converting global_time to date for lookup file

Converting global_time to date for lookup file

Re: Can I build a simple dashboard tool taking use...

Can I build a simple dashboard tool taking user in...

Re: Alert for filename with previous date

Re: Alert for filename with previous date

Re: Alert for filename with previous date

Alert for filename with previous date