Data Model

[Volker]

Hi All.

I currently investigate a lot of time into the data model in detail, for producing reports/exports over all kind of servers (real and vm [esx|linux|win]) to collect the same items (from sense) or a default value and place them in the right place.

So I must a have a detailed view into the data model....

For example: table tblLinuxSystem: where do I find (table) the matching items (UUID and Serial) for Win systems, if the system is a VM?

Or more general. Where do I found a description about the data model?

Thx for help
Volker

[Bart_E]

More information on how to access the Lansweeper database dictionary which list information on every table can be found in this topic.

[Mister_Nobody · Accepted solution]

http(s)://ls/DataDictionary/Default.html

[Volker]

Thanks Nick.

You close this item - but one point is still open:

"Where do I found a description about the data model?"

Volker

[Nick_VDB]

The data from each table is in most cases retrieved from a specific WMI class. In this case the serial number is gathered from the Win32_BIOS WMI class. As more than one field of information is gathered from that WMI class a table was made to store all the information from a single WMI class. This is the process that is followed by most of the SQL tables in Lansweeper.

[Volker]

Well, I found it, but

tblBIOS.SerialNumber

...it seems not the best place to use for me. I think a tblWinSystem table with the same content (by sense) like the tblLinuxSystem should be the way for Win VM Systems.

It's for the wishlist.