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.
Answers (2)
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
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