Hi guys,

I am very new with Dell Kace and since my company sucks they wont get me training. lol. Hope you can help me out. Thanks in advance

I need to create a report that would provide department's name, computer name, and total computer count per department.

 

0 Comments   [ + ] Show Comments

Comments

  • This content is currently hidden from public view.
    Reason: Member is not approved yet
    For more information, visit our FAQ's.
  • This content is currently hidden from public view.
    Reason: Member is not approved yet
    For more information, visit our FAQ's.
Please log in to comment

Answers

0

How do you know the department names and relation to computer? Are you assigning a label to the machines?

 

Here is my setup:

Computers are in Active Directory OUs per department

LDAP labels are assigned to computers based on their department OU

These department labels are all in a label group called "Departments"

I then have a report that includes all of the labels from the Departments label group and the number of computers per label:
 
 SELECT DISTINCT(LABEL.NAME) AS DEPARTMENT,
COUNT(MACHINE.NAME) AS COUNT
FROM MACHINE  
LEFT JOIN MACHINE_LABEL_JT ON (MACHINE_LABEL_JT.MACHINE_ID = MACHINE.ID)  
LEFT JOIN LABEL ON (LABEL.ID = MACHINE_LABEL_JT.LABEL_ID  AND LABEL.TYPE <> 'hidden') 
LEFT JOIN LABEL_LABEL_JT ON (LABEL.ID = LABEL_LABEL_JT.CHILD_LABEL_ID AND LABEL_LABEL_JT.LABEL_ID = 258)
WHERE LABEL_LABEL_JT.LABEL_ID = 258
GROUP BY DEPARTMENT
ORDER BY DEPARTMENT
 
If you want to duplicate this report you will need to change the label ID for my departments label group (258) to the label ID that corresponds to your departments label group.
 
If you can't use the LDAP labels to get your department labels from AD then you'll need to find another way to label computers appropriately, hopefully you won't have to do that by hand.
Answered 09/11/2013 by: chucksteel
Red Belt

  • hi there chucksteel,

    Thank you for taking the time to answer my question. As much as I would like to use your script. I cant seem to find where to get the LABEL ID info. Yes, I have connected DellKace via LDAP, I just entered domaincontroller details and that's it.
    • If you login to the KBOX using the /adminui URL instead of /admin the label ID will be at the end of the URL when viewing it. Once you have the LDAP connection setup go to label management (Home, Labels) to setup the LDAP labels.
  • Hi there again,

    I just realised how much I do not know about Dell Kace.

    Q.
    How do you know the department names and relation to computer? Are you assigning a label to the machines?

    A.
    What we did was install the agent on computers, then created a smart label that if IP address is = to 192.168.0. Label would be Marketing Department.


    Do you have a guide that would help me configure this via LDAP?
    • I would recommend the reading the administrator guide (click Help in the Admin console). It's actually very helpful. Dell also provides the Kace Kontinuing Education videos which are great:
      http://www.kace.com/support/training/kke/archive?action=artikel&cat=11&id=1114&artlang=en
Please log in to comment
Answer this question or Comment on this question for clarity