
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-06-2016 12:42 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2016 12:29 PM
http(s)://ls/DataDictionary/Default.html
5 REPLIES 5

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-19-2016 01:39 PM
More information on how to access the Lansweeper database dictionary which list information on every table can be found in this topic.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2016 12:29 PM
http(s)://ls/DataDictionary/Default.html

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2016 10:07 AM
Thanks Nick.
You close this item - but one point is still open:
"Where do I found a description about the data model?"
Volker
You close this item - but one point is still open:
"Where do I found a description about the data model?"
Volker

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-11-2016 09:35 AM
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.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-06-2016 02:54 PM
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.
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.
