モバイル監視のためのNRQLクエリの例

SELECT uniqueCount(uuid) FROM Mobile SINCE 1 day ago FACET name

SELECT uniqueCount(uuid) FROM MobileSession WHERE countryCode='CN' FACET regionCode SINCE 7 days ago

SELECT uniqueCount(uuid) FROM MobileSession FACET osVersion SINCE 7 days ago

SELECT percentile(sessionDuration, 90) FROM MobileSession since 1 day ago compare with 2 days ago

SELECT histogram(memUsageMb) FROM MobileSession WHERE sessionDuration > 5

SELECT count(*) FROM MobileCrash FACET crashException

SELECT percentage(uniqueCount(sessionId), WHERE category = 'Crash') as `Crash rate` FROM MobileSession, MobileCrash facet appVersion since 90 days ago

SELECT percentage(count(*), where errorType = 'NetworkFailure' OR errorType = 'HTTPError') as 'Error Rate %', count(*) as '# of Requests', filter(count(*), where errorType='NetworkFailure' OR errorType='HTTPError' as '# of Errors') FROM MobileRequestError, MobileRequest facet requestDomain

SELECT percentage(count(*), where errorType = 'NetworkFailure' OR errorType = 'HTTPError') as 'Error Rate %', count(*) as '# of Requests', filter(count(*), where errorType='NetworkFailure' OR errorType='HTTPError' as '# of Errors') FROM MobileRequestError, MobileRequest facet requestPath where requestPath = '{MY_API_PATH}'

SELECT percentile(responseTime, 90), latest(requestUrl) as 'Latest URL' from MobileRequest facet cases(where requestUrl like '%{YOUR_CORE_API}%' as 'Core API', where requestUrl like '%{YOUR_FEATURE_API}%' as 'New Feature API')

SELECT count(*) FROM MobileRequest FACET requestDomain since 3 days ago

SELECT filter(uniqueCount(MobileRequest.uuid), WHERE responseTime > 3) / uniqueCount(MobileSession.uuid) * 100 as '% Users Impacted' FROM MobileRequest, MobileSession since 1 day ago timeseries compare with 2 days ago

SELECT histogram(responseTime, 20, 20) FROM MobileRequest since 3 days ago facet asnOwner

SELECT percentile(responseTime, 98) as '98 percentile (sec)', percentile(responseTime, 90) as '90 percentile (sec)',  percentile(responseTime, 50) as '50 percentile (sec)' from MobileRequest since 3 days ago

SELECT count(*)/uniqueCount(sessionId) from MobileRequest, MobileSession facet appName timeseries

SELECT count(*) FROM MobileRequestError where errorType = 'HTTPError' FACET requestUrl

SELECT count(*) FROM MobileRequestError where errorType = 'NetworkFailure' facet networkError

SELECT percentage(count(*), where errorType = 'NetworkFailure' OR errorType = 'HTTPError') as 'Error Rate %', count(*) as '# of Requests', filter(count(*), where errorType='NetworkFailure' OR errorType='HTTPError' as '# of Errors') FROM MobileRequestError, MobileRequest facet requestDomain

SELECT percentage(count(*), where errorType = 'NetworkFailure' OR errorType = 'HTTPError') as 'Error Rate %', count(*) as '# of Requests', filter(count(*), where errorType='NetworkFailure' OR errorType='HTTPError' as '# of Errors') FROM MobileRequestError, MobileRequest facet requestPath where requestPath = '{MY_API_PATH}'

SELECT filter(uniqueCount(MobileRequestError.uuid), WHERE errorType = 'HTTPError') / uniqueCount(MobileSession.uuid) * 100 as '% Users Impacted by Errors' FROM MobileRequestError, MobileSession COMPARE WITH 7 days AGO

SELECT count(*) FROM MobileRequestError FACET appVersion

SELECT count(*), latest(device), latest(carrier), latest(asnOwner), latest(countryCode) FROM MobileRequestError FACET deviceUuid  limit 100 SINCE 1 days ago

SELECT count(*) FROM MobileRequestError where errorType = 'HTTPError' FACET requestDomain timeseries

SELECT count(*) FROM MobileHandledException FACET appName SINCE 3 days ago

SELECT count(*) FROM MobileHandledException FACET exceptionLocation SINCE 3 days ago

SELECT count(*) FROM MobileHandledException FACET lastInteraction SINCE 3 days ago

SELECT count(*) FROM MobileHandledException FACET exceptionMessage SINCE 3 days ago

SELECT count(*) FROM MobileHandledException FACET exceptionLocationMethod SINCE 3 days ago

SELECT percentage(uniqueCount(sessionId), WHERE exceptionLocation IS NOT NULL) FROM MobileSession,MobileHandledException SINCE 3 days ago