Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Untag as favorite
Need help with Computer and Server report
mbuzard
#1 Posted : Friday, November 25, 2011 9:35:50 PM
Rank: Freeware user

Groups: Member
Posts: 1
Location: SAFE Credit Union
I have the following report, but is does not include Linux devices. How do I add those devices?

Select Top 1000000 tblComputers.LastknownIP As IP, web40AllIPLocations.IPLocation, tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, Web40OSName.OSname, Web40OSName.Compimage As icon, tblCompCustom.Custom1 From tblComputers Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join web40AllIPLocations On web40AllIPLocations.Computername = tblComputers.Computername Left Join tblCompCustom On tblCompCustom.Computername = tblComputers.Computername Where tblComputers.LastknownIP <> '' Order By dbo.tblComputers.IPNumeric
Lansweeper
#2 Posted : Monday, November 28, 2011 2:16:35 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,379
Linux machines are currently considered "devices" in Lansweeper. Device and computer info cannot easily be integrated into a single report. One of our future updates will merge computers and devices into a single "asset" category.

For now you will have to create a separate report using tblCustDevices and web40AllIPLocationsDev for the IP location.
Users browsing this topic
Guest
Untag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba