/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Report for list of services after patching

02/25/2015 1030 views
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.
Answer Summary:
0 Comments   [ + ] Show comments

Comments

  • This content is currently hidden from public view.
    Reason: Removed by member request For more information, visit our FAQ's.

Answer Chosen by the Author

0
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
Answered 02/25/2015 by: Hobbsy
Red Belt

  • 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.

All Answers

This content is currently hidden from public view.
Reason: Removed by member request For more information, visit our FAQ's.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ