Database Query Monitor: different issues
Hi
I've got AM 9 Build No: 9300
I try to apply some query monitors to a MSSQL DB and I face few problems doing it:
1. Login & password:
Why login and password are not stored after a monitor is created? Security thing?
Using domain authentication in the form: domainuame, when i try to modify my query, the content of username changes to domainusername ( disappears)
2. Primary Key:
Why do I get this warning even though I've selected one?
Warning: Unable to find the primay key for usercounts. Please use the "Primary Keys" option in that table to select a primary key and to access the query output
It prevents me from saving my monitor correctly!
3. Box header name:
Why the header name of a box where query output is being shown becomes a name of a word standing after the 'from'-word of my query?
Example: select SUBSTRING(DATA, 1, 10) AS DATA, SUBSTRING(DATA, 11, 6) AS TIME, [# Active e-Work users] from (select top 24 convert(varchar(16),date,121) AS "DATA", sum(counts) AS "# Active e-Work users" from dbo.usercounts group by date order by date desc) x
Header name: (select
Can I change it somehow?
4. Polling interval:
I can set up polling intervals only by giving # minutes but I'd like that it refreshes ex. at 12:01, 13:01, 14:01 and so on. The only way to this is to save the monitor for example at 12:01 with polling interval set up to 60 minutes. But after that any change to the monitor has to be apllied at XX:01, otherwise it's f*** up.
Any suggestions ?
I've got AM 9 Build No: 9300
I try to apply some query monitors to a MSSQL DB and I face few problems doing it:
1. Login & password:
Why login and password are not stored after a monitor is created? Security thing?
Using domain authentication in the form: domainuame, when i try to modify my query, the content of username changes to domainusername ( disappears)
2. Primary Key:
Why do I get this warning even though I've selected one?
Warning: Unable to find the primay key for usercounts. Please use the "Primary Keys" option in that table to select a primary key and to access the query output
It prevents me from saving my monitor correctly!
3. Box header name:
Why the header name of a box where query output is being shown becomes a name of a word standing after the 'from'-word of my query?
Example: select SUBSTRING(DATA, 1, 10) AS DATA, SUBSTRING(DATA, 11, 6) AS TIME, [# Active e-Work users] from (select top 24 convert(varchar(16),date,121) AS "DATA", sum(counts) AS "# Active e-Work users" from dbo.usercounts group by date order by date desc) x
Header name: (select
Can I change it somehow?
4. Polling interval:
I can set up polling intervals only by giving # minutes but I'd like that it refreshes ex. at 12:01, 13:01, 14:01 and so on. The only way to this is to save the monitor for example at 12:01 with polling interval set up to 60 minutes. But after that any change to the monitor has to be apllied at XX:01, otherwise it's f*** up.
Any suggestions ?