Hi Guys, (Please see attached file for better understanding)
I need help adjusting my query to show the below results:
I want to put all the (software, brand and product) in one single row with the total number of their count under “count”
Example, instead of having multiple Mac, Window etc… we should just have one row with the total count
Current table
Software
Brand
Product
Number of count
Mac
Apple
MTBNUYE2V0
1
Mac
Apple
MTBNUYE2V1
1
Mac
Apple
MTBNUYE2V2
1
Mac
Apple
MTBNUYE2V3
1
Mac
Apple
MTBNUYE2V4
1
Mac
Apple
MTBNUYE2V5
1
Mac
Apple
MTBNUYE2V6
1
Mac
Apple
MTBNUYE2V7
1
Mac
Apple
MTBNUYE2V8
1
Mac
Apple
MTBNUYE2V9
1
Mac
Apple
MTBNUYE2V10
1
Mac
Apple
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Window
Win.x
Youbest
2
Example of expected result:
Software
Brand
Version
Number of count
Mac
Apple
20.20.20
200
Windows
Win.x
30.90.09
320
Data is from: index=product sourcetype=my_product
Then when we click on the Number of count it should open in a new page showing all the details of the software (example of what details we should see are IP, NAME, HOSTNAME)
Data is from: |inputlookup product
... View more