QOS not publishing for custom query sqlserver probe

[Sid]

I cant get QOS for custom checkpoint in sqlserver probe

------------------------------
HCL Technologies
------------------------------

Attachment(s)

db29_S_QOS_data.xlsx   25.87 MB 1 version

[Sid]

PRD also doent have those custom checkpoint parameters

queries being used are 
1-
SELECT name, state from
sys.databases
where sys.databases.state<>6


2-
SELECT database_name as db_name,
ISNULL(ABS(DATEDIFF(MINUTE, GetDate(), MAX(backup_finish_date))), -1) as minutes ,
ISNULL(ABS(DATEDIFF(day, GetDate(),
MAX(backup_finish_date))), -1) as days_sincebackup ,sys.databases.state
from msdb..backupset
inner join sys.databases on sys.databases.name=msdb..backupset.database_name
where sys.databases.state<>6
group by database_name ,sys.databases.state

------------------------------
HCL Technologies
------------------------------

[Sid]

only checkdb_alive is being published 

------------------------------
HCL Technologies
------------------------------

[David Michel]

It looks like the query is selecting the database name, and qos metrics have to be a number.

------------------------------
Support Engineer
Broadcom
------------------------------

[Sid]

Hi David,
I am using below query- 

SELECT database_name as db_name,
ISNULL(ABS(DATEDIFF(MINUTE, GetDate(), MAX(backup_finish_date))), -1) as minutes ,
ISNULL(ABS(DATEDIFF(day, GetDate(),
MAX(backup_finish_date))), -1) as days_sincebackup ,sys.databases.state
from msdb..backupset
inner join sys.databases on sys.databases.name=msdb..backupset.database_name
where sys.databases.state<>6
group by database_name ,sys.databases.state

would it work if i change it to 

SELECT sys.databases.state, database_name as db_name,
ISNULL(ABS(DATEDIFF(MINUTE, GetDate(), MAX(backup_finish_date))), -1) as minutes ,
ISNULL(ABS(DATEDIFF(day, GetDate(),
MAX(backup_finish_date))), -1) as days_sincebackup
from msdb..backupset
inner join sys.databases on sys.databases.name=msdb..backupset.database_name
where sys.databases.state<>6
group by database_name ,sys.databases.state

------------------------------
HCL Technologies
------------------------------

[Sid]

while i am selecting state and name both in 1st query 

SELECT name, state from
sys.databases
where sys.databases.state<>6 and the state is numeric ,


------------------------------
HCL Technologies
------------------------------