Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

NPM 12 Data series with problems but working in 11.5.2

Thwacksters,

Hope you can help i have a SQL query custom chart that works just perfectly in NPM 11.5.2 but coming to NPM 12 and running the same custom chart its failing and asking me to specify a Data Series as below (this inst complaing in NPM 11.5.2)

The query:

This just returns every triggered alert 3 months ago and groups the values by day.

SELECT  DATEADD(dd, DATEDIFF(dd, 0, TimeStamp), 0) AS 'Time',COUNT(*) AS [triggered]FROM AlertHistoryView ahv with(nolock)WHERE EventTypeWord = 'triggered' AND (TimeStamp > DATEADD(Mm,-3,getdate()))group by  DATEADD(dd, DATEDIFF(dd, 0, TimeStamp), 0)

The problem is now if i try and re create my chart i get this dude..

Can anyone point me in the right direction for this i am completely happy with SQL but this data grouping is playing with me becase my grouping is done in the group by i guess :-/

Cheers

Find more posts tagged with

Accepted answers

mesverrum

I was able to get your original query working just by adding in a placeholder value to use in the group by/legend shows boxes

SELECT

DATEADD(dd, DATEDIFF(dd, 0, TimeStamp), 0) AS 'Time'

,COUNT(*) AS [triggered]

,'Count' as [Legend]

FROM AlertHistoryView ahv with(nolock)

WHERE EventTypeWord = 'triggered'

AND (TimeStamp > DATEADD(Mm,-3,getdate()))

group by DATEADD(dd, DATEDIFF(dd, 0, TimeStamp), 0)

All comments

mesverrum

I had the same problems with some of my custom charts when the upgrade rolled around. You need to add in a column to use for those values. In cases where I haven't had multiple rows I just created a dummy column.

See this example of one that I had to modify

select count(message) as [Alerts], convert(date,timestamp,111) as date, 'Total' as caption

FROM [dbo].[AlertHistory] ah

where eventtype=0

and datediff(dd,timestamp,getdate())<30

group by convert(date,timestamp,111)

order by date

Once I added the caption column and used it for those data grouping fields it worked.

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

i_like_eggs

HI Mate,

thanks for getting back but that still doesn't want to work, i put the dummy columns in and i get this: and when i select submit and preview i just get 'data is not available'

can you please screenshot how you have set the data grouping?

wish solarwinds wouldn't add this to custom charts its causing in consistency in reports for more advances reports

mesverrum

Mine works like this,

i_like_eggs

this should work what NPM version are you on? have you applied any hot fixes ?

can i also also ask in your settings did you need to change anything for example

thanks again dude