@@MSSQLDBATechSupport Thanks for your quick response Harsha Just getting below error while connecting to different server Error : login is from untrusted domain and cannot be used with integrated authentication
This error is very well know issue and documented as well from Microsoft and other third party blogs as well. This error occurs when we don't have trust relationship between domains and you account is not having sufficient privileges and also having issues with you account SPNs as well.
I understand your requirement.... one thing we need to think about what are T sql queries that we are using in health check should support... then only it can work other wise we need to alter the code. I have tested in MS SQL 2019,2022 versions... and i hope it will work from 2016 and 2017 too
Bro we had p1 incident recnt though we have this report monitoring daily . Issue is Transaction log backup reached Max size then log backup wss stopped then apps is down though we have enough information on this report . 1) in the db status section we have colour code for db online or offline .at same section we have "last database backup run" ans "last log backup run" is there but dont have color code . I suggeat to add the condotion of output checks "sysdate or sysdate-1" if not macthes then red colour highlight on that column 2) in the "Db job status " column we have colour high light only on "diaable" or "enabled" if you see the last column "Failed" or "success" dont have . Please incide it Kindly consider my request and help to inclide this to acoid overlooking by lole we do . Awaiting for your updation
Noted!... you can also do the same by observing the logic what is there for db online or offline and apply the same where ever you want.it will take time to do from my end. I had a thought instead of editing the code.showing the health check logic how we need to built then at would helpful for everyone to create there own health check report with the standard checks that there company following.
Hey
Can you help us how I can get the multiple server health check report on mail ...
Hi Nehal,
I made a video on the same
ruclips.net/video/4Gj2KOc2cnI/видео.html
Scripts are commented and pinned as well under that video.
@@MSSQLDBATechSupport Thanks for your quick response Harsha
Just getting below error while connecting to different server Error : login is from untrusted domain and cannot be used with integrated authentication
This error is very well know issue and documented as well from Microsoft and other third party blogs as well.
This error occurs when we don't have trust relationship between domains and you account is not having sufficient privileges and also having issues
with you account SPNs as well.
Hi sir, I need report from different various servers IP’s . Can I get like that from this report?
I understand your requirement.... one thing we need to think about what are T sql queries that we are using in health check should support... then only it can work other wise we need to alter the code.
I have tested in MS SQL 2019,2022 versions... and i hope it will work from 2016 and 2017 too
Bro we had p1 incident recnt though we have this report monitoring daily . Issue is Transaction log backup reached Max size then log backup wss stopped then apps is down
though we have enough information on this report .
1) in the db status section we have colour code for db online or offline .at same section we have "last database backup run" ans "last log backup run" is there but dont have color code . I suggeat to add the condotion of output checks "sysdate or sysdate-1" if not macthes then red colour highlight on that column
2) in the "Db job status " column we have colour high light only on "diaable" or "enabled" if you see the last column "Failed" or "success" dont have . Please incide it
Kindly consider my request and help to inclide this to acoid overlooking by lole we do . Awaiting for your updation
Noted!... you can also do the same by observing the logic what is there for db online or offline and apply the same where ever you want.it will take time to do from my end.
I had a thought instead of editing the code.showing the health check logic
how we need to built then at would helpful for everyone to create there own health check report with the standard checks that there company following.
could you please send me this script
Hello All
Please watch video and follow accordingly
ruclips.net/video/PPHFFaWbSiE/видео.htmlsi=zTWFZkxQsjubsJ-s