/build/static/layout/Breadcrumb_cap_w.png

SQL Query for Decommissioned Computers

I will start off by admitting I know very little about SQL databasing but have been tasked with creating a query that will give a listing of machines that have been decomissioned.  Is there someone that has done something similar or can at least point me in the right direction?  I do have the MySQL workbench setup and connected to the database though not sure quite how to use it and it is a little overwhelming to a SQL novice.  Thank you.

 

 


0 Comments   [ + ] Show comments

Answers (2)

Posted by: bkelly 11 years ago
Red Belt
1

What kind of database are you attached to, an inventory or asset management system?


Comments:
  • I completely spaced adding that. I am attached to a MySQL database in the K1000 appliance. - rogeld 11 years ago
Posted by: chucksteel 11 years ago
Red Belt
0

I think the biggest issue is how you determine whether a machine is decommissioned. Do your technicians do anything in the inventory to indicate that a machine has been decommissioned? If not, then the only thing you might be able to work with is the last time the machine updated its inventory. 


Comments:
  • When a machine is decommissioned, the date is put into KACE in the decommission field. We just have a lot of field agents whose machines don't always check in so if for some reason that field isn't filled in...then I think there are bigger problems. Will see if I can work with that some more but it will take a lot of sifting through. Thanks for the input though, gives me something to consider! - rogeld 11 years ago
  • If you have a decommissioned field, then it should be easy to create a report that only shows machines where decommissioned has a date. You should be able to do that with the report wizard. - chucksteel 11 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Link

Related Links

Post

Related Posts

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ