This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Community FAQ
Register | Log In
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- Reports & Analytics
- Re: Query Server Type and virtual / physical
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-03-2011 02:12 PM
Hi All 🙂
Was wondering if anyone has a query to give the following information:
Server type - Make Model IP Address
Physical / Virtual - If virtual specify host server by name
Would be very much appreciated
Many thanks
Jonny
Was wondering if anyone has a query to give the following information:
Server type - Make Model IP Address
Physical / Virtual - If virtual specify host server by name
Would be very much appreciated
Many thanks
Jonny
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-03-2011 05:55 PM
Basic report that shows vendor, model and IP address for server-type machines:
Your best bet to distinguish physical from virtual machines is to look at tblComputerSystemProduct.Vendor and filter this field.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name, tblComputers.LastknownIP
From tblComputers Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Domainrole > 1
Order By tblComputers.ComputerUnique
Your best bet to distinguish physical from virtual machines is to look at tblComputerSystemProduct.Vendor and filter this field.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-03-2011 05:55 PM
Basic report that shows vendor, model and IP address for server-type machines:
Your best bet to distinguish physical from virtual machines is to look at tblComputerSystemProduct.Vendor and filter this field.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name, tblComputers.LastknownIP
From tblComputers Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Domainrole > 1
Order By tblComputers.ComputerUnique
Your best bet to distinguish physical from virtual machines is to look at tblComputerSystemProduct.Vendor and filter this field.
Reports & Analytics
Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
