Filter within a widget

Hi,

I have a custom datasource for some specific SQL metrics. Presently the collection script is explicitly excluding system databases (master, model, tempdb etc.) with a WHERE clause.

I'd like to re-include these system databases but have them on their own widget (with the current widget excluding them). Only way I can think of is a duplicate datasource that simply reverses the WHERE clause, but this seems way overkill.

Can we filter per-widget?

ldoodle

Posted 1 year ago·Last reply 1 year ago

3 comments

jake_nahm

·1 year ago

Hi ldoodle, My name is Jake Nahm, and I am part of LogicMonitor's Product team. This seems like a really interesting use case for a feature that is currently in development. If you are open, I would be happy to talk through the details live.

ldoodle

OP1 year ago

WHERE
	[db].[name] NOT IN
	(
		 'master'
		,'model'
		,'tempdb'
		,'msdb'
	)

and

WHERE
	[db].[name] IN
	(
		 'master'
		,'model'
		,'tempdb'
		,'msdb'
	)

Lewis_Beard

·1 year ago

The only things I can think of would be:

Custom Datasource with the Inverse Query (as you mentioned)
Include all databases in your query and instance name, but give an instance name prefix of s_ or n_ to represent system or non-system and use wild cards in your widget, such as s_* on one widget and n_* on the other
Include all databases in your query and instance name, but make sure the database name terminates the instance name. Use globs to include or exclude, example: *_(master|model|tempdb|msdb) ... though in testing globs generically to make sure it worked, I had a hard time making the inverse work

Ideally, one day LM would support both resource and instance property filters on all widgets. If they ever had that, then we could do these kinds of things cleanly. In this future hypothetical, you could put an auto property source in the code on your instances, make the datasource multi-instanced, make instance groupings based on the instance property, AND use the instance property in the widget.

But I dont think they are there quite yet.

1	SUYASH GAIKWAD
2	PJ Pankaj Jain
3	KT Kyle Taylor
4	KV karthikeyan VG
5	ME Mir Ehtesham Ali
6	SN Sangeetha Nataraj