Win a ticket to {Future}Stack15: Submit your original NRQL for a chance to win!

So you want to win a ticket to FutureStack15? Here is your opportunity!

To enter the contest to this thread with your original Insights NRQL query and share some words about what your NRQL accomplishes.

Then sit back and watch the votes come in! The post with the most likes will win a free ticket to FutureStack15!

Want to vote? Click the to vote for your faves!

Have fun and good look to all of your contestants!

(Please review our Terms & Conditions before entering!)

1 Like

This query accomplishes finding app usage % on WIFI vs non-WIFI

SELECT percentage(count(carrier), WHERE carrier = 'wifi') as 'WIFI', percentage(count(carrier), WHERE carrier != 'wifi') as 'Other' from Mobile where appName = 'Dreamforce-2015-Android-AppStore' and appVersion >= '3.0.0' SINCE 1 month ago
7 Likes

We’re using Insights to track our MySQL database performance as we tune the DB.

A few queries helped build a dashboard that gives a snapshot of improvements (or not!) since the past week.

Average Database Duration, compared to last week
SELECT average(databaseDuration) FROM Transaction WHERE appName LIKE ‘%Production%’ SINCE 1 week ago COMPARE WITH 30 minutes ago

Database Duration’s Percentage of Total Duration, compared to last week

SELECT 100*(average(databaseDuration)/average(duration)) FROM Transaction WHERE appName LIKE ‘%Production%’ SINCE 1 week ago COMPARE WITH 30 minutes ago

Average Database Duration and Total Duration since 1 week

SELECT average(databaseDuration), average(duration) FROM Transaction SINCE 1 week ago WHERE appName LIKE ‘%Production%’

1 Like