How many computers replaced in Branch
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
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
Answers (3)
Please log in to answer
Posted by:
nbs
12 years ago
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
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
Posted by:
afzal
12 years ago
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.
Posted by:
GillySpy
12 years ago
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?
How do you define a new computer versus an old computer ? Is it by date?
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.