You can find an explanation on how to get to the database documentation here: https://www.lansweeper.com/Forum/yaf_postsm38296_Lansweeper-database-dictionary.aspx#post38296
The documentation lists most tables and their content and should help you find any information stored in Lansweeper.
As for the information you're looking for. Most if it is in the main table tblassets. Video card information is stored in tblVideoController and sound card information is stored in tblSoundDevice