Report for list of services after patching
Hello, I'm new in K1000. I need you help / advise on how to grab the following reports for server patching. - List of services before patching - List of services after patching - List of services that did not start after patching with comparison from before and after patching. Thanks in advance for your help.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
Hobbsy
9 years ago
Top Answer
Unfortunately I think you may struggle to get what you require, certainly from the standard kbox functionality. My guess from your question is that you are trying to identify services that fail to restart after patching has occurred?
Services in general are not something that can be easily (via the wizards) reported on. You will however find the detail in the NTSERVICE table, which then relates the service to the machine on which it is running through the MACHINE_NTSERVICE_JT joining table, but you may have already discovered that notifications also do not allow the ability to look at services.
The only suggestion I could make would be to ask, is it a specific service, on specific machines that you need to check are running after patching has occurred?
In which case you will need to write a custom report that says if the service is not shown as running on your required machines, that will give you an exception report.
You can then schedule the report to run after patching has occurred and use the tick box "send only if results are present". That way if you get an emailed report you know you have an issue.
Hopefully that makes sense
Comments:
-
Hi Hobbsy,
Thanks for your reply.
This part is what i badly need.
=============================
In which case you will need to write a custom report that says if the service is not shown as running on your required machines, that will give you an exception report.
You can then schedule the report to run after patching has occurred and use the tick box "send only if results are present". That way if you get an emailed report you know you have an issue.
=========================
I created a custom report that will show services
with "SERVICE_AUTO_START and status "SERVICE_STOPPED" . Below is the sql query i found.
SELECT M.NAME AS 'System',
NS.DISPLAY_NAME AS 'Service Display Name',
NS.NAME AS 'Service Name',
NS.STARTUP_TYPE AS 'Startup Type',
NS.STATUS AS 'Service Status'
FROM MACHINE M
LEFT JOIN MACHINE_NTSERVICE_JT MNJT ON M.ID = MNJT.MACHINE_ID
LEFT JOIN NTSERVICE NS ON MNJT.NTSERVICE_ID = NS.ID
WHERE M.OS_NAME LIKE '%server%'
AND NS.STARTUP_TYPE LIKE 'SERVICE_AUTO_START'
AND NS.STATUS LIKE 'SERVICE_STOPPED'
In the Report schedule, i can see the "Dont Send Empty Report" but still need to indicate schedule.
Kindly advise how i can make it generate and send automatically after the server patching.
Thanks in advance. - lalako88 9 years ago