Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- About Hppjet
Hppjet
Path Finder
Member since:
09-20-2017
06-05-2020
Community Statistics
| Posts | 21 |
| Solutions | 1 |
| Karma Given | 1 |
| Karma Received | 3 |
| Member Since | 09-20-2017 |
Activity Feed
- Got Karma for Re: How do you automatically remove the last entry in a table?. 06-05-2020 12:50 AM
- Karma Re: Combine 3 Fields with Same ID for elliotproebstel. 06-05-2020 12:49 AM
- Got Karma for How to edit my search to divide the sum by a specific number?. 06-05-2020 12:49 AM
- Got Karma for Re: I'm having trouble with the "over" syntax. How to use it in this situation?. 06-05-2020 12:49 AM
- Posted Can you help me with my time range Issue? on Dashboards & Visualizations. 11-13-2018 11:08 AM
- Tagged Can you help me with my time range Issue? on Dashboards & Visualizations. 11-13-2018 11:08 AM
- Tagged Can you help me with my time range Issue? on Dashboards & Visualizations. 11-13-2018 11:08 AM
- Posted Re: How do you automatically remove the last entry in a table? on Dashboards & Visualizations. 10-10-2018 08:35 AM
- Posted Re: How do you automatically remove the last entry in a table? on Dashboards & Visualizations. 10-10-2018 08:35 AM
- Posted Re: How do you automatically remove the last entry in a table? on Dashboards & Visualizations. 10-10-2018 08:33 AM
- Posted How do you automatically remove the last entry in a table? on Dashboards & Visualizations. 10-10-2018 07:31 AM
- Tagged How do you automatically remove the last entry in a table? on Dashboards & Visualizations. 10-10-2018 07:31 AM
- Posted Re: How to create a table that has values summed up by the column? on Splunk Search. 05-03-2018 09:45 AM
- Posted Re: How to create a table that has values summed up by the column? on Splunk Search. 05-03-2018 09:14 AM
- Posted Re: How to create a table that has values summed up by the column? on Splunk Search. 05-03-2018 09:14 AM
- Posted How to create a table that has values summed up by the column? on Splunk Search. 05-03-2018 08:49 AM
- Tagged How to create a table that has values summed up by the column? on Splunk Search. 05-03-2018 08:49 AM
- Tagged How to create a table that has values summed up by the column? on Splunk Search. 05-03-2018 08:49 AM
- Posted Re: Combine 3 Fields with Same ID on Splunk Search. 03-05-2018 04:03 AM
- Posted Combine 3 Fields with Same ID on Splunk Search. 03-03-2018 10:35 AM
Topics I've Started
| Subject | Karma | Author | Latest Post |
|---|---|---|---|
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 0 | |||
| 1 | |||
| 0 | |||
| 0 |
11-13-2018
11:08 AM
I have an issue with using today's time range. I really need it to pull 11:30 PM to 11:30 PM whenever I go to look at a day. Does anyone have some suggestions?
... View more
10-10-2018
08:35 AM
It keeps failing the last line to display but it is | head (timerange < Number)
... View more
10-10-2018
08:35 AM
| table _time SQYDLBHR
| streamstats count(SQYDLBHR) as timerange
| eventstats count(SQYDLBHR) as this
| eval Number = this - 1
| head (timerange
... View more
10-10-2018
08:33 AM
1 Karma
| table _time SQYDLBHR
| streamstats count(SQYDLBHR) as timerange
| eventstats count(SQYDLBHR) as this
| eval Number = this - 1
| head (timerange
... View more
10-10-2018
07:31 AM
I am doing a time chart but I don't want Today's date to show in the table. I know I can do that with the date range but that is cumbersome.
Any way to write it in SPL to do this?
... View more
- Tags:
- splunk-enterprise
05-03-2018
09:14 AM
I need to take the values in the second column and turn those into columns which will sum the values based on what is in the first column.
... View more
05-03-2018
09:14 AM
I need to take the values in the second column and turn those into columns which will sum the values based on what is in the first column.
... View more
05-03-2018
08:49 AM
I would like to manipulate it to look like this:
... View more
03-05-2018
04:03 AM
Thank you!!! Yes, it worked perfectly. I wanted to be able to sum for every possible userID. This made my week.
... View more
03-03-2018
10:35 AM
I have 3 fields that will contain the same user IDs and I would like to merge them into 1. They each have a sum value they represent but the 3 fields are just a different role.
If the events look like
Day 1 Pounds=20,field1=A,field2=B,field3=C
Day 2 Pounds=50,field1=C,field2=A,field3=B
Day 3 Pounds =60,field1=B,field2=R,field3=A
Is it possible to combine the 3 so if field1 = A field2 = A field3 = A then the sum(Pounds)=130
... View more
- Tags:
- splunk-enterprise
01-23-2018
10:36 AM
I am trying to add color to a single value chart. The 1000 is the goal and it changes based on the number of days the search pulls.
Here is my search.
index=Foo ShiftName=1 MachineNumber<26 NumberOfGGRollPaths ElapsedMachineFootageInOrderPath
| eval "Square Yards"= (NumberOfGGRollPaths * ElapsedMachineFootageInOrderPath)*0.66667
| stats dc(_time) as numberofuniquedays sum("Square Yards") as SQYDS
| chart sum(SQYDS)
| eval Scale = (SQYDS/(numberofuniquedays * 1000))
| rangemap field=Scale green=1000-1 yellow=0.8-0.5 red=0.5-0
I can't get the chart to change a color. Please help.
... View more
- Tags:
- splunk-enterprise
11-16-2017
11:40 AM
I want to show the top 10 shop orders. Then show the sum of the parts that make up the shop order.
... View more
11-16-2017
11:15 AM
index="all_eqt" | stats sum(TotalSquareYards) as TSY by ShopOrder DefectDescription| table ShopOrder DefectDescription TSY |sort -TSY | head 10 | chart sum(TSY) over ShopOrder by DefectDescription
I am not able to get the chart to show the top 10 shop orders with TSY instead it just shows the first 10. Please help.
... View more
09-25-2017
07:26 AM
1 Karma
Thank you for this solution and lesson. I didn't know it would be lost after stats.
... View more
09-25-2017
05:40 AM
I was hoping to create a column chart that has totals for "Login Hours" that is separated by machine state(running, stopped) that is broken out by Employee last name.
... View more
09-22-2017
07:25 PM
index="Plt15_tms3" ShiftName="1" EmployeeLoggedInLastName="*" MachineNumber<26 MachineState="*" | stats sum(ElapsedMachineSecondsInOrderPath) as ElapsedMachineSecondsInOrderPath by EmployeeLoggedInLastName | eval "Login Hours"=ElapsedMachineSecondsInOrderPath/3600 | chart sum("Login Hours") **over** MachineState by EmployeeLoggedInLastName
updated - marked as code
... View more
09-22-2017
07:22 PM
Of course but I won't accept answers while I'm away from work...
... View more
09-21-2017
09:37 AM
1 Karma
ShiftName="1" EmployeeLoggedInLastName="*" MachineNumber="*"| stats sum(ElapsedMachineSecondsInOrderPath) by EmployeeLoggedInLastName
I want to divide the sum by a specific number like 3600.
... View more
09-20-2017
01:18 PM
index="all_eqt" Plant=15 ProcessCode=T DefectCode="*" MachineNumber<26 | stats sum(TotalSquareYards) as "Total Square Yards" by StyleName | sortStyleName
I'm trying to limit the data shown on the chart to the top 5 styles with the highest TotalSquareYards
... View more
09-20-2017
09:46 AM
index="all_eqt" Plant=15 ProcessCode=T DefectCode="*" MachineNumber<26 | stats sum(TotalSquareYards) as "Total Square Yards" by DefectCode
How do I change the x-axis "TA" label to display "styles" instead?
... View more
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
06-05-2020
02:03 AM
|
