I've been tasked by my manager to report with Kaseya where service packs are missing so we can start change requests with clients and go through a process of updating them.
My problem is I've not really found Kaseya to be useful at reporting SQL or Exchange Service Pack levels, I found a really neat power shell script for Exchange that also conveniently does Windows SP level too and am working on having that automated and reporting to correct people but I've had no real luck in an easy decent way of determining what SQL service pack levels are.
How are other people reporting on service pack levels with Kaseya? It'd be nice if the product did this out of the box but I'm missing where it does this if it does.
Can't you quickly run something like this with a report?
I think you can create a report that contains Computer name/Product name/License Version/Install date
With some smart filtering (only show exchange or SQL) a report should be made within a matter of minutes.
All you then have to do is compare your versions with the most current versions with most recent SP.
For Exchange: social.technet.microsoft.com/.../exchange-server-and-update-rollups-builds-numbers.aspx
For SQL: social.technet.microsoft.com/.../783.sql-server-versions.aspx
If the information is found by kaseya, you should be able to create a report for that :).
Try This .
1) Create new custom field in Audit tab called “ SQL version “
2) Make Sure Power Execution Policy Unrestricted in end point if you can add below commands in attached PS file
Set-ExecutionPolicy -Scope Process -ExecutionPolicy RemoteSigned
3) import attached Script and PS1 file ..execute
NOTES : Tested with 2008 OS not sure about 2003
KB : support.microsoft.com/default.aspx
SQLVer1.ps1Procedure SQL version information.xml
same steps for ExchangeProcedure Exchange Verions.xmlExVerion.ps1