Blog Posts tagged with Kace K1000 Express

Ask a question

K1000 Express Video Tutorials

This post contains a series of tutorial videos that walk through the installation, configuration and usage of the K1000 Express Management Appliance.

The Dell KACE K1000 Systems Management Appliance Express (K1000 Express) is a free, introductory version of the award winning Dell KACE K1000 Systems Management Appliance. The K1000 Express is an inventory-focused software solution designed for systems that run Microsoft Windows®, including laptops, desktops, servers and tablets.

Installing K1000 Express: VMware ESX Installation

This training video explains how to install the K1000 Express virtual appliance on a VMware ESX or ESXi Server.



Installing K1000 Express: Microsoft Hyper-V Installation

This training video explains how to install the K1000 Express virtual appliance on a Microsoft Hyper-V Server.



Installing K1000 Express: Initial Configuration

This training video explains how to perform the initial configuration of the K1000 Express virtual appliance including the initial login to the web interface, applying the license key, and configuration of network settings.  




K1000 Express: Agent Provisioning

This training video explains the various options for provisioning agents with the K1000 Express including some best practice recommendations.



K1000 Express: Inventory

This training video provides an overview of the hardware and software inventory features of the K1000 Express.



K1000 Express: Dell System Updates

This training video explains how to configure the Dell Update subscription settings and provides an overview of the Dell System Update features of the K1000 Express.




K1000 Express: Dashboard

This training video provides an overview of the Dashboard features of the K1000 Express.



K1000 Express: Reporting

This training video provides an overview of the Reporting features of the K1000 Express.




K1000 Express: Support Options

This training video provides an overview of the support options available for the K1000 Express. 


Be the first to comment

How to create a K1000 notification to monitor the status of your Windows services

If you are concerned that some of the Windows services that should normally run on all your computers are not running and you want to keep an eye on these kind of situations you can the following custom K1000 Notifications to monitor them.

In the current version of K1000 is not possible to creare this kind of notification using the wizard but we need to use a custom SQL to achieve what we need.
A bit of background before to put the hands on the SQL code:
The following SQL uses many different tables and the most important to consider are:

MACHINE        contains all the machines that are in our inventory
NTSERVICE     contains information about the services discovered on the machine, their name, version, status and other details about them.
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
SERVICE_DEMAND_START
SERVICE_DISABLED

STATUS        represents the current status of the service. The most common values are:
    SERVICE_RUNNING
    SERVICE_STOPPED
MACHINE_NTSERVICE_JT It is used to link the MACHINE table with the NTSERVICE table

In the following example we want to monitor the DHCP Server (DHCPServer) and the DNS server status and send an email notification to the administrator when one of these two services is stopped.
First of all we need to create our notification using the wizard:
  1. Under Reporting click on Notifications
  2. Click on Choose Action -> New -> Device Notification
  3. Enter the title, the recipients (at least one) and the frequency and press Create
  4. 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"
  5. Remove all the SQL code and replace it with the following one:

SELECT MACHINE.NAME AS SYSTEM_NAME,
       SYSTEM_DESCRIPTION,
       MACHINE.IP,
       MACHINE.MAC,
       MACHINE.ID AS TOPIC_ID
  FROM MACHINE
       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:

  1. 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
  2. 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
  3. 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
    14yI3l.png

Be the first to comment

K1000 report: Working Hours per week per person

This report is made to know how many hours has worked each one on the current week, so it is personally. there is one report for everyone in support department. it is easy, you just have to change de USER.ID.
This report calculate the hours worked from Monday to Friday of this week.

select U.FULL_NAME AS ATENDENTE, HD_QUEUE.NAME AS FILA,

SUM(format(time_to_sec(timediff(HD_WORK.STOP,HD_WORK.START))/ 3600.0 + HD_WORK.ADJUSTMENT_HOURS,2)) AS 'Horas trabalhadas',
curdate() as Semana,
date_sub(curdate(),INTERVAL (dayofweek(curdate())- 2) day) as Segunda,
date_add(date_sub(curdate(),INTERVAL (dayofweek(curdate())- 2) day), INTERVAL 4 day) as Sexta

from HD_TICKET

LEFT JOIN USER U ON (HD_TICKET.OWNER_ID = U.ID)
left join HD_WORK ON (HD_TICKET.ID = HD_WORK.HD_TICKET_ID)
left join HD_QUEUE ON (HD_TICKET.HD_QUEUE_ID = HD_QUEUE.ID),
    
 (select date_sub(curdate(),INTERVAL (dayofweek(curdate())- 2) day) as LUNES,
       date_add(date_sub(curdate(),INTERVAL (dayofweek(curdate())- 2) day), INTERVAL 4 day) as VIERNES FROM DUAL) H
WHERE U.ID = 29 and
HD_TICKET.OWNER_ID = U.ID and
HD_TICKET.ID = HD_WORK.HD_TICKET_ID and
HD_TICKET.MODIFIED between H.LUNES and H.VIERNES 

GROUP BY ATENDENTE
Be the first to comment

Easier Goods-In entry of any Asset Type

WO3mOv.jpegThe BarKode solution for KACE has a great track record for enabling the Asset management life-cycle within customers K1000. The ability to easily create, update and manage Asset records means that working practices or processes can now be documented and followed, quickly and simply, with the data associated captured and recorded within the K1000 Asset database.

For some time now customers have been asking if they are able to "Doublescan" data to enter it into KACE. This functionality could be used for things like scanning in preset location codes, but more importantly, for assets that are not agent managed this is a great way to get data entered without the techs thumbs getting in the way! 

For example, with BarKode you now have the ability to create an Asset Type of iPhone, to assign an Asset number to the device, but then potentially to scan the IMEI number and Serial number straight from the iphone box into the asset record using the BarKode UI. 

Having this functionality would mean that all types of Assets with barcode serial numbers or product codes can have this data entered at the point of goods receipt, providing a much more comprehensive and efficient goods in process.

Any field that is a text field can be double scanned and on the BarKode UI shows an arrow with the text "Value" on the left hand side of the field, as in the following image:



Dragging the field to the left within the UI will then expose the Double scan button, clicking on the button will start the camera scan functionality ready to scan the value into the Asset record


















The latest release of BarKode for Dell KACE, available on the appstore or Playstore now includes Doublescan  functionality. 

To see how the functionality will further enhance and simplify Asset entry and management in your KACE K1000 visit the following Youtube link


For more information talk to your Dell rep, Quest rep or email Sales@IndigoMountain.co.uk to set up a short demo
Be the first to comment
Showing 1 - 4 of 4 results

Top Contributors

Talk About appdeploy-tips