paddie
commented
11 years ago This is two-fold. The current script that gathers information on each mac is a simple script that sends POST's the information to the MINI in json format. We simply re-write the script to POST to another path, and have our Django server parse the json format into a model. We don't need to do any conversion of the current MongoDB database.
I see you've done some of the initial database design on workstations in ADP-Inventory / inventoryapp / tracker / models.py. I don't know if you've modelled this on how our MDM looks, but I suggest we give the WorkstationDevice a bit more meat:
Example:
class WorkstationDevice(Device):
os = models.CharField(max_length=100)
dns_name = models.CharField(max_length=100) # should be hostnameShould have a bit more information specific to the machine, something like hostname, OS version etc. Just to minimize joins when retrieving from the database and wanting all the information of the device at the same time:
class WorkstationDevice(Device):
uuid = models.CharField(max_length=100, primary_key=True) # max_length(OSX_serial,WIN_serial)
hostname = models.CharField(max_length=100)
user = models.ForeignKey(userModel) # maybe
added_date = models.DateTimeField(auto_now_add = True)
os = models.CharField( max_length=50 ) # OSX10.8 / WIN8 / WIN7
build = models.CharField( max_length=50 ) # version_id / build_id
device_model = models.CharField(max_length=50)
ram = models.IntegerField() # Could be models.CharField
cpu = models.CharField(max_length=50) # "core 2 duo, 2.4 GHz"
jensraaby
@paddie