Home Analytics

Analytics Archiver beating SQL Novice - advice please

Sean_TerrySean_Terry Customer Advanced IT Monkey ✭✭✭

Appreciate its early days with the archiver. Just looking at what is possible whilst the global search doesn't search analytics.

I'm not entirely sure if this is possible yet. In some ways I prefer OData because it adds a search box for me but I wondered if there was a way to replicate this...

...Using SQL. This is the very basic SQL query I have

/****** Script for SelectTopNRows command from SSMS ******/

SELECT TOP (1000) [WorkItemId]

   ,[Title]

   ,[WorkItemId]

   ,[Status]

   ,[Priority]

   ,[AssignedUser]

   ,[CreatedByUser]

   ,[AffectedUser]

   ,[Category]

   ,[Tier]

   ,[LastModified]

   ,[ResolvedDate]

   ,[ClosedDate]

 FROM [CiresonAnalytics].[dbo].[SM_WorkItem_ServiceRequest]


I assume that enable Chart Filtering might be what I'm after? If so, not entirely sure how I can change the query to either search a specific workitem id or tickets for a specific date span.

Basically looking to see if I can have dedicated page.

Best Answers

Answers

Sign In or Register to comment.