We are using Kbox since last 3 years , now we want to check that during this period how many computers have been replaced in the each branch. and how many New computes have been added. We have dynamic labels for each branch.

Please let me know if this is possible or not , If yes then I will appreciate a hint or idea to achieve this.

Thanking you
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
I've a similiar requirement so, after gillyspy's helpful advice (sorry it took so long for the penny to drop!) I'm using a slightly modified query that is in the KACE knowledge base re: duplicate machines;

select MACHINE.NAME AS SYSTEM_NAME,LAST_SYNC,IP,KUID,MAC,BIOS_SERIAL_NUMBER, CT FROM (MACHINE ,
( select COUNT(ID) CT, MACHINE.NAME FROM MACHINE GROUP BY MACHINE.NAME )M2 )
LEFT JOIN ASSET ON MAPPED_ID=MACHINE.ID
WHERE
M2.CT>1 and
MACHINE.NAME=M2.NAME
ORDER BY SYSTEM_NAME

To get the label info you'd have to do a join, my SQL foo is pretty nubbish so not sure how I'd do that if I wanted t , but you could use the IP address to determine the branch, or machine name, if you use specific machine names per branch.

knowledge base article is @ http://www.kace.com/support/kb/index.php?action=artikel&cat=3&id=673&artlang=en
Answered 10/18/2011 by: nbs
Orange Belt

Please log in to comment
0
Thank you, but i dont understand how it will provide me informaiton about the computers replaced in different branches over the time. I have checked, it is listing the duplicate machines.
Answered 10/19/2011 by: afzal
Fourth Degree Green Belt

Please log in to comment
0
Afzal, can you define your questions in terms of things that you might see in the kbox? For example, when you say "computers that have been replaced?" how do you visually identify a computer that has been retired and replaced by another?

How do you define a new computer versus an old computer ? Is it by date?
Answered 10/23/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity