K1000 Report w/Department Name, Computer Name and Computer Count
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
Answers (1)
Please log in to answer
Posted by:
chucksteel
11 years ago
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.
Comments:
-
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. - sphinx_17 11 years ago-
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. - chucksteel 11 years ago
-
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? - sphinx_17 11 years ago-
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 - chucksteel 11 years ago
