Can Python Do This? Asset Management

[Larz60+]

Goals:

• allow user to input assets into sqlite database
  look at using sqlite with SQLAlchemy, It will make your life easier with models.
  plain sqlite will work as well, just easier to maintain with SQLalchemy
  
• assets should have the attributes of asset_type,asset_id,serial_number,hostname,ip_addr,location,os_version and confirmation for new addition
  look at other systems, decide what tables you need and the fields in them, then build routines to maintain each.
  
• asset should be able to be removed with one click and confirmation
  easy python task
  
• would like to ping asset with 1-click box beside asset to see if asset is online
  easy python task
  
• would like to use the rdp protocol to remote into asset
  there are many packages to help with this. see: https://pypi.org/search/?q=rdp
  
• should have a easy to view dashboard which can be accessed via web-gui. This would be able to import/export existing assets from a csv file into database
  My choice would be wxpython
  The best way to sample what's availaable in to install wxpython [inline]pip install wxpython[inline]
  Then download demo code here: https://github.com/wxWidgets/Phoenix/
  run demo with python demo.py run from wxpython phoenix source directory
  PyQt5 is probably the best option, but may have to pay fees if you ever decide to make it a paid for product