The most important field in this table are:
NAME represents the name of the service
STARTUP_TYPE represents the service startup type (if starts automatically, manually or disabled).
the most common status types are:SERVICE_AUTO_START
STATUS represents the current status of the service. The most common values are:SERVICE_RUNNING
- Under Reporting click on Notifications
- Click on Choose Action -> New -> Device Notification
- Enter the title, the recipients (at least one) and the frequency and press Create
- Click on the name of the notification that you just created and, as editor option, select : "To edit the Notification using this editor, Click Here"
- Remove all the SQL code and replace it with the following one:
SELECT MACHINE.NAME AS SYSTEM_NAME,
MACHINE.ID AS TOPIC_ID
LEFT JOIN ORG1.MACHINE_NTSERVICE_JT
ON ORG1.MACHINE.ID = ORG1.MACHINE_NTSERVICE_JT.MACHINE_ID
LEFT JOIN NTSERVICE
ON ORG1.MACHINE_NTSERVICE_JT.NTSERVICE_ID = NTSERVICE.ID
WHERE NTSERVICE.STATUS = 'SERVICE_STOPPED'
AND NTSERVICE.NAME IN ('DHCPServer', 'DNS')
Changing the where clause and modifying the IN clause adding other services you can keep an eye on different situations.
Some important points to remember:
- It is recommended that you test your SQL code before to sue in a notification or in a report: you can easily connect to the internal database of the K1000 using TOAD for MySql or the native tools of MySQL
- Remember that the data is collected thought the Inventory and so it is not realtime: by default the inventory is sent to the K1000 every 2 hours. So do not exaggerate with the frequency of the notification
- the field NAME of the table NTSTATUS contains the real name of the service and not the descriptive one. To find out the real name of a service open the services.msc snap-in and double click on the service
The real name of the service in the one stated in the General tab, Service name