Blog Posts tagged with Kace K1000 Management Appliance 6

Ask a question

KACE: Trouble-Shooting K1000 Agent Provisioning for Windows 7 and Windows 8

1. Find out what network profile / location you are currently using, Home, Work, Public, or Domain (Control Panel -> Network and Sharing Center):


 
2. Open “Change sharing options for different network profiles” (Control Panel à Network and Sharing Center -> Change advanced sharing settings): 

 

3. Click the down arrow for the profile / location you are currently on: 


 

4. Go to “Network discovery”, “File and printer sharing”, & “Public folder sharing” options and select ‘Turn On…’ for all 3 then click “Save changes”.
5. Go to the Windows (start) button and enter “GPEdit.msc” in the “Search programs and files” box.
6. Select the following trees: Computer Configuration -> Windows Settings à Security Settings -> Local Policies à Security Options. Then find “User Account Control: Run all administrators in Admin Approval Mode”. 


 

7. Double click this option and set it to “Disabled”: 


 
8. You MUST reboot the system at this time! Then try to provision the KACE agent again. If it fails please let us know of any errors that come up.

Be the first to comment

Remove / Purge Kace LDAP Users

Here is simple piece of code to purge kace users not associated with tickets. This will maintain the historical ticket data and cleanup superfluous kace user accounts brought in from LDAP that aren't or are no longer being used. This was run as an adhoc ticket rule to cleanup the entries. I don't recommend letting it run automatically as it is a deletion statement and the way its written its *very* inefficient. It took about an hour to process about 5,000 users in our instance.

Before you even consider this, please run the daily backup task of the kbox. THEN pull the backups via FTP. Do NOT rely on downloading the backups via the web browser. I highly recommend scripting a regular backup pull via ftp. Once you have the newest possible backup files, make a copy of them and then consider if you would like to try the cleanup. 

Use at your own risk. 

select statement:

SELECT USER.*

 from USER

where (not exists(select 1 from HD_TICKET
where HD_TICKET.SUBMITTER_ID = USER.ID )) 
AND USER.USER_NAME != 'Admin'
AND USER.USER_NAME != 'R1' 

Update statement:

DELETE
USER.*

from USER

where (not exists(select 1 from HD_TICKET where HD_TICKET.SUBMITTER_ID = USER.ID )) 
AND USER.USER_NAME != 'Admin'
AND USER.USER_NAME != 'R1' 

After this runs, you can reimport LDAP users with your typical settings/schedule and will have effectively refreshed to the latest users in ldap at that time. 

To only import active LDAP entries, consider the following filter:

(&(mail=KBOX_USER)(sAMAccountType=805306368)(!(userAccountControl=514)))
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

Custom Inventory Rule Smart Label on the Dell Kace K1000

How to make a label to see all of your Custom Inventory Rules (CIR)


When you start making more and more rules, it's hard to remember which ones you have. 
You can create a smart label that includes all of them. 

  1. From the Admin portal, click Inventory Software
  2. Click Smart Label
  3. Without entering any criteria for the search, give the smart label a name and click Save. 
    1. I named my "S - Custom Inventory Rules" but you can name it whatever you want. 
  4. Go to Home Label Management > Smart Labels > Click the Smart Label you created
  5. Click the Edit SQL button
  6. Replace the text for the SQL query with the below then click the Save button:

SELECT ID FROM SOFTWARE
WHERE (SOFTWARE.IS_MANUAL='1')
AND ((SOFTWARE.INVENTORY_RULE != ''))

Now when you go to Software inventory and click View By > Label, and select the label you created, you will see all of you CIR's. 

LJreFu.png
Be the first to comment

Dell C1765nfw Color MFP

The max levels for all colors is 700, so the OID for Black Toner works for all of them. 

 

I believe the Marker Life count is the amount of printed pages total

 

Object Identified (OID)

Property

.1.3.6.1.2.1.43.11.1.1.9.1.4

Black Cartridge Supply Level

.1.3.6.1.2.1.43.11.1.1.9.1.3

Yellow Cartridge Supply Level

.1.3.6.1.2.1.43.11.1.1.9.1.2

Magenta Cartridge Supply Level

.1.3.6.1.2.1.43.11.1.1.9.1.1

Cyan Cartridge Supply Level

.1.3.6.1.2.1.43.11.1.1.8.1.4

Black Cartridge Max Capacity

.1.3.6.1.2.1.1.6.0

Location

.1.3.6.1.2.1.1.1.0

System Model

.1.3.6.1.2.1.43.10.2.1.4.1.1

Marker Life Count

 

 

 

Be the first to comment
Showing 1 - 5 of 9 results

Top Contributors

Talk About Adobe