17 May 2023
	
		
		10:51 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
 - last edited on 
    
	
		
		
		30 May 2023
	
		
		09:38 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
 by 
				
		 MaciejNeumann
		
			MaciejNeumann
		
		
		
		
		
		
		
		
	
			
		
Hello Community,
I just recently started using Notebooks and wanted to see what other have created for Notebooks.
The two I have found interesting are:
fetch logs
| filter contains(content, "Errors")
fetch events
| filter event.kind == "DAVIS_PROBLEM" AND matchesValue(labels.management_zone, "company-app)
Solved! Go to Solution.
18 May 2023 08:24 AM
Hello @oracleman,
The possibilities of notebooks are truly amazing, and we're using them even in the Community Team to improve moderation. For example, we're using this query to quickly identify the questions from users who are just starting their adventure with Dynatrace Community:
fetch bizevents
|filter event.provider =="community"
|filter author.rank.name =="Newcomer" OR author.rank.name == "Visitor" OR author.rank.name == "Frequent Guest" OR author.rank.name == "Observer" OR author.rank.name == "Participant"
|filter depth==0 
|filter replies.count== 0
|fields subject, conversation.view_href, author.rank.name, conversation.last_post_time_friendly, conversation.last_post_time
|sort conversation.last_post_time asc 
Thanks to getting data from the forum to the Dynatrace, we can quickly identify, for example, which topics/labels have the most questions without accepted solutions so that we can contact the right team for help.
Of course, other users will probably show more IT-related examples, just wanted to show that you can use it in very various ways, as sometimes imagination is an only limit 😊
